Duplicate entry on Prep Sheet

Post Reply
lebo.kgware
Posts: 5
Joined: Fri Jun 02, 2017 7:45 am

Duplicate entry on Prep Sheet

Post by lebo.kgware » Fri Jan 26, 2018 10:05 am

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.

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.

Post Reply