SAP Business One

SAP Business One Reaches Major Milestone

SAP Business One, the comprehensive Enterprise Resource Planning (ERP) suite, has just reached a major milestone, surpassing 60,000 customers worldwide. This makes Business One the most popular of SAP’s current product lineup. In context, over 1,000,000 users from 60,000 firms in 170 countries are currently running B1. As the user base grows, SAP continues to [...]

2019-06-14T03:57:18-08:00June 28th, 2018|SAP Business One|Comments Off on SAP Business One Reaches Major Milestone

Using Reference Field Links in SAP Business One

Have you ever wished you had the power to CHOOSE what information gets added to the journal entries that are created by documents? If the answer is YES, then you will be ecstatic to know that now you get to decide what additional information can be brought over to the journal entry by using SAP [...]

2019-06-14T03:56:52-08:00January 23rd, 2018|SAP Business One|Comments Off on Using Reference Field Links in SAP Business One

SAP B1 Report – Production Order Status for related Sales Orders

In SAP Business One, you have the ability to link Product Orders to Sales Orders. Additionally, at release 8.82 of SAP Business One, the Procurement Confirmation Wizard can automatically create Production Orders directly from Sales Orders, or after Sales Orders have been posted. However, this is not a report that list all Production Orders associated [...]

2019-06-14T04:00:39-08:00March 3rd, 2016|SAP Business One|Comments Off on SAP B1 Report – Production Order Status for related Sales Orders

SAP Business One – Sales Summary total for last 24 hours

Sales Summary total for last 24 hours This query in SAP Business One returns 1 value, the total sales dollars in the last 24 hours. This is a great query to turn into an alert, or use in a Dashboard on release 8.8 or SAP Business One. SELECT sum(T0.[DocTotal]) AS 'SO$' FROM ORDR T0 WHERE [...]

2019-06-14T04:01:06-08:00February 3rd, 2016|SAP Business One|Comments Off on SAP Business One – Sales Summary total for last 24 hours

SAP Business One – Query – Production Planning Board

Query - Production Planning Board SAP Business One Production Production Planning Board. This is a great report and drill down, providing production planners a tool to help manage their planned and released production orders. SELECT T3.[CardName], T3.[CardCode], T0.[DocNum], T0.[Status], T0.[ItemCode], T0.[DueDate], T0.[PlannedQty], T0.[CmpltQty], T0.[RjctQty], T1.[ItemCode], T1.[PlannedQty], T2.[OnHand] FROM OWOR T0 INNER JOIN WOR1 T1 ON [...]

2019-01-16T11:22:41-08:00January 11th, 2016|SAP Business One|Comments Off on SAP Business One – Query – Production Planning Board

SAP Business One – Query Generator

Sub Queries can be extremely useful. Let’s say you want to get a list of business partners (Customers) who have ordered 1000 or more cases of your products in total. Because your report would be getting data from the RDR1 table, without a sub query, the best you could do is sum quantities for all [...]

2019-01-16T11:22:41-08:00November 24th, 2015|SAP Business One|Comments Off on SAP Business One – Query Generator

SAP Business One – Change Item Descriptions

SAP Business One Change Item Descriptions on Marketing Documents Did you know that you can change an item description on all marketing documents such as Purchase Quotations, Goods Receipt, Goods Returns, AP Invoice, Sales Quotations, Purchase Orders, AP Invoice, Sales Orders, Delivery Notes, etc?) This nice feature is either forgotten or never learned by many [...]

2019-01-16T11:22:41-08:00October 12th, 2015|SAP Business One|Comments Off on SAP Business One – Change Item Descriptions

SAP Business One – Incoming Payments with Payments On Account

SELECT T0.DocNum AS 'Inc Pay Numb', T0.DocDate AS 'Post Date', T0.CardCode AS 'Cust Numb', T0.CardName AS 'Customer Name', T0.DocTotal AS 'Total Check Recd', T0.NoDocSum AS 'Overpayment' FROM ORCT T0 WHERE T0.[NoDocSum] < > 0 AND T0.DocTotal < > T0.NoDocSum AND T0.DocDate >= '[%0]' AND T0.DocDate ORDER BY T0.CardName, T0.DocDate FOR BROWSE We hope you find [...]

2019-01-16T11:22:41-08:00September 28th, 2015|SAP Business One|Comments Off on SAP Business One – Incoming Payments with Payments On Account

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()) >= [...]

2019-01-16T11:22:42-08:00September 14th, 2015|SAP Business One|Comments Off on SAP Business One Training Tips #6

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 [...]

2019-01-16T11:22:42-08:00April 2nd, 2015|SAP Business One|Comments Off on SAP Business One Training Tips #5

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 [...]

2019-01-16T11:22:42-08:00March 16th, 2015|SAP Business One|Comments Off on SAP Business One Training Tips #4

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' [...]

2019-01-16T11:22:42-08:00February 26th, 2015|SAP Business One|Comments Off on SAP Business One Training Tips #3

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 [...]

2019-01-16T11:22:42-08:00February 5th, 2015|SAP Business One|Comments Off on SAP Business One Training Tips #2

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 [...]

2019-01-16T11:22:42-08:00January 22nd, 2015|SAP Business One|Comments Off on SAP Business One Training Tips #1

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 [...]

2019-01-16T11:22:42-08:00May 5th, 2014|SAP Business One|Comments Off on SAP Business One 9.0 Drag & Relate