Item Group / Chart of Accounts

 3 Replies
 1 Subscribed to this topic
 38 Subscribed to this forum
Sort:
Author
Messages
mikefortuna
Basic Member
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
    Posts: 476
    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
      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
        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