"Hi KDS Consulting,
This usually happens when the Sage Intelligence Metadata (Alchemex.svd) file gets too large or could be corrupt. Another instance this could occur would be due to .NET security.
You'll be able to isolate the issue by trying…"
There could be some formatting that was ported over when copying the FRx sheet into Report Designer.
You'll be able to test this by copying individual items from the FRx sheet into Notepad and thereafter into Excel.
If it works after…"
There souldn't be any issues with that combination as long as you're using the on premise version of Office 365.
In a nutshell, the article directs you to check the data sheets for the report you ran. There will be a duplicate…"
Was the distribution instruction created by the prior controller?
If so, that could be the issue. Please have the new controller setup the distribution instruction, before the prior controllers mailbox permissions are applied to the new…"
This would most likely be due to User Access Control being active on the machine.
Please have a look at the below links to see the issues that this could cause (yours being one of them):
- Understanding UAC
- UAC in Vista
- UAC in…"
This could be as a result of the companies not being in the Tenant cache or in the consolidation list.
If they do not display in the Tenant Cache (check by opening Report Manager, click on Tools and thereafter "Tenant Cache"…"
Connecting Excel to a DB to capture an image may not work unless the file type is recognized by Excel.
Excel natively understands raw data and as a result, this connection would most likely result in some scrambled characters being displayed…"
You'll have to get Sage Intelligence to output the data you need to Excel as Crystal Reports and Sage Intelligence do not exchange data.
You'll need to add a query in the Connector module to pull the data you wish to see in the…"
Do these invoices exist in the raw data brought back from the system?
It could be that the underlying data isn't available...You can check this by unhiding the data sheets in Excel and looking for those specific invoices.
If the data…"
That certainly is strange!
I'd recommend contacting your ERP support desk to assist with this as there's definitely something weird going on.
Out of curiosity, is the company name exactly the same as it appears in the tenant cache…"
You'll firstly need to know were (which table) this data is contained and thereafter write the relevant SQL to extract that data. This can also be done by creating a container in the connector module and adding the table were all…"
The company would need to be in the tenant cache for this to work as the transaction drill-down queries the DB with supplied parameters.
You'll be able to see if this exists by opening Report Manager, clicking on the "Tools"…"
This can be achieved by use of a "pass through variable" in your container. You'll can use this variable to filter data in the report to a specified date range. You can find more information on how to set this up at the below…"