Sage 100

 View Only

  • 1.  Job Cost WIP

    Posted 10-09-2023 14:46

    Recently upgraded someone from 2017 to 2023.  Having something weird happening in JC and maybe I'm just being stupid, but...

    They run all of their reports based on the WIP amount.  I am seeing some activity that has happened since the upgrade where dollars are moving from WIP and I don't think they should be.

    This particular Job has had NO billings to the customer yet.  But in this cost code, every line item that was paid (to the VENDOR) appears to have been removed from the WIP amount.

    Is that how it's supposed to be?  Surely not.



    ------------------------------
    Beth Bowers
    (269) 358-0989
    ------------------------------


  • 2.  RE: Job Cost WIP

    Posted 10-09-2023 15:10

    I wonder if you copied the live company to a test company and ran the Job Cost 'Restore Job History" for that job if the information would be there.  Someone may have accidentally closed the job then changed the Job Status back to Open.



    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------



  • 3.  RE: Job Cost WIP

    Posted 10-09-2023 15:12

    It's only this one cost code.  The other cost codes that existed should have also had it happen, right?  The odd thing is that this one had all of the activity SINCE the upgrade.



    ------------------------------
    Beth Bowers
    (269) 358-0989
    ------------------------------

    Original Message


  • 4.  RE: Job Cost WIP

    Posted 10-09-2023 15:22

    Strange  Did they accidentally post the costs in a future period?



    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------

    Original Message


  • 5.  RE: Job Cost WIP

    Posted 10-09-2023 15:26

    Nope.  I don't think that Unbilled takes that into account, anyway.



    ------------------------------
    Beth Bowers
    (269) 358-0989
    ------------------------------

    Original Message


  • 6.  RE: Job Cost WIP

    Posted 10-12-2023 13:52

    **Update on this - have opened a case with Sage.  Learned that rebuilding JC sort files prompts to recalculate Unbilled Amount (and WHY would they need that?) but either doesn't work at all, or it's fixing the total on the JC_JobCostCode file instead of the individual amounts in the JC_JobCostCodeDetail file (the JC_JobCostCode file is correct).  We've verfied that the Billed field in the transaction file says NO, so this has nothing to do with that one conversion error that mistakenly changed those fields.  In addition, it only seems to be affecting the totals of activity that happened AFTER the conversion.  So far have not been able to make it happen at will.  OF COURSE.



    ------------------------------
    Beth Bowers
    (269) 358-0989
    ------------------------------

    Original Message


Related Content