Thursday, February 25, 2016

P2P Queries



1)What is the name of the supplier who sent this invoice?
2.  What is the amount and date of this invoice?
3.  To what accounts was this invoice distributed?
4.  What is the invoice due date and the amount left to be paid on this invoice?

1) SELECT   v.vendor_name, v.vendor_id
  FROM   ap_supliers v, ap_invoices_all i
 WHERE       i.vendor_site_id = 12
         AND i.invoice_num = 'W33578'
         AND i.org_id = 204
         AND v.vendor_id = i.vendor_id;


2)
SELECT   invoice_amount, invoice_date, invoice_id
  FROM   ap_invoices_all
 WHERE   vendor_site_id = 12 AND invoice_num = 'W33578' AND org_id = 204;
3)
SELECT   c.segment1,
         c.segment2,
         c.segment3,
         c.segment4,
         c.segment5
  FROM   gl_code_combinations c, ap_invoice_distributions_all d
 WHERE       d.invoice_id = 10916
         AND c.chart_of_accounts_id = 101
         AND c.code_combination_id = d.dist_code_combination_id
4)
SELECT   due_date, amount_remaining
  FROM   ap_payment_schedules_all
 WHERE   invoice_id = 10916;

No comments:

Post a Comment