• How To Export a Single Transfer in Inventory Control and Re-Import Using different Items

    I have been trying to transfer items from one location to another but every time I try, I receive an error with the importation. What I did was try to export a single transfer, however, it exported everything even the ones that are posted from way…
  • PORCP1headerFields.FieldByName("RCPHSEQ").SetValue("0", false) || Returns "Object reference not set to an instance of an object"

    Good day, Please assist, I have C# code to export data from my local DB to Sage. When inserting invoice headers I get "Object reference not set to an instance of an object" I am fairly new to project and Never worked on sage before. I have a very…
  • Sage 300 2014/2018 with Microsoft Excel 2010 32 bit

    Is there a work around or fix available for FR Reporter not working or playing up for sage 2014/2018 versions with Excel 32 bit office 2010. Get the error below when executing reports "PrintReport: Error on opening the xla macro. Have received…
  • Importing «Receipt» data from external...

    We have «Sage 300 ERP AccPac v2014». We export IBM Notes data in XML to TransAcc module. I must modify le doctype for actual data, they are considered as «Prepayment», and I must change doctype for «Receipt». Here the sample of data: [code]<?xml version…
  • Sage 2012 (v6.2) with SQL Client Native 11?

    Hi, We are installing a Sage client in a new machine as user change its PC but when trying to set up ODBCs we dont found Native 10 that is installed in old machines. Just Native 11. Any problem? Not at all? Thank you
  • Current fiscal period for a company in database?

    Can someone please tell me what table/column will give me the current fiscal period for a company?
  • User Creation Date and License Type Fields in Sage 300 2014 Database

    Hello, I was hoping someone might be able to assist me. I am trying to create a report using the Sage 300 2014 database. I need to see the date that a user was created in the system and also need to know what type of license the user is assigned to…
  • POPORH2 table - 2014 PU4

    Greetings! In the data dictionary, for the above table, I see an 'ENTEREDBY' field; when I open POPOR04.rpt to try and modify it to include the 'ENTEREDBY' field in the report, I do not see this field in the POPORH2 table in Database Fields panel of…
  • Migration from PFW to Sage 300 ERP

    Hi there, We are migrating from Sage PFW to Sage 300 ERP 2014 and when processing the Sage ERP Migration Application the following error occurred: “SemMain has stopped working” -We uninstalled and reinstalled the program -Ran the program as an…
  • loading data error

    Hi, We are using Sage 2014 and We have the following error message when we load data ( error=856, native code=476485). any clues? thanks
  • Data Integrity Check

    Hi, We ran the Data Integrity Check and we have the following error message:"E: Database XXDAT uses an application CS that is not installed. 1 Error found in Administrative Services. Any ideas?
  • T4a E-filing in Sage 300 Canadian Payroll. How to specify which box for Other

    One of my clients issues T4a's for student allowances. The allowances are coded as T4a other in the earning setup and when we print the hard copy it we can tick on Other information, Print Totals and we can specify the box 105. However, when we went to…
  • error GL Batch list UI failure

    Hi, We are on Sage 2014/ OS Windows Server 2008 Service Pack 1 we are using Workstation Setup and when running G/L transactions the following error occurred: [G/L Batch List] Closing the UI due to failure to activate Sage 300 ERP data sources. And…
  • Sage 300 ASP pages do display properly in CRM V7.3

    Sage 300 V2014 / CRM V7.3b / WIn 2012 R2 / SQL V2014 / IE V11 / - I am just testing an upgrade of S300 & CRM to the above versions on my test server for a client. - I have everything working fine except for the Sage 300 .ASP pages - when I open…
  • 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…
  • 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?????
  • Re: Reconciliation the Clearing Account

    Hello, i am reconciling the clearing account. that means warehouse receipt & invoices posted to close the year-end. I export a report from Payable clearing audit and found a lot of non-matched invoices with receipts and it is very difficult to get the…
  • (error = 39024, native code = -267086253) message

    Hi Everyone, I am trying to upgrade from Sage 5.6A to Sage 300 ERP 2014. I've done a DBDUMP from Accpac 5.6 Pervasive Database and DBLOAD to MSSQL 2012. During the DBLOAD, I get the following message. Any ideas? Thanks
  • (error = 3924, native code = -267086253) message

    Hi Everyone, I am trying to upgrade from Sage 5.6A to Sage 300 ERP 2014. I've done a DBDUMP from Accpac 5.6 Pervasive Database and DBLOAD to MSSQL 2012 and get the following message. Any ideas?