We are on GP8 sp3.
IN SOP the distribution for Sales, COGS, Inventory (and a few others) are all determined by the site ID for Branch segment substitution. Our site ID equals a physical retail branch or warehouse. We also have sales territories set up for each branch and various sales people assinged to these territories.
Our retail branches are measured and remunerated on their Gross Profit (using FRx reports). There is no balance sheet reporting for branches although there are a few balance sheet accounts for each branch.
The issue - One branch (e.g. WN) does all the work for a sale but the goods get delivered from a warehouse or another branch (e.g. LH). ON the sales order the sales person and sales territory (WN) But the site ID changes to where the physical stock is being delivered from (LH). This results in the Sales, cost and inventory distributions going to LH branch that did none of the hard work. So the manager of the WN branch (that did all the work) gets frustrated as he misses out on revenue.
Is anyone aware of any 3rd party products or customisations where the distribution substitution for Inventory is driven from the Site ID but the sales/COGS distribution substitution are driven from the sales territory? Any other comments would be appreciated.
Hi, I came across this in another post and it might be worth taking a look:
If it sorts your issue, let us know.
Ian Stewart MVP - International support for Dynamics GP. Local knowledge, local timelines, local GP talent. Genesys Financial Systems (Europe) Microsoft Gold Certified Partner http://dynamicsgp.wordpress.com/
I would take a look at Flexicoder by eOne to see if it can accomplish what you want. http://www.eonesolutions.com.au/Content.aspx?page=Flexicoder
Victoria Yudin - Dynamics GP MVP (2005-2014)
Want to use Crystal Reports or SSRS with Dynamics GP? Check out GP Reports Viewer
Here's a bit of a low-tech solution; why not leave out the Sales & Cogs distribution in the Site ID and instead put it in at the customer level? The customer card allows for each of those accounts.
Might be worth 15 minutes to test out?
Other Microsoft Sites
I'm a Customer
I'm a Partner
Follow Microsoft Dynamics