PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 05/02/2017 10:30 AM by  Jeremy
MA01 Summarize Distributions
 5 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Katie Walsh
SCM Informatics Manager
UCHealth
New Member
(7 points)
New Member
Posts:3


Send Message:

--
04/05/2017 2:37 PM
    Our MA01 Summarize Distributions flag (currently set to blank, which summarizes amounts) compromises our ability to perform granular, item-level analytics.  We have developed a SQL spend query starting in GLTRANS but without APDISTRIB detail information, we are finding it very difficult (maybe even impossible) to accurately join to POLINE. We are cautiously considering an MA01 configuration change and are interested in learning from any other organization that may have done this (lessons learned, considerations, etc).  We are on version 10, windows.  Thanks,
    Kat V
    Sr Supply Chain System Analyst
    South Broward Hospital District
    Veteran Member
    (1831 points)
    Veteran Member
    Posts:625


    Send Message:

    --
    04/06/2017 9:06 AM
    What are you trying to get a report on?
    Katie Walsh
    SCM Informatics Manager
    UCHealth
    New Member
    (7 points)
    New Member
    Posts:3


    Send Message:

    --
    04/06/2017 11:03 AM
    We have built a SQL spend query for KPIs, Dashboards, and other analytic reports. It ties to GL290. Our current query is reliable only to distribution grain (company, accounting unit, and GL) and to a document level grain (company, vendor, purchase from). We need to expose the PO Line grain to allow our customers to drill down to actionable information (like Item, MFG, Contract, Item Type, etc). APDISTRIB should bridge GLTRANS to POLINE, but can't in our case because we are summarizing distributions per MA01 configuration. We have tried but have so far been unable to work around this. We are interested to explore a change to this MA01 setting, but we have reservations without first finding out if anyone else has been in this position and successfully resolved this.
    Kat V
    Sr Supply Chain System Analyst
    South Broward Hospital District
    Veteran Member
    (1831 points)
    Veteran Member
    Posts:625


    Send Message:

    --
    04/06/2017 12:40 PM
    OK - APDISTRIB can connect to POLINE but you need to go through the MAINVDTL to find the common fields.  We didn't change MA01 to get to the detail. 
    Katie Walsh
    SCM Informatics Manager
    UCHealth
    New Member
    (7 points)
    New Member
    Posts:3


    Send Message:

    --
    04/06/2017 3:20 PM
    Can you confirm what your setting is on the MA01 Other Tab Summarize Details field? Is it blank or no?
    Jeremy
    Private
    Private
    Veteran Member
    (204 points)
    Veteran Member
    Posts:82


    Send Message:

    --
    05/02/2017 10:30 AM
    We had the exact same issue as the original poster. After MONTHS of trying to come up with a report, we finally decided to change our setup to match in detail.
    Trust me: If it is an option to make the change, then do so. It is MUCH easier to get the detailed reporting you are seeking. Especially if you have tax and/or AOC's.
    You are not authorized to post a reply.