Receivables Management Recurring Batch

(1) Share

Report

Posted on by Community Member

Hello,

Doeas anyone know if there is a way to control the incremental numbering of an invoice created in a receivable recurring batch?

When I initially setup the batch I used a beginning invoice number of 01. When I posted the recurring batch the document number became 01000000000001, when I posted the second time 01000000000002, etc. I understand the need for a unique document number, but I was hoping to limit the incremental number to 5 digits so my new invoice number would be0100001, then 0100002 etc.

Thank you in advance!

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (0)

Rosemary 10 on at

Like (0)

Report

Hi,

Have you checked your options in Receivables Management Setup>>Options? You can change your options there for the ranges you require.

Regards

Rosemary

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

That option only lets you choose the next invoice number - not the increments. I would think that skipping invoice numbers wouldn't sit very well with auditors.

Was this reply helpful? Yes No
Rosemary 10 on at

Like (0)

Report

Ok, maybe I did not understand the scenario that was described and yes auditors would not like a scenario like that.

I created a recurring batch entered transactions, posted the batch. When I went into the batch again the numbering was the next sequential document number.

I did this in Fabrikam, so the initial start would have been the 010001?? Isn't this how it is expected to work?

Regards,

Rosemary

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (1)

Report

Rosemary & Zovic,

The key here is recurring batch. The system automatically adds a 10 character suffix to the regular invoice number. The first posting adds 0000000001, the second adds 0000000002, an so on. Back many years ago it only added 4 characters, they increased it because the number of times you could advance the number was too limited. I remember creating a macro that posted it past the limit just to see what would happen. I was expecting the system to throw some mean-spirited error, but it didn't even blink an eye. The batch didn't post, but it went through the same process as if it did.

Anyway, I'm not aware of any setup option that will allow you to change the suffix to something shorter.

Kind regards,

Leslie

Was this reply helpful? Yes No
Rosemary 10 on at

Like (0)

Report

Thanks Leslie for clarifying that, the transaction I did comprised of the same set of values within GP, I did not reduce the length.

Regards

Rosemary

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

i have the same question and I dont see any place where we can set up the number of digit. I dont understand why we are able to do that in invoice number but not in recurring number according to the estimated company business size

I hope that Microsoft will add this feature in future...

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report

Hi Jean-Marie,

You don't see anyplace because that place doesn't exist. To the best of my knowledge you cannot change this without custom programming.

Kind regards,

Leslie

Was this reply helpful? Yes No