Item Ledger Compression in 3.6

DevInChi · 2006-11-01

One of our clients compressed their Item Ledger for the years 1999 - 2002 a few months ago with no issues. That is until now. During their last running of the Inventory Adjust Cost periodic, they received an error message of

"There is no Item Ledger Entry in the Filter Prod. Order No. xxxx, Prod. Order Line No. xxxx, Entry Type Output".

There is an Output Entry out there, but it is the compressed entry, so it has no Prod. Order No. and Prod. Order Line No. Has anyone else run into this issue, and if so, any suggestions on a fix? Thanks!

Savatage · 2006-11-01

Can old production orders be deleted??

I wonder if the answer here - can also apply to your situation
http://www.mibuso.com/forum/viewtopic.php?t=14496

DevInChi · 2006-11-01

I didn't think the Finished Production Orders could be deleted, but Navision will only prevent you from deleting if there are Item Ledger or Capacity Ledger Entries with the corresponding Prod. Order No. After compression, this link no longer exists.

Since the Production Orders are so old, I don't think the customer will have an issue with deleting them and it will prevent Navision from searching for non-existent Item Ledger Entries.

WITH ItemLedgEntry DO BEGIN
TESTFIELD("Entry Type","Entry Type"::Consumption);
TESTFIELD("Completely Invoiced",TRUE);
IF NOT ProdOrder.GET(ProdOrder.Status::Finished,"Prod. Order No.") THEN
EXIT;

Thanks so much for your advice. I am going to test it out right now...

Savatage · 2006-11-01

Test is the key word

Item Ledger Compression in 3.6

Comments

Categories