CIM Load 7.1.1 & 7.13.1

[itjobber]

I need to CIM data into 7.1.1 (Sales Order Maintenance) and 7.13.1 (Pending Invoice Maintenance)

I need help creating the CIM files - Has anyone successfully CIMed data for these and do you have sample CIM files that I can use.

I am using MFG/Pro 8.6e

Thanks

 

[ovf]

Hi,

I have made several programs "cim" load data to 7.1.1 and 7.1.13.

The "trig" is to know exactly what data the program need, especially regarding tax, gmt, salesman, …
When I am testing I always start by creating a small program:

{mfdeclre.i}
Batchrun = true.

{gprun.i “”sosomt.p””}

Then I make a note of the behavior of the screens, in all the cases I can imagine my customer will have.

I like to start a transaction before loading data.

After load of data I will test that the data is where it is supposed to be. If not I will save my input and output files (this will show me what to correct) and undo the transaction.

[FONT='Calibri','sans-serif']Regards Ole[/FONT]

 

[itjobber]

Thanks for your help, I have written a simple excel macro to create the cim file for the required input data.

 

[nate100]

Hello,
I have done CIM loads before.
Please let me know if you are still having any problems.

Thank you.

 

[itjobber]

Thanks for the offer, I did manage to get the CIMM program working however I got a lot of errors and warnings because of the way the system was setup. I had to unblock a lot of the control settings for Invoices before I got it to CIMM correctly.

 

[mianico]

Thanks for the offer, I did manage to get the CIMM program working however I got a lot of errors and warnings because of the way the system was setup. I had to unblock a lot of the control settings for Invoices before I got it to CIMM correctly.

i am also trying to cim load data directly into 7.1.1. I am having problems with the batch files, can you show me an example of a batch file you used?

 

[itjobber]

Hello Mianico,

Here is a sample of the batch file. Note that I only needed the following fields to be cimmed:

Sales Order
Invoice No.
Sold-To
Bill-To
Ship-To
Order Date
P/O
Salespsn
Line No.
Item Number
Shipped Qty
Price
Due Date

=============================
@@batchload sosomt.p
"SO61256"
"10PLE001"
"10PLE001"
"00010001"
"29/11/06" - - "29/11/06" "29/11/06" "PO3271"
-
-
"1" "13025CS040103" "50"
-
-
.
.
-
-
.
-
-
@@end
=============================

 

[mianico]

Thanks so much for this help.
I am having trouble with the Line,item and Qty but I will persevere!

 

[sharkdim]

i think you can use a sequence id ,such as
define variable iii as integer.
iii = iii + 1.
assign line = iii
..........

Thanks so much for this help.
I am having trouble with the Line,item and Qty but I will persevere!

 

[oldemanw]

Note that you may have to use variable length cim files.
E.g. we use cim's to update duedates in existing sales orders, but depending on whether the line is confirmed or unconfirmed, there is an extra field to skip.
The same goes for transaction comments.

I solved this by creating a program that writes variable length cim files.

Another thing to be aware of is that in batchmode some frames or questions may not pop up.