Year end was October 31, 2008 and we performed a count. I went through the procedure to do the count actually on November 2, 2008 and of course the system was set for oct 31, 2008. we have a handful of modules, OE, IC, CQ, SA, GV, GL, AR and AP (just in case having that info makes a difference in your answer.

here is the question....i printed off the item valuation report after the inventory was done....it was the value of the print out before less the variance....it made sense.

There were some items on that list that did not have any values. We use moving average method to value our inventory. Today when i print out the item valuation for october 31, 2008 it doesn't look the same and there are average values for these items.

You see we found out at year end by the accountant that one item was input in wrong at the count date and now i need to adjust. i was going to adjust the item as of nov 1st since i haven't closed november off.

why did this report change? and how do i know how this will affect the inventory, this change, and the bottom line. i have 2000 inventory items and this just all seems confusing.

thanks
Laura

i traced one item and found that we sold 24 units nov 26.....i did the day end today...and the 24 units sold is reflected in the oct 31 report...why does that data get represented in a report that is dated after the sale? is this how adagio works?

please someone help me understand how this works.
thanks

Hi Laura

I don't work for Softrak, so this may not be the official reply. But I think that your question is so data-specific that you might benefit from having a local Adagio consultant look at your data. A consultant could also lessen your confusion with one-on-one training. Of course that costs money, but sometimes that's inevitable.

In the meantime, you should definitely run Data Integrity Check on your data to confirm that the data is clean. If it isn't, then all bets are off as to how the report figures are calculated.

Steve

Hi Laura,

If you print the Item Valuation report and change the date to something earlier than today, the report subtracts all historical transactions it finds, dated between the report date and today. This means that for a back-dated Item Valuation to report the correct quantities, all transactions related to the item must be in IC History. Can you confirm this? You can check the Transaction History tab from the Item Inquiries with Sales and Costs function, for that item.

For example, if your current Qty on Hand of an item is 100, and there is a transaction history record for a shipment of 24 on Nov 26th, then if you backdate the report to Nov 25th the report calculates the Qty On Hand on that date as 124. If your history is incomplete, the report cannot correctly calculate the QOH as of that day.

Certainly a Data Integrity Check that fails could be a cause, as Steve noted.

thanks steve.
i just set up a blank company and was fiddling with the program at home. I noticed this. if you have an inventory item at Dec 1 with nothing in it...receive 500 units dec 2 and then dec 3 you sell 250 units.....if you do not do day end and print the item valuation you will see that dec 1 the item has -250 units....although you shipped this product on dec 3rd. this means that the item valuation report does not catch a moment in time. once you start posting invoices against inventory you can never get that one moment in time back. once you do day end...the cost will show negative as well.

i don't understand why a sale from 2 days in the future would affect the inventory item valuation report.

thanks,
i did a data integrity check and all was fine and it didn't change what i was seeing.

however what is ic history...how do i complete that?

Hi Laura,

If you use OE, then you have to print and purge the Invoice Audit List report in order to update the IC History file with the sale. Try doing this and you should find that the Item Valuation report will start doing what it should.

i went to the item inquiry and looked into the history and saw the transactions.

i started fresh again because i was getting confused.
so i had 400 units in at $1. dec 4....so then i invoice 100 units dec 5th.....i processed day end and printed and cleared the audit list...dec 5th item valuation list is correct.

but for Dec 1 the list now show -200 units.
now what am i doing wrong, please make me see the light.

although i logged into oe December 6th, it is posting the shipments for dec 1? why is that. all three invoices show in the history as dec 1 and this is why the valuation report is getting messed up. what did i do wrong.