120
Hello,
when I try to make invoice and post it , I face this error " Cannot execute a data definition language command on Accounting event (AccountingEventDateTmp). Accounting date: , 0.The SQL database has issued an error " anyone can help me how can I solve it ?
*This post is locked for comments
Hi Dr. Ludwig,
I created PO then confirmed it then when I try to make Invoice I have a problem and switch to pending invoice and I have to deleted it from the previous mention tables to move on that pending , then when I try to make invoice again I face that error " Cannot execute a data definition language command on Accounting event (AccountingEventDateTmp). Accounting date: , 0.The SQL database has issued an error " Kindly note that is our production environment .
Hi,
I don't fully understand what has been done so far.
Did you create an invoice and deleted that invoice before posting and when you try to invoice the PO again, you see that error?
Is that the process you executed?
Can you replicate this in a different demo/test system?
Best regards,
Ludwig
Hi Dr. Ludwig,
I try to do invoice for PO , kindly that was a problem and I solved it by deleted it's records from VendInvoiceInfoLine and VendInvoiceInfoTable then it work fine , then when i try to invoice and post it I face that error .
Hi,
What invoice do you try to post (PO, SO, FTI or an ordinary vendor invoice)?
In which form do you try to post and do you know if modifications have been made?
Best regards,
Ludwig
#1
André Arnaud de Cal...
291,711
Super User 2024 Season 2
#2
Martin Dráb
230,458
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
