Skip to main content

Applying Prepayments to Invoices

You can apply the available amount of Item type distributions from a Temporary type prepayment to one or more invoices to offset the amount you pay on the invoice(s). If you entered the prepayment as a Permanent type and want to apply it, you can query the prepayment in the Invoices window and change the Prepayment Type to Temporary.
If you use Automatic Offsets then your setting for the Prevent Prepayment Application Across Balancing Segments Payables option controls whether you can apply a prepayment to an invoice or expense report with a different balancing segment.
Prerequisites
The invoice type is Standard, Mixed, or Expense Report.
Today's date is on or after the Settlement Date of the prepayment.
The invoice date is on or after the date of the prepayment.
The prepayment is type Temporary, fully paid, validated, not cancelled, has no active holds, and has not already been fully applied.
The prepayment has the same supplier, invoice currency and payment currency as the invoice.
If the prepayment has a value in the Prepayment PO Number field, then the invoice must be matched to the same purchase order.
You can apply a prepayment in the following ways:
i-> Applying Prepayments in the Invoice Workbench
ii-> Applying Prepayments in the Invoice Gateway
iii-> Applying Prepayments to Invoice Records in the Payables Open Interface
iv-> Applying Prepayments to Expense Reports

Applying Prepayments in the Invoice Workbench
Payables creates Tax distributions automatically either when you choose the Calculate Tax button in the Distributions window, or when you submit Invoice Validation for the invoice. For invoices you enter in the Invoice Workbench, you can apply a prepayment either before or after you validate an invoice, or while you are entering it. If you use Line level or Tax Code level automatic tax calculation, Payables always creates separate tax lines for your Item and Prepayment type distributions.
Note: Use automatic tax calculation to create tax distributions for prepayments. Manually created tax distributions for prepayments are not included in the Distribution Total. If the Distribution Total does not match the Invoice Amount, Payables applies a hold to your invoice during Invoice Validation.
When you apply a prepayment to an invoice, you can see all available prepayment Item distributions for the same supplier in the Apply/Unapply Prepayments window. You can partially apply a Prepayment distribution by applying only a portion of its available amount.
To apply a prepayment, you can either create or query the prepayment and then select the invoice to which the prepayment will be applied, or you can create or query the invoice and then select the Prepayment distributions you want to apply. If you want to apply specific Prepayment Item distributions to the invoice, then you must query the invoice and apply the prepayment to the invoice. Otherwise, Payables will apply the amount of the application across the available Prepayment Item distributions, starting with the first Prepayment Item distribution, up to the application amount.
When you apply a prepayment, you can print a Prepayment Remittance Notice, which you can send to the supplier. This notice states that a prepayment has been applied to an invoice and this may result in a decreased payment or nonpayment of the invoice.
To apply a prepayment to an invoice in the Invoice Workbench:
1. In the Invoices window, query either the prepayment or the invoice to which you want to apply it.
2. Choose the Actions button and select the Apply/Unapply Prepayment check box. Choose OK. The Apply/Unapply Prepayments window opens. This window shows different information depending on what you queried, an invoice or a prepayment. If you initially queried a prepayment, Payables displays all invoices that are not fully paid and to which the prepayment can be applied. If you want to limit available choices, enter a query or use the Find Invoices to Apply window by choosing Find from the View menu.
Check the Apply check box for each Prepayment distribution you want to apply to the invoice.
If the invoice references a prepayment, check the Prepayment on Invoice check box for each prepayment distribution that reduced the amount of the invoice.
Enter the amount to apply for each prepayment distribution.
Optionally change the GL Date, which is the accounting date for the new Prepayment distributions that Payables creates when you apply a prepayment. If you want to see more information on an invoice, select it and choose the Invoice Overview button.
If you initially queried an invoice, Payables displays all validated and paid Prepayment distributions that you can apply to the invoice. If you want to limit available choices, enter a query or use the Find Prepayments to Apply window by choosing Find from the View menu.
Check the Apply check box for each Prepayment distribution you want to apply to the invoice. Enter the amount to apply for each prepayment. Optionally change the GL Date, which is the accounting date for the new Prepayment distributions that Payables creates when you apply a prepayment. If you want to see more information on a prepayment select it and choose Invoice Overview.
3. If you want to print a Prepayment Remittance Notice for the supplier, select the Print check box.
4. Choose the Apply/Unapply button to apply the prepayment amounts you specified and to save your work.
5. Review the new Prepayment distributions for the invoice in the Distributions window. On the Prepayment distributions you can adjust the values in the description fields. Make any necessary adjustments to account for tax on the invoice.
6. Save any changes and validate the invoice. Any unpaid amount remaining on the invoice is ready for payment.
Applying Prepayments in the Invoice Gateway
For Invoice Gateway invoices, you specify the prepayment information when you enter the invoice record. During import Payables applies the prepayment. You can also apply prepayments to invoices in the Invoice Workbench after you import them.
Note that for Invoice Gateway invoice records Payables applies the prepayment during import, so the available prepayment amount is available to apply to other invoices until import.
You can apply a specific prepayment or multiple prepayments to an invoice. If you enter only a prepayment amount and do not identify a specific prepayment, Payables applies available prepayments for that supplier, in order of oldest prepayment to the newest, up to the prepayment amount. You can specify the first prepayment to apply. If the prepayment amount you enter exceeds the available amount on the specified prepayment, Payables then applies other available prepayments, in order of oldest to newest, up to the remaining prepayment amount.
When you enter an invoice record in the Invoice Gateway, Payables does not notify you if you have available prepayments for the same supplier. You can submit the Prepayments Status Report to get the prepayment details you need to successfully apply the prepayment.
You can apply one or all prepayment Item distributions. If you do not specify a value for Prepayment Distribution, Payables applies the prepayment amount across all available prepayment Item distributions in chronological order, starting with the first prepayment Item distribution, up to the prepayment amount. You cannot apply more than the total amount of available prepayment Item distributions, and you cannot apply more than the total amount of the Standard invoice you are entering.

Applying Prepayments in the Invoice Gateway
For Invoice Gateway invoices, you specify the prepayment information when you enter the invoice record. During import Payables applies the prepayment. You can also apply prepayments to invoices in the Invoice Workbench after you import them.
Note that for Invoice Gateway invoice records Payables applies the prepayment during import, so the available prepayment amount is available to apply to other invoices until import.
You can apply a specific prepayment or multiple prepayments to an invoice. If you enter only a prepayment amount and do not identify a specific prepayment, Payables applies available prepayments for that supplier, in order of oldest prepayment to the newest, up to the prepayment amount. You can specify the first prepayment to apply. If the prepayment amount you enter exceeds the available amount on the specified prepayment, Payables then applies other available prepayments, in order of oldest to newest, up to the remaining prepayment amount.
When you enter an invoice record in the Invoice Gateway, Payables does not notify you if you have available prepayments for the same supplier. You can submit the Prepayments Status Report to get the prepayment details you need to successfully apply the prepayment.
You can apply one or all prepayment Item distributions. If you do not specify a value for Prepayment Distribution, Payables applies the prepayment amount across all available prepayment Item distributions in chronological order, starting with the first prepayment Item distribution, up to the prepayment amount. You cannot apply more than the total amount of available prepayment Item distributions, and you cannot apply more than the total amount of the Standard invoice you are entering.
Additional Prerequisite for the Invoice Gateway
Get up-to-date prepayment information from the Prepayments Status Report. To apply a prepayment to an invoice in the Invoice Gateway:
1. In the Invoice Gateway window, enter a Standard type invoice record.
2. Enter the following fields to apply a prepayment to the invoice during import.
Prepayment Number: Invoice number of the prepayment.
Prepayment Distribution: Distribution number of the prepayment Item distribution you want to apply. Leave blank to prorate the amount across all available prepayment Item distributions.
Prepay Apply Amt: Amount of the prepayment you want to apply.
Prepayment GL Date: Accounting date for the prepayment application. This will be the GL Date on the Prepayment distribution that import creates for the invoice.
3. If the supplier invoice references the prepayment, then enable the Prepayment on Invoice check box.
4. Submit Payables Open Interface Import to import the invoice record. Payables applies the prepayment amount to the invoice during import.
5. View the new distributions for the Standard invoice in the Distributions window. On the Prepayment distributions you can adjust the value in the Description field. Make any necessary adjustments to account for tax on the invoice.
6. Save any changes and validate the invoice. Any remaining unpaid amount on the invoice is ready for payment.

Comments

  1. This is an awesome post.Really very informative and creative contents. These concept is a good way to enhance the knowledge.I like it and help me to development very well.Thank you for this brief explanation and very nice information.Well, got a good knowledge.
    Invoices Apps

    ReplyDelete

Post a Comment

Popular posts from this blog

Application Utilities Lookups and Application Object Library Lookups

Maintain existing and define additional Lookups for your shared Lookup types. You can define up to 250 Lookups for each Lookup type. Each Lookup has a code and a meaning. For example, Lookup type YES_NO has a code Y with meaning Yes, and a code N with a meaning No. Note: In Releases 11.0 and earlier, there were two Lookup features, Special Lookups and Common Lookups. These two features have been merged into one. The new consolidated Lookups feature has Lookups maintained in this form. If you make changes to a Lookup, users must log out then log back on before your changes take effect. Lookups Block Type Query the type of your Lookup. You can define a maximum of 250 Lookups for a single type. User Name The user name is used by loader programs. Application Query the application associated with your Lookup type. Description If you use windows specialized for a particular Lookup type, the window uses this description in the window title. Access Level The access level restricts changes that...

About Bank Reconciliation

The diagram in this section provides an overview of the Cash Management process, from entering bank statements to posting accounting entries to your general ledger. There are two major process steps you need to follow when reconciling bank statements: 1. Load Bank Statements: You need to enter the detailed information from each bank statement, including bank account information, deposits received by the bank, and payments cleared. You can enter bank statements manually or load electronic statements that you receive directly from your bank. (See: Entering Bank Statements Manually and Loading Bank Statement Open Interface ) 2. Reconcile Bank Statements: Once you have entered detailed bank statement information into Cash Management, you must reconcile that information with your system transactions. Cash Management provides two methods of reconciliation: Automatic--Bank statement details are automatically matched and reconciled with system transactions. This method is ideally suited for b...