27 Stock Take VideoEnglishالعربيةfrançaisTagalogहिन्दी

Stock Take Video

Have you watched the Stock Take Video?

Using Stock Take Export

• Select the Inventory Module then the Stock Take Button
• To Export your Stock Take Inventory List to a Tab Delimited txt file that can be edited in an excel spreadsheet select the Export button at the bottom of the screen .
• It is not necessary to select an Account until you Import the Stock Take.
• Select the Department you are performing the Stock Take on or tick the All Department radio button.
• Select the Yellow Folder icon to name and Save your Stock Take.
• Name the file and remember where you place it Eg. Desktop Then Select Export

NB: The file is automatically saved as a 'pdi' file and it is important that it remains a pdi file to ensure it will Import successfully.

• Select Cancel to close the Stock Take screen until you are ready to Import your pdi file with updated stock levels.
• Open up Excel then go to File Open on Top Menu Bar and locate the folder you have saved the ERP data file to 
• Change the file type to All Files as ERP has it's own file extension 'pdi'
• Select the pdi file to open it in the Excel Text Import Wizard.

There are three steps to follow to open the data file correctly.

1. Click Next - You need to change the Text Qualifier from (") to (None).
2. Click Next -  All columns within the Data Preview need to be Hightlighted.
3. Select text from the Column Data Format and then select Finish.

In the newly opened Excel sheet enter the Quantity of stock per item into the Final Count column. If you are using Bins you must enter the Final Quantity for each Bin and a Total Final Quantity for the Product - being the total of the Bins.

NB: Always remember to save your pdi file correctly. After you have made changes to your spreadsheet and wish to close and save these changes, follow these steps:

• Select YES to saving the changes
• Select SAVE to save over top of the existing doc or if you do not wish to replace the original doc simply rename the file at this point.
• Select YES to replace the existing doc.
• Select YES to keep this format to leave out any incompatible features.

When you have completed your data entry for your Stock Take levels, you are ready to Import the file back into ERP.

Select the Inventory Module and then the the Stock Take button

Select the Import Button and the Stock Take pdi file you have saved,

Enter the Adjustment Date of the Stock Take. This is Critical to ensure transactions since the stock take are Processed in the Correct Order  Eg. If the stock was counted two days ago and a sale or purchase occurred yesterday, the stock take date must be entered as two days ago or the transaction will be deemed to have already been counted in the stock take. Select Process. And answer Yes to the Question 'Do you wish to delete the Lines with 0 adjustment?' This saves time in processing the stock take and if there are no changes then these items do not need to be adjusted. The Inventory Stock Take will auto load into the Stock Take screen with all Final Quantities and Adjustment Values.

The screen will then close when completed.

To view the changes select Stock Adjustment List Tab.

NOTE: ONCE STOCK HAS BEEN IMPORTED THE PRODUCTS MUST BE ASSIGNED TO A DEPARTMENT

Select Inventory Tab Data Update Button Select All products by clicking on the radio button or individual product Click radio button for Add to Department Select from the drop down menu Add Products to Department and select a department or click on the All radio button and the product will be assigned to All Departments

Then Click on Process