Edit a paid AP supplier invoice
For the purposes of editing, a AP supplier invoice is considered paid if it is:
-
Selected for payment
-
Partially paid
-
Fully paid
Compared to unpaid AP supplier invoices, paid AP supplier invoices have more restrictions in terms of what you can edit. Your options are also affected by factors such as the AP supplier invoice state, your configuration, and where the AP supplier invoice originated.
If you need to make a change that requires journal entries to be posted, the reporting period in which the transaction's GL posting date falls must be open.
| 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 paid AP supplier invoices
You can only edit AP supplier invoices that originated in Accounts Payable within the same application.
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 non-posting fields for AP supplier invoices that originated in Purchasing only in Accounts Payable and you can reclassify the AP supplier invoice. For most changes, however, you’ll need to start over.
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 could have different names like "PO bill", "Receipt", and so on.
AP supplier invoices created from charge payoffs
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 cannot be edited. You can only reverse the payment, reverse the charge payoff, and then 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".
AP supplier invoices created from manual payments
When you create a manual payment in Cash Management, it creates an AP supplier invoice in Accounts Payable with a state of Paid. This AP supplier invoice cannot be edited. You can only reverse the manual payment and create a new one.
These AP supplier invoices appear in the AP supplier invoices list with a Summary title of "Quick Payments: <date> Batch:. For example, "Quick Payments: 2020/07/15 Batch".
Edit non-posting fields in a paid AP supplier invoice
When a AP supplier invoice's state is Paid, Partially paid, or Selected, you can only edit fields that do not post to the GL. You can edit these fields when the reporting period is closed because they do not require journal entries to be posted.
If the AP supplier invoice originated in Purchasing, you cannot edit non-posting fields in the purchasing transaction, but you can edit them in the AP supplier invoice.
The following table shows the non-posting fields that you can edit in an AP supplier invoice. All other fields are considered posting fields.
| 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? |
| Supplier document number/AP supplier invoice number | No | Yes | Yes |
| 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 |
| (line item) Memo | No | Yes | Yes |
*For Partially paid AP supplier invoices, only.
To edit non-posting fields in a paid AP supplier invoice:
-
Go to Accounts Payable > All > AP supplier invoices.
- Select Edit next to the AP supplier invoice you want to change.
- Change the non-posting fields as applicable.
- Select Save.
Edit an AP supplier invoice that has been selected for payment
The Selected state indicates that the AP supplier invoice has been selected for payment but the payment has not been processed. A payment request was created that includes the AP supplier invoice.
When an AP supplier invoice's state is Selected, you can only edit fields that do not require journal entries to be posted. See the Edit non-posting fields in a paid AP supplier invoice.
For these AP supplier invoices, to edit fields that require posting, you need to reset the AP supplier invoice state to Posted, first.
To reset a Selected AP supplier invoice to Posted and edit the AP supplier invoice:
-
Do one of the following:
Either method sets the AP supplier invoice's state back to Posted and the AP supplier invoice is considered unpaid.
- To change the AP supplier invoice, see edit an unpaid AP supplier invoice.
Change the GL account or dimensions for line items
To change the GL account, department, location, or other dimension values for an AP supplier invoice line item in a Paid or Partially paid AP supplier invoice, you need to reclassify the AP supplier invoice.
You can reclassify an AP supplier invoice when all of the following conditions are met:
- The Enable reclassification for AP supplier invoices and adjustments option is selected in Configure Accounts Payable
- You have the AP supplier invoices: Reclassify permission
- The AP supplier invoice wasn’t paid by a credit card
- The AP supplier invoice date is in an open period
If any of the above conditions are not met, you cannot reclassify the AP supplier invoice. In this scenario, start over.
You cannot use the reclassify function to change the dimensions on lines that are allocated. In this scenario, start over.
If you reclassify an AP supplier invoice in Accounts Payable that originated in Purchasing, the change will not be made to the Purchasing transaction. If you want the change to be made in Purchasing, start over.
To reclassify an AP supplier invoice:
-
Go to Accounts Payable > All > AP supplier invoices.
- Select Edit next to the Paid or Partially paid AP supplier invoice you want to change.
- Select Reclassify.
- Edit the line items as applicable.
- Select Save.
You can also use the reclassify function to update 1099 information for suppliers who are set up for 1099 treatment. See Reclassify an AP supplier invoice in Accounts Payable for details.
Change the amount that you owe a supplier
You cannot edit the line item amounts in a Paid or Partially paid AP supplier invoice. In this scenario, you can create an adjustment for the applicable amount.
If you overpaid the supplier, create a debit memo (which becomes a supplier credit). If you underpaid the supplier, create a credit memo (which becomes an AP supplier invoice that you pay).
You can create adjustments in either Accounts Payable or Purchasing. The best practice is to create the adjustment in the application in which the AP supplier invoice originated. So if the AP supplier invoice originated in Purchasing, convert the PO purchase invoice to a debit memo or credit memo in Purchasing.
Learn how to create an Accounts Payable adjustment.
Learn how to convert a Purchasing transaction.
Change the supplier or GL posting date, add or remove line items, or allocate line items
You cannot change the supplier, GL posting date, or line item data like the Billable flag for line items, and you cannot add line items or allocate line items in a Paid or Partially paid AP supplier invoice. If you need to make these types of changes, start over.
Start over
Starting over with a paid AP supplier invoice means that you void the payment, reverse any adjustments, and then reverse the AP supplier invoice, which effectively zeroes out the transaction. Then you can add a new AP supplier invoice with the correct information and process the payment as applicable.
Accounting flow for AP supplier invoice with no supplier credits
The following example shows the accounting flow for an AP supplier invoice with one expense line item for R100.00. After the AP supplier invoice was paid, the payment was voided and the AP supplier invoice was reversed.
| Event date | GL posting date | Event | Accounts Payable account | GL account for expense | Payment account | Journal |
|---|---|---|---|---|---|---|
| January 15 | January 15 | Create the AP supplier invoice | Credit 100 | Debit 100 | Accounts Payable | |
| January 28 | January 28 | Pay the AP supplier invoice/Process the payment | Debit 100 | Credit 100 | Cash Disbursal | |
| February 2 | January 28 | Void the payment | Credit 100 | Debit 100 | Cash Disbursal | |
| February 2 | January 15 | Reverse the AP supplier invoice | Debit 100 | Credit 100 | Accounts Payable |
Accounting flow for AP supplier invoice with supplier credit adjustment
The following example shows the accounting flow for an AP supplier invoice with one expense line item for R100.00 and that also had a supplier credit (debit memo adjustment) for R25.00 applied during Pay AP supplier invoices. After the AP supplier invoice was paid, the payment was voided, the adjustment was reversed, and finally the AP supplier invoice was reversed.
| Event date | GL posting date | Event | Accounts Payable account | GL account for expense | Payment account | Journal |
|---|---|---|---|---|---|---|
| January 15 | January 15 | Create the AP supplier invoice | Credit 100 | Debit 100 | Accounts Payable | |
| January 17 | January 17 | Create the debit memo adjustment | Debit 25 | Credit 25 | Accounts Payable | |
| January 28 | January 28 | Pay the AP supplier invoice/Process the payment | Debit 75 | Credit 75 | Cash Disbursal | |
| February 2 | January 28 | Void the payment | Credit 75 | Debit 75 | Cash Disbursal | |
| February 2 | January 17 | Reverse the debit memo adjustment | Credit 25 | Debit 25 | Accounts Payable | |
| February 2 | January 15 | Reverse the AP supplier invoice | Debit 100 | Credit 100 | Accounts Payable |
Accounting flow for AP supplier invoice with Inline credit
An inline supplier credit is a negative line item in an AP supplier invoice. If you applied the entire negative line amount to the same AP supplier invoice in which the negative line exists, you can simply void the payment and reverse the AP supplier invoice as reversing the AP supplier invoice will also reverse the credit. However, if you applied part or all of the negative line item to a different AP supplier invoice and that AP supplier invoice is also paid, then you’ll have to void the payment for that AP supplier invoice in addition to the AP supplier invoice you want to change.
The following example shows the accounting flow for an AP supplier invoice with one expense line item for R100.00 and an inline credit line item of: R25.00. The entire inline credit was consumed by this AP supplier invoice. After the AP supplier invoice was paid, the payment was voided and the AP supplier invoice was reversed.
| Event date | GL posting date | Event | Accounts Payable account | GL account for expense | Payment account | Journal |
|---|---|---|---|---|---|---|
| January 15 | January 15 | Create the AP supplier invoice | Credit 100 | Debit 100 | Accounts Payable | |
| Debit 25 | Credit 25 | Accounts Payable | ||||
| January 28 | January 28 | Pay the AP supplier invoice/Process the payment | Debit 75 | Credit 75 | Cash Disbursal | |
| February 2 | January 28 | Void the payment | Credit 75 | Debit 75 | Cash Disbursal | |
| February 2 | January 15 | Reverse the AP supplier invoice | Credit 25 | Debit 25 | Accounts Payable | |
| Debit 100 | Credit 100 | Accounts Payable |
Start over with AP supplier invoices originating in Accounts Payable
If you paid the entire AP supplier invoice with one payment method and didn't apply any adjustments, you can void the payment and reverse the AP supplier invoice at the same time in the applicable register. Otherwise, void the payment where applicable, reverse the adjustment, and then reverse the AP supplier invoice from the AP supplier invoices list.
To start over with an AP supplier invoice that originated in Accounts Payable:
- Void the payment. Use the payment date as the void date. Where you void the payment depends on how you paid the AP supplier invoice. For example, if you paid with a cheque you would void the payment in the Cheque Register.
- If an adjustment was applied to the AP supplier invoice, reverse the adjustment. Use the adjustment transaction date as the reverse date. The AP supplier invoice's state is now Posted.
-
Reverse the AP supplier invoice.
-
Go to Accounts Payable > All > AP supplier invoices.
- Find the AP supplier invoice that you need to reverse.
-
Select More actions > Reverse at the end of the row.
- Use the calendar tool to select the Reverse the transaction on date. Use the AP supplier invoice's GL posting date as the reverse date.
- Enter the reason for the reversal and any other pertinent information in the Memo field.
- Select Submit.
-
- Create a new AP supplier invoice.
- Void the payment. Use the payment date as the void date. Where you void the payment depends on how you paid the AP supplier invoice. For example, if you paid with a cheque you would void the payment in the Cheque Register.
- If an adjustment was applied to the AP supplier invoice, reverse the adjustment. Use the adjustment transaction date as the reverse date. The AP supplier invoice's state is now Posted.
-
Reverse the AP supplier invoice.
-
Go to Accounts Payable > All > AP supplier invoices.
- Select Reverse next to the applicable AP supplier invoice.
- Use the calendar tool to select the Reverse the transaction on date. Use the AP supplier invoice's GL posting date as the reverse date.
- Enter the reason for the reversal and any other pertinent information in the Memo field.
- Select Submit.
-
- Create a new AP supplier invoice.
Start over with AP supplier invoices originating in Purchasing
If the AP supplier invoice originated in Purchasing, you still need to void the payment and reverse any adjustments. However, there's no reverse function for AP supplier invoices that originated in Purchasing. Instead, you need to create an adjustment that zeroes out the effects of the AP supplier invoice and then apply the adjustment to the AP supplier invoice.
To zero out the AP supplier invoice, you can either convert the source purchasing transaction to a purchasing adjustment transaction (debit memo) or you can create a debit memo adjustment in Accounts Payable. The best practice is to convert the purchasing transaction as the purchasing transaction might also affect inventory totals and values.
To start over with an AP supplier invoice that originated in Purchasing:
- Void the payment. Use the payment date as the void date. Where you void the payment depends on how you paid the AP supplier invoice.
- If an adjustment was applied to the AP supplier invoice, reverse the adjustment. Use the adjustment transaction date as the reverse date. The AP supplier invoice's state is now Posted.
-
Reverse the effects of the AP supplier invoice.
-
Do one of the following:
- Convert the Purchasing transaction to a Purchasing adjustment transaction (debit memo) or
- Create a debit memo adjustment in Accounts Payable. The adjustment must have the same number of AP supplier invoice line items and use the same accounts, same amounts, and same dates as the AP supplier invoice.
-
Go to Accounts Payable > All > AP supplier invoices.
- Filter the list for the applicable supplier.
- Select Line details next to the applicable AP supplier invoice.
- Select Credit details next to an AP supplier invoice line item
- Select the checkbox next to the matching credit from the debit memo that you created in step a. and then select Save. This applies the credit to the AP supplier invoice line item.
- Repeat steps e and f for each AP supplier invoice line item.
- Select Save.
- In the Pay AP supplier invoices page, select the AP supplier invoice and select Pay now. This removes the AP supplier invoice from your supplier aging report.
-
- Create a new purchasing transaction.
- Void the payment. Use the payment date as the void date. Where you void the payment depends on how you paid the AP supplier invoice.
- If an adjustment was applied to the AP supplier invoice, reverse the adjustment. Use the adjustment transaction date as the reverse date. The AP supplier invoice's state is now Posted.
-
Reverse the effects of the AP supplier invoice.
-
Do one of the following:
- Convert the Purchasing transaction to a Purchasing adjustment transaction (debit memo) or
- Create a debit memo adjustment in Accounts Payable. The adjustment must have the same number of AP supplier invoice line items and use the same accounts, same amounts, and same dates as the AP supplier invoice.
-
Go to Accounts Payable > All > AP supplier invoices.
- Filter the list for the applicable supplier.
- Select Line details next to the applicable AP supplier invoice.
- Select Credit details next to an AP supplier invoice line item
- Select the checkbox next to the matching credit from the debit memo that you created in step a. and then select Save. This applies the credit to the AP supplier invoice line item.
- Repeat steps e and f for each AP supplier invoice line item.
- Select Save.
- In the Pay AP supplier invoices page, select the AP supplier invoice and select Pay now. This removes the AP supplier invoice from your supplier aging report.
-
- Create a new purchasing transaction.
What to do when the reporting period is closed
If the reporting period is closed, do one of the following:
- Open the reporting period, perform the applicable editing tasks, and close the reporting period
- Make GL journal entries in the current period to correct the applicable account balances