gtGLOutwardsCashJCLine

This function records the line item information required to create an Outwards Cash transaction.

Each outwards cash transaction is uploaded to Greentree Desktop as a complete transaction set. The payment either uploads in its entirety or nothing of the document is loaded into Greentree Desktop.

Reference

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

Job

The Job code for this line.

It must be a valid code for the Company specified in gtGLOutwardsCash.

It must belong to the Profit Centre Group of the user (set up in JC Preferences)

ActivityCode

The JC Activity Code for this line.

It must be a valid code for the Company specified in gtGLOutwardsCash.

It must be of type Purchasesor Disbursements.

If Job does not use a Work Centre Plan (WCP), then the Activity Code must belong to the Job's Activity Code Group.

If Job uses a WCP, then the Activity Code must conform to the rules of the WCP.

WorkCentre

The JC Work Centre for this line.

Must be a valid code for the Company specified in gtGLOutwardsCash.

If Job uses a WCP, then the Activity Code must conform to the rules of the WCP.

NetAmount

The net amount of the line.

TaxType

Valid tax types are:

I - Inclusive
E - Exclusive.

TaxAmount

The amount of tax for this line.

TaxCode

The code that determines the tax rate and type for the transaction. If not entered and there is no valid default from the Company an error is returned and the user must specify a valid Tax Code.

TaxPerc

Percentage of tax for this line.

Quantity

The quantity relevant for this line. If not specified, this defaults to 1.0000.

Narration

Narration for the transaction line.

SellRate

This parameter is only relevant if the Job Cost Module Control option Allowed to change sell rate on PO/AP is selected. Enter a numeric value to change the sell rate that would normally default using the process, or leave null to assume default.

Returns

Ok - if no errors encountered
Error - if errors encountered.

Errors Returned

Job xxx could not be found.
Job xxx does not belong to your Profit Centre Group.
Activity Code xxx could not be found.
Activity Code xxx is not a Purchase or Disbursement type.
Activity Code xxx does not belong to the Job's Activity Group.
Work Centre xxx could not be found.
Activity Code xxx and Work Centre xxx are not valid for the Job.
Activity Code xxx and Work Centre xxx are not valid for the Job - the Activity Code does not belong to the Activity Code Group of the Plan Work Centre xxx.
Activity Code xxx and Work Centre xxx are not valid for the Job - Work Centre is completed.
Total Payment must be greater than zero.
Must have a valid GL Outwards Cash Reference number. Should be GLOUTCASH-nnn.
Must have a Job.
Must have an Activity Code.
Must have a Work Centre.
Must have Tax Amount.
Default Tax Code not found, must have a Tax Code.
Invalid Tax Percentage, must be a number or omitted.
Invalid Discount Percentage, must be a number or omitted.