Editing a Commodity Price after Item in Inventory

Editing a Commodity Price after Item in Inventory

Problem

A commodity has been billed at an incorrect price, items have already been received in inventory, and may have been issued as well.



Step by Step Instructions

A purchase order establishes the unit cost of a commodity. The warehouse processes a RC (receiver) document when the items are received. This adds the commodities (stock items) to inventory at the purchase order unit cost. If the invoice and subsequent payment are for a different unit cost it causes the stock items to be incorrectly priced in the inventory.

The steps to correct the incorrect unit cost depend on two things:

1.) Whether the stock items have been issued or not.
2.) If the payment will exceed the variance tolerance of the purchase order. (Is the payment over the difference allowed between the payment and the purchase order.


Commodity has not been distributed and allowance not exceeded:

      1.)   Pay the PRC at the new price and it will update the unit cost on the purchase order. The change will update the unit for the stock items when issued in the future.


Commodity has not been issued and purchase order tolerance exceeded (purchase order tolerance limit will not allow the PRC to process):

      1.)   Edit the purchase order for the correct unit cost

      2.)   Process the PRC


Commodity has been issued and purchase order tolerance not exceeded:

      1.)   Complete a SN (stock return)

      2.)   Pay the PRC

      3.)   Complete a SRQ (stock requisition) to reissue the items


Commodity has been issued and purchase order tolerance exceeded (purchase order tolerance limit will not allow the PRC to process):

      1.)   Complete a SN (stock return)

      2.)   Cancel the RC (receiver)

      3.)   Edit the purchase order

      4.)  Process the PRC

      5.)   Create new RC (receiver)

      6.)   Complete a SRQ (stock requisition) to re-issue the stock at the correct price.




    • Related Articles

    • QRG - Creating inventory payment

      (A copy of the QRG with screenshots can be found here: https://drive.google.com/file/d/1GBv1GsDsgW4yhk0o_2u7_OPLlwcVX8Ws/view ) Introduction The process is designed to allow the user to enter the quantity on the payment request when the Receiver (RC) ...
    • QRG - Creating a PRC transaction

      (A copy of the QRG with screenshots can be found here: https://drive.google.com/file/d/1aFAJIMFDNd_4H2MVZChVQxA2LsfLRmSG/view ) Introduction This quick reference guide describes how to create a Commodity-based Payment Request (PRC) transaction in new ...
    • Unit Price is not equal to the referenced Unit Price. (A1665)

      Title Unit Price is Not Equal to the referenced Unit Price (A1665) Problem You cannot change the unit price on a payment document that references a Purchase Order (PO, DO, PD). Solution The unit price must be the same on both the payment and the ...
    • QRG - Inventory Freeze and Inventory History

      Description and Purpose To assure accuracy, Inventories are periodically frozen in FINET to allow physical counts of the items in the warehouses. Currently, those with Inventory have selected to freeze entire warehouses to perform the count. However, ...
    • QRG - Item Transaction History

      Description and Purpose Have you ever wanted to know the specific history of a stock item and figuring it out was not easy? You would have to jump around to the various transactions and tables to assess what happened. FINET now has a new query page ...