October
04

How To Default MAS90 Customized Report Setting Reports To Todays Date

Posted 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

© 2011, Wayne Schulz. All rights reserved. Sage 50, Sage 100, Sage 300 and Sage 500 are registered trademarks of Sage. Have additional unanswered questions about MAS90? You may contact Schulz Consulting here.

We publish an email newsletter each Tuesday at 3pm – join here.


Related posts you might want to review:

  1. Fixed! – Default printer may now be assigned to standard reports and standard form codes after applying MAS 90 service update 23
  2. Job Status tab displays data in the incorrect fields and Job Cost Reports with Job-to-Date, Period-to-Date or Year-to-Date information display data in the incorrect fields.
  3. Setting up Sage Payment Services with MAS90 or MAS200
  4. MAS90 Purchases Clearing report doesn’t foot in v4.3
  5. What versions of Crystal Reports are supported by Sage ERP MAS 90 or 200?

About

This entry was written by a Sr Consultant who has worked with Sage 100 ERP ( Formerly Sage MAS 90 and MAS 200) since 1986. He provides technical support to companies located throughout the United States on all versions of Sage 100 ERP Contact Wayne via our info request page.The views expressed on this site are solely those of the author and do not reflect the opinion or position of any other person or company. We are NOT in the business of providing tax, accounting or audit advice and you are advised to consult with your tax professional in such matters and not to rely on any information here as authoritative tax, technology or accounting advice. Information is subject to change without notice. Google+

Filed Under Sage 100 

Comments

Comments are closed.