Hello again, Lorraine

I'm glad that the advice helped you! That's always encouraging!

I'm afraid that I can't quite get a clear understanding of the new problem by your description. I understand the error message, however, let me ask a couple of questions:

1. Is this still the same QIP import batch you are speaking of, a new one from QIP or one from another application?

2. Is it possible that you may have inadvertently "replaced" a unit of measure field (this would be the 3rd to last field for the detail) with the new date field when editing the original ICSBATCH - ? You should check this, as this could be your problem. When editing a file like this, it is extremely important to ensure that no other data is changed, (even a space occurring where it did not exist before, or a missing comma) as the import structure is very sensitive to this, and it will not import the batch if there are fields missing or invalid characters in fields due to a mistake made in editing the file, or data corruption.

3. Prior to posting the QIP batch, did you do a data integrity check, to make sure the data was ok? Have you done one on I/C?

I don't think it would be a good idea to delete the header and detail lines in icsbatch - when the icsbatch is created it adheres to a particular format and expects to see this format when you go to import the shipment batch.

In any case, I would also suggest making a copy of your original icsbatch file then rename it before trying to make any more changes on it - at least then you will have an original to go back to if you want to experiment a little.

Regards

[This message has been edited by Softrak Support (edited 10-13-2000).]

Hi Lorraine

The lines in the ICSBATCH should look similar to this:

"H"," ",001016,1," 1600","Dr. Penn ",0
"D","A14000 "," A1"," 1","",1.00,"EA ",7.95,5.64
"D","A14000 "," A1"," 1","",1.00,"Carton ",286.20,203.04

The unit of measure in this case is the 7th field "EA ". This should be the same in your case - you should not have any of those "xxxx"'s there - that is why you are getting that error message, likely. The other fields that show "xxxx"'s should not be like that, either.

Other than restoring data from a good backup made prior to you posting the invoices in QIP, or editing the ICSBATCH again, to reflect the proper information that should be there, there is nothing you can do about this. You must be careful, however, as when you posted in QIP, it also updated your AR Customer transactions....is all the information you were expecting to see in AR ok?

The "1.00" you are seeing is quantity of items shipped, and having your Company Profile set to not accept decimals should not be the problem here.

At this point, if editing the ICSBATCH is not an option, and you don't have a problem with deleting the file and starting over - you could enter the shipments manually in IC using your QIP batch listing as an entry source. That would be the most reliable thing to do.

Dear Lorraine

I am real happy to hear that you have been successful in understanding the past responses I have posted to you as well as your success in editing the icsbatch file correctly to see that it does work.

Yes, the changes in the QIP ptf only take effect on new batches posted in QIP, thus, if there is an existing icsbatch prior to posting new invoices, the workaround to edit that batch so it will conform to the expected format for IC Shipments.

You are most welcome! Hope all goes well in future transactions!

Take care