Invoicing Number Range

[Former Member]

Hi

We are facing an issue with the invoicing number range. We have about 15 number ranges defined for the manual processing. When a user is trying to invoice an account for multiple months system is creating the invoices out of sequence.

For Example

Number ranges availbe

101 - 199

201 - 299

301 - 399

401 - 499

May, June, July months invoices need to be created. (Due to BBP, separate invoices will be created for each month).

User selected all the 3 months bill documents.

At the end of invoicing

May month got the invoice number = 433.

June got the invoice number = 155

July got the invoice number = 322

When we leave this on system we get the correct number allocation why not with the manual invoicing. I checked the buffering is not on for any of the number ranges.

Any idea?

Thanks

[william_eastman · Accepted solution]

Ankur:

There is no system guarantee to pick the same range in your scenario, as they are three distinct invoicing processes.  Beyond that, the number given is not material to the system, only the timestamps and the sequence kept internally.  If you need this then you need to eliminate the multiple ranges from the configuration but of course that is there for performance benefits.

regards,

bill.

[Former Member]

Thanks William for the reply.

The problem is timestamp of all 3 invoices are same, so without looking at the billing document it is hard to tell the correct sequence. I know we can look at the Key Date (Bill Key date) to determine the sequence.

Is there any other way to determine the correct sequence?