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 S-FS Average Lapsed Days .  Monthly Special.  This SQL provides information normally requested from Financial Personnel.  It calculates the average number of days it takes a Customer to pay for all of their their AR Invoices.  You will need to set up a User-Defined Field and be familiar with the Formatted Search function in SAP B1.

SAP B1 SQL S-FS Tax Code Autopopulate in BP Address .  Frequently Requested SQL.  This is a type of straight-forward SQL frequently requested and these types of autopopulation can save End Users a bit of time, if they would like a default for some data field on an SAP B1 window.  This SQL helps to avoid typing in a Tax Code where the End User ends up entering a default Tax Code 95% of the time.

SAP B1 SQL S-FS In-Stock of Specified Warehouse in Row level of marketing document . Useful SQL. SAP B1 always show the total In-stock of the item regardless of the warehouse being used in Marketing Documents. If you want to display the In-stock of the specific warehouse selected by the End User during Sales Processing, then you can use this FMS.

SAP B1 SQL S-FS Autogenerate Card Code Based on Card Type .  Frequently Requested SQL.This  SQL code is used to auto generate BP code based on Card Type.