We have many other accpac installations that came from the same version where the issue does not exist or is less than 0.01% of the transactions have this issue, but we have 4 installations that show almost 40% of the transfers of the overall transfers have this situation occurring. Two new tris-heteroleptic Ru(ii) complexes with triphenylphosphine (PPh3). I thought maybe there was a known issue with accpac that was corrected with a version of PU, but all these companies would always be on the same version and PU. What even further boggles my mind is that on the same server in the same Accpac installation (5.6A) there are 2 other companies that have the same issue, but their "correction" fiscal year and period are all different from each other but also have the same issue. What further boggles my mind is the date in which the issues appears to "correct" itself and is fixed at a specific fiscal year and period. I've run a data integrity check and it finds no issues. When I look at documents that are the same, say TFR00001, the cost is positive for both TRANSTYPE 12 and 13, but the quantities are negative for 12 and positive for 13. The first query returns 4000 records and the second 2000 records. Select COUNT(ICHIST.TRANSTYPE) from ICHIST where TRANSTYPE = 12 AND HOMEEXTCST 0 AND QUANTITY < 0 To give you an idea I'm querying as follows: I'm trying to rebuild transactions from ICHIST and I'm noticing I have a large amount of data in TRANSTYPE = 12 that has negative QUANTITY and positive HOMEEXTCST and I expect that typically these should both be negative.
0 kommentar(er)
