V8.03x
We use the BookDtl table extensively in BAQs and ODBC. While trying to verify the accuracy of a report, I found a single sales order that was valued at just $3,340 but the BookDtl value is a whopping $9.9 Million!
I have tested and retested and am sure that it is in error. I even went back to our 6.1 db prior to conversion and the same BookDtl data is there (converted after this order was entered).
Can anybody think of what might have caused this? Does anybody else have this problem? How can I trust the data if I found one single monster error?
Thanks in advance,
Randy Weber
We use the BookDtl table extensively in BAQs and ODBC. While trying to verify the accuracy of a report, I found a single sales order that was valued at just $3,340 but the BookDtl value is a whopping $9.9 Million!
I have tested and retested and am sure that it is in error. I even went back to our 6.1 db prior to conversion and the same BookDtl data is there (converted after this order was entered).
Can anybody think of what might have caused this? Does anybody else have this problem? How can I trust the data if I found one single monster error?
Thanks in advance,
Randy Weber