Exporting Data into CSV

[mlebeau]

I'm trying to export the ship to information from Sales Orders or Invoices. I only want 1 line per sales order.

ie: 12344, John Doe, 1234 Your St, Your Town, .....
12345, Jane Doe, 2345 Your ST, Your Town,.....

I get the information repeated for every line item on the SO or Invoice.

Any suggestions or hints????

[jdncpa]

If I am understanding your question right......


If you open the csv file in excel you should see the results you want. I am assuming you opened it up in wordpad or something and it all looked jumbled together.

[mlebeau]

I opend it in Excel.

I get multiple records for the same SO or Invoice.

If the sales order has 3 line items, I get three duplicate records of the same ship to information.

[dringstrom]

Having the data repeat on every row of the transaction is by design in the software. However, I can easily create an Excel macro that would eliminate the extraneous data for you...contact me directly if you're interested. Your other option is to create a custom application via Dynamic Data Exchange (DDE), but this also involves programming knowledge.

Good luck!