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
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