cancel
Showing results for 
Search instead for 
Did you mean: 

Document ID in Bank Statement

Former Member
0 Kudos


Hello Experts,

I created a remittance advice for an outstanding Customer Invoice with payment method as bank transfer. Later I created a bank Statement ( Bank Statement ID is 92) to clear the remittance Advice. The open Customer Invoice was cleared automatically after releasing the bank statement. If I look at the document flow of the remittance advice then it shows that the invoice was cleared by the bank statement but the Bank Statement Id was showing as different number. ( See the attachment - Remittance Advice.jpg ).

If I open the bank Statement which I created then in the Bank Statement I can see Document ID in the bank Statement. ( See attachment Bank Statement.jpg). I want to know, what is document Id in the bank Statement and where we have number range for this document ID.

Regards,

Saurabh

Accepted Solutions (0)

Answers (2)

Answers (2)

alexandre_colombo
Active Participant
0 Kudos

Hi Saurabh,

This is the designed system behavior. The ID 92 that you see corresponds to the Statement ID of that bank statement. Each year, the IDs starts over.

The Statement ID can be re-used. For example, considering bank account "A" you start the year with Document ID 1 and Statement ID 1. The subsequent bank statement would have Document ID 2 and Statement ID 2.

If you reverse/cancel this bank statement 2, the next bank statement that you create will have Document ID 3 and Statement ID 2

In short, the Statement ID counts the number of bank statement for a given bank account. Note that number can be skipped here. (The system raises an warning if that happens.). The Document ID is number of bank statements regardless of the bank account. Following the above example, if you create a new bank statement for bank account "B" it would have Document ID 4 and Statement ID 1.

For the ID structure i.e.: 115-1 that you see in the document flow, the "-1" corresponds to the transaction ID of the advice in the bank statement, as mentioned by Marlene

I hope this clarifies your query.

Regards,

Alexandre.

0 Kudos

Hi Saurabh

this is the internal bank statement ID, the 115-1 is the combination internal bankstatement ID + item.

Best regards

Marlene

0 Kudos

Hi Saurabh

Bank Statement internal ID share one number range per company, which starts with 1 per calendar year.

Best regards

Marlene