Issues Information With Requesting Location

Sort:
You are not authorized to post a reply.
Author
Messages
S. Rosa
Basic Member
Posts: 7
Basic Member
    I am trying to obtain issues information from ICTRANS but also need to relate the IS document type transactions to requesting locations entered in IC21. MMDIST contains the account distribution I need and it actually has a REQ-LOCATION field but the field contains no information. MM280 is able to provide this information. Does anyone understand how?
    JonA
    Veteran Member
    Posts: 1162
    Veteran Member
      I've been trying to do this using addins and Crystal for nearly 7 years. I've nevery been able to get both IC21 direct issues and req data. I always revert to IC220 to analyze IC transations.
      Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
      S. Rosa
      Basic Member
      Posts: 7
      Basic Member
        Thanks for the reply. The user was able to get MM280 to tie out to GL after some help with report parameters so the problem is resolved. It would still be nice to know where the reqloc information is located for IS documents. One would think that it would be in ICTRANS or MMDIST but noooooo :blink:
        Cameron
        Basic Member
        Posts: 8
        Basic Member
          The Req Location for IS type documents is in field FROM_TO_LOC in ICTRANS.
          JonA
          Veteran Member
          Posts: 1162
          Veteran Member
            Yes, that will give you the req location but we're looking for the accounting unit and account that was charged for the supply. If you query ICTRANS it returns the AU and account for Issues (IC21) activity but not for the activity from requisitions/shipments that have been filled and finished in WH32.
            Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
            Jason Locke
            New Member
            Posts: 1
            New Member
              This join to MMDIST should get you what is needed.

              LAWSON.MMDIST MMDIST
              ON (ICTRANS.COMPANY = MMDIST.COMPANY)
              AND (ICTRANS.LOCATION = MMDIST.LOCATION)
              AND (ICTRANS.DOCUMENT = MMDIST.DOC_NUMBER)
              AND (ICTRANS.SHIPMENT_NBR = MMDIST.DOC_NBR_NUM)
              AND (ICTRANS.LINE_NBR = MMDIST.LINE_NBR)
              JonA
              Veteran Member
              Posts: 1162
              Veteran Member
                Doesn't give me the offset acct unit for requisition issues,
                Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
                You are not authorized to post a reply.