820
Hello,
I know in SOP the distribution for Sales, COGS, Inventory (and a few others) are all determined by the site ID for Branch segment substitution. However, is this only the case when an Item ID exists? Can this also work for "true" non-inventory items?
*This post is locked for comments
Good point, most people do not pass in costs for non-inventory items, but if you are, then this will not work. I don't see a way to make anything other than the Sales account do the Site Segment ID substitution for non-inventory items. If it's important to have this happen and to keep using non-inventory items, then you may need to look into a customization or to see if eOne's Flexicoder (www.eonesolutions.com.au/content.aspx) can do this.
For non-inventory items, I do not believe there will be any posting to Inventory or COGS, so it really should not matter what you have there. Only the Sales account matters.
Are the accounts not populating for new transactions or old/existing ones? No existing transactions will be changed when settings are changed, so you will need to update those manually. For new transactions if the accounts are not populating, are the items inventory or non-inventory?
Thank you for your assistance. I did not have the Inventory accounts in Posting Accounts populated. I had them under Sales. I now get the COGS and Sales accounts to populate ,, with the correct substitute segment, however the Inventory account does not populate at all on the line item in SOP.
I'm on version 11.00.1752 .
Any ideas about why the Inventory account wouldn't populate, but the others do?
Thank you
There is another setting to consider. If on the Sales Order Processing Setup window you have selected to use Posting Accounts From Item, then the Non-Inventory items will use the Sales accounts from the Inventory Posting Accounts for the company and the Site Segment ID substitution will work. However, if on the Sales Order Processing Setup window you have selected to use Posting Accounts From Customer, then the Non-Inventory items will first look at the customer accounts, then the Sales Posting Accounts set up, and (in either case) the Site Segment ID substitution will not work.
I don't believe this has changed any time recently, so the GP version should not matter, but I just tested this in GP 2010 R2 to confirm this is how it works.
Hi Rita,
Sorry about the link, the KB number is KB 874223. If you are using non-inventory items in Sales then the general ledger accounts to set up will be in the Posting accounts not under Inventory but under Sales instead. Could you check that there is something in there for me? When you create an Order or Invoice using a non-inventory item do you get any accounts at all in distribution?
Regards
Tracy
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,432
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
