165
I have a journal with Account type as "project" and the offset as "Ledger"
On validating system is validating this journal and result is ok but once i am clicking the posting button i am getting this error.
cannot create a record in EXPENSE (ProjCostTrans) The record already exists
Good morning Mohamed,
This thread is a couple of days open already and I wonder if you have made any progress and probably already fixed it?!
Would be great if you could let us know if some additional help from the community is needed.
Many thanks and best regards,
Ludwig
Hi Mohamed,
If you don't have intercompany transactions and the sequences are correct, there can be a customization on indexes of this table which can cause this behavior. Can you review all indexes on this table and if they don't allow duplicates, then verify the fields in that index to see if it could cause your issue.
Hello Mohamed,
Can you have a developer taking a look at this issue?
To me it sounds as if something is 'broken' / corrupted in the data that you have in your system.
Best regards,
Ludwig
Hi ludwig;
Yes the journal was created manually and i delete this journal and create again but getting the same error.
Hello Mohamed,
How was the journal created (manually or via an import, etc.)?
Have you tried deleting the journal, recreating it again and then tried posting the transaction?
Best regards,
Ludwig
Hi andre;
I compare the project transcation id in ledgerjournaltrans_project with transid in projcosttrans but didn't find any duplicates and also i try to increase recid+1 in projcosttrans but still getting the same error.
Hi Mohamed,
Can you review the number sequence related to the Project transaction ID (Project parameters form)? Does it have overlapping numbers? Is it trying to use a number which had been used before already?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (