AR : Adjustments 1

http://docs.oracle.com/cd/A60725_05/html/comnls/us/ar/recpts10.htm


Lookup --> select * from ar_lookups where lookup_type = 'ADJUSTMENT_TYPE';

LOOKUP_CODE    MEANING

CHARGES    Charges Adjustments
FREIGHT    Freight Adjustments
INVOICE    Invoice Adjustments
LINE    Line Adjustments
TAX    Tax Adjustments

===================================================================================
Approval Type

select LOOKUP_CODE , MEANING from ar_lookups where lookup_type = 'APPROVAL_TYPE';


LOOKUP_CODE    MEANING

A    Approved
M    More Research
R    Rejected
U    Unaccrued Charges
W    Waiting Approval

==========================================================================
select LOOKUP_CODE , MEANING from ar_lookups where lookup_type = 'INV/CM';

LOOKUP_CODE    MEANING

BR    Bills Receivable
CB    Chargeback
CM    Credit Memo
DEP    Deposit
DM    Debit Memo
GUAR    Guarantee
INV    Invoice
PMT    Payment
=======================================================================
User Guides can be found on following links.

http://www.vpaf.uni.edu/obo/accts_receivable/documents/ar_reportss.pdf

======================================================================

Oracle Adjustments

http://www.oracleappshub.com/accounts-receivable/ar-adjustments-detailssetup-flow-accounting-and-api/

An Adjustment in AR is an amount added or subtracted from the amount due of an Invoice, Debit Memo, Chargeback, Deposit, or Guarantee.

Oracle AR lets you create Automatic or Manual Adjustments.

Receivables lets you make either Positive or Negative Adjustments to your Invoices, Debit Memos, Chargebacks, On–account Credits, Deposits, and Guarantees.

You can approve Adjustments that are within your approval limits and give pending statuses to Adjustments that are outside your approval limits.

You can also automatically write off debit items that meet your selection criteria.

 Business need for Adjustment

Its very similar to write-off. If there is any unapplied balance in invoice after application of receipt in small value for rounding off purpose , that will be adjusted while making receipt application.

Or sometime, when Invoice amount is wrongly entered you can also add a line by adding or reducing amount.

These are very common across all industry.Telecom, Health care and retail sectors the need is very high for such functionality.

Prerequisites

To enable this Functionality you need to perform these step-up

• You need to define adjustment activity
• Navigation :-> AR Super User :->Setup --> receipts --> receivable activities.

• You need to define approval limits

Defining the Approval limits for Adjustments

Setup > Transactions > Approval Limits

• You need to define adjustment reason lookups

 Irrelevant