Question 72:
Portable Terminal
a) What is the txt file format for item.txt file? >>Answer
b) What is the txt file format for impitem.txt file ? >>Answer

Question 1 Answer:
To register the security key to your window 95/98/ME

(a) Please plug in the security key to the local parallel port.
(b) Click the Register Security key icon
(c) Restart window 95/98/ME

Note: For demo set no need to do the register.
>>Top

Question 2 Answer:
Install net security key (red colour) in window NT Server/ Window 95/98/ME

To register the security key to your window NT/ Window 95/98/ME/2000,

(a) Please plug in the security key (red colour) to the local parallel port.
(b) Plaese doucle click the LMSETUP.EXE under \emas\acc directory and follow the instruction (you can copy from \mal_ver\utility\)
(c) You have to copy the following file to the individual windows 95/98/2000/ME workstation under \window\system\, (the files you can copy from \windows\system\ subdirectory):-

Copy all the file, the file name start with vfp*.*

Note: For demo set no need to do the register, no need nethasp licensed manager. Your network server must install network card, the nethasp license manager cannot run without network card.

Run program in workstation, the haspkey logo disappear in server, how to solve?

Set in the ip address for tcp/ip protocol.

e.g. 192.168.100.1
       192.168.100.2 

Every computer must have a difference ip address (server and workstation)
>>Top

Question 3 Answer:
(1) Copy the MIM.EXE file from \utility\mim.exe to \emas subdirectory
Note: \emas subdirectory not \emas\acc subdirectory
(2) Create a shorcut to call this mim.exe file
(3) You can click the add button to add a new company
>>Top

Question 4 Answer:
For the main menu, use the ctrl key + the menu option
e.g. Maintenance

You can press Ctrl + 'M'

For the inside individual form, you can use alt key + the menu option
e.g.

Note: Alt + 'X' can be use for all the form to exit.

F2 key - Lookup

e.g. if you want list out account no. start from 3000, key in 3000 and press F2 key.
>>Top

Question 5 Answer:
(1) Delete payment transaction, you want to call back all the applied invoice.

When you delete the payment transaction, you have to unapplied all the applied invoice (mean key in zero amount in all applied invoice), or run delete unwanted transaction if you don't unapplied all the applied invoice.

Note: for the program dated before 04/08/1998, after run delete unwanted transaction, you have to run data recovery after power failure.

(2) Change applied invoice. (mean applied wrong invoice no.)

Procedure for change applied invoice:-

(a) Go to applied invoice screen, please change the applied amount to zero
(b) After exit the applied invoice screen, go back to the applied invoice screen again, (go to the credit field and press enter) the system will automatically list out all the unapplied invoice.
>>Top

Question 6 Answer:
Type install
>>Top

Question 7 Answer:
Yes

How do I enable long file name support for the workstation on a servers volume?

Novell 3.12 to 4.10

1. Load os2.nam
2. At the console prompt, ADD NAME SPACE OS2 TO VOLUME <VOLNAME>
3. Reboot workstation and test
4. Place the "LOAD OS2" in the startup.ncf file

Novell 4.11 and above

1. Load long.nam
2. At the console prompt, ADD NAME SPACE LONG TO VOLUME <VOLNAME>
3. Reboot workstation and test
4. Place the "LOAD LONG" in the startup.ncf file

e.g.

To add Long filename on Netware 4.11 to support window 95 and os/2

1. At the console prompt, type LOAD LONG.NAM
2. At the console prompt, type ADD NAME SPACE LONG TO VOLUME (VOLUME NAME)

e.g. ADD NAME SPACE LONG TO VOLUME SYS

Note: You only need to add the name space once per volume. Long name space is now added to the volume. You do not need to dismount and remount the volume, or reboot the server, Long name space has been added on the fly.
>>Top

Question 8 Answer:
Please go to My Computer (Window Desktop), select the printer option go to the paper size - select the custom.

Enter the sizes: width  850 select 0.01 inch and length  550

Go to the housekeeping, format setup, official receipt - select the file option - paper size - custom, change the paper size at as follow:

Enter the sizes: width  850  select 0.01 inch and length  550

Print the official receipt, if done, please remember go back to my computer - select the default printer - change back the paper size to original.

For 3 official receipt in 1 piece of paper.

width : 850  select 0.01 inch  length : 366

For window NT 2000, Window XP, please custom your page format first

Control Panel, Select Printer, menu file, server property, make new form.
(Note: you have to modify the existing form, after modify, change form name then click save button)
>>Top

Question 9 Answer:
Yes, of course.

Note:

For UBS Ver. 8.1, before upgrade, please go to UBS data directory do the following command

c:\ubsacc\data copy glmemo2.mem glmemof.mem

For UBS Ver. 8.2 and above, before upgrade, please copy the glmemof.mem to UBS data directory.

glmemof.mem file you can get it from \mal_ver\utility\ubs\

Procedure to transfer the data:-

(1) Copy the file called upgrade.exe from the \utility subdirectory to \emas\acc\data subdirectory.
(2) Run the upgrade.exe
(3) From the menu, select upgrade - transfer data
Enter the ubs data subdirectory : \ubs
(4) Modify gltemp file
Some of the billtype transfer from ubs data, is not correct, you have to manually change it. If the row is present red colour.
e.g. billtype 'Z' - change to either - IN, DN, CN, GJ, PV, RV, RC
(5) Upgrade the data
(6) Done
>>Top

Question 10 Answer:
Yes, of course.

Procedure to transfer the data:-

(1) Copy the file called upgrades.exe from the \utility subdirectory to \emas\acc\data
(2) Copy the file called dbstru.exe from \utility subdirectory to \ ubs\stock directory
(3) Run the dbstru.exe program, this program will auto update the ubs stock data to the latest version (6.2i)
(4) Go to the \emas\acc\data subdirectory and run the upgrades.exe
(5) Enter the \ubs\stock directory path
(6) Done
>>Top

Question 11 Answer:
In the bill format, double click the user defined field, go to property, set the following setting,

e.g.

For 2 decimal places - user defined field A

tran(ictran.dfield6,'999,999.99')

For 3 decimal places - user defined field A

tran(ictran.dfield6,'999,999.999')

Note: user defined field b - ictran.dfield7; user defined field c - ictran.dfield8
>>Top

Question 12 Answer:
(a) Go to report - variable, add in the new variable
e.g. mttludf - user defined field A

Tick the - Release after the report button
Reset at - icmast.type+icmast.entry

(b) Click the field option - under report control toolbar

Under expression: tran(mttludf, gamt)

Note:
stock received, issue, delivery order, invoice, cash sales, debit note, credit note
ictran.dfield6 - for user defined field A
ictran.dfield7 - for user defined field B

sales order
icsotr.dfield6 - for user defined field A
icsotr.dfield7 - for user defined field B

purchase order
icpotr.dfield6 - for user defined field A
icpotr.dfield7 - for user defined field B

quotation
icfmtr.dfield6 - for user defined field A
icfmtr.dfield7 - for user defined field B

gamt - amount
gprice - price
gqty - quantity
>>Top

Question 13 Answer:
ictran.billno
>>Top

Question 14 Answer:
Install EMAS - Payroll System, your problem will fixed.
>>Top

Question 15 Answer:
Please check the following posibilities:-

(1) Check your debtor control A/C in customer maintenance
(2) Check your creditor control A/C in creditor maintenance
(3) Debtor and creditor A/C range in housekeeping setup
(4) Any blank record exist in debtor or creditor maintenance
(5) Do you have any main group setting?
(6) Do you have any other debtor?
>>Top

Question 16 Answer:
Yes, of course.

Procedure to transfer the data:-

(1) Copy the file called upgrades.exe from the \utility subdirectory to \emas\acc\data
(2) Go to the \emas\acc\data subdirectory ans run the upgrades.exe
(3) Please tick the invoicing option
(4) Enter the \ubs\invoicing directory path
(5) Done
>>Top

Question 17 Answer:
(1) You have to key in the Fixed Assets and the depreciation A/C in the Fixed Assets maintenance.
(2) For all the Fixed Assets account cannot have main group account
>>Top

Question 18 Answer:
If all your customer using open item method, of course, both report will be same, but if some customer is using balance forward method, the both report got difference is normal, because knock off - aging report for knock off customer only, not including balance forward customer.

or

Please double check your opening balance -
Both report must be the same balance

(1) General Report (2) - opening balance
(2) Maintain knock off bill
>>Top

Question 19 Answer:
On Hand
Onhand (item_no, location, shelf no, date, alias)
e.g.
onhand(icitem.item_no, "", "", "", "icitem")

Unit Cost
getucost (item_no, type, entry, alias, date)
e.g.
getucost(ictran.item_no, "", "", "ictran", "")

Outstanding order (SO or PO)
onpo (item_no, location, shelf, alias)

for SO - alias == "icsotr"; po - alias == "icpotr"

e.g.
onpo1 (ictran.item_no, ictran.location, ictran.bin, "icsotr")
>>Top

Question 20 Answer:
User id : emas
Password : emas
>>Top

Question 21 Answer:
Restart the computer and try again or use other com port
>>Top

Question 22 Answer:
You have to use the following format YYYYMMDD

e.g.
20000118 for date 18/01/2000
>>Top

Question 23 Answer:
Please double check your customer is it foreign customer?
In maintain knock off bills - if your customer is foreign customer, you must key in the foreign currency rate, foreign currency amount, otherwise the balance cannot come out.
>>Top

Question 24 Answer:
No, you have to create another customer code, cannot use the same customer code.
>>Top

Question 25 Answer:
If your program is 2in1, you have to change the account code in Inventory program, because change account code in Inventory program, it will automatically change the accounting also, but if you change in accounting, it will only change accounting account code only.
>>Top

Question 26 Answer:
When the time you do the year end, our system is based on transaction date do year end, not pdc cheque date, so that, even though, the cheque not yet clear, after year end, all the pdc cheque will considered clear.

Note: You can list the pdc cheque from mark last year bank reconciliation statement.
>>Top

Question 27 Answer:
The balance = Account balance + Unpost transaction (Invoice, Debit Note, Credit Note, Cash Sales) + Uninvoice D/O + S/Order (if set to 'Y' option in setup) + Current Amount you enter
>>Top

Question 28 Answer:
Your program must be version 2000L, and use the following function:-

getagent ("arcust.agent")

getarea ("arcust.area")
>>Top

Question 29 Answer:
getfield (item_no, field to get, file to search, select file when return)

e.g.
getfield (icbilltr.item_no, "icitem.minimum", "icitem", "icbilltr")
>>Top

Question 30 Answer:
Currently available program as at follow:-
(Mal_ver & pre_release version)

(1) Invoicing System
(2) Accounting System
(3) Inventory System
(4) Export Inventory System
(5) POS
(6) Report Writer
(7) Payroll

Server
Install the software as normal

Workstation
(1) Install the software as normal
(2) After run the program, all the file are generated, delete the data and reports directory
(3) Under \emas\acc\ directory, edit the file called acc.ini, key in the following statement

e:\emas\acc\
(Server drive and directory name)

Note: You have install the workstation one by one, do the above step.

Good Point: Run the program faster, because only pool the data over not program exe file.

Bad Point: When you upgrade the program, you have upgrade one by one for all the workstation, after upgrade you have remember to delete the data and reports directory and edit the acc.ini file.
>>Top

Question 31 Answer:
Copy the chklimit.exe file to \emas\acc\data\ and run it.
e.g.
chklimit 3000/A01
The system will auto generate a chklimit.txt file for you to analyze.
>>Top

Question 32 Answer:
getdesc (icmast.hjob, "glproj", "J")
>>Top

Question 33 Answer:
Yes, you can do it.

Please copy the lmsetup.exe file under \mal_ver\utility\ directory to the window NT Server and run it, it will auto install the driver and license manager to the NT server, with this lmsetup.exe, you can install the nethasp license manager window NT service. As a service the nethasp license manager launches before logon and continues to run after logout.

Note: Your network server must install network card.
>>Top

Question 34 Answer:
(1) Go to report variable add in the following variable:-

hvalue1
calculation: tick sum

(2) add a data grouping
icmast.ref

(3) Double click the group header - grey bar
Under on entry key in:

htotal (icmast.n_amt)

(4) In report writer page footer put in the following variable

hvalue1

(5) Done

Note: For grandtotal variable is hhvalue1, add a variable called hhvalue1 calculation: tick sum
>>Top

Question 35 Answer:
In oeder to display JPG images that are stored in EMAS Inventory System, there must be an OLE server for JPG files installed on the computer.

This OLE server provides information about the file being linked or embeded. This information tells EMAS Software how to display the file.

One example of an OLE server for JPG files is the Microsoft Photo Editor, which is included in the Microsoft Office CD's.

Note: The maximum for foxpro database to hold the picture image is 2GB.
>>Top

Question 36 Answer:
Knock off Bill Statement
For month 4 = tran(mmth4+mmth5+mmth6+mmth7+mmth8+mmth9+mmth10+mmth11, gamt)

Balance Forward Statement
For month 4 = tran(mage4+mage5+mage6+mage7+mage8+mage9+mage10+mage11, gamt)

When print the statement, please select 12 months aging, not 6 months.
>>Top

Question 37 Answer:
getproj (ictran.dsource, "P")
>>Top

Question 38 Answer:
mtmprw.mtdamt1    mtmprw.mtdamt2    ......
>>Top

Question 39 Answer:

Note: 30100000 is the bank a/c no.

e.g.
Go to report variable, add in a variable

mthismonth

value to store: 0    calculate: sum
Initial value: getfbal ("3010000", mdate, "T")
release after report: tick
reset at: end of report

For consolidate financial statement:-

1st company
getfbal ("30100000", mdate, "T", "1")
getfbal ("30100000", mdate, "L", "1")
getfbal ("30100000", mdate, "Y", "1")

2nd company
getfbal ("30100000", mdate, "T", "2")
getfbal ("30100000", mdate, "L", "2")
getfbal ("30100000", mdate, "Y", "2")
>>Top

Question 40 Answer:
copy /b filename lpt1

e.g.
copy /b emas.txt lpt1
>>Top

Question 41 Answer:
Do you set the main group to yourself?

e.g.
50000000 is the main a/c, under main group please leave it blank.
For a/c 50000A01, 50000A02 the main group is 50000000.
>>Top

Question 42 Answer:
S/Order
onhand (icsotr.item_no, "", "", "", "mtmptable")

P/Order
onhand (icpotr.item_no, "", "", "", "mtmptable")
>>Top

Question 43 Answer:
Closing Stock = current month closing stock - last month closing stock
>>Top

Question 44 Answer:
(1) Double click the bal field
(2) Go to print when, change it to mtmptable.bal#0 .or. ! empty (mtmptable.type)
>>Top

Question 45 Answer:
(1) Go to \emas\acc\ folder
(2) delete the selelock.dbf file
(3) restart program (select the correct program)

or

Go to command (ms dos) prompt
cd\emas\acc
type in the following command

regsvr32 dzactx.dll /s
regsvr32 duzactx.dll /s
regsvr32 dzstactx.dll /s
>>Top

Question 46 Answer:
(1) save as dbf type file when you are in excel let say item.dbf
(2) copy the item.dbf file to \emas\acc\data
(3) run foxcmd
(4) use item
(5) modi stru excl
change the field name same to emas item master file
(6) inde on item_no to abc unique
(7) copy to abc
(8) use icitem
(9) appe from abc
(10) quit
>>Top

Question 47 Answer:
Item Master File
(1) rename the icitem.dbf (if the item is store in this file)
(2) copy item.dbf file to \emas\acc\data
(3) run foxcmd
(4) use item excl
(5) modi stru
(6) change the field name as at follow:
e.g.
item_no  c(16)
desc1  c(40)
desc2  c(40)
group  c(8)
cat  c(8)
u_measure  c(6)
s_price  n(16,6)
price_b  n(16,6)

(7) index on item_no to abc unique
(8) copy to abc
(9) use icitem
(10) appe from abc
(11) repl all stock with "Y"
(12) quit

Group Master File
(1) rename the icgroup.dbf file to group.dbf
(2) copy group.dbf file to \emas\acc\data
(3) run foxcmd
(4) use group excl
(5) modi stru
(6) change the field name as at follow:
e.g.
group  c(8)
desc  c(40)
(7) index on group to abc unique
(8) copy to abc
(9) use icgroup
(10) appe from abc
(11) quit

Category Master File
(1) rename the iccate.dbf file to cat.dbf
(2) copy cat.dbf file to \emas\acc\data
(3) run foxcmd
(4) use cat excl
(5) modi stru
(6) change the field name as at follow:
e.g.
code  c(8)
desc  c(40)
(7) index on code to abc unique
(8) copy to abc
(9) use iccat
(10) appe from abc
(11) quit
>>Top

Question 48 Answer:
Please install the Generic/ Text Printer Driver and set this printer as a default printer.
>>Top

Question 49 Answer:
left (month1, 3) + "'" + right (month1, 4)
>>Top

Question 50 Answer:
Please go to boss setup: "N" - appear on S/O or on P/O when enter RE, IN, DO transaction.
>>Top

Question 51 Answer:
matrix qty 1: mmtriq1
matrix qty 2: mmtriq2
>>Top

Question 52 Answer:
Code be index file corrupted, quit all the users and run indexstk to rebuild the index file.

>>Top

Question 53 Answer:
run foxcmd
USE STOCKCARD.FRX
LOCATE FOR objtype = 1 AND objcode = 53
REPLACE Tag WITH ""
REPLACE Tag2 WITH ""
REPLACE Expr WITH ""
USE
>>Top

Question 54 Answer:
Chart of A/C
(1) rename the gldata.dbf file to data.dbf
(2) copy data.dbf file to \emas\acc\data
(3) run foxcmd
(4) use data excl
(5) modi stru
(6) change the field name as at follow:
e.g.

(7) use gldata
(8) appe from data
(9) quit

Customer File
(1) rename the arcust.dbf file to cust.dbf
(2) copy cust.dbf file to \emas\acc\data
(3) run foxcmd
(4) use cust excl
(5) modi stru
(6) change the field name as at follow:
e.g.

(7) use arcust
(8) appe from cust
(9) repl all control with "30000000"
(10) repl all autopay with "0"
(11) quit

Supplier File
(1) rename the apvend.dbf file to vend.dbf
(2) copy vend.dbf file to \emas\acc\data
(3) run foxcmd
(4) use vend excl
(5) modi stru
(6) change the field name as at follow:
e.g.

(7) use apvend
(8) appe from vend
(9) repl all control with "40000000"
(10) repl all autopay with "0"
(11) quit
>>Top

Question 55 Answer:
You can get this file from \emas\acc\data\ subdirectory

the following is structure for glpost9.dbf file

For foreign currency amount and foreign currency rate should enter zero is no foreign currency.

How to export data (other software) to glpost9.txt file?

You have an invoice
e.g. 01/01/2004 Inv 00001  Amount: 100.00  Debtor code: 30000001   Name: ABC Company  Sales A/C: 50000000   Description: Sales A/C   Currency: RM

The glpost9.txt file as at follow

"30000001","Inv 00001","","01/01/2004","Sales A/C","",100.00,,,,,"00001","01/01/2004","IN"
"50000000","Inv 00001","","01/01/2004","ABC Company","",,100.00,,,,"00002","01/01/2004","IN"

You have a payment
e.g. 31/01/2004 Receipt No.: OR0001  Payment Amount 100.00   Debtor Code: 30000001   Name: ABC Company   bank A/C 30100000  Description: Bank A/C   Currency: RM

"30000001","OR0001","","31/01/2004","Bank A/c","",,100.00,,,,"00003","31/01/2004","RV"
"30100000","OR0001","","31/01/2004","ABC Company","",100.00,,,,,"00004","31/01/2004","RV"
>>Top

Question 56 Answer:
Single Version
(1) Plug the dongle to local parallel port
(2) Go to Start - Program - Emas Software
(3) Click the install rockey driver

Network Version
(1) Plug the dongle to server parallel port
(2) Go to Start - Program - Emas Software
(3) Click the install rockey driver
(4) Click the install rockey net service
(5) In server, please install fixed IP address for TCP/IP protocol e.g. 196.168.0.1

Restart the server

In Workstation
(1) Install EMAS program, delete the data, reports and export folder (Client Server basic)
(2) Edit the acc.ini file
e.g. key in \\servername\sharename\emas\acc\ by this way, no need to do mapping.

(3) copy the client configuration file (clicfg.ini) from \mal_ver\utility\ folder to \emas\acc folder

Note: If still cannot work, edit the clicfg.ini file, change the searchflag = 2 (semi-automatic mode)   searchlist = 192.168.0.1

NOT SUPPORT WINDOWS 95
>>Top

Question 57 Answer:
ftp://mim@firstonline.net/mim/
>>Top

Question 58 Answer:
(1) save as dbf type file when you are in excel let say abcde.dbf
(2) copy the abcde.dbf file to \emas\acc\data
(3) run foxcmd
(4) use abcde
(5) modi stru excl
change the field name same to emas item udf (icitemex.dbf) file
(6) inde on item_no to abc unique
(7) sopy to abc
(8) use icitemex
(9) appe from abc
(10) quit
>>Top

Question 59 Answer:
Total length is 13

but system only capture start from 2nd digit up to 6 digit as item no., the rest is price (capture 5 digit only)

Note: first digit and last digit will not capture.
>>Top

Question 60 Answer:
tran (mmth3+mmth4+mmth5+mmth6+mmth7+mmth8+mmth9+mmth10+mmth11, gamt)
>>Top

Question 61 Answer:
mpjdesc1, mpjdesc2....
>>Top

Question 62 Answer:
When the message show apvend.fpt files is missing when run index,

run foxcmd
use apvend
copy to abc
use abc
brow

*Conform the abc table is ok.
quit

delete the apvend.dbf, apvend.frt
rename the abc.dbf to apvend.dbf
reanme the abc.fpt to apvend.fpt
>>Top

Question 63 Answer:
getgldes (voumast.accno2)
>>Top

Question 64 Answer:
If foreign currency based on month option = "N"

Last year amount = balance local currency
This year amount = balance foreign currency * unrealized currency rate

If foreign currency based on month option = "Y"

Last year amount = balance foreign currency * month currency rate
This year amount = balance foreign currency * unrealized currency rate

For A/C balance is debit balance else reverse

If this year amount > last year amount

credit unrealized A/C  Debit G/L A/C

If this year amount < last year amount

Debit unrealized A/C   Credit G/L A/C
>>Top

Question 65 Answer:
Project code: glpost.source
Project Description: getproj(glpost.source, "P")

Job code: glpost.job
Job Description: getproj(glpost.job,"J")
>>Top

Question 66 Answer:

>>Top

Question 67 Answer:
Yes, under report format 2

getinvst (minv_no1)
getinvst (minv_no2)
>>Top

Question 68 Answer:

Below are network error codes

>>Top

Question 69 Answer:
Windows XP SP2
My network places - properties - select local area connection - properties - click the setting - Under General Tap - Don't tick - "don't allow exception", option, Under the "exception" tab, click add program, select the \emas\acc\nrsvr.exe.

nrsvr.exe is for rockey dongle
nhsrvw32.exe is for hasp dongle

or

Click the add port button

Name: Rockey
Port No: 3152

Window XP SP1
My network places - properties - select local area connection - properties - click the setting - Add in the Nrsvr.exe service and the port 3152.