Featured Post

Dynamics GP 2018 is now Released

It is officially published that Microsoft Dynamics GP 2018 is available, the download link is provided below: Product download page ...

Friday, April 4, 2014

Cost Adjustment (2 out of 4) Shipment and Enter Match Invoice


In the previous post of this series ; Cost Adjustment (1 of 4) Override Documents, the first of four scenarios in which cost variance documents are calculated was thoroughly explained. In this post, we will move on with the second scenario of cost adjustment.
When using the shipment – enter match approach, the cost recorded at the shipment could be different than the one on the invoice. For instance, we received one piece of item (X) with cost of 150, then upon receiving the invoice it shows that the cost is different like 160. The following journal entries are recorded;

Business Perspective

Upon Receiving | Purchasing > Transactions > Receiving Transaction Entry (Shipment)

1

Upon Invoicing | Purchasing > Transactions > Enter Match Invoice

2

Technical Perspective

Once the shipment is posted, the following records will be written in inventory tables

3









Now, when an invoice with different unit cost (160) is matched to the shipment, a new cost adjustment record is thrown in SEE30303 (HITB), as well as other modifications in other tables;

3

  • IV30300 records an addition record with the total difference as an extended cost
  • IV10200 updates the unit cost field with the new unit cost, while the old unit cost is saved in another field which is ADJUNITCOST, Adjusted Unit Cost
  • SEE30303 records an addition record with all the cost adjustment details. Unit cost, extended cost and the associated Journal Entry created on the general ledger level
Helping Note !

This scenario supposes that the shipment is not consumed at all until the time that the invoice is recorded. The third scenarios of this series illustrate how sales documents posted before the invoice is recorded will be updated accordingly to reflect correct cost of goods sold.
Best Regards,
Mahmoud M. AlSaadi

2 comments:

  1. I don't find the 3th and 4th part. Could you send me the link please?

    Thanks
    m.suarez@bona.com.do

    ReplyDelete
    Replies
    1. Hello there,
      I am currently working on them, they will be published soon on this blog.
      Thanks for your inquiry,

      Best Regards,

      Delete