Is there a way I can have one sales item post to two or more general ledger accounts?
I am aware of the use of Kits; but I only know how that will allow you to post to two COGS accounts.
If anyone has any suggestions, I would appreciate it.
You could potentially make use of Allocation Accounts.
Can you tell us more about what determine which accounts would get used, or perhaps provide an example?
Flexicoder from eOne can recode Sales accounts in Sales Order Processing. But, in the end only one account (out of many,many possible accounts) is posted to.
I'm not sure if you can have an Allocation account as a Sales Distribution account (I've never tried, but I think it would work). You would have to test.
The only other way to do it would be manually (i.e. manually create the extra distribution entries for each Sales Order) Ugly, but it works.
Hi Justin and Tim,
Thanks for your quick response because we are of course in the middle of billing.
There are three Sales Items Monthly Marketing Fee $100 mapped to Sales account 41000, Marketing Fee 2012 $10 account 41100, Marketing Fee 2013 $20 41200.
I want to have one line item on the customer bill show "Marketing Fees" for $130 that map to $100 to Sales Account 41000, $10 to account 41100 and $20 to 41200
I have never used the allocation feature. I forgot to mention, we import the sales transactions through Integration Manager each month (Over 1,000 customers so this would be 3,000 items
Appreciate any help
This is a common requirement that I have commonly seen in various distribution companies, and this can simply be covered in Dynamics GP as part of the standard functionality of the system.
To fulfill this, you will have to consider what's called "Site Segment" or inventory account flipping, which allows you to change the Inventory, COGS, Markdown, Sales and Sales return account based on the site segment.
Allow me to visually illustrate the meaning of this feature:
Suppose that your account format is as showing below:
Now, in the inventory control, you need to configure the flipping feature by setting up the system to consider the "Division" segment.
Now your item will be linked to a general set of accounts, or lets say the default set of accounts. as showing below:
As showing below, the segment two (Division) is by default (001) which is general. So if you go to the item maintenance, you should find the item linked to these account by default.
Now on the site setup window, you should link a specific site to a specific segment so that once an item is sold, or adjusted on this site, the item account will be changed according to the specified segment
Lets suppose you have two sites, Local and Export. The item is linked to the accounts mentioned above
To sell the item and affect Export Account, you will have to transfer the item from the general site to the Export site. Then post the invoice from the Export site. Once posting the sales invoice, the following journal will be generated:
AR (from customer card)
You do need to refer back to the documentation and check the use of the account segment on the site level, here is part of the documentation which shall be quite important for this case
Your feedback is highly appreciated,
Never hesitate to share any further inquiries,
I recommend you have a read of the allocation accounts features in the GeneralLedger.pdf
Chapter 5, “Fixed allocation accounts,” and Chapter 6, “Variable allocation accounts.”
...Then do some testing/playing in a test company.
After that, let me know how it goes and if you have some specific questions I'm happy to help.
Justin and Tim,
The suggestion to use a Fixed Allocation account works great. Billing will be out and you just made me look like a great to management.
Have a great day
Thank you for your suggestion. Yes we use various segments, but I was able to create a fixed allocation account and this solved our problem.
Thank you for posting a suggested answer. Have a great day.
Tim, Thank you for your suggestion to use Allocation Accounts. It worked beautifully.
It is great to have your issue settled Marcia , never forget to close the case by verifying the proper answer.
Is there a similar solution to this problem for MS Dynamics Nav 2013 R2? I am looking for a way to post to different sales account for the sale of 1 item - Example Item A total cost is $150, which may come from different components such as $10 for Packaging, $40 for Misc Cost and $100 for Materials. I only want the customer to see Item A with a Cost of $150 but I want to Post to the 3 various G/L Sales accounts with the required amounts? Can this be done in Dynamics Nav without development?