...
- User upload template file settings
1. Template file deliminitar on Save in Pipe (|) format
2. Must follow the format, with EOR
3. Upload the file without header
- fill in information in excel format (refer Upload Supplier Invoice_Opening.xlsx (16.6 kB)
...
- fill in information in excel format (refer )
Notes:
| Field Name | Remarks |
|---|---|
| Branch Code | Refer to Control Panel > Developer > Branch Listing > Branch Code |
| Supplier ID | Refer to system supplier account PKID (auto-generated) |
| Reference # | Outstanding Invoice number |
| Remarks | |
| GL Dimension ID (Header) | Leave it Empty if no data |
| GL Dimension Code (Header) | Leave it Empty if no data |
| SINV Date | follow outstanding invoice date (before start Wavelet Txn; date format: YYYY-MM-DD) |
| Due Date | Leave it Empty if no data |
| GL Short Hand | purchases |
| Item Reference No | Outstanding Invoice number |
| Item Remarks | |
| GL Dimension ID (Item) | Leave it Empty if no data |
| GL Dimension Code (Item) | Leave it Empty if no data |
| Debit | Invoice outstanding Amount (AMOUNT INCLUSIVE OF GST) |
| Tax Code | for GST Code (TX, NR, BL, OP, IM) |
| Tax Type | GST-MY INPUT |
| Tax Rate | 0 or 0.06 |
| String | Record Terminator - Must Key IN EOR |
...