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
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
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;
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,
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
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (