Inventory revaluation is not showing in inventory in warehouse report

[Former Member]

I reevaluated my inventory for a given part in a given warehouse.  The inventory is FIFO and we just went live with inventory in our opening balance account.  The revaluation was done to the opening balance account.  When I run the inventory in warehouse report and change the report to last evaluated report, it does not show a price for the given part number in the given warehouse.  What is wrong?

Regards,

Fred

[Former Member]

It might be due to bug. What is your B1 version/PL? You haven't replied.

[Former Member]

8.81.319 PL10

[jbrotto]

The inventory manegment was revamped in this family but the patch you are running quite stable for this. We're you running other versions of b1?

[Former Member]

Do one thing: try in the test environment to revalue the same item to see if the result is the same.

[Former Member]

Do you have any add-on or SP running?

[Former Member]

Gordon,

Yes.  We have SAP fixed assets and copy express.

Regards,

Fred

[Former Member]

Have copied anything related to warehouse from other database?

[Former Member]

No.  I have not copied anything over.

[former_member218051]

Hi Fred,

In the inventory in warehouse report there are two modes.

Normal and Detailed .

Select Detailed and select the Last Evaluated Price from the drop down.

through inventory audit report and inventory posting you can trace other relevant information.

thanking you

malhaar

[Former Member]

All,

The report finally shows the reevaluated price.  I am not sure why it takes so long for the reevaluated price to show in the report.  It takes 3-5 hours.  If someone can shed light on why this is taking so long and if this is normal.  If it is not normal is their a fix?

Regards,

Fred

[Former Member]

Hi Fred.....

Just for the sake of confirmation please try to run Inventory Valuation Report for Last Evaluted Price.....

And then try to run other inventory reports you want.....

Check it in Test DB first...

Regards,

Rahul

[Former Member]

Hi Fred,

What is your B1 version/PL? Have you checked Inventory Audit Report. Only that report is the base for item cost.

Thanks,

Gordon