IVUL - 32 Import from IVPXRPT.TXT
This option allows the new Excel export format of IVP to import back into BSMGR. Here is how:
- Back up your inventory data (IVM01)
- Export data via IVP “Excel Import/Export” format to Excel.
- Change any of the included data fields which are Catalog, Title, Author, Misc., Ven 1,2 &3, Publisher, CPC code, Binding, Catalog 1, 2, Location, Min, Max, Retail, Qty Pricing 1 &2, Discount, Status, JIT Code, Special, Core, Analyze, Mo’s to stock, Special pricing 1,2,3,4.
- Save the changes into a tab delimited file in the book directory called “IVXPRT.TXT.
- Import the changes back into BSMGR via IVUL #32.
- Verify your changes.