SAP Business One Training Tips #6

Finally, an Inventory Aging report by warehouse SELECT T0.ITEMCODE , T0.ONHAND as ‘Total Qty’, CASE WHEN Datediff(day, T1.LASTPURDAT,GETDATE())= 45 AND DateDiff(day, T1.LASTPURDAT,GETDATE()) < 90 THEN T0.ONHAND END ’45 to 90 Days(Qty)’ , CASE WHEN DateDiff(day, T1.LASTPURDAT,GETDATE()) >= 45 AND DateDiff(day, T1.LASTPURDAT,GETDATE()) < 90 THEN T0.ONHAND*T0.AVGPRICE END ’45 to 90 Days(Value)’, CASE WHEN Datediff(day, T1.LASTPURDAT,GETDATE()) >= […]


SAP Business One Training Tips #5

SAP Business One – Planned Production Order Shortages Query This query uses only standard fields, and lists for any production order in Planned status, component shortages. The “AND T0.[Status] = ‘P’” can be changed to ” AND T0.[Status] = ‘R’” to show release production order shortages, or ” AND T0.[Status] <> ‘L’” to show Planned […]


SAP Business One Training Tips #4

Negative Gross Profit and Sales Report from A/R Credit Memos SELECT T0.[DocDate], T4.[GroupName], T0.[CardCode], T0.[CardName], ((T1.[Quantity]* -100)/100) AS ‘Qty Returned’, (T1.[Price]*((T1.[Quantity]* -100)/100)) AS ‘Net Sales’, (T1.[PriceBefDi]*((T1.[Quantity]* -100)/100)) AS ‘Gross Sales’, T2.[SlpName] FROM ORIN T0 INNER JOIN RIN1 T1 ON T0.DocEntry = T1.DocEntry INNER JOIN OSLP T2 ON T1.SlpCode = T2.SlpCode INNER JOIN OCRD T3 ON […]


SAP Business One Training Tips #3

Shipping Performance Report – Monitor your on time shipping performance Great report to measure your on-time delivery performance. SELECT DISTINCT DATEDIFF(DD, T2.DocDueDate, T3.DocDueDate) AS ‘Lapsed Days’, CASE WHEN DATEDIFF(DD, T2.DocDueDate, T3.DocDueDate) >= 5 THEN ‘Late by 5 Days or More’ WHEN DATEDIFF(DD, T2.DocDueDate, T3.DocDueDate) BETWEEN 1 AND 4 THEN ‘Late by 1 to 4 Days’ […]


SAP Business One Training Tips #2

Projected MRP Procurement Costs for specified MRP Scenario This report will prompt the user for the desired MRP Scenario and Price List. The report lists all the buy items in the respective MRP scenario, displaying the cost, multiplied by requested quantity. This is an ideal report to use when doing What-If MRP Scenario’s in SAP […]


SAP Business One Training Tips #1

Linking Customer/Vendor to a specific P&L account   A customer recently approached one of our Implementation Consultants and asked, “How can I track revenue/expenses to a specific P&L GL account by customer/vendor?” While the Accounting Tab of the Business Partner Master allows the user to define Payables and Receivables accounts for each customer/vendor accordingly, it […]


SAP Business One 9.0 Drag & Relate

SAP Business One 9.0 has many functions to make daily use easier and more convenient, especially in the area of reporting.  Out of the box, SAP Business One comes with multiple System and Crystal Reports to deliver standard report capabilities that all or most customers will need.  In addition to these standard reports, SAP Business […]


SAP Business One 9.0 Authorizations & Form Settings

SAP Business One 9.0 provides Authorizations and Form Settings to ensure that users see only the data they need and affect changes only in areas where management desires. Authorizations allow a user to view, create and update documents they’ve been assigned, according to a company’s system definitions.  These definitions can be applied to a specific […]


SAP Business One 9.0 Keyboard Shortcuts

SAP Business One 9.0 has many functions to make your daily use easier and more convenient.  Out of the box, many keyboard shortcuts / hotkeys are available for users, equivalent to menu commands.  Keys like CTRL, ALT and your “F-Key” are used for established functions and navigation.  While the CTRL key allows users to access […]


SAP Business One 9.0 Warehouse Bin Location Capabilities

SAP Business One 9.0 allows small and medium size businesses owners to manage bin locations for their warehouses. A bin location is the smallest unit of space in a warehouse where goods/products are stored. SAP Business One bin location function can be implemented per warehouse location. This additional detailed warehouse systems functionality allows SME’s (Small […]


Phone: 888.239.2818 | Fax: 312.621.9200

 Copyright © 2012 Clients First Business Solutions (North America) LLC. All rights reserved

CFBS Locations: New Jersey (Head Office)Alabama | California | FloridaIllinois | Minnesota | TennesseeTexas