Accounts Payable¶
- A/P Adjustments
- A/P Control Payment
- A/P Invoice
- A/P Payment
- A/P Recurring Invoice
- A/P Remit To
- A/P Vendor
- A/P Vendor Comment
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. |
Deleting Empty/Erroneous Batches¶
If an error occurs during the creation of a batch OR if the batch is empty i.e. has no entries, the batch can be deleted by setting the 'Delete Empty/Erroneous Batch' (DELEMPTYBATCH) to '1'.
| Value | Notes |
|---|---|
| 0 | Do not delete the batch. |
| 1 | Delete the batch. |
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.
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 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. |
Deleting Empty/Erroneous Batches¶
If an error occurs during the creation of a batch OR if the batch is empty i.e. has no entries, the batch can be deleted by setting the 'Delete Empty/Erroneous Batch' (DELEMPTYBATCH) to '1'.
| Value | Notes |
|---|---|
| 0 | Do not delete the batch. |
| 1 | Delete the batch. |
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