Multiple General Ledger Sales accounts for Sales item

Question Status

Verified
Marcia asked a question on 14 Apr 2015 7:26 AM

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.

Reply
Justin Thorp responded on 14 Apr 2015 7:43 AM

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

Reply
Suggested Answer
Tim Foster responded on 14 Apr 2015 7:46 AM

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

Reply
Marcia responded on 14 Apr 2015 8:23 AM

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

Reply
Verified Answer
Mahmoud M. AlSaadi responded on 14 Apr 2015 9:14 AM

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.

  1. Inventory Account                     |    11601-001
  2. COGS Account                           |    51104-001
  3. Sales Account                            |    41101-001
  4. 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,

Reply
Justin Thorp responded on 14 Apr 2015 9:27 AM

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

Reply
Marcia responded on 14 Apr 2015 1:54 PM

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

Reply
Marcia responded on 20 Apr 2015 7:39 AM

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.

Reply
Marcia responded on 20 Apr 2015 7:40 AM

Tim, Thank you for your suggestion to use Allocation Accounts.  It worked beautifully.

Reply
Mahmoud M. AlSaadi responded on 20 Apr 2015 8:14 AM

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

Never hesitate to share any further inquiries,

Reply
Pasta responded on 18 Dec 2015 3:39 PM

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?

Reply
Verified Answer
Mahmoud M. AlSaadi responded on 14 Apr 2015 9:14 AM

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.

  1. Inventory Account                     |    11601-001
  2. COGS Account                           |    51104-001
  3. Sales Account                            |    41101-001
  4. 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,

Reply
Suggested Answer
Tim Foster responded on 14 Apr 2015 7:46 AM

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

Reply