Follow us: Connect on YouTube Connect on YouTube Connect on YouTube

Pages

Sunday, 5 February 2017

Project Accounting and Purchasing Order Detail Query

SELECT   poh.segment1 "PO Number",
         TO_CHAR (poh.creation_date, 'DD-MON-YYYY') "PO Creation Date",
         pv.vendor_name "Supplier Name", pol.line_num "Line Number",
         SUM (pol.quantity * pol.unit_price) "PO Amount", poh.po_header_id,
         aia.invoice_num, aia.invoice_amount "Invoice Amount",
         aia.amount_paid "Paid Amount",
         ((aia.invoice_amount) - (aia.amount_paid)) "Amount Remaining",
         ppa.segment1 "Project Number", ppa.NAME "Project Name"
    FROM po_headers_all poh,
         po_lines_all pol,
         po_distributions_all pd,
         po_vendors pv,
         ap_invoice_distributions_all aid,
         ap_invoices_all aia,
         pa_projects_all ppa        
   WHERE poh.po_header_id = pol.po_header_id
     --AND poh.segment1='4329985'
     AND poh.po_header_id = pd.po_header_id
     AND pol.po_line_id = pd.po_line_id
     AND poh.vendor_id = pv.vendor_id
     AND pd.po_distribution_id = aid.po_distribution_id
     AND aia.invoice_id = aid.invoice_id
     AND ppa.project_id = aid.project_id
     AND ppa.project_id = pd.project_id
--   AND ppa.segment1 = '182222'
GROUP BY poh.segment1,
         poh.creation_date,
         pv.vendor_name,
         poh.po_header_id,
         aia.invoice_amount,
         aia.amount_paid,
         ppa.segment1,
         ppa.NAME,
         aia.invoice_num,
         pol.line_num
Share this article :

10 comments:

  1. Please continue this great work and I look forward to more of your awesome blog posts. Find a accountant

    ReplyDelete
  2. For example, a licensed Certified Public Accountant doing business as "Bay City Tax Service" or "Accounting & Tax Service" loses credibility. Prospective clients may perceive this company as uncertified and unlicensed.Contabilitate Iasi

    ReplyDelete
  3. he other benefit of using quickbooks support phone number services is sending invoices to clients. Mailing of invoices is done by Quickbooks, and you have yourself signed up for solution termed as Billing Solutions.

    ReplyDelete
  4. This is the thing that we call alleviating. Can't show signs of improvement than that.
    online cpa services

    ReplyDelete
  5. Nice And Informative Website. Please Keep Continue Such Kind Of Effort. Contact With Quickbooks Support Phone Number. We Deal In Bookkeeping Services, Company Payroll Services, Cost Accounting, Quickbooks Enterprise, Quickbooks Pos Support, Quickbooks Pro Support And Other Company Related Financial Services. Our Website- Http://www.Accountingexpert.Net Our Toll Free No +1-844-438-3711
    Quickbooks Support Phone Number +1-844-438-3711

    ReplyDelete
  6. Between branch exchanges (e.g. individual records of branch workers for accumulation, exchanges of settled resources, approved costs acquired by a branch representative in another branch)Back Office Services Latin America

    ReplyDelete
  7. Nice And Informative information. Please Keep Continue Such Kind Of Effort. Contact With Quickbooks Support Phone Number. We Deal In Bookkeeping Services, Company Payroll Services, Cost Accounting, Quickbooks Enterprise, Quickbooks Pos Support, Quickbooks Pro Support And Other Company Related Financial Services.
    QuickBooks Error Support
    QuickBooks Error Support Number
    QuickBooks Error Support Phone Number

    ReplyDelete
  8. Official QuickBooks® India contact us page. Let us guide you to the quickest answer or QuickBooks expert. Contact us by
    Quickbooks phone number usa.You can also find further details about how to contact our support team. ... on which QuickBooks Online product you use, so it's best to check the support site first. ... is made effective and when you will no longer have access to the service.

    ReplyDelete
  9. Nice And Informative information.You can also find further details about how to contact our support team. ... on which Dialprintersupport Support Phone Number USA | HP Customer Support team provide Data recovery, company file repair and migration support HP Printer Technical Support

    ReplyDelete
  10. When you have a business needing accounting administrations keen on you, the third step your accounting administrations promoting system ought to perform is demonstrating to you best practices to show your capacity to help your imminent customer in your introduction.Tax CPA San Diego

    ReplyDelete