Skip to main content

Recording Price Corrections From the Invoice Workbench

Use a price correction when a supplier sends an invoice for a change in unit price for an invoice you have matched to a purchase order or receipt.
Payables records and updates the invoiced unit price of previously matched purchase order shipments or distributions without adjusting the quantity billed so you can track price variances. Payables also updates the amount billed on the originally matched purchase order distributions.
You can record a simple price correction by entering a credit or debit memo and matching to a purchase order matched invoice. However, we recommend that you record all price corrections by matching to a purchase order or receipt, as described in this document.
To record a price correction for a purchase order shipment or purchase order distribution:
1. Enter the invoice.
If you are recording a price increase, enter a Standard, PO Default, or Mixed invoice. If you select PO Default, then Payables prompts you to enter the PO Number. Payables then automatically defaults the supplier, supplier number, and currency from the purchase order to the Invoices window.
If you are recording a price decrease, enter a Credit Memo or Debit Memo type invoice.
2. Select Purchase Order or Receipt from the Match button poplist, then choose the Match button.
3. In the Find Purchase Orders for Matching or Find Receipts for Matching window, check Price Correction and enter the invoice number for which you are recording the price correction. Enter search criteria for the purchase order(s) or receipts to which you want to match the invoice.
4. Choose the Find button to navigate to the Match to Purchase Orders window or Match to Receipts window.
5. Payables opens the Match to Purchase Orders window or Match to Receipts window.
6. Adjust the invoiced unit price of a previously matched purchase order shipment by matching a price correction to it. To record a price increase for a purchase order shipment, enter the Unit Price for the incremental amount of the price correction, and enter either Quantity Invoiced or Match Amount for each shipment you want to match to. If you enter a value for Quantity Invoiced on a price correction, the quantity is used only to calculate the Match Amount (Quantity Invoiced x Unit Price = Match Amount). Payables does not record this quantity in the Invoiced Quantity field on the credit/debit memo distribution because a price correction does not involve the movement of goods, only an adjustment in the price of previously invoiced goods.
7. If you want to match in further detail, you can match to specific purchase order distributions:
To match to purchase order distributions, choose the Distribute button. Select the purchase order distribution you want to match to and enter the Quantity Invoiced. Payables automatically calculates and enters the remaining field (Quantity Invoiced x Unit Price = Match Amount). The Unit Price defaults from the Match to Purchase Orders window and you cannot change it.
8. Choose Match to save your match.
To review the new invoice distributions, choose the Distributions button in the Invoices window.

Comments

Popular posts from this blog

Applying Prepayments to Invoices

You can apply the available amount of Item type distributions from a Temporary type prepayment to one or more invoices to offset the amount you pay on the invoice(s). If you entered the prepayment as a Permanent type and want to apply it, you can query the prepayment in the Invoices window and change the Prepayment Type to Temporary. If you use Automatic Offsets then your setting for the Prevent Prepayment Application Across Balancing Segments Payables option controls whether you can apply a prepayment to an invoice or expense report with a different balancing segment. Prerequisites The invoice type is Standard, Mixed, or Expense Report. Today's date is on or after the Settlement Date of the prepayment. The invoice date is on or after the date of the prepayment. The prepayment is type Temporary, fully paid, validated, not cancelled, has no active holds, and has not already been fully applied. The prepayment has the same supplier, invoice currency and payment currenc

Application Utilities Lookups and Application Object Library Lookups

Maintain existing and define additional Lookups for your shared Lookup types. You can define up to 250 Lookups for each Lookup type. Each Lookup has a code and a meaning. For example, Lookup type YES_NO has a code Y with meaning Yes, and a code N with a meaning No. Note: In Releases 11.0 and earlier, there were two Lookup features, Special Lookups and Common Lookups. These two features have been merged into one. The new consolidated Lookups feature has Lookups maintained in this form. If you make changes to a Lookup, users must log out then log back on before your changes take effect. Lookups Block Type Query the type of your Lookup. You can define a maximum of 250 Lookups for a single type. User Name The user name is used by loader programs. Application Query the application associated with your Lookup type. Description If you use windows specialized for a particular Lookup type, the window uses this description in the window title. Access Level The access level restricts changes that

Matching Prepayments to Purchase Orders

You can match a prepayment to a purchase order or receipt. The accounting entries for Item distributions on a matched prepayment typically debit a prepayment account that Payables provides. However, during prepayment entry you can override any account that Payables defaults or builds. Payables does not create an encumbrance entry for the prepaid amount when a prepayment is matched to a purchase order. The match is treated like a reservation of the quantity billed. Payables does not calculate the invoice price variance or exchange rate variance at this point. Furthermore, you cannot change the unit price during the prepayment match to purchase order. A final match to the purchase order is not allowed either. When the matched prepayment is applied to an invoice, Payables reverses the matched quantity on the prepayment to reflect the balance of the total quantity matched. The following example illustrates a prepayment application to a purchase order: You contract to attend a $5,000 trade