If you selected Item Group already, the Warehouse Level will not be available. Only Item Level is possible. However, that may make the item maintenance a nightmare should you need to change and track all item level GL determination.
In another word, you can only have one selection. There are no way those methods can be co-existed.
I still don't understand what the output you want to be produced by system in GLAccount level.
In SAP B1, in Item Master Definition you have to be specific and consistent in defining Inventory GL Method (Set GL Account By) either by Item group,warehouse, and item level .You cannot combine them and you are not allowed to change the method as long as there's impact to GL Account.
Assuming there're some transaction posted related to Item A for example. Initially Item A set to by ItemGroup and mapped to Inventory A Account then you change the setting to Warehouse level the impact would be mapped to Inventory Account B. There would misleading in sub-ledger vs ledger,1 Item A(sub-ledger) would be mapped 2 Inventory Account ( Inventory A & B). That's not good in Auditor point of view .
I had some 'unique case' but in revenue account. My customer requested to have some logic for revenue account, they want to combine between territory & item group but they dont want to maintain many warehouse only for 1 for this product
The structure of Revenue account like :
Sales A - Location 1
Sales A - Location 2
Sales A - Location 3
There're 3 possibilites solution :
1. Create Item Group like below :
Item Group A - 1 Rev. GL Account : Sales A - Location 1
Item Group A - 2 Rev. GL Account : Sales A - Location 2
Item Group A - 3 Rev. GL Account : Sales A - Location 3
2. Create formatted search in AR Invoice / Credit Memo for GL Account field to combine between territory and item group. We can do the on-the-fly change of revenue GL Account and some other contra account of Inventory / control account but we cannot change on-the-fly for inventory,asset account and control account (A/R , A/P)
3. Ask them to revise Chart of Account Structure become Sales A only then location 1,2,3 could be based on query report..
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.