Sage 100

 View Only
  • 1.  Production Management Gurus

    Posted 01-15-2025 16:00

    PM v2023 (Sage).  I am looking for a standard report that will tie open work ticket costing to the GL WIP Floor accounts.  The one I thought (Work Ticket WIP reconciliation) doesn't account for work tickets that have been completed but not closed.  The entire WT cost appears on the report.

    Am I looking at it cross eyed?  I need something for the auditors to substantiate the WIP floor value in the GL



    ------------------------------
    Jeff Schwenk
    Owner
    Bottomline Software, Inc.
    Waynesboro VA
    (540) 221-4444

    Improving bottom lines for over 25 years!
    ------------------------------


  • 2.  RE: Production Management Gurus

    Posted 01-16-2025 08:39

    My understanding is that WIP is relieved upon completion, and that closing only changes the WT status and prevents further transactions.  The thought process is that if you're processing a completion, the raw materials have been consumed and the labor has been performed.  If you're backflushing materials and/or labor and the work ticket has partial completions, these costs stay in WIP until "final completion", which is recognized by the quantity completed reaching the quantity planned.



    ------------------------------
    Susan Pawlowic
    Sage 100 Solutions Architect
    RKL eSolutions, LLC
    spawlowic@rklesolutions.com
    (717) 735-9109 Ext. 4352
    ------------------------------



  • 3.  RE: Production Management Gurus

    Posted 01-16-2025 09:49

    Agreed.  But which report is used to reconcile (tie back) to the GL?  As noted in first post, the report I used displayed total cost (after completion).  Only after I closed the WT did the costs disappear.



    ------------------------------
    Jeff Schwenk
    Owner
    Bottomline Software, Inc.
    Waynesboro VA
    (540) 221-4444

    Improving bottom lines for over 25 years!
    ------------------------------



  • 4.  RE: Production Management Gurus

    Posted 01-16-2025 10:08

    Jeff,

    I meant to reply to this earlier, but SO busy this time of year. I'm now typing as fast as I can and hopefully this makes sense.

    I agree with @Susan Pawlowic! When a completion entry is done WIP is relieved for that work ticket. Depending on the settings in PM, if you do a partial completion, some of the WIP might stay with the work Ticket. 

    You are using the correct report and since you are on version 2023 I have found it to be reliable. (version 2021 and before were sketchy though). 

    When you run the WIP reconciliation report you have a "Reconcile To" field that you can enter. I'll call that the "cutoff date". The report will show costs that post to the work ticket on or before that date in the "Total WIP" Column. If you have completed work Tickets before that cutoff date those WIP amount show in the "Costs Recognized" column so you would subtract "Costs Recognized" from "Total WIP" to get to your reconciliation amount.  The Future WIP column would show costs that were applied after the cutoff date, so that is more information that may not be necessary. 



    ------------------------------
    David Overholt
    DWD Technology Group
    ------------------------------



  • 5.  RE: Production Management Gurus

    Posted 01-16-2025 10:37

    Yes, January is busy busy.  Thanks for the clarification.  I will revisit the report with this information.



    ------------------------------
    Jeff Schwenk
    Owner
    Bottomline Software, Inc.
    Waynesboro VA
    (540) 221-4444

    Improving bottom lines for over 25 years!
    ------------------------------