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


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


SAP Business One License Policy

SAP Business One licenses are based on a named user licensing model. Each user name needs to have a license granted to it.   A named user is an employee who is authorized to access directly or indirectly the licensed SAP Business One software, which is enforced by License Policy Technical Enforcement features in version 9.0. […]


SAP Business One Product Roadmap

On February 21st 2014, SAP Business One released its first version of the Q1 2014 SAP Business One Roadmap with features and benefits mapped out to 2018.  Though not yet available to the public, it presents SAP customers and partners with a clear vision of where the product is headed in 2014 and beyond with […]


SAP Business One 9.0 Mobility Solutions

SAP Business One 9.0 offers a variety of mobile applications enabling emerging enterprises. Companies wishing to manage their business on the road anytime and anywhere on the go with can utilize SAP Business One 9.0 via mobile apps for IOS and Android devices. Today’s emerging enterprises oft SAP Business One 9.0 offers a variety of […]


SAP Business One 9.0 – Fixed Assets

Today’s Blog features what’s new in SAP Business One 9.0 and focuses on areas of enhancement and new features related to Fixed Assets.  SAP Business One 9.0 (now available) contains enhancements and additions meant to support the growing needs of the small and medium enterprise companies.  So, what’s new in SAP Business One 9.0? Integrated […]


What’s New in SAP Business One 9.0 – Bin Allocations?

Today’s Blog features what’s new in SAP Business One 9.0 and focuses on areas of enhancement and new features related to Bin Allocation.  SAP Business One 9.0 (now available) contains enhancements and additions meant to support the growing needs of the small and medium enterprise companies.  So, what’s new in SAP Business One 9.0? All […]


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