IVUL - 32 Import from IVPXRPT.TXT

This option allows the new Excel export format of IVP to import back into BSMGR.  Here is how:

  1. Back up your inventory data (IVM01)
  2. Export data via IVP “Excel Import/Export” format to Excel.
  3. 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.
  4. Save the changes into a tab delimited file in the book directory called “IVXPRT.TXT.
  5. Import the changes back into BSMGR via IVUL #32.
  6. Verify your changes.