I'm recieveing a 8115,"22003"[Microsoft][ODBC Sql Server Driver][SQL Server]Arithmetic overflow error converting expression to data type numeric when I are trying to Calculate a calcfields that are based on following:
Sum("Sales Line"."Outstanding Qty. (Base)" WHERE (Document Type=CONST(Order),Posting Group=FIELD(Code),Shipment Date=FIELD("Date Filter"),Location Code=FIELD(Locationfilter)))
I've modified the table Sales Line to Not Maintain SIFT-index, and then saved the table. Then I put on Maintain Sift-index again to rebuild the SIFT-tables on the SQL-server but I still have the same problem.
We are running DB 3.10 and 3.70B-client on SQL2K
Anyone who has a clue?
Navision Developer since 1998
WM-data Sverige AB