Below is a listing of SQL which you can review for ideas or use in your SAP B1 System:
(Back to SAP B1 SQL Tips and Tricks Main Page - SAP B1 SQL Tips and Tricks )
SAP B1 SQL E-PU Priority Items To Be Purchased . Monthly Special. This SQL lists out those products which the End User decided were priority items for keeping their assembly process going. There is a good example of how to use the CASE function to determine which quantity to post in the "To Purchase" column.
SAP B1 SQL E-PU Purchases Register by Item for Indian Localization . Frequently Requested SQL. In a typical Indian scenario, we need sale and purchase registers to check the excise payable and receivable. The following is a sample which can be used as a basic outline and modified per your requirements for reporing by Items.
SAP B1 SQL E-PU Validation and approval when Invoice Value is more than order :Monthly Special.This SQl can be used to Set validation /Approval when Purchase Invoice value is more than purchase order and can be modified to use for other documents as well.
SAP B1 SQL E-PU Purchase Analysis Report : Frequently Required SQL. This Report will give you information on purchase value, invoice value during a selected period. This Query is linked to OCRD -BP master data and OITM i.e. Item Master data. Extra fields required from OCRD ,OITM and UDF's from OPCH and PCH1 can be added as per requirement.
SAP B1 SQL E-PU Supplier Open Invoices by Due Date :Frequently Required SQL.This SQL will give you list of Supplier Invoices Open by Due Date and can be modified as per client requirements.