I have a batch on my live system and getting the below error when trying to post.
"This transaction contains error. It wont be posted. "
I moved the data to the test system to find the real issue and when posted the batch there, it worked fine. It posted without any issue.
Anyone have any idea what could be the error. How to find the detail of the issue? Please help.
If you open the transaction and print the edit list (print icon in the top right of the transaction entry screen) this should tell you what the error is.
Ian is spot on. Run the Edit List report by selecting the transaction and click on the print icon on the top right corner of the window). This report will let you know the details of the error(s) which is(are) preventing your transaction to post.
Hope this helps.
Thanks Ian and siva!!..
Siva and Ian, when I print the edit report all i get is
Is there any other ways to find the more detail cause of this issue?
Can you delete the transaction in question and enter it again to see if that resolves the issue?
Siva there are other invoices too that are affected so i can't delete them.
The difference between those invoices and other invoices are that they dont have a primary address code. I dont think it is required for posting but can we setup a GP and make it required for posting? How we do that in GP? or How we check if Primary address code is required for posting?
If you know please share.
Usually the Transaction Edit List specifies what the errors are.
You don't need an Address ID or Remit-To-ID on the invoice but if there is one then it can be any address from the creditor/vendor.
Other things to check;
It`s seldoom that there`s message ("This transaction contains error. It wont be posted.") on top of the batch edit list and ther`s no error description with Transactions/Description. Normally when you open editlist for batch having errors you will find detail error descriptions with ** at the start of string. In larger batches I normaill find text "**" using Ctrl+ F to find the error stiring. did you try finding the lines??
Can you give a little details like:
1) What is the module(POP, SOP, PM, RM, IV)?
2) What types of transactions are there in the bach(sales Invoice, Debit memo etc)
such information can help us tracing the issue.
maybe if it is a sales transaction, you could check if the Inventory items has the Cost of Good sold account on the setup.
If they don't have it you should put it line by line (Item By Item) on the transaction.They doesn't appear in the transaction distribution but they are required in posting sales transactions.
I agree with Tariq, if the exact error message is really "This transaction contains error. It wont be posted.", then this is not a GP error message I have ever seen. Perhaps there is a 3rd party product or customization that is giving that error? From the other posts in this thread it sounds like this is an SOP invoice? If so, the Batch Edit List should give you a lot more detail on what the issue is, usually it is inline with the transaction details.
I just had the same issue so I thought I would share where it came from in case someone else is looking.
We had a new Vendor that was Set up with one address ID called "MAIN"
Someone integrated an A/P Invoice and it defaulted that Address ID on the Transactions (VADDCDPR = MAIN, VADCDTRO= MAIN)
At some point between uploading and trying to post, someone else updated the Vendor Card and Deleted the Address ID called MAIN and added to different ones. PRIMARY and REMIT
So basically, the Invoice was stamped in the PM10000 table with MAIN and that Address ID didn't exist. And yes, It was the same exact error message "This transaction contains error. It wont be posted." But is was below the Transaction Information but above the Distributions on the Edit List: Right under "Distribution Messages"
So, not a helpful error. I manually keyed another invoice for that Vendor and looked at it in SQL and it was apparent there.