Sorry you are having this issue
The best bet would be to contact the sage 50 support line directly.
They will have you delete some attachment and userpref files and run a data verification
This should fix it and get you up and…"
"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)