Problem on "This entry already exists in the following table (OCFT)"?

[Former Member]

I add an Journal Entry with DI API in an addon solution, and insert the cash flow table OCFT with the sql automatically if the Journal Entry need the cash flow information. But when I add a new Journal Entry manually, the system show an error mesage "This entry already exists in the following table (OCFT)".

I think it should be the serial number conflict.However, the serial number relate the OCFT can not be found in the table ONNM?

Could you help to resolve the problem?

[Former Member]

I don't think there is such object exposed to DI API. Have you found any?

[Former Member]

HI,

No, I can not find any better way. That is why I use the SQL to insert the record to the table OCFT, which will may cause the database corruption.My requirement is to add the cash flow information when I add the journal entry with SDK. Does SAP provide any solution to deal with this scenario?

Best Regards,

Jianli

[Former Member]

Can it be done through UI? What is the background of your business process?

[Former Member]

Our customer use the addon to release the bonus, the addon will generate the journal entry automatically. Also, the journal entry should have the cash flow information. We can not ask the customer release the bonus first, and then find out the journal entry and input the cash flow information on the journal entry module.

[Former Member]

Unfortunately in Business one it is not always just the obvious tables are affected, there are history tables and numbering to consider - my concern is this line

insert the cash flow table OCFT with the sql automatically if the Journal Entry need the cash flow information. 

Looks like you might have already done some inserts and this has messed up your numbering. Try running the restore numbering - Help -> Support Desk -> Restore -> Restore Numbering File.

Manual database updates on system tables are not supported as they lead to database corruption!

[Former Member]

It is really a useful function,I can add the journal entry after restoring the numbering file.

Could I use this function to once the same problem happen?

Also, Is there any other solution to add the cash flow information to the table OCFT with the DI API?

[Former Member]

Hi,

Restore function is a nice function. However, it should under SAP support guidance. You are not allowed to run own you on.

Thanks,

Gordon

[Former Member]

Hi,

Is it possible to add the cash flow information to the table OCFT with the DI API?

Best Regards,

Jianli