Dear Experts,
I am using SAP B1 8.8 and SQL Server 2008 in Server and SAP B1 and SQL Server 2005 in Test System.
I have tested one scenario, In GRPO Document, Total amount should be calculated based on Unit price * 0.2812 * Net weight. In Test system it worked fine. But when i applied the same in Server, when i open the GRPO document i got an error message as " 1) [Microsoft] [SQL Server Na tive Client 10.0] Incorrect syntax near the keyword 'FOR'. 2) [Microsoft] [SQL Server Native Client 10.0] statement ' ' (NFN1) (s) Could not be prepared."
When i add the GRPO document, i get following error " 1) [Microsoft] [SQL Server Na tive Client 10.0] Incorrect syntax near the keyword 'FOR'. 2) [Microsoft] [SQL Server Native Client 10.0] statement 'Withholding Tax ' (OWHT) (s) Could not be prepared."
Please guide me solve this issue. I could not prepare or add GRPO document because of these errors.
Thanks in advance.
Raja.S