PROGRAM ISSUE ** THIS INFORMATION HAS NOT BEEN VERIFIED **

Account data is duplicated on Report Manager Financial Reports

Entry Type: Program Issue 

Product: Sage MAS 500 ERP

Application: Sage MAS Intelligence

Version Reported: 7.30

Status:

This issue is being researched by Engineering.

Subject:

Account data is duplicated on Sage MAS Intelligence Financial Reports in Sage MAS 500

Steps to Duplicate:

In CAD company:

  1. Expand MAS Intelligence, Report Manager. Double click Financials, right click on Financial Reports 2.0(MAS 500) and click Run.  Enter Financial Year of 2008 and 7 for Budget Set.  Click OK
  2. Click Menu Tab in Excel.  If prompted, click on Categories tab and populate the GLCatCode column appropriately.  When completed Click on Menu tab again.  From Financial Reports list select number 1 report "Actual/Budget/Variance 1-12, Qtrs & YTD/Annual Budget"   Income Statement.. 
  3. Expand one or two of the groups and note the account amounts for a few of the accounts in one of the periods.  
  4. Right Click on the worksheet tab and click Unhide, Sheet 1.  click on Sheet 1 and note all accounts are listed only once.  Close report and close Sage MAS Intelligence
  5. Expand General Ledger, Maintenance, GL Setup, Set Up Fiscal Calendar.  Select 2007 Fiscal Year. Change End Date for Period 12 to 12/26/2007.  Click yes to prompt to recalculate balances. 
  6. Select Fiscal Year 2008 from lookup. Set up End Dates as follows:
  7. Period 1    01/31/2008
  8. Period 2    02/28/2008
  9. Period 3    03/27/2008
  10. Period 4    04/24/2008
  11. Period 5    05/29/20088
  12. Period 6    06/26/2008
  13. Period 7   07/31/2008
  14. Period 8    08/28/2008
  15. Period 9    09/25/2008
  16. Period 10  10/30/2008
  17. Period 11  11/27/2008
  18. Period 12  12/25/2008 
  19. Click Finish to save changes, say yes to prompt to recalculate balances.  When completed recalculation completed, exit Set Up Fiscal Calendar.
  20. Repeat steps 1-3.  Note that the amounts have doubled.
  21. Repeat step 4.  Note the accounts now appear twice on the worksheet. Used report # 1 as example, however accounts are duplicated in any of the report selections.
  22. Right Click on any worksheet tab and unhide sheet 1.  Open sheet 1 and note all the accounts are showing up twice.  Once with period start date of 12/27/2008 and again with start date of 01/01/2008.  

Expected Behavior:

Expect the accounts and amounts not to be duplicated on the report.

Possible Workaround:

None