![]() ![]() We want to report on all items in SAP not assigned a Default Bin Location. ![]() Order by t2.SL1Code, t2.SL2Code, t0.ItemCode Left outer join OIBQ t3 on t0.ItemCode=t3.ItemCode and t0.WhsCode = t3.WhsCode Inner join OBIN t2 on t2.AbsEntry = T0.DftBinAbs Inner join OITM t1 on t0.ItemCode = t1.ItemCode Select t0.ItemCode, t1.ItemName, isnull(t3.OnHandQty,0) as ‘In Stock’, t2.BinCode, t2.SL1Code, t2.SL2Code from OITW T0 The Bin Locations Content report in SAP only shows items in stock: We needed a way to list items in stock AND items not in stock for stock taking so we can run an inventory report between locations. WHERE t0.DocStatus = ‘O’ and (t0.Printed = ‘N’ and (SELECT count(*) SELECT t0.DocEntry, t0.CardCode, t0.CardName, t0.DocDueDate as ‘Due Date’, t0.DocCur, t0.DocTotal Please note we are using Boyum Print and Deliver module: It’s easy to forget to send invoices and this report has helped us be more efficient. This query shows all AP Invoices added to SAP that are Open but have not been sent. If you like SQL want to learn more we’d love to see you at the next Business One User Group at SAP UK: UK and Ireland SAP User Group – Developing, Benefiting and Serving the SAP User Community ![]() Just copy and paste these in to your own Query Generator I wanted to share with you some of my most frequently used queries and why I like them. Now I use SQL queries in Business One almost daily. I started out as a relative novice to SQL a few months ago. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |