- Contents
- Index
- Search
Display results with all search words
gtARCreditNoteJCLine
This function supplies the information to add JC line items to AR credit note headers. The InvoiceReference parameter must be the unique ID returned by the gtARCreditNote function call.
Each AR credit note is uploaded to Greentree as a complete transaction set. The AR credit note will either be uploaded in its entirety or nothing of the document will be loaded into Greentree unless the function returns a #VALUE!, in which case, if the transactions are processed, this line will not be included.
InvoiceReference
This must be the unique identifier generated by the gtARCreditNote function call. It has the format ARCN-nnn. This ensures the lines are associated with the correct invoice header details and it ensures Excel creates the header information before attempting to calculate and create the credit note line item details.
Job
The job code for the transaction.
ActivityCode
The activity code for the transaction.
Amount
The net amount of the line.
Tax
The amount of tax relevant to this line.
Narration
The narration for the transaction.
TaxType
Valid tax types are Inclusive or Exclusive.
Quantity
The number of units relevant for this line. Defaults to 0.
UnitPrice
The price per unit of quantity above. Defaults to 0.
DiscPerc
The percentage discount given for this line. Defaults to 0.
DiscAmount
The amount of discount given on this line.
TaxPerc
The percentage of tax for this line item.
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.
Returns
- Ok if all is okay.
- #VALUE! if an invalid entry is made such as text for a numeric value. On this, case if the transactions are processed this line will not be included.
Errors Returned
- Invalid Invoice header reference. Should be ARCN-nnn.
- Must have an Job.
- Must have a Sales Code.
- Invalid tax type. Must be Inclusive or Exclusive.
- Invalid job. Must be a valid Job Code.
- Invalid sales code. Must be a valid sales code.
- Invalid Tax Code. Must be a valid tax code or omitted.