If you should encounter duplicate entries on the Prep Sheet, this is caused by duplicates on the dbo.prod 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.
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.
1 post • Page 1 of 1