Hi
My need is to make a report that aggregates, per item#, the amount of invoiced qty, according to a range of invoice dates. (in theory, the invoice date should be = the shipped date, and there would be no problem, but...)
If I make the Adhoc report based on OOLINE, I have the item# in the master table, but the invoice date comes from OOHEAD, thus can not be used in the adhoc as a filter.
Whereas if the Adhoc is based on OINVOH, there is the date, but the Item# is not part of the table, and since there is multiple item# per CO# / invoice#, it is not possible to grab the item#.
I have tried to use APIs to update a field like INAP in OOLINE whenever the invoice date is changed, however once the CO# is invoiced in full, its status prevents the API from updating any field in the CO line. I have also briefly looked at the new custom fields, however the APIs are only Get or Lst, not Upd.
i see 2 solutions:
have a script that will push the invoice date into an OOLINE field ; or ; tell the client to export the adhoc data and do a pivot chart in excel (or use Birst, Tableau...). (+bonus: tell to invoice when the goods are shipped)
Is there any canned report that can do that?
Also looking into creating a dataset/statistics but I believe the result will not be a "table" to display, but something "on the fly" that can not shown as a report.
Thanks
