web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

How can I fix a posted PO-Rcpt-Inv with an omitted Landed Cost?

(0) ShareShare
ReportReport
Posted on by 815

I have an odd situation.  We placed a purchase order for an item but omitted the landed cost.  When the product was received, the receiving entry was made, but when the invoice was received, it had an extra freight charge on it that didn't match the PO. (NB: we were aware of the charge, it just wasn't entered as part of the landed cost)  When the Purchasing Invoice Entry was done, that amount was put directly into the inventory GL account.

We use weighted average costing for this item.  I'm pretty sure that the current cost of the item is understated by the amount of the freight.

Example for clarity:

PO for 1000 items @ $50 = $50k

Freight, added by the vendor = $5k

We received the product & created the receiving transaction:

Debit 'Inventory' $50k, Credit 'Accrued Inventory' $50k

We received the Invoice:

Debit 'Accrued Inventory': $50k, Debit 'Inventory': $5k, Credit 'AP': $55k

So, if I understand it correctly, the current (average) cost of my inventory is $50, and I have 1000 of them in stock, but the Inventory GL contains $55k.

I am, obviously, working with the pruchaser to ensure that the proper landed costs are configured to prevent recurrence, but is there an accepted way to fix this?  (everything is posted - the error wasn't caught until the end of the month)

Thanks, in advance!

D

*This post is locked for comments

I have the same question (0)
  • Dan Liebl Profile Picture
    7,320 on at

    You could use the Adjust Costs window (Utilities>Inventory) to change the layer valuation.   Just watch the GL so the entry created does not hit the GL.   Your GL appears to be correct based on the entries referenced above.

    Dan Liebl, CMA CPIM

    OTT,Inc

    dliebl@OTT-inc.com

  • Dee Bee Profile Picture
    815 on at

    Thanks Dan-

    I just tried that (in our trial DB), and it created the GL entry account as well.  I adjust costs on the receipt from $50/unit to $55/unit, and the item cost is adjusted properly, but the GL Entry shows Dr Inventory, Cr Inv.Offset of the $5k ($5 * 1000 OHQty)

    Is that to say that "That's how to do it, but then you have to adjust the GL back out to the Offset account" in order to not affect the Inventory GL?  (Because it was 'adjusted' in originally)?

  • Dan Liebl Profile Picture
    7,320 on at

    Yes so you will want to reverse the adjust cost entry so you will dr IV Offset and cr Inventory.  The IV GL  was updated on the invoice matching so you don't want to duplicate it.

    Dan Liebl, CMA CPIM

    OTT,Inc

    dliebl@OTT-inc.com

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans