x Want to participate? Join the group to interact

  • 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…

  • Exporting GL transactions gives error "External table is not in expected format"

    We have Sage 300 2020 running on a Windows RDS server with multiple users accessing the application via RemoteApp programs. Everything has been running fine for a couple of years but randomly last month our users cannot export files any more. A user…

  • Failed to import the ActiveX control. Please ensure it is properly registered.

    Hi all, We are having an issue while adding a SAGE300 component into a Visual Studio form (.NET project). The error we received is: Failed to import the ActiveX control. Please ensure it is properly registered. We have registered the accpacic1500…

  • Database dump fail

    Hi there, I am trying to perform Database Dump but always get the following error message. Then, if I perform database verification, it returns this. Could I know how to fix this issue to be able to dump database? Thank you!

  • Database error (operation=REV-POST, error=229)

    We are using AccPacc to work with Sage 300. When we call View.Insert the error message appeared: ------------------------------------------------------------------------ Timecard Detail. Database error (operation=REV-POST, error=229) ------…

  • APPS or module for sage 300 to import price list from my vendor in bulk

    Hi I'm looking for an apps or module to go with sage 300 that could make my life easier when I need to update bulk pricing from my vendor thanks

  • CREDIT NOTE IMPORT requiring credit note number?

    Is there a way to import an OE credit note without specifying the CRDNUMBER? I'd like the system to assign the next available number so I'm not duplicating and causing an issue with a manually entered one. When trying to import I'm getting an error: …

  • Cannot export customers

    I have a client, where for a couple of companies, I cannot export the customer or ship-to records. When I attempt to export my customers, the screen that shows the records, the first record should be customers, but it only shows a "-". If I look at attempting…

  • Importing Transactions into Project and Job Costing

    Hi, I am getting the below error message when i try and Import transactions into Costs under the PJC transactions. The Error mentions PM0420 which either has to do with Document Number or Line Number, but I am not able to resolve this error - Could…

  • spreadsheet to accpac

    hello, it is possible to enter 150-200 different item #’s into an excel spreadsheet and then import that to ACCPAC? instead of creating an item one by one in the inventory item? thanks eb

  • Vendors Single File CSV import with multiple contacts activated

    Hi all, Have a customer that imports new vendors monthly with a Single CSV file created from another system. When I try to import after upgrading there is a new table for Vendor_Contact_Selection because multiple contacts have been activated. The Status…

  • Sage 300 Budget Macro and Excel

    I've been working on a new budget for 2020, and started out using the Sage 300 macro to export the previous year's budget to Excel. I've kept the column layout and titles the same, and filled in the new numbers for the 2020 budget. Used the export macro…

  • G/L Inquiry with Income Statement Year End Income Statement Amounts

    FormerMember
    FormerMember
    Hello, I am trying to export the 2016/2017/2018 year end income statement accounts and amounts to excel. I cannot find which column definition displays this information. Every column definition I have tried does not tie out with the actual income statement…

  • Does anyone have a template for importing PM miscellaneous charges?

    I'm looking for a template, so that I don't have to start from scratch, that will import PM miscellaneous charges. I have the format information and I've asked the help desk if there was a template available, like there is for clearing checks, but there…

  • Sage 300 journal entry import

    Hi I have not seen any real postings on journal entry importing (sounds basic) except the original knowledge base how to videos. I think something has recently changed, as I was able to have .xlsm files (yes, I had customized my templates and included…

  • 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

  • A/R Import Template Sage 300

    I am looking for a template to import Accounts Receivable credit notes. It would be helpful if I also know what can be populated automatically by Sage 300 and which fields are essential to the import file. Thanks

  • Cannot export from sage 300 2014 to excel results in MDAC error.

    i have not seen this in years any problem with MDAC. when printing report to preview and then export no issue but trying to do any import/Export out of Sage say MDAC need to be installed and activated. Any idea where to start looking. Database MS…

*Community Hub is the new name for Sage City