Reset Document Numbering

[former_member232354]

Dear Experts,

We are using SAP 9.2 PL08 HANA and checking if there is any functionality to reset document numbering in the beginning of fiscal year.

We are thinking to use period indicator but our periods' are per month, as a result this is more complicated.

Could you please advice?

Kind Regards,
Alexandros Karadimitropoulos

[Johan_H]

Hi Alexandros,

As Nagarajan said, there is no ready function for this. The workaround that we use is to start a new numbering series each year, that starts with the year, and is long enough to fit all potential transactions of the given type [YYYYnnnnnetc].

So for example, assuming that you expect to create about 10.000 invoices each fiscal year: First no. 201800000 and Last no. 201899999. This would allow you to create 100.000 transactions, so there is no risk of running out of numbers, in case of a surprise.

Another method is to use the original system method, from before SAP purchased Business One, which is to start a completely new company database each fiscal year. There are tools, like the Data Transfer Workbench, with which you can transfer your chart of accounts, master data, and open transactions. This method has the advantage of always having a small, clean fast database, and the disadvantage of having to adapt all your reporting procedures to make use of multiple different databases. The Profit and Loss Statement Comparison report is a good example of this.

Regards,

Johan

[kothandaraman_nagarajan]

Hi,

There is no function to reset document numbering. User needs to create new document numbering for each fiscal year.

Regards,

Nagarajan