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. |