Update the document num/ voucher num in any modul

[noorkhanan]

Hi i want to explain , if you want to update the document number/voucher number after once you created invoices, payments,jvs,transactions or receipts you will do by this way.

select * from FND_DOC_SEQUENCE_ASSIGNMENTS.

In above table you can get the doc_sequence_id and the category_code
which you have defined for the financial year


SELECT NAME,START_DATE,END_DATE,TYPE,MESSAGE_FLAG,INITIAL_VALUE,AUDIT_TABLE_NAME,DB_SEQUENCE_NAME,TABLE_NAME,DOC_SEQUENCE_ID,APPLICATION_ID
FROM FND_DOCUMENT_SEQUENCES


FND_DOCUMENT_SEQUENCES table have information of

1) db sequences tables which are created at the time of document category creation. you will update the sequence number in sequences table under column DB_SEQUENCE_NAME up to your required sequence in next number column.

2) Audit table information in AUDIT_TABLE_NAME column.
e.g AP_DOC_SEQUENCE_AUDIT etc.
In this table you will insert new records. i missed 2 vouchers number so i will insert 2 records here.

3) voucher tables i.e AP_INVOICES_ALL,GL_JE_HEADERS etc. under column TABLE_NAME,
here you will only update doc_sequence_id,doc_sequence_value.


Hopefully this will help you.