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)

Landed Cost transactions

(0) ShareShare
ReportReport
Posted on by 75

Here's my setup scenario: Landed cost ID's have been set up for each vendor for both Freight charges (these are set at $0.00 since the freight amount is not known until the invoice is received) and for tax (set at 5%). In addition, landed cost ID's are set up for each vendor that could send a separate shipping bill(freight is not charged by the original vendor on the purchase). The Landed Cost Groups are also set as the vendor ID (this makes it easier for Purchasing to assign the landed cost group on the PO) Each LC Group has both the freight and tax for the original vendor plus any LC id's of those vendors that could send separate shipping invoices (UPS, FedEx). My question is, with each of the potential shipping LC ID's, each time a purchase is made to the vendor, received in by Inventory and an Invoice received, the Match to Shipments window for Landed Costs grows. What is the best way to clear out the lines of the Landed Costs that will never be matched and are for $0.00?

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    on at

    It has been a while - but I am pretty sure I solved this problem by making the Landed Cost for the freight not $0.00 but $.01.  Then you can match at zero to clear if there is actually no Landed Cost.  

  • Suggested answer
    Richard Whaley Profile Picture
    25,195 on at

    I am concerned that you set the LC amounts at $0.00.  This means (unless you are changing the amount before you receive the items) that any actual shipping cost is NOT being absorbed into inventory.  Upon receipt of an inventory item, the cost of that item plus the expected cost of any landed cost as listed in the PO (and associated LC records) at the time of the receipt is debited to inventory (adjusted, of course, if you are using Periodic costs, you did not say).  Then when any invoice is matched (vendor or shipping) any variance is written to PPV, not to inventory.

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