"To be able to design your own report, you have to use the connector module.
This enables you to "tap into" the database and build your own reports from the ground up or edit existing containers.
If this is a costing issue in the sales…"
That question would be better suited for the general sage 50 US support queue as sage intelligence only reports on existing data and doesn't import.
However to the best of my knowledge there is no template for the purchases…"
How good is your knowledge of SQL?
Using the connector module you should be able to do this. However it should also already be part of the line cost amount field within the sales analysis container.
But if you must indeed know the SQL…"
"Are you able to run any other reports?
If this is happening to just one company then the issue should be data related.
The general sage 50 support queue should be able to assist you with this.
"Are you saying the company does not appear in consolidation list?
If not, simply log into that company and run sage intelligence once,This will add it to the cache and you should be able to select it."
This should work fine. The video Helen posted should assist.
You can even customize one of the standard reports within the financial report designer 1-0 to do this.
Let us know if you have any issues
- Remove intelligence reporting (from the list of installed windows programs)
- Run a repair on office (with sage 50 closed)
- Reboot machine
- Reinstall intelligence reporting (just clicking on it from within sage 50 will reinstall the latest…"
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: