Edit an unpaid AP supplier invoice
An unpaid AP supplier invoice is a transaction that reflects an amount that you owe a supplier and against which you have never applied payment or selected to include in a payment request.
The fields you can edit in an unpaid AP supplier invoice depend on:
-
The application where the AP supplier invoice originated
-
The AP supplier invoice's workflow state
-
Whether the AP supplier invoice's GL posting date occurs in an open or closed reporting period
If you want to remove the AP supplier invoice or start over, see Delete an AP supplier invoice or Reverse an AP supplier invoice.
| Subscription |
Accounts Payable Purchasing |
|---|---|
| User type |
Business |
| Permissions |
For transactions created in Accounts Payable: AP supplier invoices: List, View, Edit For transactions created in Purchasing: Purchasing Transactions: List, View, Edit |
| Restrictions |
A Purchasing Transaction definition must not have Edit policy set to "No edit". |
Where you can edit unpaid AP supplier invoices
You can only edit AP supplier invoices that originated in Accounts Payable in Accounts Payable.
These AP supplier invoices appear in the AP supplier invoices list with a Summary title of "AP supplier invoices: <date> Batch". For example, "AP supplier invoices: 2020/07/15 Batch".
You can edit AP supplier invoices that originated in Purchasing in either Purchasing or Accounts Payable.
When the AP supplier invoice's GL posting date is in an open period, the best practice is to edit the purchasing transaction as any changes you make there will overwrite any changes you make to the same fields in the AP supplier invoice. There are also some fields you can only edit in the purchasing transaction and not in the AP supplier invoice.
Purchasing transaction that are configured to post to Accounts Payable appear as an AP supplier invoice in the AP supplier invoices list with a Summary title of "<transaction definition name>: <date> Batch". For example, "Supplier invoice: 2020/07/15 Batch". Your purchasing transactions might have different names like "PO bill", "Receipt", and so on.
When you create a charge payoff in Cash Management, it creates an AP supplier invoice in Accounts Payable that you use to pay your credit card. This AP supplier invoice can't be edited. You can only reverse the charge payoff and create a new one.
These AP supplier invoices appear in the AP supplier invoices list with a Summary title of "Liability AP supplier invoices: <date> Batch:. For example, "Liability AP supplier invoices: 2020/07/15 Batch".
When you can edit unpaid AP supplier invoices
When you can edit unpaid AP supplier invoices depends on two factors:
- The AP supplier invoice's workflow state
- The AP supplier invoice's GL posting date
The AP supplier invoice's workflow state
| State | Edit? |
|---|---|
|
Declined Draft Posted |
You can edit AP supplier invoices with these states, except in the scenarios outlined below. What you can edit depends on whether the reporting period is opened or closed. Exceptions:
|
|
Submitted |
You can edit an AP supplier invoice that you submitted for approval after you recall the AP supplier invoice. This removes the AP supplier invoice from the approval queue and changes the state to draft. At this point, the Edit link is available. If the AP supplier invoice is Partially approved, you cannot recall it from the approval queue. |
|
Partially approved |
You can't edit Partially approved AP supplier invoices. The Edit link doesn't appear next to these AP supplier invoices in the AP supplier invoices list or purchasing transaction list. In this scenario, do one of the following:
If your company uses AP supplier invoice approvals, Business users with the appropriate permissions can edit some AP supplier invoice details during approval. |
|
Paid Partially paid Selected |
To edit a Paid, Partially paid, or a Selected AP supplier invoice, see Edit a paid AP supplier invoice. |
|
Reversal Reversed |
You can only edit non-posting fields for Reversal and Reversed AP supplier invoices. These fields are listed in the table in the What you can edit in a closed period section. |
The AP supplier invoice's GL posting date
Depending on your company's Accounts Payable configuration, your AP supplier invoices might display separate fields for the AP supplier invoice date and the GL posting date. If you only see one Date field, then the AP supplier invoice date is also the GL posting date.
| Reporting period status | Edit? |
|---|---|
|
The AP supplier invoice's GL posting date is in an open reporting period |
You can edit the AP supplier invoice as applicable. See What you can edit in an open period for details. |
|
The AP supplier invoice's GL posting date is in a closed reporting period |
You can only edit fields that don't require the associated journal entries to be re-posted. As most changes made to purchasing transactions require the system to post to Accounts Payable, you won't be able to edit the purchasing transaction in a closed period. You can edit some fields in Accounts Payable for both AP supplier invoices and AP supplier invoices that originated in Purchasing. See What you can edit in a closed period for details. When the reporting period is closed and you need to edit a field that requires journal entries to be re-posted, do one of the following:
|
Do one of the following:
-
Go to Accounts Payable > All > Subledger > Close.
-
Go to General Ledger > All > Books > Close.
The Close <subledger or company books> from field displays the first date of the open period. For example, say the AP supplier invoice's GL posting date is February 11. If the Close <subledger or company books> from field displays February 1, then the February reporting period is open. If the Close <subledger or company books> from field displays March 1, then the February reporting period is closed.
If you don't have permissions to view the close book dates, you can just try editing the AP supplier invoice and posting it. If you receive the following error: "You can’t make entries into closed books", then the reporting period in which the AP supplier invoice's GL posting date falls is closed.
What you can edit in unpaid AP supplier invoices
What you can edit depends on whether the GL posting date falls in an open or closed reporting period.
The following table displays whether or not you can edit a particular field in an unpaid AP supplier invoice and where you can edit it when the AP supplier invoice's GL posting date is in an open reporting period.
| For AP supplier invoices originating in Purchasing | For AP supplier invoices originating in AP | |||
|---|---|---|---|---|
| Field name | Edit in Purchasing? | Edit in AP? | Edit in AP? | Notes |
| Date | Yes | No | Yes |
If Enable override of GL posting date during entry isn’t selected in Configure Accounts Payable, this date is the AP supplier invoice date and the GL posting date. For AP supplier invoices associated with a project only: Follow this process to edit the AP supplier invoice date:
|
| GL posting date | Yes | No | Yes |
You can edit this field if Enable override of GL posting date during entry is selected and Summary frequency for AP supplier invoices isn’t set to "User-specified" in Configure Accounts Payable. |
| Supplier | Yes | No | Yes |
In Purchasing only: You can edit this field if Allow edit of supplier doesn’t equal "Never" in the Security Configuration tab of the purchasing transaction definition. |
| Supplier document number/AP supplier invoice number | Yes | Yes | Yes |
This field is called Supplier document number in Purchasing and AP supplier invoice number in Accounts Payable. |
| Pay to | Yes | No | Yes |
In Purchasing only: You can edit this field if Pay-to contact has Allow Editing selected in the purchasing transaction definition. |
| Return to | Yes | No | Yes |
In Purchasing only: You can edit this field if Return-to contact has Allow Editing selected in the purchasing transaction definition. |
| Reference number | Yes | Yes | Yes | |
|
Message/Description |
Yes | Yes | Yes |
This field is called Message in Purchasing and Description in Accounts Payable. |
|
Payment term/Term |
Yes | Yes | Yes |
This field is called Payment term in Purchasing and Term in Accounts Payable. |
| Due date | Yes | Yes | Yes | |
| Place this AP supplier invoice on hold | N/A | Yes | Yes |
|
| Recommended to pay on | N/A | Yes | Yes |
|
| Payment priority | N/A | Yes | Yes |
|
| Attachment | Yes | Yes | Yes |
You can add new attachments or delete existing ones. |
| Transaction currency | Yes | No | Yes | |
| Exchange rate date | Yes | No | Yes | |
| Exchange rate type | Yes | No | Yes |
In Purchasing only: You can edit this field if Exchange rate and exchange rate type is selected in the User overrides section of the purchasing transaction definition. |
| Exchange rate | Yes | No | Yes |
In Purchasing only: You can edit this field if Exchange rate and exchange rate type is selected in the User overrides section of the purchasing transaction definition. |
| Entries | ||||
|
Account or Account Label |
N/A | No | Yes |
|
| Item ID | Yes | N/A | N/A |
Items from purchasing transactions are translated to account numbers/labels in AP supplier invoices. |
| Quantity | Yes | N/A | N/A | |
| Transaction amount | Yes | No | Yes |
In Purchasing only: You can edit this field if Override suggested price is selected in the User overrides section of the purchasing transaction definition. |
| Memo | Yes | Yes | Yes |
|
| Billable | Yes | Yes | Yes |
You can edit this field if your company is subscribed to Project Costing & Billing. |
| 1099 | Yes | No | Yes |
You can edit this field if Enable 1099 flag override is selected in Configure Accounts Payable and Configure Purchasing. |
|
Form 1099 Type Form 1099 Box |
Yes | No | Yes |
You can edit this field if Form 1099 form and box override is selected in Configure Accounts Payable and Configure Purchasing. |
| AP account | N/A | N/A | Yes |
You can edit this field if Enable Accounts Payable GL account override in AP supplier invoice and adjustment entry is selected in Configure Accounts Payable and the user has the AP supplier invoices: Override the AP account permission. |
| Department | Yes | No | Yes |
In Purchasing only: You can edit this field if Department is selected in the User overrides section of the purchasing transaction definition. |
| Location | Yes | No | Yes |
In Purchasing only: You can edit this field if Location is selected in the User overrides section of the purchasing transaction definition. |
|
Other dimensions: Class Contract Customer Employee Item Project Task Supplier Warehouse |
Yes | No | Yes |
You can edit these fields if the applicable dimensions are selected in Configure Purchasing and Configure Accounts Payable |
| Allocation | N/A | No | Yes |
You can edit these fields if Enable allocation in AP supplier invoice entry is selected in Configure Accounts Payable. |
| Allocation Splits | N/A | No | Yes |
|
When the AP supplier invoice GL posting date is in a closed period, you can only edit fields that don't require the AP supplier invoice to be posted. As most changes made to purchasing transactions require the system to post to Accounts Payable, you won't be able to edit the purchasing transaction in a closed period.
| For AP supplier invoices originating in Purchasing | For AP supplier invoices originating in AP | ||
|---|---|---|---|
| Field name | Edit in Purchasing? | Edit in AP? | Edit in AP? |
| Date | No | No | No |
| GL posting date | No | No | No |
| Supplier | No | No | No |
| Supplier document number/AP supplier invoice number | No | Yes | Yes |
| Pay to | No | No | No |
| Return to | No | No | No |
| Reference number | No | Yes | Yes |
|
Message/Description |
No | Yes | Yes |
|
Payment term/Term |
No | Yes | Yes |
| Due date | No | Yes | Yes |
| Place this AP supplier invoice on hold | N/A | Yes | Yes |
| Recommended to pay on | N/A | Yes | Yes |
| Payment priority | N/A | Yes | Yes |
| Attachment | No | Yes | Yes |
| Transaction currency | No | No | No |
| Exchange rate date | No | No | No |
| Exchange rate type | No | No | No |
| Exchange rate | No | No | No |
| Entries | |||
|
Account or Account Label |
N/A | No | No |
| Item ID | No | N/A | N/A |
| Quantity | No | N/A | N/A |
| Transaction amount | No | No | No |
| Memo | No | Yes | Yes |
| Billable | No | No | No |
| 1099 | No | No | No |
|
Form 1099 Type Form 1099 Box |
No | No | No |
| AP account | N/A | N/A | No |
| Department | No | No | No |
| Location | No | No | No |
|
Other dimensions: Class Contract Customer Employee Item Project Task Supplier Warehouse |
No | No | No |
| Allocation | N/A | No |
No |
| Allocation Splits | N/A | No | No |
Edit an unpaid AP supplier invoice
Before attempting to edit the unpaid AP supplier invoice, do the following:
- Verify the AP supplier invoice's workflow state allows editing.
- Verify whether the AP supplier invoice's GL posting date is in an open or closed reporting period.
- Verify that the AP supplier invoice doesn’t have "Liability AP supplier invoices" in its Summary title. You can't edit AP supplier invoices created from credit card charge payoffs. In this scenario, reverse the charge payoff and create a new one.
Edit an unpaid AP supplier invoice in Accounts Payable
-
Go to Accounts Payable > All > AP supplier invoices.
- Find the AP supplier invoice that you want to edit.
- Select More actions > Edit at the end of the row.
- Make your changes.
- Select Post or Submit.
-
Go to Accounts Payable > All > AP supplier invoices.
- Select Edit next to the desired AP supplier invoice.
- Make your changes.
- Select Post or Submit.
Edit an unpaid AP supplier invoice in Purchasing
For AP supplier invoices originating in Purchasing, there might be additional configuration options on the transaction definition that further restrict whether you can edit the purchasing transaction. See Edit a purchasing transaction for details.
What to do when the reporting period is closed
If the reporting period is closed, do one of the following:
- Edit the AP supplier invoice and change the GL posting date to a date in an open period
- Open the reporting period, perform the applicable editing tasks, and close the reporting period
When the reporting period is closed and you need to edit a field that requires journal entries to be re-posted, do one of the following:
- Edit the unpaid AP supplier invoice and change the GL posting date to a date in an open period.
- If it's your company's policy, open the reporting period, edit the unpaid AP supplier invoice, and then close the reporting period.