Tickets older than 90days will be Auto-Archived. Ticket updates or comments will reset the timer.

Resend TPCx 867 / POS report

To resend the actual data select Re-Sale/Rebate Report from the TPCx website.  The data can also be recreated via SQL using the query below, just edit the supplier ID and the date range.


select 
supplier.supplier_id,
supplier.supplier_name,
invoice_hdr.invoice_no,
invoice_hdr.order_no,
invoice_hdr.invoice_date,
invoice_line.extended_price
--invoice_line.*
--supplier_id, sum(extended_price)
from invoice_hdr
inner join invoice_line on invoice_line.invoice_no = invoice_hdr.invoice_no
inner join supplier on supplier.supplier_id = invoice_line.supplier_id
where invoice_date >= '2022-01-01' and invoice_date <= '2022-06-23'
and supplier.supplier_id ='143967'
--group by supplier_id


Creation date: 6/23/2022 10:59 AM      Updated: 6/23/2022 11:04 AM
DataImage67.png

DataImage67.png
Files
DataImage67.png
136.9 KB
get help Get help for this page