AR invoice number sequence in oracle apps
In this post , we will discuss how we can define AR invoice number sequence in oracle apps.Document sequence helps to assign the number to Oracle transactions which occurs more than once, by numbering them you can identify the order of its generation. It acts like a chain and if a number goes missing, the link is broken and you can see that there was a deletion or removal of the transaction. AR invoice number sequence in oracle apps helps to assign the unique sequence for AP invoice based on the category and then after that, system refer that sequence number for generating document numbers for the AP invoices. In general business practice we create the document sequences for each transaction every year for audit point of view. Here below I will share the complete setup of AR invoice number sequence in oracle apps.
Detail steps for AR invoice number sequence in oracle apps.
Step1:- Go to General Ledger responsibility
Setup => Financials ==> Sequences
Step2:- In this Step We define the Sequences
Sequences ==> Define
Here,
a) Give a name to your order Sequence,
b) Select Applications as : Payables
c) Select effective dates
d) Type: Choose as Automatic.
e) Select a Initial Value. Lets take it as 2500 in our case.
f) Save your work
a) Give a name to your order Sequence,
b) Select Applications as : Payables
c) Select effective dates
d) Type: Choose as Automatic.
e) Select a Initial Value. Lets take it as 2500 in our case.
f) Save your work
Step3:- We have already defined our Document sequence in the Last Steps now we will assign the that sequence to the Transaction Category.
Define Document Categories
You can create a document category for shipping documents such as a packing slip, bill of lading and assign it to a location or all locations.
But for for new transaction types, a new document category gets created automatically with same Name
You can create a document category for shipping documents such as a packing slip, bill of lading and assign it to a location or all locations.
But for for new transaction types, a new document category gets created automatically with same Name
Assign Document Sequence
After defining document sequences and categories, we need to assign document sequences to document categories.
After defining document sequences and categories, we need to assign document sequences to document categories.
a)
Select Application as Payables
b) As already stated, transaction type is "Invoices". we will create new orders for this transaction type and will see the numbering for the same
c) Ledger: Vision Operations
d) Method: This the method of entering the documents. This is Optional
Automatic: if you are using some interface to create documents, then this numbering will take affects
Manual: manual way of entering the sales order then this will take effect
Now move to second Tab: Assignment
b) As already stated, transaction type is "Invoices". we will create new orders for this transaction type and will see the numbering for the same
c) Ledger: Vision Operations
d) Method: This the method of entering the documents. This is Optional
Automatic: if you are using some interface to create documents, then this numbering will take affects
Manual: manual way of entering the sales order then this will take effect
Now move to second Tab: Assignment
Step 4:- Here below is the document sequence assignment part 2.
0 comments:
Post a Comment