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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Applying Add On Cost To Purchase Order / Invoice

(0) ShareShare
ReportReport
Posted on by 20

Is there an easy way to apply Additional Costs (eg, Freight, Cartage, etc.) to an original Purchase Order or Invoice so that the correct cost is reflected for the Finished Good or Item.  The Additional costs could potentially be from different vendors with different invoice numbers, so the objective would be a way to link all of those cost to the cost of the product.

 

*This post is locked for comments

I have the same question (0)
  • Beth Hodge Profile Picture
    65 on at

    I think you need to use Landed Cost.  I'm about to submit a related question myself.

  • GOYAJR Profile Picture
    35 on at

    Beth, if you get any reply to your question, please let me know.  I was under the impression that although not the easiest of tasks it was possible.

     

    thanks

  • Sam.Ye Profile Picture
    20 on at
    I would also like to know.
  • Beth Hodge Profile Picture
    65 on at

    Here's a paste of the information I got from Christina at Microsoft regarding my Landed Cost questions.  I think you'll find information about what LC does and how to set it up. 

    -Beth

    Hi Beth--

     

    Landed cost may help you on the purchasing side, but it would not pass directly through to sales order.  What landed cost does is include an additional cost in the item itself (so it gets posted to the inventory layer with a greater cost, that includes the landed portion).  So it rolls the landed cost in to the inventory cost.  It will not work with drop ship items.  However (and I did not test it all the way out) it does look like you could use it with non inventory items.

     Landed cost is set up in three parts...Cards>>Inventory>>Landed Cost, set up the individual costs you want to attribute (mark match to invoice if you want to match the cost to the actual freight invoice or whatever).  Cards>>Inventory>>Landed Cost Groups, to establish common groups of landed costs that are applied to purchase orders.  Cards>>Inventory>>Quantities/Sites to specify a specific landed cost group for a certain item/site combination.


    Then when you enter a purchase order, you can click on the line item and use the item number expansion to view the detail, and there will be a landed cost group id (defaulted from quantities/sites) and you can change it if desired (or manually enter the landed cost group if there was no default).

     Then when you receive, you can also see/change the landed cost group ID by using the expansion arrow next to the Item Number field again.  Or to see the individual landed costs calculated on the line (and modify the individual landed costs, even adding others) you can use the expansion next to unit cost.    You can also use the landed costs button at the bottom of the receivings window to apportion landed cost across the entire document (for example, take one landed cost for a total amount and apportion it to the line items based on weight, quantity, extended cost, etc).

     If you have chose to match to invoice for the landed cost, you can then later enter an invoice from the freight company using Transactions>>Purchasing>>Enter/Match Invoice (even though you have no PO from the freight company) and on the line item mark the LC checkbox (which means match to landed cost).  The system will then display any prior received landed costs that can be matched to for that vendor.

     I know this is a bit much to absorb, so post back if you need more explanation.  I find that the help screens in GP itself are more helpful than the manual in understanding it.


    Take care,

    Christina

  • Beth Hodge Profile Picture
    65 on at

    Here's a paste of the information I got from Christina at Microsoft regarding my Landed Cost questions.  I think you'll find information about what LC does and how to set it up. 

    -Beth

    Hi Beth--

     

    Landed cost may help you on the purchasing side, but it would not pass directly through to sales order.  What landed cost does is include an additional cost in the item itself (so it gets posted to the inventory layer with a greater cost, that includes the landed portion).  So it rolls the landed cost in to the inventory cost.  It will not work with drop ship items.  However (and I did not test it all the way out) it does look like you could use it with non inventory items.

     Landed cost is set up in three parts...Cards>>Inventory>>Landed Cost, set up the individual costs you want to attribute (mark match to invoice if you want to match the cost to the actual freight invoice or whatever).  Cards>>Inventory>>Landed Cost Groups, to establish common groups of landed costs that are applied to purchase orders.  Cards>>Inventory>>Quantities/Sites to specify a specific landed cost group for a certain item/site combination.


    Then when you enter a purchase order, you can click on the line item and use the item number expansion to view the detail, and there will be a landed cost group id (defaulted from quantities/sites) and you can change it if desired (or manually enter the landed cost group if there was no default).

     Then when you receive, you can also see/change the landed cost group ID by using the expansion arrow next to the Item Number field again.  Or to see the individual landed costs calculated on the line (and modify the individual landed costs, even adding others) you can use the expansion next to unit cost.    You can also use the landed costs button at the bottom of the receivings window to apportion landed cost across the entire document (for example, take one landed cost for a total amount and apportion it to the line items based on weight, quantity, extended cost, etc).

     If you have chose to match to invoice for the landed cost, you can then later enter an invoice from the freight company using Transactions>>Purchasing>>Enter/Match Invoice (even though you have no PO from the freight company) and on the line item mark the LC checkbox (which means match to landed cost).  The system will then display any prior received landed costs that can be matched to for that vendor.

     I know this is a bit much to absorb, so post back if you need more explanation.  I find that the help screens in GP itself are more helpful than the manual in understanding it.


    Take care,

    Christina

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans