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

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

GP 2010 Landed cost question

(0) ShareShare
ReportReport
Posted on by 75,848 Moderator

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

I have the same question (0)
  • Richard Wheeler Profile Picture
    75,848 Moderator 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
    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

Responsible AI policies

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

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 2

#1
babubaskaran@outlook.com Profile Picture

babubaskaran@outloo... 2

#1
Yng Lih Profile Picture

Yng Lih 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans