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)
Evolution Branch CodeExcel 2003 missing Add- insExcel 2007 Specifications PivotTable Report Specifications
Excel 2007 Split contents in cells of excel worksheetsExcel 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 Manager
Export failed due to unexpected error.The error was Compress.exe errorExternal content links on home page in reports are brokenFINALISERETINC FAILED ERROR
FRX Conversion ErrorFRX tree conversion assistant, Error: Object reference not set to an instance of an objectFinaliseRETINC () Error during generation of a report
Financial Genie CurrentYTD does not print the YTD values for period 1Financial Report Designer 1-1 does not balance to the ERP Report.Financial Report Designer does not use the financial categories instead it uses account numbers
Financial Report Designer hangs at Naming Ranges and Excel does not respondFirst Instruction only sent on scheduled reportFiscal Year data missing from the Fianancial Report Designer
Fiscal period does not show correctlyFormulas removed when distributing Report Designer Add-In ReportGENIE REPORT DOES NOT GENERATE CORRECTLY
GL Accounts not showing on Management Pack S 4-6GL Detail in Intelligence ReportGeneric (All Databases) Pre-installation Requirements
Genie not licencedGet error when using 64Bit office for distributionHOW TO CHANGE YOUR PERVASIVE DATABASE CONNECTION PATH
HOW TO CREATE A SYSTEM DSN WITH ORACLEHOW 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 PROFESSIONAL
HRESULT error on Windows 8Hide Zero Rows MacroHiding and Showing Reports
History of the reportHotfix for Sage 300 v5.5 Licencing issue in Terminal Server EnvironmentHotkey for "Run as administrator" Windows Vista, 7, 2008
How Evolution BIC Web Reporting differs from Evolution BIC from a Connection PerspectiveHow 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 7How to: Disable User Account Control (UAC) in Windows VistaHow to: Run Alchemex as an Administrator
How to: Understanding Windows Vista User Account Control (UAC) and File VirtualizationHow to Change the Decimal Place in Cells in Microsoft Excel 2003How to Lock Individual Cells in a Worksheet in Excel
How to Run a Program as an Administrator in Windows 7How to Serialise AlchemexHow to Use Excel's CountBlank Function
How to Use Your Excel Add-In Functions in VBAHow to add a data container based on a stored sql procedureHow to change a report connection
How to change a report to use a different containerHow to change your MetaData pathHow to clear additional ranges
How to create a 32 bit ODBC driver on a 64 bit machineHow to create a PICKLISTHow to create a basic task scheduler in Windows 7
How to create a task scheduler with windows server 2012How to increase Report Parameter when limited to 2000 rowsHow to increase timeout on container
How to manually add a licenceHow to protect the output bookHow to register ALWrapper and ALDBConvert
How to reset admin password in Sage 100 Intelligence Security ManagerHow 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 Windows
How to use Windows Scheduler to schedule reports in Sage 100 IntelligenceHow 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 BOUNDS
ISSUE: Alchemex FA Error for Microsoft Office 64 BitIf 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 query
Import Failed Syntax error(missing operator)Importing and exporting reportsIncorrect values on Sales Master 4-5
Information for expenses starting with April are not correctInitialization of the data source failed. Check the database server or contact your database administrator.Installation Guide - Financial Reporting for Sage ERP X3
Installing 32-bit ODBC Drivers for BtrieveInstalling AlchemexInstructions for moving SMI 4.4 to a different location after Performance Patch has been applied
Intelligence DrillDown does not work on Accounts with maskingIntelligence Reporting-shows blank data of the dashboard reportsInternal Error 2753. F7673 PLASOCFILE.EXE
Invalid Object NameInvalid Procedure call or argumentInvalid procedure call or argument error
Invoice Date field missing in pivot tableInvoice 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 componentIt 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 onlyItem 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 reportLocking/Unlocking a ReportLocking and Unlocking a report
Logon has been disabled by your VARMANAGE OBJECT SCOPE COMPANY IDMULTI – STEP OPERATION GENERATED ERRORS
Macros called from an Alchemex report that has string parameters that include the comma character fail.Main PageManagement Pack 13th period missing
Management Pack ConsolidationManagement pack report Not Showing Actual, Budget and Variance TitlesManual steps for the report drill down functionality within the Management Pack
MapAccountCategories failedMapping is requested every time Report is run out even after creating and linking reportMetabase Version Relevance when Exporting Reports
Metadata Repository (SVD) issuesMicrosoft Excels Dynamic Array Function update breaks Sage Intelligence ReportingMicrosoft ODBC Driver Manager Data source name not found and no default driver specified
Microsoft 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 issues
Missing BIgenerator and PLdrill on terminal serverMissing Resource Automation error Library not registeredMove your Alchemex install
Moving Alchemex.svd file and Templates folder from one server to anotherMoving licencingMultiple-step operation generated errors. Check each status value
Multiple-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 workstation
My Sales Analysis report is not pulling cost for assembly line itemsN functionNamed Ranges in Excel
New Addedd columns not pulling through in Pivot Table fields in Sales Master ReportNew Twist on SQL Server does not exist or access denied.Newer version of PLPLUGB.DLL on earlier version of the core software
Not a valid Win32 Application errorNot recognizing some files with XLT formats after upgrading to Excel 2007Not wanting to create a Pivot from your raw data
ODBC Connection for Pervasive.SQL 2000/2000iOUTPUT TEMPLATE FILE ERRORObject reference not set to an instance of an object
Object reference not set to an instance of an object.Office 365 hangingOnly 3 Tabs showing on Report properties
Opening balance not showing on Financials Report in Sage 100 ERP Intelligence report if the ending balance of the period is zeroOutgoing mail server does not exist or cannot be reachedOverriding Workstation Login Mode
PERVASIVE ODBC CLIENT INTERFACE ERROR-THE SPECIFIED FILENAME IS INVALIDPLSupport.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-INPaste method of worksheet class failedPastel Auditor journal export to Pastel Evolution does not export contra account adjustments
Pastel 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 layout
Pastel Partner – All Sales related TemplatesPayroll summary report does not match detail reportPerformance Issues Sage 50US V2020
Permission rights to AlchemexPervasive 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 errorPicklistM does not return correct paramaters listingPicklist Functionality
Pivot Table LayoutPivot table graphs losing all colours in Excel 2007.Power View report does not refresh automatically
Problem: 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 requests
Problem: Web Solution opens and runs successfully but does not output into ExcelProblems with Excel when Running ReportsProcess for Custom Grouping & Subtotaling of Management Pack Templates
Prompted for repository path even though it has been entered after installing Sage Intelligence for the first timeProvider Cannot be FoundPurchase Master 2-2 Report not pulling through values
QUICK GENERATE AND QUICK EDIT MENUS BLANK/MISSINGQuantity is double in the Purchase Master reportQuick Navigating between Report Manager and Administrator
RECEIVING AN ERROR WHEN TRYING TO DO A FRX CONVERSION WITH A LARGE REPORTING TREERECEIVING ERROR DURING THE CREATION OF A FILTERRETINC Error
RETINC MACRO ERRORReceived error Query too complex when try to start Report Manager.Register DLL's
Registering the Alchemex COM ServerRegistration Error 53 File not foundRegistration of the file PATH-FILENAME failed Occurring when Registry Entries have been incorrectly secured
Remove Blank Rows in ExcelRemoving a Workstation LicenseRenaming a Data Connection
Report "hangs" or "freezes"Report Designer AddIn Task Pane missingReport Designer Drilldown report missing
Report Designer Layout Generator not including opening balance amount for Actual YTD ColumnReport Designer Task Pane Missing or ClosedReport Designer not installed
Report Execution Error Pastel Xpress Version 18Report 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 Intelligence
Report designer add-in (RDA) does not recognize characters that are not “-“ used to separate account segmentsReport designer not licensed in RDA formula cellsReport manager not launching
Report run keeps prompting to enter SQL database credentialsReport tools add-inReporting Trees Export/Import error
Reporting tools no longer working in the add-ins tabReporting trees hang when managing or editing in Report Designer Add-inRequest Terminated by service - terminate hanging process
Rowset does not support fetching backwardRun Time Error '3706':Run a Macro by Clicking a Cell in Excel
Running Any Sage Auditor Report, Excel Add-ins keep disappearingRunning a Trace on BIC/AlchemexRunning a batch report
Running a report in Design ModeRunning 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 amounts
SAGE 100 Financial Reports 3-0 reportSAGE 300 WORKSTATION WINDOWS INSTALLER POP-UPSAGE 500 – MANAGEMENT PACK – PERIOD 13 DOES NOT DISPLAY WHEN USING THE CHANGE PERIOD
SAGE CRM Conflicting with Sage Intelligence Add-inSALES MASTER 4-5 REPORT IS PULLING THE EXCLUSIVE PRICE NOT INCLUDING 14% AS A TOTAL SALE INCLUSIVE.SAME REPOSITORY SHOWING DIFFERENT REPORTS ON EACH WORKSTATION
SECURITY MANAGER MODULE ERRORSI5200-T Unable to view all reporting units in Sage IntelligenceSIR Node is missing on the copy company
SMTP add-in failsSQL Deadlock ErrorSQL EXECUTION ERROR-AN ERROR OCCURRED ATTEMPTING TO RETRIEVE LOOKUP DATA
SQL Execution error Table not foundSQL Joins ExplainedSQL Login failed for user
SQL SERVER DOES NOT EXIST OR ACCESS DENIEDSQL statement is not of the type SELECTSQL timeout on ETL
SVD CORRUPTION AFTER UPGRADESVD Communication toolSage 100 .Net Error
Sage 100 users unable to run any Sage Intelligence reportsSage 300 Report Shortcut missingSage 300 bulk import
Sage 500 Report Designer Add-in (RDA): Opening and Closing Balance formulas produced the same resultSage 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.0Sage Alchemex E-Mail Add-InSage ERP X3 - Opening Balances not reporting the simulated year
Sage ERP X3 - Retained Earnings not balancingSage ERP X3 If 3 dimensions are selected at runtiime, not all correct data is returnedSage ERP X3 Not all site detail is being reported
Sage Evoluiton Alphanumeric accounts ErrorSage 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 ReportSage Intelligence: Budget numbers showing incorrect amountsSage Intelligence: Importing union reports with sub-reports that have different connections
Sage Intelligence: Out of memorySage Intelligence: “Dashboard Analysis AR 3-8 does not balance against Sage 300 Trial Balance”Sage Intelligence Reporting (previously Alchemex smart reporting) developer license
Sage Intelligence does not support multiple fiscal years within the same calendar yearSage Intelligence for X3 Licencing InformationSage Intelligence takes a long time to open
Sage Intelligent Reporting: Report name does not change on the report list when it has been changed on the reportSage MAS 500 Automatic Filter of CompanySage Pastel company load is slow
Sage intelligence reporting for Sage ERP X3 release notesSales Analysis report of Sage Intelligence Reporting doesn't reflect the sales revenue amount correctlySales Report in Pastel Evolution
Sales master 4-10 is not picking physical address entered on the invoiceScalable SQL cannot create external index fileScheduled Report Mail Distribution Issue
Scheduling a ReportScheduling a Report using the Windows SchedulerSecurity Guide
Serialisation check failed
Setting Access Permissions for the BIC ModuleSpaces required for multiple account selectionStarting and Stopping Pervasive.SQL Workstation Engines
Steps to add a company in Pastel PartnerSteps to enable cookies on your Web BrowserSteps to find container belonging to a report
Steps to troubleshoot SQL connectivity issuesSuppress Zero Rows of a reportSwitching MetaData Sets
Sybase System connectionSybiz – 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 Issues
System VariablesTASK PANE DOES NOT APPEAR WHEN RUNNING REPORT DESIGNER ADD-INTHE CONNECTION FOR THE CUBE REPORT HAS NO CUBE FILE SPECIFIED
THE METADATA FOLDER SPECIFIED IN THE EVOLUTION COMPANY DOES NOT EXISTTHE OUTPUT TEMPLATE FILE IS MISSINGTHE SPECIFIED FILE FORMAT IS NOT KNOWN
TIPS ON DEVELOPING A MANAGEMENT PACKTRIAL BALANCE NOT PULLING THROUGH THE CORRECT YEARTask Pane error HRESULT:0x800A03EC
Task Pane is missing in Excel when generating a Report Designer Add-InTask 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 companies
Task pane does not launch running a Financial Report DesignerTask pane is missing when running the Financial Report Designer add-in 1-1Task pane not displaying in Excel Online
Tenant Cache populating with incorrect drivers repeatedlyTest KB PostThe "?" wildcard returning inaccurate results in reporting tree's (7.4 Core)
The Accounts amounts are not matching with the Balance sheet amountsThe 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 GenieThe 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 machine
The 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 empty
The file alchemexpolicy.exe is not marked for installationThe 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 timesThe multi-part identifier could not be bound.The required System Variable @TENANT CODE@ must be supplied in the command line parameters to BICORE.exe
The specified database for the consolidation does not exist in the connection cacheThe 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 option
The 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 errorTop Support IssuesTrial License Expires in 1 Days message showing in Sybiz BIC Report Manager when BIC is licensed
Troubleshooting Common Pervasive PSQL IssuesUNABLE TO CONNECT DATA SOURCE NAME NOT FOUND AND NO DEFAULT DRIVER SPECIFIEDUNABLE TO GET THE ADD PROPERTY OF THE WORKBOOK CLASS
UNEXPECTED ERROR OBJECT REFERENCE NOT SET TO AN OBJECTUNEXPECTED ERROR PERMISSION DENIEDUnable to allocate licences