Hello, I do not know what you mean. You first need to start with learning basic queries then work your way up to complex ones. There are only WHERE and GROUP BY clauses basically so if you can break out the query into pieces you can build the data structure you need. Not a great answer but I don't really understand the requirements.
Dear Sir, Am seeking to know if any standard report exists which would show me a the existing stock alongwith the valid selling price maintained for the item. I do understand it's from two different areas and such instances are best through developed reports, but just trying and learning to know if there exists some report for this. This is a useful information for the sales team, as most of you all would agree. Thanks and regards, Firoz
Hi Michael. i,m trying to do a query for my Purchasing relation from purchase request until the invoice in SAP B1. something like the relationship map but in a query format. point me in the right direction
Hi Curtis, if you want to break down the taxes you should check out the tax subreport from the system documents, it will give you the tables and relationships on how you would join the tables to get specific tax codes. Then you could do a subquery or derived table, etc.
Can you show how to pull a query that includes customers from a specific customer group that haven't purchased in a six month period along with those that have purchased. Scenario: We want to pull all customers from Customer Group A that have purchased from specific item groups and also those customers from Customer Group A that have not purchased in the past six months. Is that possible with one query?
Hi Shallon, yes this is totally possible. But I don't have enough information to write you a specific query. If you take my SQL course I will write it for you, should only take a few minutes. sql.battleshipcobra.com/ connect with me on LinkedIn if you want to provide me with more context.
Dear Micheal thanks for your video's .... but i still try to find Part 2 but I cant find it ... may you mention me or past link of part 2 with my respect
Part 2 should be right here: th-cam.com/video/6eCTMW_WBCM/w-d-xo.html or you can take my full SQL course which covers all of these topics at: sql.battleshipcobra.com/
Michael, thank you very much!!! I have a problem writing a query that I need to show all documents added in last 5 minutes, or 300 seconds. For example in OPRQ table. Please help :)
Hi Michael. Thank You very much for responding!!! I have a client who demands for one user to be informed when somebody add new goods receipt PO or new purchase request. Thanks to your advise I will try with fit them into options from print preferences menu per this two documents. Just to send internal message after adding above mentioned documents. I think this will suits them fine. Thank you again and please come visit us in Serbia :)
You would need to make a timestamp from the "CreateDate" and "CreateTS" columns on a normal document. Then you can measure the time difference to get the last five minutes.
@@montoya_SRB You can use an alert query to detect new GRPO, etc. Out of the box SAP doesn't work so well with this because it could potentially alert you multiple times. I would recommend using B1UP dashboards or B1UP Print & Delivery reporting so you can send an email alert when a new GRPO is added. Print & Delivery will send the email, mark the document as "read" (to prevent sending twice) and then sends the email to whomever you want. It's a really good system for this. If you use dashboards the B1UP dashboards can show you in real-time what documents are new and open.
Dear Michael can you give some solution? I would make comparison between Old price and new price in SAP B1. So i can know how much different that two price. For example price for Iphone 7, today the price is 12,000 $ so what was the price before it? Thanky you michael
I'm really thanks to you, but it does not work for my companies, because we change price list all the time. So i have another query to solve my problem. Here it is SELECT DISTINCT T3.[ListName], T0.[ItemCode], T1.[ItemName], T0.[Price] as 'New Price', T2.[Price] as 'Old Price' FROM ITM1 T0 INNER JOIN OITM T1 ON T0.[ItemCode] = T1.[ItemCode] INNER JOIN AIT1 T2 ON T1.[ItemCode] = T2.[ItemCode] INNER JOIN OPLN T3 ON T0.[PriceList] = T3.[ListNum] WHERE T1.[UpdateDate] = [%0] ORDER BY T1.[ItemName] but it does not display what i want. I need display with price now and price before only for 1 price. but in that query i display all old price so i really don't know what the latest old price. Can you help me for solve this problem?
Dear Michael hope you have amazing time how i can Change the tag to SAP Business One, if the problem isn't actually with SQL Server.how i can Removed secondary tag as it is unrelated.warm regards
Dear Michael really i appreciate your reply and regarding my question you can see below,frankly no one has right idea so please if you can help me answers.sap.com/questions/104710/i-cant-login-to-sap-92-since-i-change-sql-password.html?childToView=111203#comment-111203
All Thanks Michael Really i appreciate your tips but i already did but while i cant access i did uninstall while im new for sap and sql as well i stil confuse please if you have training i can buy you are the best
Where is the data base reference manual you spoke of that you were placing here for us? I would love to have that!
HII MIKE
HOW DO I CREATE THREE SEPARATE ROWS OF TOTALS AND SUMS SO TO COMPARE COMPANY GROWTH ( LOSS); WHAT FILTERING METHOD, WOULD YOU RECOMMEND?
Hello, I do not know what you mean. You first need to start with learning basic queries then work your way up to complex ones. There are only WHERE and GROUP BY clauses basically so if you can break out the query into pieces you can build the data structure you need. Not a great answer but I don't really understand the requirements.
Dear Sir,
Am seeking to know if any standard report exists which would show me a the existing stock alongwith the valid selling price maintained for the item.
I do understand it's from two different areas and such instances are best through developed reports, but just trying and learning to know if there exists some report for this. This is a useful information for the sales team, as most of you all would agree.
Thanks and regards,
Firoz
Where can I find trial balance in SAP business one?
Mich - need ur help. What is static data in SAP B1 ??? Need to find the answer by monday...
Hi Michael. i,m trying to do a query for my Purchasing relation from purchase request until the invoice in SAP B1. something like the relationship map but in a query format. point me in the right direction
Hi Michael,
Thanks for the video, helped a heap!
Is it possible to have another column which is inclusive of GST for the totals?
Hi Curtis, if you want to break down the taxes you should check out the tax subreport from the system documents, it will give you the tables and relationships on how you would join the tables to get specific tax codes. Then you could do a subquery or derived table, etc.
Can you show how to pull a query that includes customers from a specific customer group that haven't purchased in a six month period along with those that have purchased. Scenario: We want to pull all customers from Customer Group A that have purchased from specific item groups and also those customers from Customer Group A that have not purchased in the past six months. Is that possible with one query?
Hi Shallon, yes this is totally possible. But I don't have enough information to write you a specific query. If you take my SQL course I will write it for you, should only take a few minutes. sql.battleshipcobra.com/ connect with me on LinkedIn if you want to provide me with more context.
Dear Micheal thanks for your video's .... but i still try to find Part 2 but I cant find it ... may you mention me or past link of part 2 with my respect
Part 2 should be right here: th-cam.com/video/6eCTMW_WBCM/w-d-xo.html or you can take my full SQL course which covers all of these topics at: sql.battleshipcobra.com/
Michael, thank you very much!!! I have a problem writing a query that I need to show all documents added in last 5 minutes, or 300 seconds. For example in OPRQ table. Please help :)
Hi Michael. Thank You very much for responding!!! I have a client who demands for one user to be informed when somebody add new goods receipt PO or new purchase request. Thanks to your advise I will try with fit them into options from print preferences menu per this two documents. Just to send internal message after adding above mentioned documents. I think this will suits them fine. Thank you again and please come visit us in Serbia :)
You would need to make a timestamp from the "CreateDate" and "CreateTS" columns on a normal document. Then you can measure the time difference to get the last five minutes.
@@montoya_SRB You can use an alert query to detect new GRPO, etc. Out of the box SAP doesn't work so well with this because it could potentially alert you multiple times. I would recommend using B1UP dashboards or B1UP Print & Delivery reporting so you can send an email alert when a new GRPO is added. Print & Delivery will send the email, mark the document as "read" (to prevent sending twice) and then sends the email to whomever you want. It's a really good system for this. If you use dashboards the B1UP dashboards can show you in real-time what documents are new and open.
Hi Michael.
I just started to learn SAP B1 not long ago and I have a question? what is Query and what is for it? and can't understand it.)
@@BattleshipCobraSAP thank you very much it was helpful
subscribed. helpful video :)
Great vid
Dear Michael can you give some solution? I would make comparison between Old price and new price in SAP B1. So i can know how much different that two price. For example price for Iphone 7, today the price is 12,000 $ so what was the price before it? Thanky you michael
Michael Taylor my companies focus on handphone selling. so the price of that item will be update any time. i will try your query tomorrow.
I'm really thanks to you, but it does not work for my companies, because we change price list all the time. So i have another query to solve my problem. Here it is
SELECT DISTINCT T3.[ListName], T0.[ItemCode], T1.[ItemName], T0.[Price] as 'New Price', T2.[Price] as 'Old Price' FROM ITM1 T0 INNER JOIN OITM T1 ON T0.[ItemCode] = T1.[ItemCode] INNER JOIN AIT1 T2 ON T1.[ItemCode] = T2.[ItemCode] INNER JOIN OPLN T3 ON T0.[PriceList] = T3.[ListNum] WHERE T1.[UpdateDate] = [%0] ORDER BY T1.[ItemName]
but it does not display what i want. I need display with price now and price before only for 1 price. but in that query i display all old price so i really don't know what the latest old price. Can you help me for solve this problem?
It's working. Thank you so much. I do apologize if i had disturbed your time.
Michael Taylor Hello michael. How are you? Now my company using SAP Hana, so could you help me to remake that query to SAP Hana?
Dear Michael
hope you have amazing time
how i can Change the tag to SAP Business One, if the problem isn't actually with SQL Server.how i can Removed secondary tag as it is unrelated.warm regards
Dear Michael
really i appreciate your reply and regarding my question you can see below,frankly no one has right idea so please if you can help me
answers.sap.com/questions/104710/i-cant-login-to-sap-92-since-i-change-sql-password.html?childToView=111203#comment-111203
no i cant
i uninstall the sql and sap as well,even i delete all those i still cant install sap again
All Thanks Michael
Really i appreciate your tips but i already did but while i cant access i did uninstall
while im new for sap and sql as well i stil confuse please if you have training i can buy
you are the best
This is very helpful thank you very much. :-)