Tips and Tricks – Schulz Consulting

Sage 100 and Sage 100cloud File Layouts Online

August 21, 2018 by Wayne Schulz

The Sage 100 2018 File Layout and Program Information detail is now available online. This information can be valuable when writing reports, designing data imports or just for obtaining a broader understanding of Sage’s structure.

The table and program structures are presently limited to Sage 100 and Sage 100cloud version 2018.

Prior releases of Sage 100 from version 4.x on have very similar table structures, except for Payroll and Job Cost which received complete revamps in 2018.

To review the Sage 100 file layouts online in your web browser, navigate to:

http://help-sage100.na.sage.com/2018/FLOR/index.htm

How To Reprint The Data From A Sage 100 ERP Accounts Payable Check Stub?

January 9, 2013 by Wayne Schulz

Have you ever printed an accounts payable check and for whatever reason the detail on the stub which shows the invoices paid is missing?

When printing accounts payable checks there is a field labeled “Stub Lines”

I have seen instances where setting this number TOO HIGH can cause a check to print with incomplete/partial invoice listings.

The resolution is generally to reduce the Stub Lines number to be the actual # of lines that can fit on that check. Also, remember that both stubs of the check may have different amounts of space for invoice listing depending upon whether customization’s have made to your check layout. In those cases select the # of lines which is the SMALLEST # which fits on either of the stub in order to prevent losing invoice details.

Unfortunately re-printing check stubs is not possible however you may wish to use the Payments History Report from the Accounts Payable – Reports menu or the Trial Balance report on the same menu. Both of these standard Sage 100 ERP (fka MAS90 or MAS200) reports will show the check invoice detail.

63% of Pirated Software Contains Malware or Viruses

January 2, 2013 by Wayne Schulz

A Microsoft study performed in December 2012 indicated that 63% of sampled pirated software was being distributed with some type of malware or trojan virus. And the news gets even worse for those pirating Microsoft software where 77 percent of the Windows Update functionality had shown to be disabled or re-routed to third-party services.

The study also found that among computers with bootleg copies of Windows operating systems (OSes), 77 percent of the Windows Update functionality has been disabled or re-routed to third-party services. The software giant said these PCs with disabled Windows Update bypass genuine software checks and are denied critical security patches which causes them to be defenseless against malicious cyberattacks.

ZDNET: 3 in 5 pirated software in Southeast Asia malware-ridden

Parcel Is Located Already At Post Office: Warning USPS Delivery Scam Email

May 10, 2012 by Wayne Schulz

If you’ve received the following email alert about a package sent via express mail which is awaiting your pickup – be advised the US Postal Service is warning that this is a scam.

There is likely an attachment to that email which when clicked will infect your computer. Delete any such notifications unopened.

Here is a copy of one such bogus email:

From: USPS Customer Service
Date: Thu, May 10, 2012 at 10:00 AM
Subject: Parcel is located already at the post office
To: sales@s-consult.com

Delivery information,

We couldn’t deliver your parcel at your address.
Reason deny\Postal code isn’t specified.

LOCATION OF YOUR ITEM:Amarillo
STATUS: not delivered
SERVICE: Express Mail
NUMBER OF YOUR ITEM:U756213378NU
FEATURES: No

Postal label is enclosed to the letter.
Print your label and show it at the post office.

An additional information
If the parcel isn’t received within 30 working days our company will have the right to claim compensation from you for it’s keeping in the amount of $5.13 for each day of keeping.

You can find the information about the procedure and conditions of parcels keeping in the nearest office.

Thank you for using our services.
USPS Services.

via: USPS (PDF Warning)

MAS90 and MAS200 v4.4 Product Update 5: SVTRNA Bug Advisory

May 6, 2011 by Wayne Schulz

One of our most used hidden utilities within MAS90 and MAS200 is a program SVTRNA. What the program does is allow you to copy master data (no financial totals only names, descriptions, addresses) from the accounts payable, accounts receivable or inventory modules of an existing MAS90 or MAS200 company code into a brand new code.

This is super helpful when establishing a new company within MAS that is virtually a mirror image of an existing one and which will make use of all (or virtually all) of the same customers, vendors or inventory.

One of my 90 Minds Consulting Group colleagues just noticed that on version 4.4 product update 5 that when he copied over inventory data he was also receiving a little more than he bargained for. Normally only the master information for each inventory item would copy (description, product line, etc). It appears there may be a bug in v4.4 product update 5 which results in some totals (quantities on hand) also transferring if you use the SVTRNA utility.

This isn’t a huge issue – except according to my colleague there’s no way to fix the totals by using the Visual Integrator module. So if you’ve made a data transfer using SVTRNA into inventory and hadn’t thought to keep a backup – you could find yourself in a bit of a pickle.

Your best bet when making copies of data is to always make a complete backup of your MAS data BEFORE attempting the transfer (here’s one way that Sage recommends). We’ll update you with more information on this as we hear about it.

90Minds

Contact Us