R12 - AP Invoice Setup - 1

Hi Friends,

Today i am posting required setups related to Account Payables.

1. Payment terms : We define payment terms that we can assign to an invoice to automatically create scheduled payments when we submit Payables Invoice Validation for the invoice. we can define payment terms to create multiple scheduled payment lines and multiple levels of discounts. Payment terms have one or more payment terms lines, each of which creates one scheduled payment.

Setup>Invoice>Payment Terms

Underlying tables.

select * from AP_TERMS where name = 'XX_TERM' and term_id = 9999;

select * from AP_TERMS_LINES where term_id = 9999;

2. Distribution Sets :

Use a Distribution Set to automatically enter distributions for an invoice when you are not matching it to a purchase order.
We can assign a default Distribution Set to a supplier site so Payables will use it for every invoice you enter for that supplier site. If we do not assign a default Distribution Set to a supplier site, we can always assign a Distribution Set to an invoice when we enter it.

(N)>Setup>Invoice>Distributions Sets

 For Ex : Create an invoice and assign above created distribution set.

Click on Distributions button. verify the amount is distributed onto two accounts based distrinution set.

 select * from AP_DISTRIBUTION_SETS where distribution_set_name = 'XX_NAME';

select * from AP_DISTRIBUTION_SET_LINES where distribution_set_id = 9999;

3. Tolerances :

Use the Invoice Tolerances Template window to define the matching tolerances we want to allow for variances between invoice, purchase order, and receipt information. we can define both percentage-based and amount-based tolerances.
Tolerances determine whether Payables places matching or tax holds on an invoice. When we submit Payables Invoice Validation for an invoice that we have matched to a purchase order or receipt, Payables checks that the invoice matches the purchase order or receipt within the purchase order matching tolerances you define.


(N)>Setup>Invoice>Tolerances 

 select * from AP_TOLERANCE_TEMPLATES where tolerance_name = 'TEST_9';

4. Hold and Release Names : 

Use the Invoice Hold and Release Names window to define the names that we use to manually hold or release invoices. We can define hold names that we assign to an invoice during entry to place the invoice on hold.

(N)>Setup>Invoice>Hold and Release Names

 select * from AP_HOLD_CODES;

5. Pay Group :

Pay Groups are used to classify each invoice - Pick one Pay Group and pay all related invoices at one shot.

Setup -->  Lookup  --> Purchasing