Inventory: Inventory Valuation Report by Date not balancing with / different than Inventory Enquiries Valuation by Date Utility

Let's show you how to resolve the Inventory Valuation Report by Date not balancing with / different than Inventory Enquiries Valuation by Date Utility in Sage 200 Evolution.

Click here for a detailed article on this topic.

  • Why would this happen what is the logic

    If you run the valuation report under reports and leave date as today, they are showing with values.

     

    If you run through enquiries, valuation by date at Jan they are there with values but at Feb they have no values…

     

     

    They are showing as in stock in the Feb valuation by date but at ZERO value

  • in reply to BCSKZN

    Hi Bennie

    We have picked up an issue on this and believe sage needs to look at this as a bug and fix

    If you create a new item receive into stock and bin - then do a bin transfer the cost is not transferred with to the new bin - so the valuation report both via the enquiry and standard by date brings through a zero cost. This needs to be sorted ASAP please

    Even using your knowledge base article does not resolve

  • in reply to BCSKZN

    Is this Ricky I'm corresponding with? Slight smile

    Please confirm the following:

    1. Sage Evolution version?

    2. Have you perhaps activated Cost per Warehouse, or are you still running Cost per Item?

    3. Are you aware of the Save Valuation button that you should press on the Inventory | Enquiries | Valuation by Date utility (after setting it up for a specific month)?

    Kind Regards

    Bennie

  • in reply to Bennie Pienaar

    Hi Bennie

    They on version 11.0.1.5 - cant upgrade to 11.0.4 because it gives errors - tried this on 2 other customers - same issue.

    did copy copany as sage suggested but same problem - reference HD15379357.

    they were on cost per item - tested by making it cost per warehouse - same problem.

    if you run the valuation report as at norm (today) alls fine, if you run the valuation by date under enquiries - it brings up 0 values.

    seems to only be for new items - as i tested it on old items and it works. - however items in reference were created in January and they only implemented this procedure in February.

    also only impacts new items that have done bin transfers.

    we have used the save valuation report function - same problem.

    I'm busy downloading 11.0.3 to see if i can upgrade to that without errors.

    bear in mind - i have put an incident through to sage regarding the upgrade to ver 11.0.4 but have had no feedback as yet - since last week

    Regards

    Brett

  • in reply to BrettFields

    i have tested this on a blank new company and it does the same thing

  • in reply to BrettFields

    Hi Brett

    Can we perhaps arrange a remote session meeting for Friday 31 March 2023 to discuss this query further?

    If yes, please advise suitable time.

    Then you can show me the finer details and I can perhaps make a few suggestions.

    Failing a positive outcome from that meeting we can then chat about the next moves going forward.

  • in reply to Bennie Pienaar

    Hi Bennie can we do 9am on Friday?

  • in reply to BrettFields

    Hi Brett

    We had a productive meeting yesterday, thanks.

    I'll soon follow up with you with regard to your Upgrade query also. 

    If I don't get back to you by COB on Tuesday next week, please remind me Slight smile