PastelImportGLBatch
This plugin has been deprecated.
In order to use this function, the necessary Pastel SDK files have to be installed on the host computer.
Import a general ledger or cashbook batch into Pastel.
Properties
Data path
The location of the Pastel data files.
GL path
The location of the Pastel program files.
User id
An optional user id to send with the batch import.
Entry type number
The entry type number in Pastel.
Import string
A pipe-separated ("|") string that defines the batch content. The import string must use the following layout:
| Field | Type | Format |
|---|---|---|
| Period | Numeric | 1-13 |
| Date | Character | DD/MM/YYYY |
| GDC | Character | G=General Ledger, D=Customer, C=Supplier. |
| Account Number | Character | 7 characters e.g. "600000" |
| Reference | Character | 8 characters |
| Description | Character | 36 characters maximum |
| Amount | Numeric | 15.2 -ve=CR, +ve=DR |
| Tax Type | Numeric | 0-30, 0=no tax |
| Tax Amount | Numeric | 15.2 -ve=CR, +ve=DR |
| Open Item Type | Character | See note below |
| Job Code | Character | 5 characters |
| Matching Reference | Character | 8 characters |
| Discount Amount | Numeric | 15.2 -ve=CR, +ve=DR |
| Discount Tax Type | Numeric | 0-30, 0=No tax |
| Contra Account | Character | 7 characters e.g. "600000" |
| Exchange Rate | Numeric | Customer or supplier exchange rate |
| Bank Exchange Rate | Numeric | Bank exchange rate |
Note:
If there is a matching reference and the transaction is an allocation, Pastel finds the original document for the relevant customer or supplier, and allocates the transaction to that document. If the matching reference is blank, Pastel leaves it as unallocated.
For additional formatting options, please consult the Pastel SDK help file.
Output
A string value that contains the result of a successful import operation.