ERPstuff - Oracle EBS Community

hi,

i like to know the steps to define sequential numbering in oracle payables when we get identical invoice number from two different suppliers.


regards

sudharshan

Hi Sudarshan

The following are the steps to define sequential numbering.

1. Switch to sys admin reponsibility
2. Define a sequence
3. Define a category
4. Assign that category to the sequence.

Thanks
Karan

Sorry

i couldnt find the keyword --sequence from system admin but i could find the word sequence from "application devloper" but it is not enterable.can some one help me through this


regards

sudharshan

HI sudharshan

Follow this navigation in Sys Admin responsibility:

Application --> Document --> Define
Application --> Document --> Categories
Application --> Document --> Assign

thanks,

AMan

Assign System Administrator Responsibility to Your User navigate to

For Sequence Number Definition
Application --> Sequential Numbering --> Define


For Sequence Number Assignment
Application --> Sequential Numbering --> Assign

Hi


Thanks a lot for the information.

Is it possible to do for custom tables.


Regards

Sudharshan

Even after giving Document sequence in the payables. I have to give manually invoice number. If this is technical can you give the base table where sequence is create when we define from front end and also Select Statement to get my invoice number created automatically.

Hi Folks,

Before to above process,

the main step is you have to enable Profile Option in sys admin: "Sequential Numbering" set to Always/Partial. Then ony it will work.

thanks and regards

Hi oracleapps

I think from my low experience it couldn't generate invoice number automatic fro AP module because you use the invoice number field to enter the supplier's invoice number not your invoice number.

I think you can do this in AR by using Document sequence in AR & make it generate the automatic number for invoices.

Thanks
Hisham

Hi Murthy as you said i did process and enabled profile option eventhen also i am able to give number in invoice number filed. Is there any thing customization to be done.

Thanks

Folks,

I suppose we are trying to get the sequence number onto the invoice.

An invoice number is different from a Sequence number......Two suppliers can have the same invoice number but will always have a unique document sequence number.

When we enter an invoice details we will be able to give an invoice number......we need to go to Folder>>>show field and select the document category ....now this field will show up on the invoice....select our category that we have defined for the document sequence....and when we complete the invoice if we have asked for a message it displays a message.........After this we will be able to see a Column VOUCHER NUMBER........This is our document sequence number.

Folks this is what I know from the limited knowledge that I have....please correct me whereever I'm wrong.

Hope this helps.

Thanks,
Ben[?]

hi friends,

will anybody tell me how to assign default document category at invoice level.

thanks in advance

manpreet singh