Hi all,
When migrating inventory data between systems, a positive item journal was imported via config package and "invoiced qty" section of the config package (I believe) was set to 0. This has led to a number of positive item ledger entries (that are now closed as they have been subsequently sold), stuck with "Expected Cost" (see below). I suspect invoiced qty is the culprit here, as subsequent migrations done by another party have used invoiced qty and the issue below isn't a problem with those ledger entries.
As you can see from the inventory valuation of the item, it has a carrying value of $0.00 on the balance sheet (as we now have qty of 0 for this item), however, the splits are now negative actual cost and positive expected cost.
Is there a process that can be run to fix the above? Any suggestions or help would be much appreciated!
Cheers,
Tim