AR Invoices, Debit Memos, Credit Memos

The AR Invoices, Debit Memos, Credit Memos Writeback template creates accounts receivable invoices, debit memos, and credit memos in Acumatica directly from a workbook. Use it for batch customer invoices, recurring billing, project or contract billing, and other manual AR transactions. It uses the NECWRITEBACK formula, generated with the Writeback Wizard, to send changes from your workbook back to Acumatica.

Typical workflow

1. Select the AR document type and complete the invoice header.
2. Enter the invoice lines in the invoice grid.
3. Review the Validation column and correct any line level errors.
4. Confirm the number of lines, bill total, discounts, and overall status in the entry summary.
5. Select Writeback to create the AR document in Acumatica.
6. After a successful writeback, use the populated reference number to open the document in Acumatica.
7. Select Reset before preparing another AR document.

Invoice header

Contains information shared by every line in the AR document.

Field	What to select
Type	Acumatica AR document type to create, such as an invoice, debit memo, or credit memo.
Reference Nbr.	Reference number returned by Acumatica after a successful writeback. The populated value links to the created document.
Invoice Date *	Date assigned to the customer invoice or AR document.
Post Period *	Financial period in which the document will be recorded.
Customer Order Nbr.	Customer purchase order or reference number associated with the document.
Project/Contract	Project or contract associated with the document, when applicable.
Customer *	Customer associated with the document.
Location *	Customer location used for the document.
Currency	Currency of the AR 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.

important

Fields marked with an asterisk (*) are required. Each populated line must include either an Inventory ID or the appropriate revenue account coding.

Writeback actions

Action	What it does
Writeback	Validates the completed template and creates the AR document in Acumatica. A confirmation message indicates whether the writeback succeeded.
Reset	Clears the current AR 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.

Invoice grid

Contains the individual inventory, revenue, project, tax, and salesperson details that make up the AR document.

Column	What it shows
Branch *	Branch assigned to the invoice 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 Price	Selling price per unit. Used with Qty to calculate Ext. Price.
Ext. Price *	Extended line price. Calculated from quantity and unit price when available, or entered directly.
Discount Percent	Discount percentage applied to the line.
Discount Amount	Discount amount applied to the line.
Account *	Revenue or other general ledger account assigned to the line.
Subaccount *	Subaccount associated with the selected account.
Tax Category	Tax category used to determine the applicable taxes.
Project Task	Project task associated with the line, when applicable.
Cost Code	Project cost code associated with the line, when applicable.
Salesperson	Salesperson associated with the invoice line.
Validation	Displays missing field errors, invalid combinations, or confirmation that the line is ready.

Review

Before writing back the document:

• Confirm that the correct document type is selected and all required (*) fields are complete.
• Verify that each line includes either an Inventory ID or the appropriate revenue account coding.
• Resolve any errors shown in the Validation column.
• Check the Lines Entered, Total Bill Amount, and Total Line Discounts in the entry summary.
• Confirm the Entry Status shows the document is ready for writeback.

The document can be written back only when all required fields are complete and no line level errors remain.