Sage 100

 View Only

  • 1.  Inventory Valuation by period report

    Posted 12-26-2019 12:03
    Hi Folks,
       I have a client were their inventory by period report is different for a prior period than it was last month.   They are wondering what transaction caused the change.  Is there a way to research this or a type of transaction to look for?    

    Thanks much!
    Bob Osborn

    ------------------------------
    Bob Osborn
    Consultant
    ACI Consulting
    ------------------------------


  • 2.  RE: Inventory Valuation by period report

    Posted 12-26-2019 12:29
    Bob - I think I would start by dumping the IM_ItemTransactionHistory.M4T data to excel or perhaps crystal.... Excel would likely be more useful, but that table has fiscal year and period in it for each inventory transaction and also date & time updated...

    ------------------------------
    Randy Marion
    ------------------------------



  • 3.  RE: Inventory Valuation by period report

    Posted 12-26-2019 17:01

    HI Randy,

      Well, I can dump all the data.  The question is what am I looking for?   I am trying to find a $600 difference between one month and another in a $4-5 million dollar inventory.    The problem is I don't know what causes there to be a difference in the inventory valuation by period in a prior month.

     

    Thank you,

     

    Bob Osborn

    ACI Consulting

    p 714.282.0378 ext. 402    f 714.282.0235

     

    Bob@ACIconsulting.com

     

     ACISignature1                  

    MCP_SE_Small.bmp

    This communication, including attachments, is confidential and may contain proprietary information intended only for the proposed recipient. Please notify the sender and delete this message if you believe that you have received this message in error or if you are not the proposed recipient. Unauthorized disclosure, copying, or distribution of the information is strictly prohibited.

     

     

     

     



    ------Original Message------

    Bob - I think I would start by dumping the IM_ItemTransactionHistory.M4T data to excel or perhaps crystal.... Excel would likely be more useful, but that table has fiscal year and period in it for each inventory transaction and also date & time updated...

    ------------------------------
    Randy Marion
    ------------------------------


  • 4.  RE: Inventory Valuation by period report

    Posted 12-26-2019 17:21
    Look for something with a transaction date  in a different period that the update date

    ------------------------------
    Beth Bowers
    Mom to Samson, Peanut, ChiChi, Canton, Cagney and Daisy (NO Oxford comma - shriek!)
    Beth Bowers
    269-445-1625
    ------------------------------

    Original Message


  • 5.  RE: Inventory Valuation by period report

    Posted 12-27-2019 11:53
    The transaction date is one way as @Beth Bowers mentioned, another way would be to use the fiscal year and period and look for update dates out of line.  Be advised though, it is fairly normal for some transactions to occur in the next month but before the period is closed... might be handy to know the actual date the modules were closed to see what is outside
    ​

    ------------------------------
    Randy Marion
    ------------------------------

    Original Message


Related Content