[an error occurred while processing this directive]
[an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive]
[an error occurred while processing this directive]

Entering Zero Dollar Invoices

Updated 02/11/2021

Printable Versionpdf icon Oracle R12 - Quick Reference Guide

Note: All $0.00 Invoices should be recorded as manual payments after all steps in this QRG have been completed. For details on how to perform a manual payment see the QRG titled - ENTERING AND RECORDING A MANUAL PAYMENT.

Introduction

This QRG has information on how to fix entries related to:

  • Using the wrong accounting strings
  • Using the incorrect Project (POET information)
  • Referencing the wrong Purchase Order or Purchase Order lines

Invoices > Entry > Invoices

Invoice Workbench

To enter a zero dollar invoice, complete the following steps:

Step Number Field Name Description Action
1. Operating Unit Operating unit invoice is to be entered for. Defaults based on responsibility or Select from list of values (LOV).
2. Type Document Type Select 'Standard' for corrections of Non-Matching Invoices (this is the default).

Select 'Mixed' for corrections involving matching to the correct purchase order. If you do not choose mixed, the correction document will not be able to be validated and must be cancelled.
3. Invoice Num   Vendor’s invoice number - See Document Numbering Scheme.

This is the addendum information that goes to the vendor (comments to print).

Do not use special characters (e.g. “*”) in the invoice number, or enter spaces after the invoice number. Using special characters in the invoice number or adding spaces after the invoice number, can cause the SPS payment file to fail to upload into the SPS system.

Please note when entering an invoice that has Project Accounting invoice numbers need to be 30 characters or less.
4. Supplier Supplier Name Enter the Supplier Name or Select from the LOV.
5. Supplier Number Supplier Number Defaults if Supplier entered first or Select from LOV.
6. Supplier Site Supplier Site Defaults based on Supplier Number, otherwise select from LOV.
7. Invoice Amount Invoice Amount Enter $0.00.
8. Invoice Date Invoice Date Enter date listed on invoice in MM/DD/YYYY format or Select from calendar view.
9. Log/Accepted Date Log/Accepted Date Enter the later of log or delivery/acceptance date in MM/DD/YYYY format.
10. GL Date Determines the accounting period. Defaults to the system date. You will need to change if attempting to post in a period other than the current period. The format is MM/DD/YYYY.
11. Description Invoice Description Description of the invoice. Can be used to help a customer identify the purpose of the transaction.

Note: This will not display on the payment record sent to the supplier.
12. [ ] These fields are Descriptive Flexfields, which captures additional information for the invoice header. If choosing Check as Payment Method, you will need to update the EFT Exception Reason Code with “Correction".

If the corrections you are making do not involve matching to a Purchase Order that has been created in Prism, you should change the SEND INVOICE TO PRISM flexfield to “No”.
13. Terms Terms of Invoice Enter ‘Immediately’ if these terms have not already defaulted.
14. Payment Method Payment Method Defaults based on the supplier.

If the Payment Method is Check or Interagency, leave the default value.

If the Payment Method is Electronic, you must change the value to check.
15. Pay Group Used to select invoice for payment Change the pay group to “Manual Pay In Full”.
16. Payment Reason Payment Reason Defaults in from Trading Partner entered.

Your next action will depend on what you are trying to correct. Click on the appropriate link below.

After you have made all necessary corrections and validated the invoice, you will need to pay the invoice in full. Refer to the QRG titled ENTERING AND RECORDING A MANUAL PAYMENT.

Correcting Matches to Incorrect Purchase Orders

This section is only for matching to correct transactions involving the wrong Purchase Order. *If you do not need to match, you may skip this section.

Step Number Field Name Description Step
1 Match button Creates a Match to a PO Click on the Match button.This will bring up the Find Purchase Orders for Matching Window.

Find Purchase Orders for Matching Window

Perform the following steps to find purchase orders for matching:

Important: You will need to match against both the PO that was matched by the original invoice and the PO that should have been matched to the original invoice.

Step Number Field Name Description Action
1 Purchase Order Num Lists the Purchase Orders for that vendor. Select the PO number
2 Find Button Finds the Purchase order selected. Click the Find button.This will bring up the Match to Purchase Orders Window.

Match to Purchase Orders Window

Perform the following steps on the Match to Purchase Orders window:

Step Number Field Name Description Action
1 Match checkbox Selects the PO shipment to match to the invoice. Check the Match checkbox next to the shipment line of the Purchase Order that you want to match against.
2 Qty Invoiced Amount to match to the PO line Enter the same quantity that was used to match to the incorrect PO.Copy the quantity directly from the applicable shipment on the PO Summary to insure correctness.

If you are matching to the incorrect PO, enter a negative quantity.

If you are matching to the correct PO, enter a positive quantity.
3 Unit Price Price per Unit Ordered Do not update this field.

An error message will be received if you do and attempt to save.
4 Match Amount Amount to match to the PO Tab to this field.Oracle will calculate the match amount by multiplying the quantity billed by the unit price.
5 Match button Matches the invoice to PO Click the Match button.
6 OK button Saves the transaction Click the OK button.
7 Repeat steps 1 through 6 until all incorrect lines have been replaced by corrected accounting strings.
8 Save Icon Saves any pending changes Click on the Save Icon (Yellow Disk)
9 Exit Exit the screen Select the X in the top right corner of the Distribution screen

Repeat the matching process until you have corrected all needed lines.You will have a positive match and a negative match for each matching line you are correcting.

You should now validate the invoice.Please go to that section by clicking on link to the left.

Correcting Wrong Accounting Strings

This section is only for correcting transactions that involve incorrect accounting strings.*If you are correcting Purchase Orders matched to only, you may skip this section.

Step Number Field Name Description Action
1 Lines tab Takes you to the Lines section. Click on the Lines tab this will open the Lines form.
2 Amount Amount of the line. Enter zero.
3 Distributions button Distributions button. Select the distributions button to enter distributions to be tied to the line.
4 Type Distribution Type Defaults to 'Item'. Do not change.
5 Distribution amount Amount of Distribution Enter the dollar amount for the distribution.

If this distribution is to reverse prior accounting, enter the amount as a NEGATIVE.

If this distribution is to enter the correct accounting, enter the amount as a POSITIVE.
6 Account Accounting String (AFF) If this ties to negative amount enter the accounting string(s) from the invoice(s) you are correcting.

If this ties to the positive amount enter the correct accounting string.
7 GL Date Used to determine accounting period Defaults to system date.May need changed to reflect proper accounting period.
8 Description Description for distribution line. Enter a description for the correction being made.
9 Global Descriptive Flexfield - GDF ( ) GDF - ( ) Non-Federal Suppliers - The BETC (Agency BETC) will default as DISB, It is not necessary to enter the ( ) GDF field unless the default should be updated.

Federal Suppliers - Click into the ( ) GDF. Click the Context Value LOV. Context Value will populate with ‘US Federal Attributes’.Populate the Trading Partner TAS. The Trading Partner BETC will default based on the Trading Partner TAS. BETC (Agency BETC) is also required and will default as DISB but can be edited if appropriate.
10 [ ] - Descriptive Flexfield (DFF) Descriptive Flexfields - Additional fields used to capture information for reporting purposes. Enter the same information that was entered for the distribution line(s) being corrected.

Repeat steps 1 through 10 until all incorrect lines have been replaced by corrected accounting strings.

Step Number Field Name Description Action
11 Save Icon Saves any pending changes Click on the Save Icon (Yellow Disk).
12 Exit Exit the screen Select the X in the top right corner of the Distribution screen.

You should now validate the invoice. Please go to that section by clicking on the link.

Correcting Incorrect Project (POET information)

This section is only for correcting transactions that involve incorrect accounting strings.*If you are correcting Purchase Orders matched to only, you may skip this section.

Step Number Field Name Description Action
1 Lines tab Takes you to the Lines section. Click on the Lines tab this will open the Lines form.
2 Amount Amount of the line Enter zero.
3 Distributions button Distributions button Select the distributions button to enter distributions to be tied to the line.
4 Type Distribution Type Defaults to 'Item'.Do not change.
5 Distribution amount Amount of Distribution Enter the dollar amount for the distribution.

If this distribution is to reverse prior accounting, enter the amount as a NEGATIVE.

If this distribution is to enter the correct accounting, enter the amount as a POSITIVE.
6 Account Accounting String (AFF) Do not populate this field as the POET information should be entered which will then auto populate this field.
7 Project The Project the distribution needs tied to. If this ties to negative amount enter the Project from the invoice(s) you are correcting.

If this ties to the positive amount enter the correct accounting string
8 Expenditure Organization Expenditure Organization ties to the Internal_ORG AFF value. If this ties to negative amount enter the Expenditure Organization from the invoice(s) you are correcting.

If this ties to the positive amount enter the correct Expenditure Organization
9 Expenditure Type Expenditure Type ties to the BOC AFF value. If this ties to negative amount enter the Expenditure Type from the invoice(s) you are correcting.

If this ties to the positive amount enter the correct Expenditure Type to be billed.
10 Task There is at least one task per Project. If this ties to negative amount enter the Task from the invoice(s) you are correcting.

If this ties to the positive amount enter the correct Task.
11 Expenditure Item Date This date should match the GL date entered on the invoice distributions. Defaults to GL date entered on invoice header. May need changed to ensure it matches to GL date on distribution.
12 GL Date Used to determine accounting period Defaults to system date.May need changed to reflect proper accounting period.
13 Description Description for distribution line. Enter a description for the correction being made.
14 [ ] - Descriptive Flexfield (DFF) Descriptive Flexfields - Additional fields used to capture information for reporting purposes. Enter the same information that was entered for the distribution line(s) being corrected.
15 Global Descriptive Flexfield - GDF ( ) GDF - ( ) Non-Federal Suppliers - The BETC (Agency BETC) will default as DISB, It is not necessary to enter the ( ) GDF field unless the default should be updated.

Federal Suppliers - Click into the ( ) GDF. Click the Context Value LOV. Context Value will populate with ‘US Federal Attributes’.Populate the Trading Partner TAS. The Trading Partner BETC will default based on the Trading Partner TAS. BETC (Agency BETC) is also required and will default as DISB but can be edited if appropriate.

Repeat steps 1 through 14 until all incorrect lines have been replaced by corrected POET strings.

Step Number Field Name Description Action
16 Save Icon Saves any pending changes Click on the Save Icon (Yellow Disk)
17 Account Accounting string (AFF). Once the distributions were saved the POET information should cause the Account field to auto populate.

Note: The Default USSGL will be populated but must be updated to the appropriate USSGL, i.e. 61000001
Once charge account populates update the USSGL to the appropriate USSGL, i.e. 61000001.
18 Exit Exit the screen Select the X in the top right corner of the Distribution screen

You should now validate the invoice. Please go to that section by clicking on the link.

Validating the Invoice

Step Field Name Description Action
1 Actions... Button Validates the document Select the Validate checkbox.
2 OK button Confirms the validate action Click the OK button.
3 Status Status of the document Make sure the status of the document is 'Validated'.
4 Global Descriptive Flexfield - GDF ( ) GDF ( ) Click All Distributions.Review the GDF ( ) values for BETC, which populates from the matched Purchase Order. Update-/Change if necessary.If the values did not populate from the matched purchase order they must be entered and the changes saved.

Note: For Federal Suppliers Only, populate the Trading Partner TAS and Trading Partner BETC. For all suppliers BETC is required.

If you have corrected an IPAC related invoice, you will need to record the transaction in the IPAC Interagency Transfer Window.

Reminder: All $0.00 Invoices should be manually paid.For details on how to perform this step see the QRG entitled - ENTERING AND RECORDING A MANUAL PAYMENT.

Back to Top

[an error occurred while processing this directive] [an error occurred while processing this directive]