Share
Report
770This is a 7.0 FP1 environment in which PO's are manually entered.
This is the 3rd month in which customer called to report batches which do not post. The error message is invalid currency id, and the currency ID ont he problem batches is blank.
Other databases work fine, and other modules in this database work fine. I used SQL to look at the Company table in the system database, as well as the currency tables in the APP db. I don't see any blank basecuryid or curyid field in the setup tables. The GLSetup has the correct currency ID.
After I update the currency id, the batches post fine. I noticed that the curyacct table has records for both blank curyid and the correct curyid, while AcctHist does not. AcctHist has only the correct currency id's on all records.
I searched online but did not see a solution. I'm unable to figure out where it is coming from. A suggestion was made to Rebuild views and I don't know whether that is the correct course of action (I have not tried this yet).
Please advise. Thank you!
Laura Barber
*This post is locked for comments
All responses (
Answers (
