Page 1 of 1

Duplicate entry on Prep Sheet

Posted: Fri Jan 26, 2018 10:05 am
by lebo.kgware
If you should encounter duplicate entries on the Prep Sheet, this is caused by duplicates on the table. One entry will be the one that appears in the Prep Sheet, that shows twice with the same B/Stock, Production, Purc., Fill, F/Open, etc. figures. When you type a Closing Stock value on one item, exit the Prep Sheet, the same value is applied to the next item.

Cause: Unknown

Fix: Open the Prod table in Data Tools and sort by PROD number, you will notice two entries with the same PROD number, one with a name and another without. Delete the entry without a name. The Prep Sheet will now only have one valid entry and the duplicate will be gone.