Item Group / Chart of Accounts

 3 Replies
 1 Subscribed to this topic
 38 Subscribed to this forum
Sort:
Author
Messages
mikefortuna
Basic Member Send Private Message
Posts: 14
Basic Member

How does the Item Group know which GL chart of accounts to use?

I have Item Group A.   I have two companies, Co1 and Co2 attached to Group A.  I have two GL charts, Chart1 and Chart2 attached to Co1 and Co2 respectively.  

In IC11, I go to add an Issue Account.  The account is in Chart1, but I get the error message "Account number is not defined in Chart2."  

There is nothing to specify in IC11 which chart to use, only the Item Group.  How does the Item Group know which GL chart it is supposed to be using?

Ragu Raghavan
Veteran Member Send Private Message
Posts: 477
Veteran Member
Extract from the code IC11PD

END-IF
* **** Because multiple companies can exist for an
* **** ITEMGROUP, insure the account and sub-account
* **** combination is valid for all companies within the
* **** ITEMGROUP for which a particular item pertains.
MOVE IC11F1-ITE-ITEM-GROUP TO DB-ITEM-GROUP
MOVE ICCSET2-ITEM-GROUP TO WS-DB-BEG-RNG
PERFORM 850-KFIND-BEGRNG-ICCSET2
PERFORM UNTIL (ICCOMPANY-KNOTFOUND)
INITIALIZE EDAC60WS
MOVE ICC-COMPANY TO IFACWS-COMPANY
MOVE IC11F1-ITE-ISS-ACCOUNT TO IFACWS-ACCOUNT
mikefortuna
Basic Member Send Private Message
Posts: 14
Basic Member
Oh, so it's saying that it is checking ALL charts for ALL companies attached to the item group. I should be able to either add the account in Chart2, or remove Co2/Chart2 to a different item group?

I changed Co2 to a different item group and it worked.



Still, how does the Item Group get attached to a GL in the first place? Where does the IC company connect to the GL company?  It just assumes you named them the same in the Company field?

JonA
Veteran Member Send Private Message
Posts: 1163
Veteran Member
IC01 is where the IC company is built and linked to Item Group and the GL company. An IC company cannot be added unless the GL company exists.
Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health