Schulz Consulting

Sage 100cloud Consulting

  • Home
  • Services
  • Contact

How To Default MAS90 Customized Report Setting Reports To Todays Date

October 4, 2011 by Wayne Schulz

Here’s a really useful fix that we made today for a customer.

We had modified an existing Aged Invoice report for a customer on v4.3. Saved it as report setting “CUSTOM”.

They noticed that while their “STANDARD” report would automatically default to today’s date — the CUSTOM one that we created and saved under the new CUSTOM name would not.

Turns out this was discussed on the forums about two years ago. It’s a WAD — unless you use this undocumented trick.

You saved a set of alternate Report Settings for the A/R Aged Invoice Report under some name other than STANDARD.

This unfortunately included the Aging Date report option, so now it always wants to age the invoices as of that same date every time, and this is annoying.

You want it to default the Aging Date the same way that it does with the STANDARD Report Settings.

This works for me:

Open SY_ReportOption table in DFDM.

Find the record for the AR_AGEDINVOICEREPORT_UI in your company that has the name of your Report Settings on it.

Edit the OptionsString$. Add ; to the end of it. (That looks like an HTML tag, and your browser might’ve tried to render it, so I will spell it out for you. It’s semicolon, less than, capital R, capital T, greater than. No spaces anywhere.)

Done.

If you browse over to the record for the STANDARD Report Settings, you’ll see that it already has this interesting little bit on the end of its OptionsString$ too. It’s the magic signal that tells the report code to go default some things (like date options) in a smart way instead of just reading them out of this file. The details of exactly what this little token means will vary from report to report.

via: http://community.sagemas.com/t5/Personalization-Customization/A-R-Aging-Date-after-creating-customized-Aging-Report/m-p/6165

Share this:

  • Twitter
  • Facebook
  • Email
  • LinkedIn

Filed Under: Sage 100 ERP Tagged With: date, report setting

About Wayne Schulz

Wayne Schulz is a Sage 100 Consultant located in Connecticut. He has worked with Sage 100 and Sage 100cloud ( Formerly Sage MAS 90 and MAS 200) since 1986 and provides advanced Sage 100 technical support to companies located in Connecticut, Massachusetts, Rhode Island, New York and throughout the United States. If you are experiencing an issue with Sage 100, and would like to schedule a support session - please request assistance here or call 833-724-3100.

Search Our Site

Sage 100cloud Latest News

  • What Are The Differences Between Sage 100 Perpetual and Subscription Licenses? January 11, 2021
  • Sage 100 Aatrix e-Filing Bug Erroneously Reports Bad SSN Matches for 2020 January 6, 2021
  • There is No Sage 100 IRD for 2020 January 6, 2021
  • Is Your Sage 100 Payroll Year-End Processing Slowly? January 5, 2021
  • Sage Announces Sage Partner Cloud December 16, 2020
  • What Happens When Your Sage 100 Subscription Expires? December 10, 2020
  • Sage 100 – 2020 eFiling Deadlines for W2, 1099 and ACA Released December 9, 2020
  • Sage 100 data conversion for version 2020.1 takes a long time or appears to hang on IM_LotSerialTransactionHistory when it contains a large number of transactions. December 8, 2020

Our sponsors

Contact Us

Schulz Consulting
Connecticut Office
Phone: 860.657-8544
Email Us
Locally serving all of Connecticut, Massachusetts, Rhode Island, Vermont,
New York, New Jersey. Available remotely nationwide.
We are a local branch of DSD Business Systems Connecticut.

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

loading Cancel
Post was not sent - check your email addresses!
Email check failed, please try again
Sorry, your blog cannot share posts by email.