PastelImportGLBatch

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:

    FieldTypeFormat
    PeriodNumeric1-13
    DateCharacterDD/MM/YYYY
    GDCCharacterG=General Ledger, D=Customer, C=Supplier.
    Account NumberCharacter7 characters e.g. “600000”
    ReferenceCharacter8 characters
    DescriptionCharacter36 characters maximum
    AmountNumeric15.2 -ve=CR, +ve=DR
    Tax TypeNumeric0-30, 0=no tax
    Tax AmountNumeric15.2 -ve=CR, +ve=DR
    Open Item TypeCharacterSee note below
    Job CodeCharacter5 characters
    Matching ReferenceCharacter8 characters
    Discount AmountNumeric15.2 -ve=CR, +ve=DR
    Discount Tax TypeNumeric0-30, 0=No tax
    Contra AccountCharacter7 characters e.g. “600000”
    Exchange RateNumericCustomer or supplier exchange rate
    Bank Exchange RateNumericBank 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.

Links