Open collection of SAP Business One queries. - No warranty by SAP
- A-AD Administration Module SQL Posted to Wiki
- B-FN Financials Module SQL Posted to Wiki
- C-SO Sales Opportunities Module SQL Posted to Wiki
- D-SL Sales AR Module SQL Posted to Wiki
- E-PU Purchasing AP Module SQL Posted to Wiki
- F-BP Business Partner Module SQL Posted to Wiki
- G-BK Banking Module SQL Posted to Wiki
- H-IN Inventory Module SQL Posted to Wiki
- I-PR Production Module SQL Posted to Wiki
- J-MR MRP Module SQL Posted to Wiki
- K-SR Services Module SQL Posted to Wiki
- L-HR Human Resources Module SQL Posted to Wiki
- SAP B1 D-SL Sales and Buy FIFO Price for Batch managed Items
- SAP B1 D-SL Sales and Purchase FIFO Price for Non-Batch Items
- SAP B1 SQL A-AD Alert Message AP Invoices Coming or Past Due
- SAP B1 SQL A-AD Alert Message Negative Inventory in Stock By Warehouse and Total
- SAP B1 SQL A-AD Alert Message Tax Code Missing From Address
- SAP B1 SQL B-FN Debtors Aging Report by date
- SAP B1 SQL B-FN General Ledger Report with Account Code and Date Range as Selection Criteria
- SAP B1 SQL B-FN Journal Entry Detail by Date Range
- SAP B1 SQL Contributors' Tips and Tricks
- SAP B1 SQL D-SL AR Inv and CM List by Gross Profit
- SAP B1 SQL D-SL AR Invoices and Credit Memos by Sales Person and Date Range
- SAP B1 SQL D-SL Calculate Sales profitability based on B2B Orders
- SAP B1 SQL D-SL Lapsed Days Order to Deliveries Order Details Ver 3
- SAP B1 SQL D-SL Late Sales Order by Date Range
- SAP B1 SQL D-SL Sales Register by Invoices for Indian Localization
- SAP B1 SQL D-SL Sales Register by Item for Indian Localization
- SAP B1 SQL E-PU Priority Items To Be Purchased
- SAP B1 SQL E-PU Purchase Analysis Report
- SAP B1 SQL E-PU Purchases Register by Item for Indian Localization
- SAP B1 SQL E-PU Supplier Open Invoices by Due Date
- SAP B1 SQL E-PU Validation and approval when Invoice Value is more than order
- SAP B1 SQL F-BP BP Data Check from DIE
- SAP B1 SQL F-BP Tax Code Workstation
- SAP B1 SQL G-BK Deposit with AR Invoices from Lockbox
- SAP B1 SQL G-BK Incoming Payments with Payments On Account
- SAP B1 SQL G-BK Payments by Bank Transfer within Date Range
- SAP B1 SQL H-IN Display Item Usage in Item Master Data Screen
- SAP B1 SQL H-IN Item Inventory Details for ST Postings During Inventory
- SAP B1 SQL H-IN Item Inventory Opening and Closing Stock per warehouse
- SAP B1 SQL H-IN Item Prices in Each Price List
- SAP B1 SQL I-PR Components within Bills of Material for Any or All
- SAP B1 SQL I-PR To Check the Components upto 6 levels deep into a BOM
- SAP B1 SQL -Item Wise - Warehouse Wise Stock Report
- SAP B1 SQL J-MR Minimum Data Check for MRP Completeness
- SAP B1 SQL Links and Additional Information
- SAP B1 SQL S-FS Autogenerate Card Code Based on Card Type
- SAP B1 SQL S-FS Average Lapsed Days
- SAP B1 SQL S-FS In-Stock of Specified Warehouse in Row level of marketing document
- SAP B1 SQL S-FS Tax Code Autopopulate in BP Address
- SAP B1 SQL Standards and Notes
- SAP B1 SQL Suggested Standards - Basic Outline of the SQL
- SAP B1 SQL Tips and Tricks
- SAP B1 SQL V-MS Listing of All SQL on System
- SAP B1-SQL Z-TS Block Receipt of Final Product without Component Issue
- SAP B1-SQL Z-TS Block users entering duplicate reference number on Sales Purchase Order documents
- SAP B1 SQL Z-TS Prevent Duplicate Barcodes for Item
- SAP B1 SQL Z-TS Restrict Documents without Base Documents
- SAP B1 SQL Z-TS Restrict negative balance for Cash account in Outgoing Payment
- SAP B1 SQL Z-TS Setting Mandatory Field
- S-FS Formatted Searches SQL Posted to Wiki
- V-MS Micellaneous Items SQL Posted to Wiki
- Y-SP Stored Procedures for SQL Posted to Wiki
- Z-TS Transaction Notification SQL Scripts Posted to Wiki