Different GL codes for different location codes

(0) Share

Report

Posted on by Katie Pieczynski

3,225

Is there a way in GP 2010 that we can have default GL codes for each location code? For example, I invoice out of our CHA location and our NY location (but the same company in GP). When I invoice out of our NY location I have to physically go in and change each line item to have a different inventory GL account. I would like to be able to have it automatically change it if I change the location code.

Thank you,

Katie

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Frank Hamelly | MVP... 46,625 Super User 2025 Season 2 on at

Like (0)

Report

Hi Katie, yes, you can do that. Have a look at the Help files for 'Site Segment Substitution' in the inventory module. This automates the account code mapping between an inventory Site and you GL account string.

Open the Site Maintenance window and hit the Help button.

Was this reply helpful? Yes No
Katie Pieczynski 3,225 on at

Like (0)

Report

Thank you for the reply, unfortunately I dont think that will work. I tried to change it but it changes the GL for every section. For example when I enter an invoice for our CHA location we get the following:

Inventory: 00-1200-0000

Cost of Sales 00-5000-0000

Sales 00-4000-0000

Markdowns 00-4000-0000

Returns 00-5050-0000

When I change the site id segment for the NY location to 1203 and enter an invoice then every single GL is changed to the 00-1203-0000. I am only wanting the Inventory GL to change. I am going to assume this isn't possible out of the box.

Thank you,

Katie

Was this reply helpful? Yes No
Frank Hamelly | MVP... 46,625 Super User 2025 Season 2 on at

Like (0)

Report

Yes, you're right Katie, it changes it for every account set at the Inventory Card level. Nothing out of the box allows for substitution of just the inventory account.

Wish I had better news,

Was this reply helpful? Yes No
Suggested answer

Mahmoud Saadi 32,738 on at

Like (0)

Report
Inventory flipping feature works perfectly when it comes to tracking inventory per location. Although, this requires a specific design to be considered for the following accounts;

Inventory Account

Inventory Offset

COGS

Markdown

Inventory Return

I have previously worked with a client, with which the tracking per site is a requirements. I ended up changing the account design for the accounts mentioned above, and transferring old balances accordingly in order to activate the inventory flipping.

Please never hesitate to share any further inquiries,

Was this reply helpful? Yes No
Suggested answer

Victoria Yudin 22,769 on at

Like (0)

Report

Katie,

It sounds like you want to do something more than what GP can do for this out of the box. You might want to check out Flexicoder by eOne to see if it can do what you want: www.eonesolutions.com/.../FlexiCoder

Was this reply helpful? Yes No
Suggested answer

soma 24,410 on at

Like (0)

Report

You can achieve your requirement by creating a customization.

Hope this helps!!!

Was this reply helpful? Yes No