x Want to participate? Join the group to interact

  • BIC V10 Inventory Master

    Good day Hope you can assist. I have an issue since upgrade to V10 when running BIC Inventory Master or any customized report dependent on this report, it gives error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'Bin'. …

  • HOW TO USE SAGE INTELLIGENCE SQL EXPRESSION

    Hi I am crating a BIC Report I would like to pass an IF function using the SQL expression option using the InvNum when I create it as showed below I get an SQL Syntax error SELECT IF (InvTotExcl >InvTotIncl ,InvTotExcl *-1 , InvTotExcl ); Kindly…

  • There are a few points discussion: 3 part invoice, effects on the BIC report, as well as the calculations fields don't make sense

    When running the sales master report (Even on the latest version after contacting support) 1. If I issue and invoice a client, I can see the sales figure correctly as well as the quantity. But when I invoice first or vice versa, when I run the intelligence…

  • SIR Macro Error - Automation Error Catastrophic Failure

    Hi All I am experiencing an issue when running reports with Macros. The first report with a macro runs successfully but any subsequent report with a macro gives us the Automation Error - Catastrophic Failure. We have tested the following: 1…

*Community Hub is the new name for Sage City