SAP Business One – A well written user Manual and Guide

Here is a very well written comprehensive user guide to SAP Business One. It’s in Microsoft Word format so you can customize it and make edits for your own company. We hope you find this helpful. You can view it within the blog, or click on the link above the document to download it. Download [...]

Share

SAP Business One – How to Import AR Invoices, and then Import Applied Cash Receipts

Thanks to Don Shields for this overview on how to properly import Accounts Receivable (AR)  Invoices and then applied Accounts Receivable (AR) Cash Receipts into SAP Business One using the the Data Transfer Workbench ( DTW ). Templates: (RECOMMEND TAB DELIMITED TEXT FILES FOR IMPORTS with no text identifier, stay away from .csv) Make sure [...]

Share

FourthShift Edition 9.0 released for SAP Business One

In a recent interview with Diane Palmquist, vice president and general manager of SAP Solutions for SoftBrands, she shared the vision that went into developing the Just Released FourthShift Edition 9.0. From that vision came an ERP system, rewritten and streamlined with all new code (500 thousand lines v. 2 million), based on N-Tier architecture and positioned [...]

Share

SAP Business One Query Tip: How to Break Down a Date into Separate Fields (DATE PART, DATENAME)

Note: This is not a comprehensive description of the capabilities of either of these SQL Functions. Suppose you would like to get the current month number for a date in SAP Business One. Let’s use the Document Date from the Purchase Order table (OPOR.DocDate). We will be looking at the DATEPART and DATENAME Functions in [...]

Share

SAP Business One Referencing/Triggering One UDF from Another UDF

When referencing one UDF from another UDF use the $[Filename.Fieldname] technique descried in the Formatted Search manual and not the number technique. The number technique (like…$[$4.0.0] (for the Vendor/Customer Number on the screen)) works when you press Shift + F2, but the values cannot be automatically triggered from other UDFs. The requirement was to have [...]

Share