[lynale]

I wanted to create a report of sales order with customer and vendor names. The way our system was built would not show them all on the front end reports/saved searches, as the vendor is on the item line of the sales order form or mostly binded to the PO, not SO. Even the Vendor : Legal name would not display all vendor name. What I have been doing so far is using Access to pull the data from transaction_lines chunk by chunk or by ship_date using Access. But the db gets large too quickly and kept giving me the “Invalid argument” error.

Any idea or suggestion on a how to achieve this report from the front end or an enhancement to the report’s capability would be appreciated.
This is a cached copy. Click here to see the original post.

[evan_goldberg]

RE: "Invalid argument" error extracting data from transaction_lines

You have only one PO per sales order?

[Author]

Posts