Hello Experts,
I want to create a stored procedure in SAP B1 databse using SQL server where I can use the case statement. For selecting tax rate against selected HSN/SAC Code.
Thanks in Advance; for your help.
With Regards
Hello experts,
I am trying to add all types of cgst break up for single state.
But it gives me an error of combination of key fields cannot be duplicated.
How can I resolve it.
HELLO EXPERTS,
HOW CAN I PUT THE CONDITIONS OF SUM AND COUNT WHILE MAKING REPORT BY SQL QUERIES IN SAP BUSINESS ONE.
FOR EXAMPLE :- I WANT TO SUM ALL QUANTITY IN THE REPORT OF SINGLE INVOICE.