Sage 100

 View Only

  • 1.  Last Cost Update when using Receipt of Goods and Receipt of Invoice separately

    Posted 07-08-2025 12:55

    Hi Everyone,

    Has anyone got a fix or suggestion for updating the Last Cost with the cost used from Receipt of Invoice and NOT Receipt of Goods entry.

    We are looking for accurate costing information.  Currently when a receipt of goods is entered if the user does not have the correct cost (the user is the warehouse receipt person) they receive the goods and it is expected that when the invoice is entered with the correct cost the Last Cost field is updated - this does not happen.

    Any thoughts would be gladly appreciated.

    Thanks. Jacquie.



    ------------------------------
    Jacqueline Hoyte
    Director of Client Services
    Integrated Data Technology, Inc.
    ------------------------------


  • 2.  RE: Last Cost Update when using Receipt of Goods and Receipt of Invoice separately

    Posted 07-09-2025 08:14

    I'm not sure if we can trigger a user-defined-script after the POR update process, but maybe you could run a job (BOI script?) every night that goes over every Invoice line received that day and overwrites the LastCost field?



    ------------------------------
    Steve Iwanowski, NextStep Technology Advisors, aka DSD Lancaster PA ¯\_(ツ)_/¯
    ------------------------------



  • 3.  RE: Last Cost Update when using Receipt of Goods and Receipt of Invoice separately

    Posted 07-09-2025 08:16

    Or, if you don't want to mess with the standard Sage logic, do something similar to the above saving to a new user-defined-field (LastCostInvoice)



    ------------------------------
    Steve Iwanowski, NextStep Technology Advisors, aka DSD Lancaster PA ¯\_(ツ)_/¯
    ------------------------------

    Original Message


  • 4.  RE: Last Cost Update when using Receipt of Goods and Receipt of Invoice separately

    Posted 07-09-2025 09:52

    Why are there cost variances?  Typically the cost is agreed upon prior to or at the time the PO is entered.  If the vendor invoice is different than the PO then the vendor should be contacted to find out why.  



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



  • 5.  RE: Last Cost Update when using Receipt of Goods and Receipt of Invoice separately

    Posted 07-21-2025 12:52

    I have this issue with a Job Cost client.  DSD is using enhancement PO-1031 with custom programming to solve this issue for our customer.

    Hope that helps.



    ------------------------------
    Scotia Saunders
    Keystone Business Solutions
    scotia@teamkbs.com
    ------------------------------



  • 6.  RE: Last Cost Update when using Receipt of Goods and Receipt of Invoice separately

    Posted 07-22-2025 08:59

    Hi Scotia,

    Thanks so much for that - I couldn't believe I was the only one with this issue :)

    I will reach out to DSD and follow-up.

    Thanks again. Jacquie



    ------------------------------
    Jacqueline Hoyte
    Director of Client Services
    Integrated Data Technology, Inc.
    ------------------------------

    Original Message


  • 7.  RE: Last Cost Update when using Receipt of Goods and Receipt of Invoice separately

    Posted 07-25-2025 08:00

    I have a somewhat-similar request:  Is there a way for the item's average cost to be updated during PO Receipt for drop-ship items? 



    ------------------------------
    Brett Zimmerman
    Net at Work
    Greater Boston Area
    ------------------------------

    Original Message


Related Content