Sage 100

 View Only

  • 1.  Production managment wip reconciliation report discrepancy

    Posted 02-19-2025 17:18

    I have a client who is having some issues with material issues not posting properly to work tickets although it does post to the G/L correctly.  Most of the ones I have seen so far are the result of a duplicated issue followed by a correction to remove the duplication.  I've looked under the hood with DFDM and can identify the discrepancies.  Basically the Widget X is applied for 20 units,  the accidentally issued another 20 units.  A correction is posted to remove the 20 and then the work ticket shows that 0 have been issued.

    Using DFDM I found what to correct in in work ticket header,  work ticket detail, work ticket step and have fixed the numbers for units and material costs.   However, when we do a WIP reconciliation report these fixes are not reflected.  So far I have been unable to identify where the material costs below are being pulled from.

    DFDM for the work ticket header shows the correct number, but the report does not.

    Anyone have a clue as to where the WIP reconciliation report gets its number from?



    ------------------------------
    Thomas Rogers (TomTarget)
    Target System Technology, Inc.
    ------------------------------


  • 2.  RE: Production managment wip reconciliation report discrepancy

    Posted 02-20-2025 07:54

    The WIP Reconciliation Report gets the material costs from the Work Ticket History Step file.  If you make the DFDM change in there it should be reflected on the report. 



    ------------------------------
    Bernie Lehman
    Partner
    Lehman Wesley & Associates
    ------------------------------



  • 3.  RE: Production managment wip reconciliation report discrepancy

    Posted 02-20-2025 18:38

    Thanks Bernie!

    We are on our way now.



    ------------------------------
    Thomas Rogers (TomTarget)
    Target System Technology, Inc.
    ------------------------------

    Original Message


  • 4.  RE: Production managment wip reconciliation report discrepancy

    Posted 02-21-2025 01:04

    @Thomas Rogers  - Did you create a case with Sage for this issue.  I have 2 clients I have to sporadically correct the tables on.  I have reported this several times and I always work with Karen McWhirter.  Engineering is finally involved.  The more cases reported, will hopefully get a faster resolution.



    ------------------------------
    [Michele] [Herzog] [CPA,CITP, CGMA]
    [Overland Park] [KS]
    [816-520-1365]
    ------------------------------

    Original Message


Related Content