Greetings Gurus...
Am attempting to write an SQL Query to require approval for a Service Type Purchase Request which is higher than $250 in the "Total Before Discount" field. This is on version 10.0 PL02 HANA.
It is as follows:
SELECT DISTINCT ...
FORMATTED SEARCHES ARE GREAT, BUT THEY CAN BE TROUBLE ALSO.
Formatted Searches (FMS) are another fine tool you can use in SAP B1. You can read up on Formatted Searches with some SAP B1 documentation, or maybe you can buy Gordon Du's book titled "Ma...
Am currently working with an individual, hoping to help her improve her SQL skills. She has a great start, but we are going to get her up to the next level, and one way is going to be the usage of CASE in her new SQL.
USING CASE IN SAP B1 CAN HELP E...
Mentioned the Relationship Map in the last blog. If you want to review some information on the usage for the data fields of LineNum versus VisOrder, have a look here:
https://blogs.sap.com/2018/12/23/sap-business-one-linenum-or-visorder-which-one-t...
LineNum or VisOrder – Which One to Use???
I was once very active in the SAP B1 Forum doing quite a few things: answering questions, writing blogs, and developing a Wiki. I really enjoyed sharing what little bit of knowledge I had, thanks to Marily...
David - yes, I do have some written for several Customers, but it might not meet your requirements. When you say "all linked documents to a Purchase Order", that can be many different documents for different companies, depending upon how their busin...
Hello Suyog - if you saved the existing query in the Query Manager, just run the SQL and then click on the "pencil" icon in the upper left hand corner.And onwards you go!!!Regards, ZalPS - you cannot pull a saved existing query into the Query Generat...
Here Suyog - try loooking at this blog. It shows fairly well how to come up with Relationship Map information...https://blogs.sap.com/2018/12/30/sap-business-one-recreate-the-relationship-map-with-linenum-and-base-line/Regards, Zal
Hello Mikael - some suggestions:Run a Profit and Loss Statement by using the following path - Financials Module > Financial Reports > Financials > Profit and Loss Statement. Export to Excel.Run a Transactions Report by using the following path - Fin...
