Josh Thigpen posted on September 18, 2009 12:19
A Novel Use for Landed Cost and an Explanation of Dynamics GP Landed Cost Postings and Options
This week I’ve been working on a deployment where one line of business sells containers of material which is purchased to order. The ultimate goal is to provide them with very accurate margin analysis on these container Sales Transactions both as a business measure and to provide feedback into their quoting process. Our client is coming from QuickBooks where they’ve been using ‘Job Cost’ to accumulate and report on these costs.
Most of these orders are coming overseas and have both import and overland freight and duty fees, etc. etc. associated with them. Since these transactions have variable indirect and direct costs and they’re purchased to order, we needed to come up with a way to track both budgetary and actual costs against a PO without having to go to a Project Solution (which would’ve taken too much setup and maintenance).
We’ve decided we’ll be using Landed Cost as a way to capture import costs against container material that is purchased against Sales Transactions. This gives us both our budget and actual costs and we can pull both the Purchase and Sales sides of this transaction together through the SO/PO link. The following is a write up I did for our client as an explanation of the GL Impacts of using Landed Cost as part of this solution as well as the expected impact(s) on Sales COGS Postings.
The next step in the process will be developing a number of Custom SSRS Reports to provide the multiple output our client would like. Check back for a writeup on the Landed Cost Schema and .rdl downloads.