• Restoring MS SQL backup to another database

    MS SQL server 2012, Sage 300 2014 PU 3 I am trying to restore a test database using the most recent backup of its associated production database - in SQL Server Management Studio. I am restoring to another name and that task completes without errors…
  • New Update, No Notification

    I am a Sage Certified Consultant. I subscribe to the announcements forum. I am supposed to have new posting emailed out to me. This did not happen. My customer just received the CP72DSP1 notice by email, but I do not. How do I get back on the Customer…
  • Code Changers don't work after Payroll 7.2 upgrade

    Sage 300 2014 PU4 (also 2012 with PU4) with Payroll 7.2 none of the code change products work, system says 'newer version of Canadian Payroll was detected. XXXXX Code Change must be upgraded!' Is there an upgrade available?????
  • BI Reporting Manager Error

    Hi, i get this error when open BI Report Manager I'm on Sage 2014 PU3 "The function GetDataValue can only service SQL calls that result in a single return value. Please modify the SQL statment accordingly. The SQL statment supplied was : - SELECT…
  • Cashflow Statements

    Is there an example of a Cashflow statement in Intelligence Reporting? I am looking for one and do not see it.
  • Credit Card Payment made with Sage Payment Solutions in Sage 300 to Wrong invoice

    A credit card payment was entered, posted to the correct customer, but to the wrong invoice. Is there a way to fix this. We attempted to reverse the entry, but since it was made with Sage Payment Solutions this was not allowed.
  • Finding Missed Preauth in Order Entry

    When the terms are credit card all orders in order entry should be pre authorized. Is there a way to find orders that should have a pre authorization and do not?
  • OE invoices not showing prepayments

    If I enter an order in OE and enter a prepayment and post the order, when I later invoice the order the prepayment is not shown against the invoice, but only on the right hand side of the invoice totals as an order prepayment. If I enter the prepayment…
  • Sales Analysis - An unexpected error occurred while checking the licensing. Error 1402 AFTER PU3

    After a clean install of PU3 we can't run Sales Analysis. Interesting because in the release notes it states that they've included the fix. So, with the Hotfix described in KB20225 - is it safe to apply it to PU3?
  • Do A/R Invoices have or allow for Kit (Kitting) Items?

    Would like a conclusive answer if Accounts Receivable (A/R Transactions) allow for the use of Kit items with individual components. I know they are available in Order Entry Transactions. Thank you for any/all help!
  • Bank Rec

    We are doing a bank rec and the amount of deposits outstanding is incorrect. When we take a look at the outstanding deposits they are only $13,000, but the report shows $41,000. The outstanding checks are correct. Any ideas?
  • miscellaneous freight charges

    How do I see the activity for miscellaneous freight charges in order entry? The only report I see just lists the set-up information for miscellaneous charges.
  • national account sales report

    How do you create a report to show the sales for a national account if the customer numbers are not contiguous?
  • Intelligence Reporter

    I have attached a screen shot of my Report Manager UI. I am on Sage 300 2014 PU 3. The panels on the screen are mixed up. Has anyone seen this behaviour? Thanks
  • Credit limit check on invoicing for multiple shipments

    Hi The company I work for is using Sage 300 ERP 2014 PU2 Order Entry (OE) with active credit limit on customers. I face a problem when I create an invoice for multiple shipments, as below sample: Credit Limit : 200,000 OE Pending Balance: 150,000 (consist…
  • Sage 300 ERP Portal Errors

    We just turned on the portal for one of my clients and when we attempt to use the inquiry feature to see the OE invoices we get errors for all the criteria. When we select the invoice date, we cannot select a time period because all we get is ERROR.
  • Importing Inventory Records

    When attempting to import inventory records we get an error "Category Cannot Be Blank" We have an entry in the category field. We even updated the inventory record with the value manually and then again attempted to import and we still get the error.…
  • Total by territory

    I have successfully added the territory field to my sales report is Sage Intelligence, but I cannot get the field to total correctly. If I put the field before the customer number it total, but only for each customer. If I place the field to the left…
  • Changing top 5 customers Sales Report

    How do you change the Sage Intelligence Report for the top 5 customers? I may want the top 10 or top 20, or even left the customer enter the number they would like to see.
  • Sage Intelligence Report - Sales by Ship-to State

    I need to total my Sage Intelligence Report by the state of the ship-to address. What table(s) do I need to link to Sales Master 3-0 data container.
  • New Application Object Model (AOM)

    A new Application Object Model (AOM) is available for Sage 300 ERP 2014 product update 3. You can find it in KB 19194: Is there a database schema (Application Object Model) available for Sage 300 ERP .
  • Customer Check applied to wrong invoice

    How do you fix a customer check that has been applied to the wrong invoice.
  • Error When attempting to open Sales Orders in one compnay

    This is the error I receive. View 'OE0520' is not a valid View ID. I went back to my client and did a database dump and load into my system and I still get the error. Any ideas?
  • Sage 300 ERP: What's New - May 2015

    Lots of new updates are available for Sage 300 ERP this month. Check out the latest below. Note: You must login to the Knowledgebase in order to view downloads. Remember, you can drill down to all currently supported downloads from the Sage 300 ERP: Download…
  • Vendor Item Number

    Where is the vendor item number stored for purchase orders?