Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Landed Cost transactions

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

  • Suggested answer
    Richard Whaley Profile Picture
    Richard Whaley 25,195 on at
    Re: Landed Cost transactions

    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.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Landed Cost transactions

    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.  

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans