Upload Deposit

Menu Path: Customer > Task > Upload Deposit

Step 1: Click file link: 'Download Template File'

Notes:

select source fields and add to target fields (The compulsory fields are pre-selected and can not be removed)
default format is “comma” delimiter

Step 2: Fill in the data

Sample of Upload Deposit file

No	Field Name	Data Type	Remarks	Where to find	Sample Data
1	BRANCH_CODE	String with Maximum (50) Characters	Compulsory	Control Panel > Developer > Branch Maintenance > Branch Listing > Refer to "Branch Code"	A Co.-B1
2	CUSTOMER_CODE	String with Maximum (150) Characters	Compulsory, Customer ID / Customer Code	Customer > Maintenance > Customer > Account PKID or Customer > Task> Settle Document > Customer	4703
3	METHOD_OF_PAYMENT	String with Maximum (30) Characters	Compulsory, CASH, CARD, CHEQUE, PD CHEQUE, COUPON, OTHER
4	PAYMENT_AMOUNT	Floating Point Number	Compulsory
5	RECEIPT_DATE	String in the following format (yyyy-mm-dd)	Compulsory		2017-11-20
6	SALESMAN	String with Maximum (100) Characters	Compulsory	Customer > Task> Settle Document > Salesman drop down list	admin
7	PAYMENT_MODE	String with Maximum (30) Characters	Compulsory if Method Of Payment is CARD	Accounting > Maintenance> Card Listing > Generate> Payment Mode
8	PAYMENT_NUMBER	String with Maximum (50) Characters	Compulsory if Method Of Payment is not CASH. [Card no./Cheuque no./PD Cheuqe no./Coupon Serial no.]
9	TAX_CODE	String with Maximum (36) Characters	Must follow configured Tax Code
10	CARD_APPROVAL_CODE	String with Maximum (50) Characters
11	CARD_BATCH	String with Maximum (50) Characters
12	CARD_NAME	String with Maximum (100) Characters
13	CARD_VALID_THRU	String in the following format (yyyy-mm-dd)
14	CASHBOOK	String with Maximum (100) Characters
15	DATE_PD_CHEQUE	String in the following format (yyyy-mm-dd)
16	GL_DIMENSION_CODE	String with Maximum (50) Characters
17	GL_DIMENSION_ID	Integer
18	REMARKS	String with Maximum (300) Characters
19	TAX_RATE	Floating Point Number

Note: The amount recorded will follow Output tax GST configuration, if the configuration is set as inclusive, the Amount recorded will be inclusive of GST

Excel sample:

CASH

CARD

Step 3: Save file, save as comma separated values (.csv) format

Step 4: Upload file

Sample of Error Message:

If the file is not sucessfully uploaded, please refer to the column with RED color background
Please move the cursor to the RED color background to see the Error Message

If this situation happen, please verify and correct the error eg: in the above case, put the correct Payment Mode in the file
After editing the file, please repeat STEP 4