Accounts Payable

A/P Adjustments

Views/Record Types Supported

All

Update

Insert only

Limitations

None

Writeback fields

AP0030.CNTBTCH	Batch Number
AP0030.CNTENTER	Batch Entry Count
AP0030.ENTRYTOT	Total of Entries
AP0031.CNTBTCH	Entry Batch Number
AP0031.CNTITEM	Entry Number

Implementation Notes

Batch Posting

The resulting batch may be posted by setting the ‘Post Created Batch’ (POSTCREATEDBATCH) field to one of the following values.

Value	Notes
0	Do not post the batch.
1	Post the batch if there are no errors during batch creation.
2	Post the batch irrespective of any errors. The batch will only be posted if the Error Action has been set to either Reject Record or Continue; when set to Abort the batch will not be posted.

A/P Control Payment

Views/Record Types Supported

N/A

Update

Insert only

Limitations

None

Implementation Notes

Allows to toggle on /off the hold status of an A/P Invoice.

A/P Invoice

Views/Record Types Supported

All inc. Intercompany Transactions

Update

Insert only

Limitations

No Project and Job Costing Support

Writeback Fields

AP0020.CNTBTCH	Batch Number
AP0020.CNTINVCENT	Number of Entries
AP0020.AMTENTR	Batch Total
AP0021.CNTBTCH	Entry Batch Number
AP0021.CNTITEM	Entry Number
AP0022.CNTBTCH	Entry Detail Batch Number
AP0022.CNTITEM	Entry Detail Entry Number
AP0022.CNTLINE	Entry Detail Line Number

Implementation Notes

Entry record can be either A/P Invoice Batch (AP0020) or A/P Invoice Header (AP0021).

Auto Calc Document Total – When this is set to True the Document Total field, as found on the Document Tab of the User Interface will be automatically calculated by summing the detail lines and any exclusive taxes.

Distributing Tax

Tax can be distributed using the invoice header over the detail lines as per the Distribute Tax button found on the Tax tab of the user interface. To distribute tax set the following fields with respective values:

Field	Description	Value
SWCALCTAX & SWTXBSECTL	Tax Amount Control & Tax Base Control	0 or 2
DISTTAXES	Distribute Taxes Over Details	True

Batch Posting

The resulting batch may be posted by setting the ‘Post Created Batch’ (POSTCREATEDBATCH) field to one of the following values.

Value	Notes
0	Do not post the batch.
1	Post the batch if there are no errors during batch creation.
2	Post the batch irrespective of any errors. The batch will only be posted if the Error Action has been set to either Reject Record or Continue; when set to Abort the batch will not be posted.

A/P Payment

Views/Record Types Supported

All

Update

Insert only

Limitations

No Project and Job Costing Support

Writeback Fields

AP0030.CNTBTCH	Batch Number
AP0030.CNTLSTRMIT	Last Entry Number
AP0030.FUNCAMOUNT	Functional Batch Total
AP0031.CNTBTCH	Entry Batch Number
AP0031.CNTENTR	Entry Number
AP0031.DOCNBR	Document Number (Set when payment is auto-numbered)

Implementation Notes

All forms of payments (Applied, Prepayment & Miscellaneous) may be created. To set the receipt type, change the AP0031.RMITTYPE field as per the AOM.

A/P Recurring Invoice

Views/Record Types Supported

All

Update

Insert/Update

Limitations

None

Writeback Fields

AR0064.CNTLINE

Line Number

Implementation Notes

Taxes

Tax can be distributed using the invoice header over the detail lines as per the Distribute Tax button found on the Tax tab of the user interface. To distribute tax set the following fields with respective values:

Field	Description	Value
SWCALCTAX & SWTXBSECTL	Tax Amount Control & Tax Base Control	0 or 2
DISTTAXES	Distribute Taxes Over Details	True

Updating Recurring Payables

When updating an existing recurring payable, set the Vendor & Recurring Payable fields.

To update an existing line it is necessary to identify or matched to the line being updated. This is achieved by setting the either the CNTLINE or IDDISTCODE fields.

To control which should be used for matching the ‘Line Match Method’ (MATCHMTD) field controls how the lines are matched.

 

Field Id	Line Match Method Value	Notes
Line Number (CNTLINE) (Default)	0	The value may be obtained either at the time the Recurring Payable is created, or via a lookup against the Recurring Payable Details.
Distribution Code (IDDISTCODE)	1	When matching by distribution code, ensure there are no duplicate distribution codes in the recurring payable. When duplicate distributions are present only the first one is updated.

A/P Remit To

Views/Record Types Supported

All

Update

Insert/Update

Limitations

None

A/P Vendor

Views/Record Types Supported

All

Update

Insert/Update

Limitations

None

A/P Vendor Comment

Views/Record Types Supported

All

Update

Insert/Update

Limitations

None