About zal_parchem2

zal_parchem2

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 ...

zal_parchem2

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...

zal_parchem2

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...

zal_parchem2

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...

zal_parchem2

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...

zal_parchem2

More than welcome Santos - glad to hear it helped out. I also have first-hand knowledge of how frustrating it can be when doing a migration and trying to manually figure all of this out. The main reason it was written.Regards to you in Brazil - Zal...

zal_parchem2

Greetings Adam...A suggestion for you. When you post that you have SQL which needs to be changed, I would suggest you include a copy of that SQL with your posting. You will get many more replies and alternatives to your requirements.There are actua...

zal_parchem2

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...

zal_parchem2

Here is an screen print for you...Regards, Zal

zal_parchem2

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...

User Statistics

User Activity

SQL Query to set off an Approval Process for Service Type Purchase Request

SAP Business One – Formatted Searches and How to Find Them

SAP Business One - Using CASE in SAP B1 SQL - Top Ten CASEs

SAP Business One – Recreate the Relationship Map with LineNum and Base Line

SAP Business One - LineNum or VisOrder - Which One to Use???

Re: SAP Business One – Formatted Searches and How to Find Them

Re: Replacing values in SQL Query

Re: SAP Business One – Recreate the Relationship Map with LineNum and Base Line

Re: Query generator

Re: Query generator