Spreadsheet Server on AS/400

2535 pts.
Tags:
AS/400
SQL queries
Our 3rd party software "Spreadsheet Server" retrieves the wrong details after a drill-down request. Our G/L is based on the (400) MOVEX package - this module is not heavily modified. The problem is that the drill-down (into a month's balance for a specific G/L account) returns details for a different period. It likely matters that we recently switched from a Fiscal (July - June) year to a Calendar year and we also went from SSW V12R5M21 to V14R5M1 Yes we're working with the vendor, but zero results so far My hope is that someone here has already been through this and can point us in the right direction for a resolution. Thanks

Answer Wiki

Thanks. We'll let you know when a new response is added.

It turns out there is a SETTINGS value for which Year type to use. I guess most shops (us included) use Type 1. Switching this to Type 2 (Calendar Year for us) gives us the drill down info we need.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: