All pages

Jump to: navigation, search
All pages
 
All pages | Previous page ("Error" Impicit Conversion from data type date time to int is not allowed. Use the CONVERT function to run this query)
Excel 2003 missing Add- insExcel 2007 Specifications PivotTable Report SpecificationsExcel 2007 Split contents in cells of excel worksheets
Excel Memory LimitsExcel Pivot table limits.Excel behaving strangely while an Alchemex report is running.
Excel formulas are removed when a Reports Designer Add-In report is distributedException error when launching Security ManagerExport failed due to unexpected error.The error was Compress.exe error
External content links on home page in reports are brokenFINALISERETINC FAILED ERRORFRX Conversion Error
FRX tree conversion assistant, Error: Object reference not set to an instance of an objectFinaliseRETINC () Error during generation of a reportFinancial Genie CurrentYTD does not print the YTD values for period 1
Financial Report Designer 1-1 does not balance to the ERP Report.Financial Report Designer does not use the financial categories instead it uses account numbersFinancial Report Designer hangs at Naming Ranges and Excel does not respond
First Instruction only sent on scheduled reportFiscal Year data missing from the Fianancial Report DesignerFiscal period does not show correctly
Formulas removed when distributing Report Designer Add-In ReportGENIE REPORT DOES NOT GENERATE CORRECTLYGL Accounts not showing on Management Pack S 4-6
GL Detail in Intelligence ReportGeneric (All Databases) Pre-installation RequirementsGenie not licenced
Get error when using 64Bit office for distributionHOW TO CHANGE YOUR PERVASIVE DATABASE CONNECTION PATHHOW TO CREATE A SYSTEM DSN WITH ORACLE
HOW TO PASS A VALUE TO A PARAMETER ON A SQL STORED PROCEDURE VIA A REPORT PARAMETERHOW TO SET UP A SCHEDULED TASK IN WINDOWS 7 PROFESSIONALHRESULT error on Windows 8
Hide Zero Rows MacroHiding and Showing ReportsHistory of the report
Hotfix for Sage 300 v5.5 Licencing issue in Terminal Server EnvironmentHotkey for "Run as administrator" Windows Vista, 7, 2008How Evolution BIC Web Reporting differs from Evolution BIC from a Connection Perspective
How can we disabled named ranges without the Administrator module?How do I create a report shortcut and save it on local network for other pastel user to run.How to: Disable User Account Control (UAC) in Windows 7
How to: Disable User Account Control (UAC) in Windows VistaHow to: Run Alchemex as an AdministratorHow to: Understanding Windows Vista User Account Control (UAC) and File Virtualization
How to Change the Decimal Place in Cells in Microsoft Excel 2003How to Lock Individual Cells in a Worksheet in ExcelHow to Run a Program as an Administrator in Windows 7
How to Serialise AlchemexHow to Use Excel's CountBlank FunctionHow to Use Your Excel Add-In Functions in VBA
How to add a data container based on a stored sql procedureHow to change a report connectionHow to change a report to use a different container
How to change your MetaData pathHow to clear additional rangesHow to create a 32 bit ODBC driver on a 64 bit machine
How to create a PICKLISTHow to create a basic task scheduler in Windows 7How to create a task scheduler with windows server 2012
How to increase Report Parameter when limited to 2000 rowsHow to increase timeout on containerHow to manually add a licence
How to protect the output bookHow to register ALWrapper and ALDBConvertHow to reset admin password in Sage 100 Intelligence Security Manager
How to schedule a consolidated reportHow to switch between the 32-bit versions of ASP.NET 1.1 and the 64-bit version of ASP.NET 2.0 on a 64-bit version of WindowsHow to use Windows Scheduler to schedule reports in Sage 100 Intelligence
How to view auto connection detailsHow would I know which report is linked to which container in Alchemex Administrator?How would you calculate percentages on Microsoft Excel?
INCORRECT DETAIL FOR FISCAL PERIOD SEPTINDEX OUT OF BOUNDSISSUE: Alchemex FA Error for Microsoft Office 64 Bit
If you click on Income statement or balance sheet, nothing happens when running the management pack.Implicit conversion from data type datetime to int is not allowed. Use the CONVERT function to run this queryImport Failed Syntax error(missing operator)
Importing and exporting reportsIncorrect values on Sales Master 4-5Information for expenses starting with April are not correct
Initialization of the data source failed. Check the database server or contact your database administrator.Installation Guide - Financial Reporting for Sage ERP X3Installing 32-bit ODBC Drivers for Btrieve
Installing AlchemexInstructions for moving SMI 4.4 to a different location after Performance Patch has been appliedIntelligence DrillDown does not work on Accounts with masking
Intelligence Reporting-shows blank data of the dashboard reportsInternal Error 2753. F7673 PLASOCFILE.EXEInvalid Object Name
Invalid Procedure call or argumentInvalid procedure call or argument errorInvoice Date field missing in pivot table
Invoice amount doubled on AR Invoice Aging Report in Sage IntelligenceIssue: Pastel Evolution 6.5 Management Pack 3-3, incorrect opening balances for multiple retained income accounts.It was not possible to instantiate the Object BIEngine.Applicagtion. The error Returned was Cannot Create ActiveX component
It was not possible to write to the MetaData RepositoryIt was not possible to write to the Metadata Repository.Please make sure there are sufficient user permissions on the Alchemex.svd file and that the file attributes are not set to read only.It was not possible to write to the Metadata Repository. Please make sure there are sufficient user permissions on the Alchemex.svd file and that the file attributes are not set to read only
Item cannot be found in the collectionJoins in Pervasive SQL can sometimes be order specific.Keyword not supported 'driver'
LICENCE MANAGER AND TERMINAL SERVICES ISSUES ON ENTERPRISE EDITION SERVERLeave days due listing BI report does not include leave history.Lists include all companies when using a consolidation report
Locking/Unlocking a ReportLocking and Unlocking a reportLogon has been disabled by your VAR
MANAGE OBJECT SCOPE COMPANY IDMULTI – STEP OPERATION GENERATED ERRORSMacros called from an Alchemex report that has string parameters that include the comma character fail.
Main PageManagement Pack 13th period missingManagement Pack Consolidation
Management pack report Not Showing Actual, Budget and Variance TitlesManual steps for the report drill down functionality within the Management PackMapAccountCategories failed
Mapping is requested every time Report is run out even after creating and linking reportMetabase Version Relevance when Exporting ReportsMetadata Repository (SVD) issues
Microsoft Excels Dynamic Array Function update breaks Sage Intelligence ReportingMicrosoft ODBC Driver Manager Data source name not found and no default driver specifiedMicrosoft ODBC SQL Server Driver SQL Server Login failed for user ’sauser’.
Microsoft ODBC SQL Server Driver Shared Memory SQL Server does not exist or access denied.Microsoft office 2016 and Financial Report Designer compatibility issuesMissing BIgenerator and PLdrill on terminal server
Missing Resource Automation error Library not registeredMove your Alchemex installMoving Alchemex.svd file and Templates folder from one server to another
Moving licencingMultiple-step operation generated errors. Check each status valueMultiple-step operation generated errors. Check each status value.
Multiple-step operation generated errors Check each status value.Multiple versions of Alchemex / Sage intelligence on one workstationMy Sales Analysis report is not pulling cost for assembly line items
N functionNamed Ranges in ExcelNew Addedd columns not pulling through in Pivot Table fields in Sales Master Report
New Twist on SQL Server does not exist or access denied.Newer version of PLPLUGB.DLL on earlier version of the core softwareNot a valid Win32 Application error
Not recognizing some files with XLT formats after upgrading to Excel 2007Not wanting to create a Pivot from your raw dataODBC Connection for Pervasive.SQL 2000/2000i
OUTPUT TEMPLATE FILE ERRORObject reference not set to an instance of an objectObject reference not set to an instance of an object.
Office 365 hangingOnly 3 Tabs showing on Report propertiesOpening balance not showing on Financials Report in Sage 100 ERP Intelligence report if the ending balance of the period is zero
Outgoing mail server does not exist or cannot be reachedOverriding Workstation Login ModePERVASIVE ODBC CLIENT INTERFACE ERROR-THE SPECIFIED FILENAME IS INVALID
PLSupport.exe tool corrupts Alchemex.svd filePROBLEM LOADING DATA. OBJECT OF TYPE ‘SYSTEM.DOUBLE’ CANNOT BE CONVERTED TO TYPE ‘SYSTEM.DATETIME’PROBLEM LOADING DATA WHEN RUNNING CONSOLIDATION REPORT DESIGNER ADD-IN
Paste method of worksheet class failedPastel Auditor journal export to Pastel Evolution does not export contra account adjustmentsPastel Evolution 6.0 Management Pack 3-2, incorrect opening balances for multiple retained income accounts.
Pastel Evolution BIC Web Reporting User GuidePastel Partner - period 13 not pulling through when creating layoutPastel Partner – All Sales related Templates
Payroll summary report does not match detail reportPerformance Issues Sage 50US V2020Permission rights to Alchemex
Pervasive ODBC Client Interface Client LNA The ODBC Client interface cannot access the data source because SQL Connection Manager is not running at the specified port number.Contact your system administrator for assistance. SQLState 08S01Pervasive SoftwareODBC InterfacePervasive Software SQL EngineA variable-length column must be defined last in a view or table definition.Pervasive SoftwareODBC InterfacePervasive Software SQL EngineGeneral error
PicklistM does not return correct paramaters listingPicklist FunctionalityPivot Table Layout
Pivot table graphs losing all colours in Excel 2007.Power View report does not refresh automaticallyProblem: IIS6 does not appear to be running .asp pages. Returns the “Page cannot be displayed” error when trying to launch the Alchemex Web Solution website.
Problem: Installing Alchemex on Windows VistaProblem: Report requests are hanging, status screen shows as ‘request waiting to be processed. Request Server is running but does not appear to be picking up requestsProblem: Web Solution opens and runs successfully but does not output into Excel
Problems with Excel when Running ReportsProcess for Custom Grouping & Subtotaling of Management Pack TemplatesPrompted for repository path even though it has been entered after installing Sage Intelligence for the first time
Provider Cannot be FoundPurchase Master 2-2 Report not pulling through valuesQUICK GENERATE AND QUICK EDIT MENUS BLANK/MISSING
Quantity is double in the Purchase Master reportQuick Navigating between Report Manager and AdministratorRECEIVING AN ERROR WHEN TRYING TO DO A FRX CONVERSION WITH A LARGE REPORTING TREE
RECEIVING ERROR DURING THE CREATION OF A FILTERRETINC ErrorRETINC MACRO ERROR
Received error Query too complex when try to start Report Manager.Register DLL'sRegistering the Alchemex COM Server
Registration Error 53 File not foundRegistration of the file PATH-FILENAME failed Occurring when Registry Entries have been incorrectly securedRemove Blank Rows in Excel
Removing a Workstation LicenseRenaming a Data ConnectionReport "hangs" or "freezes"
Report Designer AddIn Task Pane missingReport Designer Drilldown report missingReport Designer Layout Generator not including opening balance amount for Actual YTD Column
Report Designer Task Pane Missing or ClosedReport Designer not installedReport Execution Error Pastel Xpress Version 18
Report Utility SVD Error - SI Repository will need to be specifiedReport designer Add-in drill down includes incorrect accounts when using account ranges that contain wild cards in Sage 100 IntelligenceReport designer add-in (RDA) does not recognize characters that are not “-“ used to separate account segments
Report designer not licensed in RDA formula cellsReport manager not launchingReport run keeps prompting to enter SQL database credentials
Report tools add-inReporting Trees Export/Import errorReporting tools no longer working in the add-ins tab
Reporting trees hang when managing or editing in Report Designer Add-inRequest Terminated by service - terminate hanging processRowset does not support fetching backward
Run Time Error '3706':Run a Macro by Clicking a Cell in ExcelRunning Any Sage Auditor Report, Excel Add-ins keep disappearing
Running a Trace on BIC/AlchemexRunning a batch reportRunning a report in Design Mode
Running a report using a SQL Query and receiving an “Out of Memory error”.Running the Purchases Master 4-5, values on the report are excluding discounted amountsSAGE 100 Financial Reports 3-0 report
SAGE 300 WORKSTATION WINDOWS INSTALLER POP-UPSAGE 500 – MANAGEMENT PACK – PERIOD 13 DOES NOT DISPLAY WHEN USING THE CHANGE PERIODSAGE CRM Conflicting with Sage Intelligence Add-in
SALES MASTER 4-5 REPORT IS PULLING THE EXCLUSIVE PRICE NOT INCLUDING 14% AS A TOTAL SALE INCLUSIVE.SAME REPOSITORY SHOWING DIFFERENT REPORTS ON EACH WORKSTATIONSECURITY MANAGER MODULE ERROR
SI5200-T Unable to view all reporting units in Sage IntelligenceSIR Node is missing on the copy companySMTP add-in fails
SQL Deadlock ErrorSQL EXECUTION ERROR-AN ERROR OCCURRED ATTEMPTING TO RETRIEVE LOOKUP DATASQL Execution error Table not found
SQL Joins ExplainedSQL Login failed for userSQL SERVER DOES NOT EXIST OR ACCESS DENIED
SQL statement is not of the type SELECTSQL timeout on ETLSVD CORRUPTION AFTER UPGRADE
SVD Communication toolSage 100 .Net ErrorSage 100 users unable to run any Sage Intelligence reports
Sage 300 Report Shortcut missingSage 300 bulk importSage 500 Report Designer Add-in (RDA): Opening and Closing Balance formulas produced the same result
Sage 50 Canadian changing Account number containersSage Accpac Intelligence:The cube failed to generate.OLE DB error OLE DB or ODBC error.Sage Alchemex Advanced Report Designer Troubleshooting Version 1.0
Sage Alchemex E-Mail Add-InSage ERP X3 - Opening Balances not reporting the simulated yearSage ERP X3 - Retained Earnings not balancing
Sage ERP X3 If 3 dimensions are selected at runtiime, not all correct data is returnedSage ERP X3 Not all site detail is being reportedSage Evoluiton Alphanumeric accounts Error
Sage Intelligence: "Purchases Master 3-2 shows duplicate amounts"Sage Intelligence: "Un-posted invoices reflecting in Sales Master AR 3-6"Sage Intelligence: Budget numbers not showing on french Financial Analysis Report
Sage Intelligence: Budget numbers showing incorrect amountsSage Intelligence: Importing union reports with sub-reports that have different connectionsSage Intelligence: Out of memory
Sage Intelligence: “Dashboard Analysis AR 3-8 does not balance against Sage 300 Trial Balance”Sage Intelligence Reporting (previously Alchemex smart reporting) developer licenseSage Intelligence does not support multiple fiscal years within the same calendar year
Sage Intelligence for X3 Licencing InformationSage Intelligence takes a long time to openSage Intelligent Reporting: Report name does not change on the report list when it has been changed on the report
Sage MAS 500 Automatic Filter of CompanySage Pastel company load is slowSage intelligence reporting for Sage ERP X3 release notes
Sales Analysis report of Sage Intelligence Reporting doesn't reflect the sales revenue amount correctlySales Report in Pastel EvolutionSales master 4-10 is not picking physical address entered on the invoice
Scalable SQL cannot create external index fileScheduled Report Mail Distribution IssueScheduling a Report
Scheduling a Report using the Windows SchedulerSecurity Guide
Serialisation check failedSetting Access Permissions for the BIC Module
Spaces required for multiple account selectionStarting and Stopping Pervasive.SQL Workstation EnginesSteps to add a company in Pastel Partner
Steps to enable cookies on your Web BrowserSteps to find container belonging to a reportSteps to troubleshoot SQL connectivity issues
Suppress Zero Rows of a reportSwitching MetaData SetsSybase System connection
Sybiz – Management Pack D & S 3-6 (SV5) Sybiz – General Ledger Transactions 3-6 (SV5) The management pack reports are not calculating the balance of a foreign bank account in prior months correctly where there have been rate changes in those monthsSyspro - Dashboard Analysis 2-0 YTD Calculation IssuesSystem Variables
TASK PANE DOES NOT APPEAR WHEN RUNNING REPORT DESIGNER ADD-INTHE CONNECTION FOR THE CUBE REPORT HAS NO CUBE FILE SPECIFIEDTHE METADATA FOLDER SPECIFIED IN THE EVOLUTION COMPANY DOES NOT EXIST
THE OUTPUT TEMPLATE FILE IS MISSINGTHE SPECIFIED FILE FORMAT IS NOT KNOWNTIPS ON DEVELOPING A MANAGEMENT PACK
TRIAL BALANCE NOT PULLING THROUGH THE CORRECT YEARTask Pane error HRESULT:0x800A03ECTask Pane is missing in Excel when generating a Report Designer Add-In
Task Pane missing in a Report Designer Add-in report when using Excel 2013 in Sage 100 Intelligence 2013Task pane does not filter companies according to company selector when reports are run out for multiple companiesTask pane does not launch running a Financial Report Designer
Task pane is missing when running the Financial Report Designer add-in 1-1Task pane not displaying in Excel OnlineTenant Cache populating with incorrect drivers repeatedly
Test KB PostThe "?" wildcard returning inaccurate results in reporting tree's (7.4 Core)The Accounts amounts are not matching with the Balance sheet amounts
The Alchemex Library DateDimensionBuilder.dllDate Dimension Creation Toolis not installed or registeredThe BI add-in tool is conflicting with “Solver Add-in” in Excel.The Excel Genie
The FREE Alchemex BI is applicable to Accpac ERP 5.4 and 5.5The Microsoft.Jet.OLEDB.4.0'provider is not registered on the local machineThe SQL statement contains 1 unsupplied Pastel Business Intelligence Centre Variable(s)
The account type “Non-current Assets” does not appear on the balance sheetThe download file PLDONGLE.DLL is emptyThe file alchemexpolicy.exe is not marked for installation
The function MailSMTP failed.The installation package cannot be installed by the windows installer service. You must install the windows service pack that contains a newer version of the windows installer service.The job cost are showing multiple times
The multi-part identifier could not be bound.The required System Variable @TENANT CODE@ must be supplied in the command line parameters to BICORE.exeThe specified database for the consolidation does not exist in the connection cache
The system variable @SYSTEMUSER@ does not work when being used in the expression source of a pass through variable.The task Scheduler does not work on 64Bit office when using the outlook optionThe user runs a report however the Report shows value not specified.
The way the drill-down tool operatesThe “current balance” for balance sheet accounts is brought into the intelligence report incorrectly as zero when it should reflect the ending balance from the last period of the previous year.Timeout error
Top Support IssuesTrial License Expires in 1 Days message showing in Sybiz BIC Report Manager when BIC is licensedTroubleshooting Common Pervasive PSQL Issues
UNABLE TO CONNECT DATA SOURCE NAME NOT FOUND AND NO DEFAULT DRIVER SPECIFIEDUNABLE TO GET THE ADD PROPERTY OF THE WORKBOOK CLASSUNEXPECTED ERROR OBJECT REFERENCE NOT SET TO AN OBJECT
UNEXPECTED ERROR PERMISSION DENIEDUnable to allocate licencesUnable to copy or paste reports in Report Manager Error 52