Buy Off Report Format
The Accrual Write-Off Report to provide supporting detail for your write-off journal entries. The process is as follows. First, you analyze the Accrual Reconciliation Report for transactions that you should expense out of the accrual accounts. After you have researched the reported accrual balances, you then use the Accrual Write-Off window to indicate which entries you wish to remove and write off from this report. And, after you have written off these entries, you use the Accrual Write-Off Report as supporting detail for your manual journal entry.
buy off report format
Once you have completed the accrual reconciliation process, you can use this report to display written off transactions for the following problems in receiving, purchasing, inventory, work in process, or accounts payable transactions:
Since this report displays transactions from purchase order receipts and accounts payable invoices, you must install Purchasing and Payables to run this report. If you have Inventory or Work in Process, the Accrual Write-Off Report also displays any inventory or work in process transactions you have written off.
For each Advance Shipment Notice (ASN) sent to you by your supplier, the Advanced Shipment Notice Discrepant Receipts report checks for overshipped or unfulfilled shipments. It looks for discrepancies between what the ASN said was shipped and what you actually received. In addition, these discrepancies are sent to the Oracle e-Commerce Gateway process responsible for generating Application Advices. (For example, Application Advices are sent back to suppliers detailing errors that occurred when the suppliers sent ASNs.)
The report evaluates discrepancies for expected receipt dates that fall within the date range you enter. It also sends information to e-Commerce Gateway for the generation of Application Advices, if the expected receipt date of the shipment falls within the date range you enter.
The purpose of this report is to show all Oracle Payables (AP) and Oracle Purchasing (PO) transactions where the AP transactions are matched to PO (could be receipt as well). The AP and PO Accrual Reconciliation Report provides a transactional breakdown of each accrual account with a net balance not equal to zero in a summarized or full transaction details version. In summarized mode, for each accrual account, only the distribution information and PO, AP, WO (Write-Off) and Total Balances are displayed. For detailed mode, the individual transaction details for each distribution are also shown.
If you install Purchasing and Oracle Payables, you can run this report. If you accrue expense purchases on receipt, you can reconcile your expense AP accrual account using this report. If you accrue expense purchases at period end and you do not perform inventory receipts, no information will be available to report.
Important: Most commercial installations accrue expense receipts at period end because this information is not required as the receipt occurs. If you accrue expense purchases on receipt, you have more entries to reconcile in the AP accrual accounts.
The Blanket and Planned PO Status report can be used to review purchase order transactions for items you buy, using blanket purchase agreements and planned purchase orders. For each blanket purchase agreement and planned purchase order you create, Purchasing provides you with the detail of the releases you created against these orders. Purchasing prints the blanket agreement or planned purchase order header information, if no release exists.
The Buyer Listing shows the buyer name, default purchasing category, ship-to location, and effective dates of all buyers or a selected set of buyers. You can also use the report to isolate buyers who are assigned to a category of procurement items. See: Defining Buyers.
The Contract Status Report can be used to review the status of your contracts and list purchase order information for each contract. Purchasing prints the contract information if there are standard purchase order lines that reference that contract.
The country of origin is the country in which an item is manufactured. This report displays the countries of origin specified on the purchase order shipment and the receipt. This report also displays the purchase order and receipt number for the item.
The country of origin is the country in which an item is manufactured. This report displays the Country of Origin specified in the Approved Supplier List (ASL). It also includes the supplier item information, the ASL status, and unit of measure for each item. See: Defining the Supplier/Item Attributes.
The CUM History Report prints details of receipts, returns and adjustment activity that have impacted the CUM for a specified CUM period. This report also includes the receipts, returns and adjustment activity created for standard purchase orders that refer to Global Blanket Purchase Agreements (GBPAs) which have the Supply Agreements checkbox selected.
The Encumbrance Detail Report can be used to review requisition and purchase order encumbrances for a range of accounts if you have enabled the encumbrance option for requisitions or purchase orders, and have entered and approved requisitions and purchases. You use this report to review the accounts encumbered.
Receipt accrual: You can generate the Encumbrance Detail Report as needed when the Accrue at Receipt option is used for expense destinations. Upon entering receipt delivery information, an automated process transfers the receipt information to General Ledger using the Journal Import Process. For inventory destinations, you must first run the Oracle Inventory Transfer to General Ledger process before the encumbrance activity can be shown in this report.
Period-end accrual: Encumbrance reversals created from the period-end accrual process are not reflected in the Encumbrance detail report. Only encumbrance reversals from invoices are reflected in the report, and the timing depends on encumbrance type setup in Oracle Purchasing and Oracle Accounts Payable:
If Accounts Payable and Purchasing use the same encumbrance type, the report reflects encumbrance reversals at the time of either invoice posting (for Accrual basis accounting) or payment posting (for Cash basis accounting). If posting is required, you must first run the Oracle Accounts Payable Transfer to General Ledger process (for invoices or payments, as needed).
The Expected Receipts Report can be used to review all or specific supplier sourced expected receipts or expected customer returns that have not yet been received for a particular date or a range of dates. The report excludes purchase orders that are cancelled, closed, or closed for receiving at the header, release, line, or shipment level. You can specify the expected receipts you want to review.
Use this report to improve or speed up your receiving operations. Your receivers may sometimes not have access to Oracle Applications when they need to enter receiving transactions. They can use the report of expected receipts to record receiving transactions and later enter them. There is space at the end of each shipment for you to record comments, the receipt date, and the quantity/amount you received.
The Financials/Purchasing Options Listing can be used to review the options set for your system in the Financials Options and Purchasing Options windows. This report also displays your receipt numbering options in the Receiving Options window, for each organization.
The Internal Requisitions/Deliveries Discrepancy Report lists requisition documents with items whose source type is inventory. Internal requisitions are typically for transfers of material from your inventories. Use this report to identify goods that have been shipped and have a delivery discrepancy. This report can be run only if Order Management is installed.
If the invoice price and the purchase order unit price are in the same currency but the exchange rates differ, the exchange rate variance is also displayed in this report. For example, if the report displays an invoice price variance of -9.5 and an exchange rate variance of -6, the total invoice price variance of -9.5 includes the exchange rate variance of -6.
The Item Detail Listing shows detail information for items defined as Purchasing Items in the Item window as well as unit of measure conversion, notes, manufacturer part numbers, and dispositions assigned to the item. Purchasing lets you isolate items by limiting the items, categories, or buyer you want to review. For example, if your categories reflect purchased commodities, you can use the listing to review what manufactured items are for a commodity.
The Item Summary Listing shows the inactive or active status of items. You can also use the report to review the commodities of items that are inactive. And, finally, you can use the report as a listing of all items defined as Purchasing Items in the Items window.
The Location Listing shows internal organizations locations and addresses. Purchasing lets you specify which locations you want to review: Ship To, Bill To, Office, Internal, and Receiving. Use this report to isolate locations which are only for a specific function, such as locations where receiving is permitted. This document can be used as a resource when entering purchase order receiving locations.
The Matching Holds by Buyer Report can be used to review all or selected invoices that Purchasing or your accounts payable system placed on matching hold. You can review price holds, quantity ordered holds, quantity received holds, and quality holds. You can review the matching holds for one or more buyers. After printing all of a particular buyer's matching holds, Purchasing prints summary matching hold information for this buyer. At the end of the report, Purchasing prints summary matching hold information for all of the buyers that you selected. This report helps you understand why an invoice is on hold and provides you with the information you need to solve the problem. You can also monitor the performance for suppliers or buyers using this report. 041b061a72