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 :

55 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
  11. This comment has been removed by the author.

    ReplyDelete
  12. i found your article very intresting. really nice post. keep posting this type of important post. lots of love from rajasthan
    also help me to improve my backlinking i am adding my website link.

    http://buycbdonlinestore.com

    ReplyDelete
  13. i found your article very intresting. really nice post. keep posting this type of important post. lots of love from rajasthan
    also help me to improve my backlinking i am adding my website link.

    https://onlinepharmacypill.com/product/tramadol-50-mg/

    Tramadol 50mg
    Buy Tramadol 50mg
    Tramadol 50mg Online

    Tramadol 50 mg is a pain medication which is sold under the brand name of Ultram. It is an anti-inflammatory and anti-analgesic drug which is generally prescribed to treat moderate to severe pain. It is very useful in the treatment of chronic pain. Now you can buy Tramadol 50 mg online at affordable price

    ReplyDelete
  14. continue this great work and I look forward to more of your awesome posts. SG Accountants Ilford
    Accountants near me

    ReplyDelete
  15. Useful information shared by you and it was really worth reading it. Thanks for sharing
    For complete Assistance Using QuickBooks visit: QuickBooks customer service

    ReplyDelete
  16. I am really enjoying reading your well written articles. It looks like you spend a lot of effort and time on your blog. I have bookmarked it and I am looking forward to reading new articles. Keep up the good work. สำนักงานบัญชีสมุทรปราการ

    ReplyDelete
  17. I am really enjoying reading your well written articles. It looks like you spend a lot of effort and time on your blog. I have bookmarked it and I am looking forward to reading new articles. Keep up the good work. สมัคร ufabet

    ReplyDelete
  18. this newsletter gives the nicely-ventilated in which we can take a look at the fact. this is definitely exceptional one and offers indepth recommendation. thanks for this quality article. QuickBooks File Doctor

    ReplyDelete
  19. Oracle Apps R12 and Oracle Fusion Cloud Self Paced Online Training Videos Published on Udemy with Life Time Access & Live Meeting Support to Clear your Queries. Avail 25% to 80% discount. Please Check https://www.oracleappstechnical.com for Never Before Offers and Discount Coupon Codes.

    ReplyDelete
  20. Pretty good post. I just stumbled upon your blog and wanted to say that I have really enjoyed reading your blog posts. Any way I'll be subscribing to your feed and I hope you post again soon. Big thanks for the useful info. https://cbalance.hu/

    ReplyDelete
  21. Nice & Informative Blog ! Facing QuickBooks Error 15241? Don’t worry, dial us at 1(844)514-7111 for instant resolution of issues. QuickBooks Error 15241 or Could not initialize license Properties arrives while any of the company files is either missing or damaged.
    Fix QuickBooks Error code 15241

    ReplyDelete
  22. Awesome blog. I enjoyed reading your articles. This is truly a great read for me. I have bookmarked it and I am looking forward to reading new articles. Keep up the good work! online tax preparation

    ReplyDelete
  23. Har du letat efter den bästa webbutiken där du kan köpa din kvalitetsmedicin som, Tramado, Oxynorm, Oxycontin, Oxycodone, RItalin, Sobril, Stesolid. sök nrmer för vi är här för att ge dig kvalitetsmedicin till mycket överkomliga priser. köp Ritalin i Sverige

    ReplyDelete
  24. buy top quality undetectable counterfeit bank notes and SSD solution for cleaning black money, iconiclabo provide you a grade range of super quality counterfeit currencies such as dollars, pounds, Euros and many more undetectable bills for sale

    ReplyDelete
  25. Awesome article, it was exceptionally helpful! I simply began in this and I'm becoming more acquainted with it better! Cheers, keep doing awesome! Relationship Between Finance VS Accounting

    ReplyDelete
  26. If you are looking for more information about flat rate locksmith Las Vegas check that right away. taxfyle.com

    ReplyDelete
  27. i love reading this article so beautiful!!great job! sales tax calculator

    ReplyDelete
  28. That appears to be excellent however i am still not too sure that I like it. At any rate will look far more into it and decide personally! accounting services

    ReplyDelete
  29. tighter pores and skin and stronger bones and joints. With fats loss you transform your body. Fat loss is a way of life method in which you deliver your frame what it desires with out depriving and surprising it with chance of hunger. You get to look slow however everlasting regular development. It might also sound bizarre, but it's feasible to get thinner with out honestly seeing a trade in your weight. This takes place while you lose frame fats while gaining muscle. Your Pure Dietary Keto weight stays the same, even as you lose .

    https://www.healthmassive.com/pure-dietary-keto/

    ReplyDelete
  30. Wherever relevant, use low fats milk, cream, cheese and even yogurt. You may not know the difference while you eat but your body will. 39. Cream is the real culprit. It may be so hard to give up in this for https://mymaleextrareview.com/keto-xp/ eto XP. 42. When ingesting out, order salad. This is a need to-do in your eating regimen. When you incorporate a salad in your meal, you get filled greater speedy and it leaves you no room for extra of the main route. Forty three. Incorporate activity. No Keto XP plan can help you if you are sitting on your sofa and making your self physically weak and fats. It can be tough to incorporate exercise and your task might not allow time for Keto XP club, but incorporating hobby isn't always pretty much making your .

    Keto XP

    ReplyDelete
  31. Viaxal Enhance Better sex drive and moxie When charm and testosterone level is improved, it restores the essentialness level with more excitement and sexual drive. So the pills are bewildering for reviving sexual drive and moxie level.

    https://buddysupplement.com/

    ReplyDelete
  32. The expansion in their work openings have been quickened because of the fall of the Enron organization and the breakdown of the American Twin Towers. Advena

    ReplyDelete
  33. will provide Financial Consulting services and do bookkeeping with quickbooks online, xero and excel including Financial Statements within 1 day QuickBooks Online

    ReplyDelete
  34. This is an informative post. Thank You for sharing this.
    A common issue that users face is the QuickBooks Banking error 102. This problem mainly happens when there are some technical follies in the website or if it is under maintenance.
    QuickBooks Error code 1722 is a most common error code that is reported by many users in QB community. This error can slow down your Windows or you computer starts freezes repeatedly.

    qbo intuit login | QuickBooks Unrecoverable Error

    ReplyDelete
  35. I have been looking for this information for quite some times. Will look around your website .
    Delhi Escort
    Udaipur Escorts
    lucknow Escort
    Noida Escort

    ReplyDelete
  36. Thanks for sharing.I found a lot of interesting information here. A really good post, very thankful and hopeful that you will write many more posts like this one.
    Magellan GPS update
    magellan map update free download

    ReplyDelete
  37. If you want a fix Brother printer error code 35. There are many ways can be followed to fix Brother printer error code 35. if you want a perfect & right solution recommended by an expert. follow the blog steps which are mentioned in the BLOG.

    ReplyDelete
  38. Got stuck with Hp 79 Service Error and want to quickly troubleshoot this error? dont worry we are here for you you just need to visit us as well follow our blog or can contact us on our toll free number.

    ReplyDelete
  39. keep it up https://taxprepbuddies.com/virtual-tax-preparation-service/

    ReplyDelete
  40. Wow, What a Excellent post. I really found this to much informatics. It is what i was searching for.I would like to suggest you that please keep sharing such type of info.Thanks klarna abrechnungsbericht einlesen

    ReplyDelete
  41. We have sell some products of different custom boxes.it is very useful and very low price please visits this site thanks and please share this post with your friends. klarna abrechnungsbericht einlesen

    ReplyDelete
  42. I am a sweet, Hot, beautiful, and gracious Independent Call Girl with an attractive body, who is waiting to enjoyment you. I am well educated and experienced in how to handle my clients. You will not want to leave me and you will come back for sure to meet me again. I can be so loving and tender at the same time.
    Agra Call Girl

    Lucknow Call Girl

    Kanpur Call Girl

    Aligarh Call Girl

    Allahabad Call Girl

    Varanasi Call Girl

    Bareilly Call Girl

    Mirzapur Call Girl

    Noida Call Girl

    ReplyDelete
  43. The article shares very meaningful information, at least for me. Thanks for sharing, my friend! Please visit my website hope you enjoy it
    Punjabi Bagh Escorts Services ||
    Rajkot Escorts ||
    Ramnagar Escorts ||
    Rishikesh Escorts ||
    Rudrapur Escorts ||

    ReplyDelete
  44. Ambala Escorts Mania is a famous escorts corporation in Ambala . We've a massive collection of escorts and speak to women with a exceptional range. We believe in client delight and comments. Our Escorts corporation is presenting escorts service from a long time. Our Escorts and contact women are very professionals and pleasant with clients.


    Call girls in ambala

    call girls in manesar
    escorts service in kurukshetra
    karnal escorts service
    kaithal escorts service
    escorts service in jind
    jhajjar escorts service
    call girls in yamunanagar

    ReplyDelete
  45. Biosource Wellness Keto are the best way to deal with enhance your fat touching off with the most elevated type BHB ketone salts and the progression ketogenic diet!

    ReplyDelete
  46. The thing stocks very meaningful information, at the least for me. Thank you for sharing, my buddy! Please go to my website hope you enjoy it

    Kufri Escorts ||
    Keylong Escorts ||
    Pahalgam Escorts ||
    Horsley Hills Escorts ||
    Dharamkot Escorts ||
    Chopta Escorts ||

    ReplyDelete
  47. Nice Blog !
    One such issue is QuickBooks Error 136. Due to this error, you'll not be able to work on your software. Thus, to fix these issues, call us at 1-855-977-7463 and get the best ways to troubleshoot QuickBooks queries.

    ReplyDelete
  48. We understand that updating Gamin Maps regularly could be a tedious process –hence Garmin Express Application. This application was designed specifically to ensure an effortless maintenance of your Garmin Device. Garmin Express lets you download the Garmin Map Updates directly from the official Garmin website, in a direct straightforward manner.

    garmin updates
    garmin map updates
    garmin gps updates
    garmin nuvi updates
    garmin express updates

    ReplyDelete
  49. Please continue this great work and I look forward to more of your awesome blog posts. test bank

    ReplyDelete
  50. Keto Wave Pills This weight decline supplement is set up with normal substances to have the alternative to now not damage your body. If you have a few kind of misinformed decisions about this dietary tablet, by then you could search for counsel from the prosperity master.

    ReplyDelete
  51. If you want to find some updating options and other types of features, these features you can find in the Magellan Content Manager. Check it for Magellan updates.


    magellan gps update
    tomtom gps update
    magellan gps updates
    tomtom gps updates

    ReplyDelete