Schulz Consulting

Consulting and Upgrades

  • Home
  • Services
  • Contact

Data File Display and Maintenance (DFDM) for Sage 100 Premium Available Now

March 1, 2017 by Wayne Schulz

 

DSD Business systems have released a free Sage 100  Premium – Data File Display and Maintenance. The new utility actually works for all versions of Sage 100 (Standard, Advanced, and Premium) but is most helpful to those on the Premium (aka SQL) versions which previously did not offer a Data File Display and Maintenance (aka DFDM) utility and instead required consultants and users to use SQL Management Studio to manipulate data files.

This utility is available for Sage 100 v2013 or higher. It adds the ability to select the database (aka company code) as well as the table name from a drop down list. Standard DFDM required that you manually browse through a sometimes confusing path to locate tables manually while the Premium version of Sage 100 included no DFDM and instead required you to use SQL Management Studio.

The utility is free to users on Sage 100 v2013 or higher. Download it from DSD Business Systems – here.

Filed Under: Sage 100 ERP Tagged With: dfdm, dsd business systems, Premium, SQL Management Studio

How To Find and Fix Bad Dates in MAS90 and MAS200 Data Tables

September 28, 2011 by Wayne Schulz

A user has just asked our 90 Minds group whether there’s an easy way to detect a bad date that is within a set of their MAS90 version 4.4 data.

Update August 27, 2018:

Sage has issued a Check Date utility for Sage 100 and Sage 100 cloud which can be run from recent versions of Sage 100 and automatically seeks out bad dates.

Download the CHECKDATE utility from Sage here.  Place the download in your \MAS90\SOA folder and from the FILE menu select RUN and SYZCON.

Then RUN “CHECKDATE”

This utility prompts for your Sage 100 company code. It then scans relevant data files and places a file XXX_CheckDate.txt in MAS90\HOME\Textout\

 

This can be a very tricky issue to resolve mostly because finding the exact bad record is hampered by the fact that MAS90 or MAS200 will error out each time you run a report – or try to design a report to print the bad record(s).

That is — unless you know the secret setting that will allow the bad date(s) to print via a Crystal report.

If you’re wrestling with a bad date somewhere in your MAS90 or MAS200 files – here’s the solution that I’ve used before to quickly print out the data and find the bad date record:
Go into your SOTAMAS90 ODBC source. Check off “NULL Date”. Create a report in Crystal that draws from the file with the bad date. The bad date will no longer stop the report from processing. Sort by the date field. The bad dates will sort to the top (or end).
Now go into Sage ERP MAS 90 or MAS 200 (usually through Data File Display and Maintenance) and fix the bad record(s).

Note: Always backup prior to making any changes to your data through Data File Display and Maintenance. We are not responsible for damage done to your data.

Filed Under: Sage 100 ERP Tagged With: dates, dfdm, odbc

Access Sage 100 in the cloud today. 3rd party applications supported Available 24/7 from anywhere. Dedicated hosts

Call 1-888-244-6559 (toll-free)

Search Our Site

Sage 100 Newsletter

Sage 100 News

  • Shipment Tracking Functionality Restored to Sage 100
  • How To Edit 1099 Totals In Sage 100
  • How to Reconcile Sage 100 Accounts Payable Detail to the General ledger
  • Sage 100 Year-End 2022 Training Series
  • Minimum Sage 100 Versions for E-Filing for Tax Year 2022
  • What Are The Differences Between These Sage Fixed Asset Versions: Lite, Single-User, Network and Premier?
  • Sage 100 Paperless Email Electronic Delivery Failing With Rackspace
  • How To Check Sage 100 Compatibility with Avalara’s TLS 1.2 Requirement
  • Sage 100 TLS 1.2 Compliance Update ( Nov 2022)
  • What Are My Sage 100 Mobile Sales Options?

Contact Us

Schulz Consulting
Connecticut Office
Click Here To Contact Schulz Consulting
Email Us
Available remotely nationwide.
We are a local branch of DSD Business Systems Connecticut.

Copyright © 2023 · Parallax Pro Theme on Genesis Framework · WordPress · Log in