Is that specific column in excel in your pivot-table formatted as "date"
Format it as date (the entire column in the sheet)
Then try grouping those dates once more (clearly defining the month and year start and end)
The Sage 50 general support queue should be able to help you with this
They will delete the rptdata.DAT file within that company and have it re-generate a brand new one
This should solve the problem"
Does this happen all companies on that machine?
Could you try this on a sample company like BCS (bellwether Garden Supply)?
If this happens just in one company, then you may have a corrupt "reports" file within just that one…"
There is a data dictionary document called DataDict.pdf that is included with the installation of the Sage 50 program. Please refer to the locations listed below.
Windows XP or 32-Bit Windows Vista, 7, and 8:
I believe this is indeed standard behavior as the internal names in the database cannot be changed. The naming exists to help you when working within the report manager and not once the data has been pulled to excel because the data on…"
"Try this work around:
- Load a sales report (or any other non financial report) into excel
- Enable the Bi generator addin (in the excel addins section)
- Then Run your report designer
- You should see the bitools tab now
- Try designing your…"