Dynamics Community Forum Thread Details

GL Distribution altered upon invoicing

Good morning,

Just curious if anyone would have an idea on why when we invoice our GL distribution was altered from what we prefer the GL to be based on Customer Maintenance?

We have it set up in Maintenance to go to SALES in a certain GL...but once it invoiced, it was altered to an adjustment GL we have set up.

Any particular reason this would occur?

Categories:

Financial Management

When you look at the posted invoice and the distributions window, is it changed there too? Or is it only changed in the GL?

The only feature that changes the accounts from a GP perspective is Site Segments, but you will see that change BEFORE you post the invoice. Especially for the Sales account. However, this feature is for ONE segment only. In your case it looks like more than one segment was changes as the Sales account went from

8-000-4800-000 to

1-000-4930-000

That is a change to the 1st and the 3rd segment.

So, first thing I would check is to see if there is a site segment that might be coming into play. On the invoice, look to see what site was used on the line item. Then go to Cards > Inventory > Site and pull up the site. At the bottom of the screen, you will see "Account Segment ID". If this is populated look to see what division, it's set to and that might be part of the issue. It's coded to put that segment to that value if the account exists. Plus, you would see this change on the actual posted invoice.

The article below describes this functionality.

support.microsoft.com/.../how-to-set-up-the-account-segment-id-per-site-id-in-inventory-in-microsoft-dynamics-gp-44131145-c60a-4ed3-255e-b45cf716d843

Now for the other segment, I'm not sure why that is happening on two. I know other 3rd parties do that so see what else you might have installed under Customization status. Microsoft Dynamics GP >Tools > Customize > Customization Status. I personally came accross one product when troubleshooting called " Override General Ledger Accounts "offered by InterDyn. This add-in does allow the segment override by item or customer, and it can be done on all SOP documents. So, if user is overriding say site and also a customer segment (AKA more than one segment) then it might be this product.

Hope this is helpful.

Thanks for using Microsoft Communities,

Angela Ebensteiner

Sr. Technical Advisor

Microsoft Dynamics GP

Quick Links

Leaderboard