Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

GP 2010 Landed cost question

Posted on by 75,730

I was testing to see if landed cost was a way to solve a problem and I have found it solves one problem but creates another.

Let's say I sell fuel and there is an additional 5 cent charge per gallon. I come along and order 1,000 gallons at $4.00 per gallon.

In inventory I now see a receipt for 1,000 gallons at $4.05 per gallon. So inventory is good.

However, when doing the shipment I see it hitting the IV account once for $4,000 and another time for $50. When I come along and do the invoice match, it only recognizes the initial $4,000 so the vendor is going to be shorted $50. The vendor needs to get a check for $4,050. What setting am I missing so the invioce match will pull the total cost to go on the invoice?

 

 

*This post is locked for comments

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    Re: GP 2010 Landed cost question

    Dan, I actually found a youtube video made by RoseASP that desribed the procedure exactly as you described. We need to show the landed cost amout plus the item cost as one payable amount plus adjust the cost of the item. I never paid attention to the LC column on the invoice match screen before. Well I finally found a use for it!

  • Dan Liebl Profile Picture
    Dan Liebl 7,320 on at
    Re: GP 2010 Landed cost question

    Richard, in going with the 'KISS' method, I would just change the receipt cost to $4.05 a gallon.  I think LC was designed with a different vendor in mind (tarif freight).     Getting back to this situation, did you set up the LC to invoice match?   If so, you would have to do a second match for the fuel surcharge.  The vendor would have a $4,000 invoice and a $50 invoice so the correct amount would be reflected.  

    Dan Liebl, CMA CPIM | Senior Consultant | 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

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