Dear all,If we make a sales order in SAP B1, I would like to see, by pressing SHIFT+F2 to see what the BP bought in the last 180 days and the quantities.What query should I make, to see the list?Please advise.Thanks in advanceRegards Mark
Dear all,In SAP B1 when creating a sales order, we have a row called 'In Stock'. But certain items we have in 2 different warehouses. How can I see change the view of this list, so I can see:- Total stock- Stock WHS 1- Stock WHS 2 etc, etc,I hope you...
Dear all,Please can you help me with a query?I would like to see per vendor which item we sold per month and an average over 6 months, so it will be easier for me to order new stock.Please advise.Regards, Mark
Dear all,Hope you can help me with the following query:DECLARE @YEAR AS INT = 2024sELECT * ,Alles.Januari + Alles.Februari + Alles.Maart + Alles.April + Alles.Mei + Alles.Juni + Alles.Juli + Alles.Augustus + ...
Dear all,I got a question about printing open lines after making AR invoice.If we are printing a sales order after making an AR invoice, it prints all the lines also the ones which are already printed on the invoice.How can we only print the open lin...
Dear Lothar,I mean a query what will be helpfull for all clients. So we don't need to change it manualy.I used to have a query, that when i pressed Shift+F2 in a sales order on the line of 'item description', I got a list of what that particular clie...
Dear Lothar,It keeps on popup a screen where we need to select BP group.Isn't it possible to get just a list of last 180 days order products and quantities if I want to make a salesorder?Please advise.
