SAP Business One callID using an old entry's id while adding service call

[mohamad_kaddoura]

I am currently using SAP Business One 8.81.

The issue I am facing is with adding a service call through SAP Business One. The callID in the field cannot be manually changed and is trying to use a callID of an already made service call.

Adding new service call

Last service call

I have used SQL statements to insert service calls into the OSCL table. I thought this might be an SQL indexing issue, but I didn't find a way to navigate system index tables to manipulate this number with my SQL scripts.

Amidst the manual SQL inserts, a service call was added at callID = '5232' through SAP B1 and now that the count is '5233' I suspect that SAP B1 inserts into OSCL in a different way than I did. I have checked the 'NNM1' table, but it only holds the NextNum value of the DocNum not the callID. The DocNum is being updated successfully.

This issue started occurring recently, the company staff suspected that it happened after an update to the system.

[azizelmir]

Hi Mohamad,

You can find the CallID in the table ONNM.

SELECT * FROM ONNM WHERE ObjectCode='191'

Aziz

[mohamad_kaddoura]

Thank you very much, this has finally fixed my issue.