How to Import the items from CSV file?
Import option
Use the import option to import the items from CSV file.
How to import the CSV file?
1. Click Inventory >> Physical Inventory. The Physical inventory screen is displayed.
2. Press F3 or click New. The Physical inventory screen is displayed.
3. In the Item Type field, select the required option.
4. In the Generation Selection section, select Generate a new blank physical inventory count for manual entry. The other three options are not applicable for import.
5. Select the Stock taking via barcode scanning check box.
6. Click Generate. A form for the above physical stock selection is created with a Reference number.
7. Double click the generated form. The CSV format selection LOV is displayed.
8. Select the option from the LOV. The csv file location is displayed.
9. Select the CSV file and click open. The selected file is displayed in the physical inventory screen.
10. Press F4 to open the form. The items are automatically updated in the screen.
Use the import option to import the items from CSV file.
How to import the CSV file?
1. Click Inventory >> Physical Inventory. The Physical inventory screen is displayed.
2. Press F3 or click New. The Physical inventory screen is displayed.
3. In the Item Type field, select the required option.
4. In the Generation Selection section, select Generate a new blank physical inventory count for manual entry. The other three options are not applicable for import.
5. Select the Stock taking via barcode scanning check box.
6. Click Generate. A form for the above physical stock selection is created with a Reference number.
7. Double click the generated form. The CSV format selection LOV is displayed.
8. Select the option from the LOV. The csv file location is displayed.
9. Select the CSV file and click open. The selected file is displayed in the physical inventory screen.
10. Press F4 to open the form. The items are automatically updated in the screen.
Related Articles
Barcode Printing Based on CSV Import
Barcode Printing Based on CSV Import Purpose: Barcodes are applied to products as a means of quick identification. They are used in retail stores as part of the purchase process, in warehouses to track inventory, and on invoices to assist in ...CSV Import Support in Wastage Entry
CSV Import Support in Wastage Entry Purpose: With the help of this module/option you can import the following information such as the date, time, item name, quantity, and reason for wastage, the system can automatically populate the relevant fields ...CSV Import Support in Stock Update
CSV Import Support in Stock Update Purpose: The purpose of stock updation is to reduce the costs of holding stock while ensuring you can meet customer demand. Businesses should always have a 'safe' amount of stock so that they're able to react and ...Excel Import - SO functionality
Excel Import - SO functionality Purpose: The "Excel Import- SO" function key in the Sales Order section of the POS is used to import sales orders from an Excel spreadsheet into the POS system. This is a useful feature for businesses that receive a ...How to convert a file in other formats to CSV format using "Purchase Invoice import" option?
Profile File Import This option is used to import purchase invoice in formats other than csv and .xls formats such as .dav. There are certain standard file formats provided by the suppliers such as Allied, DAVA & MicroPro. For suppliers who use DAVA ...