Numbering Series Error. SAP Business One 9.3

[former_member1093396]

Dear All,

I have an issue with one of my client, when creating document numbering, an error message displays that shows 'Series 2012-1 overlaps object A/R invoices' I applied the following script so as to correct it , it still did not work

UPDATE NNM1 set LastNum = NextNumber + 1 WHERE SeriesName NOT IN ('2014') -- 2012 IN DELIVERY 5737 UPDATE NNM1 SET InitialNum = 5739 WHERE SeriesName = '2012-1' and BeginStr = '12DN-' -- 2014 in delivery lastnumber = 17000 --SELECT * FROM NNM1 where ObjectCode = 15 and SeriesName = '2014' update NNM1 set LastNum = 17000 where ObjectCode = 15 and SeriesName = '2014' Update NNM1 set InitialNum = 13006, NextNumber = 13006, LastNum = 13007 where SeriesName = '2013-1' and BeginStr = '13IS-' --select * from NNM1 where ObjectCode = 69 and SeriesName = '2011' update NNM1 set LastNum = 21 where ObjectCode = 69 and SeriesName = '2011'

even though it allowed me create a new numbering series, but when l applied period indicator to posting period, same error message will f;lag out, what am l not getting correctly here.

i need your assistant

Joel Moses

[kvbalakumar]

Hi,

Hope you understand that updating SAP tables via SQL will void the support. Having said that, please try to use the Restore numbering file from Help menu at Test database.

Perfect solution is to log a SAP Support incident!

[agustin_marcoscividanes]

Hi

can you check if both years have the same period indicator?

Do you use the field "Last number"?

You cannot update data through SQL: SAP does not allow.

Kind regards

Agustin