VIEW PO Orders to AP Invoices


VIEW PO Orders to AP Invoices

Share this:

Price: $199.99

 

Product Description

NOTE - This is a VIEW not a report and enables you to build dozens of reports.  

What happens now?

Once you've decided on the report or view you'd like to buy, simply add it to your basket and proceed through the checkout. You will visit 2checkout.com who are our payment processor, and on successful payment you will return to our site and the code will be unlocked for you to use. There will be a direct link in the order confirmation screen, or you can view the code at any time in the future through your Account screen.

What am I buying?

There are a total of 259 lines of code in this product. Here is an example:
87.    NVL(INV.APPROVED_AMOUNT,0) Invoice_Manual_Approval_Amount,
88.    INV.APPROVAL_DESCRIPTION Invoice_Manual_Approval_Descr,
89.    INV.APPROVAL_STATUS Invoice_Manual_Approval_Status,
90.    (NVL(INV.APPROVED_AMOUNT,0))*NVL(INV.EXCHANGE_RATE,DECODE(
91.   INV.INVOICE_CURRENCY_CODE,
92.   SOB.CURRENCY_CODE,1,NULL)) Invoice_Manual_Apprvl_Amt_Base,

Report Fields

Accrual Posted Flag Batch Name Buyer Name
Buyer Number All segments of the Chart of Accounts Invoice Date
Invoice Distr Gl Date Invoice Number Item Description
PO Document Number Posted Flag Promised Date
Accrual Posted Flag Assets Addition Code Assets Tracking Flag
Base Amount Base Currency Code Base Invoice Price Variance
Base Quantity Variance Batch Name Buyer Name
Buyer Number Cancel flag Closed Code
Destination Organization Distribution Line Number Earliest Settlement Date
Exchange Date Exchange Rate Exchange Rate Type
Exchange Rate Variance Final Match Flag Goods Received Date
Hazard Class Hold Match Status Income Tax Region
Income Tax Type Invoice Creation Date Invoice Date
Invoice Description Invoice Distr Amount Invoice Distr Amount Base
Invoice Distr Description Invoice Distr Gl Date Invoice Distr Line Type Code
Invoice Manual Approval Amount Invoice Manual Approval Descr Invoice Manual Approval Status
Invoice Manual Apprvl Amt Base Invoice Number Invoice Posting Period Name
Invoice Price Variance Invoice Price Variance Base Invoice Source
Invoice Terms Invoice Type Lookup Code Item
Item Description Item Revision Need By Date
PO Currency Code PO Document Number PO Document Type Lookup Code
PO Line Amount PO Line Amount Base PO Line Number
PO Line Type PO Unit Price PO Unit Price Base
Pay Alone Flag Posted Amount Posted Amount Base
Posted Base Amount Posted Flag Prepay Amount Remaining
Prepay Amount Remaining Base Project Name Project Number
Promised Date Quantity Quantity Invoiced
Quantity Received Quantity Variance Rate
Rate Date Rate Type Reversal Flag
Ship To Organization Shipment Amount Shipment Amount Base
Shipment Number Shipment Quantity Shipment Quantity Billed
Shipment Quantity Cancelled Stat Amount Task Name
Task Number Vat Code Vendor Name
Vendor Number Vendor Site Code