Document Numbering Format setting in SAP Business By Design

[Former Member]

Hi~

Our company is using SAP Business by Design and would like to setup the Document Numbering Format for Customer invoicing as below:

IN-YYMM-XXX

where:

IN as Prefix

YY as Year, eg. 14=2014

MM as Month, eg. 01=January

XXX as running number:restart by each month, eg. 001,002,003...

However by going through the setting in SAP Business by Design, it only allows us to setup the year as suffix and placing the running number as in the middle:IN-X-YYYY

Please kindly advise how we could set the numbering as mentioned, thanks a lot!~

[Former Member · Accepted solution]

Hi Kin,

For your solution you have to create an extension BO for Customer invoice in that before save script file you can come up with your logic and achieve the same.

Regards,

Akash Shivpuriya

[Pedro_muller]

I saw a documentation of the SAP By Design (About Document Numbering Formats for Customer

Invoicing) and for me it is difficult to do believe that the system has only 2 behaves:

1 - SAP by Design starts the invoice as 1 and sequential (impossible to change the initial number - to start with 102 or 1,043)

2 - Create a rule, a prefixed is mandatory and then it is possible to define a start number

Someone had one case that the customer wanted customer invoice to be just numbers and starts with a number different than 1 ? How to solve?

[Adie]

Hello Kin Kwok,

Currently, only the calendar year can be used in the document numbering format as standard function. You may refer to the suggestion from Akash for your specific requriement on formatting.

Thanks,

Adie Shi

Support Engineer