Incorrect Fiscal Period displays on the data tab when runing the Customer Sales 2-1 and GL Fiscal Calendar not based on the standard calendar year format
Entry Type: Program Issue
Product: Sage MAS Intelligence
Application: SMI Report Manager
Version Reported: 7.30
Status:
Resolved with either of the following:
Subject:
Incorrect Fiscal Period displays on the data tab when runing the Customer Sales 2-1 and GL Fiscal Calendar not based on the standard calendar year format.Steps to Duplicate:
In [SOA] company:
- In MAS 500, expand General Ledger, Maintenance, GL Setup, Set Up Fiscal Calendar.
- Create a Fiscal Calendar which doesn't follow the standard calendar format.
- Select Fiscal Year 2006. Delete all periods 2 through 12 leaving the First Period remaining.
- Enter a 'Start Date' of 04/01/2006 and 'End Date' of 04/30/2006 for Period 1. Click finish. If prompted to Recalculate Balances click Yes.
- Select Fiscal Year 2007. Delete periods 2 through 12. Enter 05/31/2006 for the 'End Date' for period 1.
- Click on 'Add Period' and add periods 2 through 12. Click finish. If prompted to Recalculate Balances click Yes.
- Expand MAS Intelligence, Tools, Report Manager.
- Expand the Sales Folder.
- Select the Customer Sales 2-0 Report and click Run.
- Enter the Report Parameters: Start Date = 01 January 2007. End Date = 31 January 2007. Click Ok.
- Unhide the DataSheet tab (Sheet 1).
- Note the columns K (FiscalPeriod) and L(FiscalYear). Fiscal Period = 1 and Fiscal Year = 2008. This is incorrect. The Fiscal Period = 9 and the Fiscal Year = 2007 for the PostDate in 01/2007.
