Excel Cim load for Purchase Order Maintenance

[Kalyansid]

Hi,

I need a Excel Cimload sheet format for Purchase Order creation to create CIM using QAD Cim tool. Please if anyone has it can you please email me the sheet @ kalyansid@gmail.com.

regards

 

[sgs.prasad]

There is no specific format of excel file to load the data. It all depends on the user data. The standard MFGPRO will accept only the file which are already in CIM format. The input file specified will not be excel file but the formatted CIM file.
Prepare the CIM file based on the data available and input the same to MFGPRO cim loader.

I think it is better to create your own cim program instead of using MFGPRO program

 

[ttobba]

Use the visual basic editor in MS Excel to output the data to a .csv file in the format desired. Then create a progress program to validate and load the data. Just make that the values in the excel file never change cell position or you VB script wont work right!