Inventory Valuation Report - Expected Cost

Batman

Hi,
Running the inventory valuation report in Fin man/Inv/Report gives different quantity value when the expected cost option is ticked on. EG if not ticked then the inventory quantity value is 54,000 but running with the option ticked gives a quantity value of 0???

Is this correct ?

It doesnt like like it to me, Any one got any suggestions please?

Thanks,


Agi.

mrsa

Difference is between un invoiced sales/purchases. In "Expected category" goes posted purchase (return)receipts, posted sales (return) shipments that are not yet inoviced. So if you have difference with mraked and not marked option in expected cost, you have not invoiced sales or purchases.

kriki

[Topic moved from 'NAV Three Tier' forum to 'NAV/Navision Classic Client' forum]

Alex_Chow

Batman wrote:

Hi,
Running the inventory valuation report in Fin man/Inv/Report gives different quantity value when the expected cost option is ticked on. EG if not ticked then the inventory quantity value is 54,000 but running with the option ticked gives a quantity value of 0???

Is this correct ?

It doesnt like like it to me, Any one got any suggestions please?

Thanks,


Agi.

Expected cost posting should only affect G/L. Not the item ledger entries, you should still get the same result.

How are you getting the figures for when it's checked or not? Did you run adjust cost? Maybe if you uncheck it, the results will be the same?

mrsa

Alex Chow wrote:

Expected cost posting should only affect G/L. Not the item ledger entries, you should still get the same result.

How are you getting the figures for when it's checked or not? Did you run adjust cost? Maybe if you uncheck it, the results will be the same?

Inventory Valuation is roport on value entry table and it sumarize actual/expected cost, and cost posted to G/L regrdless of Invnetory G/L post expected cost setup