Problem with Document Sequencing in AR

[aganguly]

Hi Friends,

I am having the following problem related to Document Sequencing in AR. Posting this issue with a hope that I would get some help from an expert person.

Every year we create Document Sequence for the new financial year and the Document Sequence starts from 1.

In AR we have around 25 Doc. Seq. and all the Doc. Sequences are working fine except 1. This particular Doc. Seq. is related to VAT. This is not starting with 1 in a new financial year. It is continuing with the old Doc. Seq. number and is getting incremented.

Can anyone help me how to find out the problem behind it.

Creation of Doc. Seq.,Category and Assignment are absolutely ok.


Thanks in advance.

aganguly

[oteixeira]

Hello.
What kind of transactions are being numbered by this Document Sequence?

Octavio

[aganguly]

Hi,

Misc-Tax-Invoice(VAT Related) transactions are numbered by this Document Sequence.

We have created the setup thru VAT Document Sequencing. But still it is not working.

Nevigation- India Local Receivables-> India TCS/VAT/Service Tax -> Setup -> VAT Document Sequencing -> Document Sequencing Setup.

Here the Current Number is showing as 1 against the Document Type name but actual curent number is 403.

Thanks.

aganguly

[oteixeira]

Hello.

Try the following:
-Obtain the DOC_SEQUENCE_ID used by one of the problematic transactions

SELECT doc_sequence_id FROM ra_customer_trx_all WHERE customer_trx_id = <your customer_trx_id>

Check to see if it is using the correct one:

SELECT name FROM fnd_document_sequences WHERE doc_sequence_id = <value obtained in the first query>

Octavio

[aganguly]

Hi,

I have checked up with the sql provided by you and found that it is not using the correct document sequence.

But we have done the set up correctly.

What is the solution to rectify this problem.

Thanks.

A. Ganguly

[oteixeira]

Hello Ganguly.

Well, if you are sure that the sequence setup is ok it is difficult to find out what can be wrong.
Anyway, you should have a Sequence Assignment with the type of your problematic transactions with:
Application=Receivables
Category=The name of your transaction type
End Date=Null
Set of Books=The appropriate SOB
Method=Depending of the creation method, you may need to have two lines, one for Manual and one for Automatic.

Also search for the sequence that is assigned to the problematic transactions and find out why it has not an end date.

Octavio.