If the first stock take in Advanced Stock for a new site is displaying duplicate values across the Opening and In columns this has been caused by the first stock take being created and then deleted - there is no way to undo the deletion but the following outlines steps you can do to correct the opening stock take value for your first stock take.
Delete the current stock takes:
Log into Procure Wizard.
Click into the Admin cogs
icon along the top and then in Advanced Stock on the left.
Click into Stock Taking.
Locate and Delete the stock takes currently there using the Red Cross icon.
Create a stock take for 1 day for the day before your official opening day for your stock take.
Click into the Admin cogs
icon along the top and then in Advanced Stock on the left.
Click into Stock Taking.
Click Create New Stock Take.
Set the parameters for the stock take and click Create.
Once created enter 0 on all closing values and lock the stock take.
Once created and locked you now have a stock take that will push through an opening value of 0 correcting the duplication.