90 Minds Sponsor

SAP Business One Versus (vs.) Sage MAS 500

We are always being asked to compare and contrast solutions. Below is a bulleted list comparing SAP Business One and Sage MAS500.

  • SAP is a Total Business Solution. Includes Accounting, Distribution, Manufacturing, Sales Force Automation & Customer Service in one integrated solution with one code base, one database with a single installation. It’s your choice as to how much or little to use, but as you use more, its available with the one price per user. Since CRM is part of the standard solution, you can use it in all areas. For example, create to-do’s and followups regarding a purchase order, a General Ledger Entry, or collections activity against an invoice.
  • MAS500 is only ERP, not CRM. You need to purchase Sage Saleslogix for CRM and then use their newly released (and still being debugged) integration. This is the 3rd integration in 4 years as the prior ones have been terrible.

[Read more…]

Our SAP Business One resource center is now up.

We’ve just posted up a comprehensive sub-site focusing around SAP Business One.  This site contains, videos, articles, PDF’s and documents showing software in action, customer success stories, technical data etc.

Information on Crystal Reports and Xcelsius is also included.  Both these products work well with Sage MAS90 and MAS200.  Everything is wrapped up in an entertaining and visual video and avatar presentation format.

Click HERE to go to our sub-site.

SAP Business One NJ Resource Center

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 or View SAP Business One To Go 2007 on Scribd

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 G/L Account Determination is filled out CORRECTLY. Particularly that the Sales Account tab is filled out and the Checks Received account is setup as a Cash account.

1. A/R invoices = oInvoices

a. Documents

i. Use a doctype of “S” for Service.

ii. Handwritten = tYES if you want to import invoices numbers from the old system. Uses the “Manual” numbering series.

b. Document_lines

i. Use the enum for the account code. Recommend setting up an opening balance offset accout. A/R from the BP will be the other half of the entry.

ii. Use item Description for you comments like “Open bal entry”

iii. Other columns used: LineTotal, Price, Quantity, Taxcode (use the exempt one, but one will be required).

2. Payments = oIncomingPayments

i. Payments

1. Payment header file and you can also import cash amounts in the cashsum column ONLY if it is a cash payment.

2. Leave the Bank account related columns blank if you are going to include a line in the Payment_Checks file for the line.

3. The example shown in the templates for DTW is an example of Cash payments that are not applied to any invoice.

4. SAP will not let you use a DocDate before the start of the fiscal year. Also, if you are applying the payment to a document, the payment doc date must be after the a/r invoice date.

5. The DocNum in the payments file is the internal transaction number, not the Customer’s check number. That goes in the Payment_Checks file. You can put tYES in the handwritten column and then put whatever number you want in the DocNum column, otherwise leave them both blank and SAP will assign #’s to the incoming payment doc headers.

6. Put a comment in the JournalRemarks if desired.

ii. Payment_Checks

1. Use if the payments are checks. If they are cash fill in the cashsum line in the payments file and do NOT put a line in this file for that line.

2. Fill in the BankCode column with the house bank code.

3. CheckNumber for the customer’s check number they paid with.

4. CheckSum is the total of the check.

iii. Payment_invoices

1. Use the DocEntry column to enter the reference of the invoice number to apply the line to. To get this you have to query the OINV table. I imported my invoices and immediately ran the query to get the DocNum with the invoice number matched to the DocEntry and pasted that into Excel. Then used VLOOKUP() to prepare my Payment_invoice template.

2. You don’t need to have an entry in this file for every payment, only if you want to have a particular payment applied to an open A/R Invoice. These are linked by the RecordKey like normal in DTW. Payment_checks without a corresponding Paymnet_invoice will be imported as payments on account.

via: Mark Chinsky and Don Shields, New Jersey CT , TX, Texas Sage MAS 90 and 200, Job Ops, and SAP Business One consultants

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 to change as the market demands. New functionality has been added that expands FourthShift Edition’s market to include discrete and process manufactuers that function in make-to-order, make-to-stock, and configurable environments.

Listen for an audio sneak peek.