PDA

View Full Version : questions on importing po's


dbrew0
12-04-2001, 02:19 PM
When I use excel 97 to generate the .csv files used in PCA 2002 I have some problems and questions.

1) I get an error when I have multiple lines with the same po # (like having multiple items purchased on the same po) in the .csv file. How can I have multiple lines with the same po imported and go to the same po record?

2) I have noticed that the amount field will cause the unit cost field to change on an imported record (ie if '0' in amount field, a '0' will be placed in the unit cost field even though an actual unit cost is shown in the .csv file) WHY?

Thanks in advance!
Dan

Marka
12-07-2001, 06:09 AM
I just exported my PO file to a .csv file and imported it to Excel. I do have multiple items listed on one po and I DO NOT get any errors.

Also I have no idea why your costs are changing, mine are not on the imported file.