Difference between revisions of "27 Stock Take Video"
From TrueERP wiki
Simon Clive (Talk | contribs) (Created page with " Stock Take Video Have you watched the stock take video? Using Stock Take Export Select the Inventory tab then the Stock Take Button Select the 'Export' button to export your...") |
Simon Clive (Talk | contribs) |
||
| Line 1: | Line 1: | ||
| + | '''Stock Take Video''' | ||
| − | 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. | |
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | #Click '''Next''' - You need to change the '''Text Qualifier''' from '''(")''' to '''(None)'''. | |
| − | Click | + | #Click '''Next''' - All columns within the Data Preview need to be '''Hightlighted'''. |
| − | + | #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. '''<br> | |
| − | + | ||
| − | + | '''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 Inventory Tab | + | Select the Import Button and the '''Stock Take pdi''' file you have saved, |
| − | Data Update Button | + | |
| − | Select All products by clicking on the radio button or individual product | + | 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. |
| − | 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 | + | 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 | Then Click on Process | ||
Latest revision as of 18:00, 1 November 2011
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.
- Click Next - You need to change the Text Qualifier from (") to (None).
- Click Next - All columns within the Data Preview need to be Hightlighted.
- 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
