SAP B1-How to use query generator to make customized reports (báo cáo tùy biến bằng query generator)

[Music] hello everyone today i'm gonna show you how to make your own customized records using curry generators on sap p1 to open the function you go to manutune curry and curry generators coverage generator it looks like this on to the example we want to make a consolidated report on item in accordance with a good recipio and delivery which is relate to this item so first of all we'll open the item master data window to you curry generator you have to open system information like this put a stick on system information after opening system information every time you put your mouse on a specific information on any window the system information will be shown on the bottom left corners by this way i know that's the information of item stored in the table or i tm so input ytm which is item codes and item name that's what i can one and see on my repo so i want to see the item group name on the wrapper as well click this so i choose the booklet on item pro so now we have to check the report the item group have been sold but it's just the code and i want the name so i open the item book window and take the name the name from table oitp so now i input o i t b and red tap button to show the information of the table i chew on the item proof if i click on this one execute now we have item proof now all the wrapper and i don't want to display the item of course such as deleters excuse again and then code disappeared so now i want to have the information of good delivery which relevant to the item so you can find here we have the table d p and i i want to have a i want to take quality use right and the total light so i include the table here the pd and one all the information now display are displayed which is double booklet to choose what i want to show on the record how about i want to show the quality [Music] here you can see it's just super click and the qualities he have been choose having chosen the price and total life socialize this means the prime money ball to the qualities i'm going to do receipts again you can see the quality here the unified here and the flight total is here so next one i want to take the information on the delivery according to the item so again i p in the name of the table of delivery d dln1 all the information has been shown again and i just simply choose quality sprite and little talks again you can see that's also here double click on this and execute to see the record so now we have the quality the prime the control of the good recipie and quality grind and protocol of [Music] delivery so i'll open it to okay so it's very difficult to distinguish with uh to no we see the quality of goodie cpo and with the quality of the delivery so now we make a little bit adjustment on the script like the quality has received qualities yeah this means you change the name for the columns we do the same with the quality of the delivery as delivery quality okay okay we are what we are doing to you to change the name of the column on the wrappers over the price the price is achieved right on table 2 and on table 3 the right the price e sale price okay excuse again now we we can see that the quality and the price has been changed the name of the column have been changed so what i'm gonna do now is make some additional columns to the right post let's say i want to have a column like available quality this mean i make a calculation usually receipt quality miner to the cell quality then i have the available qualities let's check on the record you can see now we have a delivery quality minor to receive quality and have vulnerable qualities easy to understand i want to make another additional column like craft office so to have proper office i have to take the sale price minus to the purchase price and then we have a quarter of office so i want to make a small grip you can see now so we have here the t3 price is mean the sale price why not to the t2 price this man the price we take from goodreads po make the minus and then we have a cross office simple execute and you see the result water foreign five dollars and then we might not sell the purchase price two dollars let me have a crack profit of three dollars it's easy to understand so just click cancel another function is you can use some of the column to to make a short or to make a proof on your report for example i will i want to short my wrap-up on the item code you can see that that compose has been shortest as unfortunately orders now i want to make a condition i make a condition on my report this means that i just want to generate the report on specific item code so every time i execute where the system asks me which item i want to generate the report on so in this case it should be ppp0001 and you can see this the report is generally on the item vpp001 we have here all the information so the available quality is one thousand and the profit e three thousand but i want to change the name of the quarter office because it's not the quarter fifth of the item it's just a quarter office of a one unit of the item so i change the name again button office on it tune it i think this again choose the item that i want to see on the report click on ok and you see the column name have been changed to save the repo for later use you just use the same buttons to the category and then give the report a name for example i'll give the name a query too for it too just click on save so after saving the curry wrapper you can use this anytime as you want to use this icon here click on the icon here chill the category and then to the career report click on ok again choose the item that you want to generate the report on click on ok and you can see this is the red box you can use anytime after creating this once and then you can use this anytime as here you can use this version to edit or make some modify or make some adjustment on the script directly from this window thank you for your watching hope that's this video you folks