Open Forum

Expand all | Collapse all

Inventory Reconcile Issue

  • 1.  Inventory Reconcile Issue

    Posted Apr 12, 2019 02:38 PM

    Good Afternoon Everyone,

    We ran Inventory Reconcile last weekend as part of our normal monthly close process, but had some strange issues occur as a result of running it.  We have several instances where items were posted from 2/12/19 and 4/19/19 as an example.  We're thinking that these may be errors duplicated from previously posted assemblies.  What's strange is that they have a date of 0/0/0000.  Can anyone shed some light on what's going on here?

    We noticed that our materials in CoGS seemed to be lighter this month, and I'm wondering if this is maybe the cause of it? Is there a smart list or something that we should be running to try and track these down?



    ------------------------------
    Dan Levett
    Accounting Manager
    White House Custom Colour
    Eagan MN
    ------------------------------


  • 2.  RE: Inventory Reconcile Issue

    TOP CONTRIBUTOR
    Posted Apr 12, 2019 05:28 PM
    Maybe there was a posting problem causing the data to be invalid.
    When you see stuff like this sometimes you just need to do SQL queries and study the data.
    Manufacturing and BOM is not something I have worked with.

    ------------------------------
    Bruce Strom
    Programmer Analyst
    Associated Grocers of Florida / Supervalu
    Sunrise FL
    ------------------------------



  • 3.  RE: Inventory Reconcile Issue

    Posted Apr 15, 2019 10:07 AM
    Thanks, Bruce! I'll start digging into that.

    ------------------------------
    Dan Levett
    Accounting Manager
    White House Custom Colour
    Eagan MN
    ------------------------------



If you've found this thread useful, dive deeper into User Group community content by role