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.
The location of the Pastel data files.
The location of the Pastel program files.
An optional user id to send with the batch import.
Entry type number
The entry type number in Pastel.
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.
A string value that contains the result of a successful import operation.