AP Bills, Adjustments, Prepayments

Acumatica, Writeback

The AP Bills, Adjustments, Prepayments Writeback template creates accounts payable (AP) bills, adjustments, and prepayments in Acumatica directly from a workbook. You can use the template for batches of vendor invoices, recurring bills, bills matched to a purchase order, and accrued AP for spending not tied to a purchase order. It uses the NECWRITEBACK formula, generated with the Writeback Wizard, to send changes from your workbook back to Acumatica.

Write a bill, adjustment, or prepayment back to Acumatica

1. Select the document Type and fill in the bill header.
2. Enter the invoice lines in the bill grid.
3. Review the AP document in the Validation column and the entry summary, then click Push to Acumatica.
4. Click Reset before you start another AP document.

AP bill header fields

The bill header holds the information that applies to every line of the AP document. Fields marked with an asterisk (*) are required.

Header field	What it contains
Type	Acumatica AP document type to create, such as a bill, adjustment, or prepayment.
Reference Nbr.	Reference number returned by Acumatica after a successful writeback. The populated value links to the created document.
Invoice Date *	Date of the vendor invoice or AP document.
Post Period *	Financial period in which the document will be recorded.
Vendor Ref. *	Vendor invoice or reference number used to identify the document.
Description	Brief description of the AP document.
Vendor *	Vendor associated with the document.
Location *	Vendor location used for the document.
Currency	Currency of the AP document.
Terms *	Payment terms used to calculate the due date and available cash discount.
Due Date *	Date by which payment is due.
Apply Retainage	Indicates whether retainage applies to the document.
Pay by Line	Indicates whether individual document lines can be paid separately.
Cash Discount	Cash discount amount calculated for the document.
Cash Discount Date	Last date on which the cash discount is available.

Writeback actions

Writeback action	What it does
Push to Acumatica	Validates the completed template and creates the AP document in Acumatica. A confirmation message indicates whether the writeback succeeded.
Reset	Clears the current AP document so the template can be used for another entry. Use this only after the current document has been successfully written back or is no longer needed.

AP bill grid

The bill grid contains the inventory, expense, project, and tax details of the AP document. Each line needs either an Inventory ID or the expense coding. Columns marked with an asterisk (*) are required on every line you fill in.

Bill column	What it shows
Branch *	Branch assigned to the bill line.
Inventory ID	Inventory item associated with the line, when applicable.
Qty	Quantity billed for the selected item or service.
UOM	Unit of measure used for the quantity.
Unit Cost	Cost per unit. Used with Qty to calculate Ext. Cost.
Ext. Cost *	Extended line cost. Calculated from quantity and unit cost when available, or entered directly.
Discount Amount	Discount amount applied to the line.
Account *	Expense or asset account assigned to the line.
Subaccount *	Subaccount associated with the selected account.
Tax Category	Tax category used to determine the applicable taxes.
Project	Project associated with the line, when applicable.
Project Task	Project task associated with the line, when applicable.
Cost Code	Project cost code associated with the line, when applicable.
Non Billable	Indicates that a project related expense should not be billed to the customer.
Expense Date	Date associated with the expense line.
Validation	Displays missing field errors, invalid combinations, or confirmation that the line is ready.

Review the AP document before writeback

You can write the AP document back to Acumatica only when every required field is complete and no line shows an error.

• Confirm that the correct document Type is selected.
• Complete every required (*) field in the header and on each line you filled in.
• Add an Inventory ID or the expense coding to each line.
• Correct every error in the Validation column.
• Check Lines Entered, Total Bill Amount, and Total Line Discounts in the entry summary.
• Confirm that Entry Status shows the document is ready for writeback.