PDA

View Full Version : import purchase order records


Unregistered
11-29-2001, 08:52 AM
How can I import individual purchase order records in csv format from excel? It appears that the entire purchase order journal must be imported.

Please advise.

Unregistered
12-03-2001, 08:56 AM
Thanks Paul!

I can see now that it will import individual records.

Now I have a couple of more 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 again in advance!