Exporting ITEMS from WOODPRO For Millworx

The IMPORT of WOODPRO items into MILLWORX has been activated with version 4.2. Essentially, the data flows from WOODPRO to MILLWORX via Excel:

[1] Export a Price List from WoodPro using the WoodPro Print Inventory Price Listing report model.

wpinventorypricexport

[2] Select any or all check boxes under the PRINT? column.

[3] Select the PRINT? Price1 option and RS Price optons

[4] Select All Items option radio button.

[5] Select Sort by Location/Item# option radio button.

[6] Click on the [ToExcel] button.

[7] Excel will open to the newly generated report. It is not necessary to edit the file by deleting columns or rows. However, Columns D through M must be formatted as a number with 2 decimal places and without a "1000" separatro.

wppricesopeninexcel

 

[7] Using Excel SAVE AS feature, name the file 'wpitems.csv' into the MILLWORX folder (example: D:\millworx). Be sure you SAVE AS a CSV (MS-DOS) (*.CSV) file.

saveas

[8] Close down Excel once the file has been saved in the appropriate file format and folder.

[9] In MILLWORX go to the FILE > Maintenance > Inventory Maintenance

 

inventorymaintenancemenuoption

[10] The Inventory Selection Table will open.

invselectable

[11] Click on the [IMPORT WOODPRO ITEMS] button.

 

wpimport

 

[12] Click [OK Import Items] and the ITEMS from WOODPRO 'wpitems.csv' will be transferred into MILLWORX.

 

[13] Next, go to the Millworx Lumber Table.

lumbertablemenuoption

 

[14] Select the TAB {By SysID (Backup and Import Options) }

 

lumbertableimporttab

 

[15] Click on the [Update Prices/Qty Available] button.

 

 

 

Published by ABCI Software Solutions | ABC ISO Consultants | Community | ISO Certification Services | ISO Resources

Copyright © Access Business Communications, Inc.