gtARStandingInvoiceGLLine

This function supplies the information to add GL lines to AR Standing Invoice headers. The InvoiceReference parameter must be the unique ID returned by the gtARStandingInvoice function call.

Each AR Standing Invoice is uploaded to Greentree as a complete transaction set. The standing invoice will either be uploaded in its entirety or nothing of the document will be loaded into Greentree Desktop.

InvoiceReference

This must be the unique identifier generated by the gtARStandingInvoice function call. It has the format ARST-nnn. This ensures the lines are of the correct invoice header details and it ensures Excel creates the header information before attempting to calculate and create the invoice line item details.

AccountCompany

The company code that the general ledger account belongs to.

Account

The General Ledger account number to be posted to.

Amount

The net amount of the line.

Tax

The amount of tax relevant to this line.

Narration

Narration for the line.

TaxType

Valid tax types are Inclusive or Exclusive.

DiscAmount

The amount of discount of the line.

Quantity

The number of units of the line. This is only applicable for quantity based general ledger accounts, otherwise it must be left at zero.

UnitPrice

Price per unit of quantity above (where applicable)

TaxPerc

Tax percentage of the line. This defaults if left blank.

DiscPerc

Discount percentage of the line (if applicable). Defaults to zero.

TaxCode

The code used to determine the tax rate and type for the transaction. If not entered and Greentree cannot find a valid default, then an error is returned and the user will be expected to enter a valid code.

SubCode

The sub code for the line item, if applicable.

TCodes

The transaction codes for the line item, if applicable.

Returns

Ok - if no errors encountered
Error - if an error is encountered

Errors Returned

Must have a valid Invoice Reference number
Must have an Account Company Identifier
Must have an Account number
Invalid Quantity, must be a number or omitted
Invalid Unit Price, must be a number or omitted
Invalid Tax Percentage, must be a number or omitted
Invalid Discount Percentage, must be a number or omitted