Microsoft Dynamics GP (Archived)

Multiple General Ledger Sales accounts for Sales item

(0) Share

Report

Posted on by Community Member Microsoft Employee

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.

*This post is locked for comments

All responses (10)

Answers (1)

Community Member Microsoft Employee on at

Like (0)

Report

RE: Multiple General Ledger Sales accounts for Sales item

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?
Mahmoud Saadi 32,738 on at

Like (0)

Report

RE: Multiple General Ledger Sales accounts for Sales item

It is great to have your issue settled Marcia , never forget to close the case by verifying the proper answer.

Never hesitate to share any further inquiries,
Community Member Microsoft Employee on at

Like (0)

Report

RE: Multiple General Ledger Sales accounts for Sales item

Tim, Thank you for your suggestion to use Allocation Accounts. It worked beautifully.
Community Member Microsoft Employee on at

Like (0)

Report

RE: Multiple General Ledger Sales accounts for Sales item

Mahmoud,

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.
Community Member Microsoft Employee on at

Like (0)

Report

RE: Multiple General Ledger Sales accounts for Sales item

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

Marcia
Justin Thorp 2,265 on at

Like (0)

Report

RE: Multiple General Ledger Sales accounts for Sales item

Hi Marcia,

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.

Thanks,

Justin
Verified answer

Mahmoud Saadi 32,738 on at

Like (0)

Report
RE: Multiple General Ledger Sales accounts for Sales item

Hello Marcia

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:

Segment One | Main Account

Segment Two |Division

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.

Inventory Account                     |    11601-001

COGS Account                           |    51104-001

Sales Account                            |    41101-001

Inventory Offset Account           |    51104-001

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:

Inventory   (11601-003)

COGS (51104-003)

AR (from customer card)

Sales (41101-003)

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,

Community Member Microsoft Employee on at

Like (0)

Report

RE: Multiple General Ledger Sales accounts for Sales item

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

Marcia
Suggested answer

Tim Foster 8,515 on at

Like (0)

Report

RE: Multiple General Ledger Sales accounts for Sales item

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.

Tim
Justin Thorp 2,265 on at

Like (0)

Report

RE: Multiple General Ledger Sales accounts for Sales item

Hi Marcia,

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?

Thanks,

Justin