Sage 300

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

We have a client running 200 2021 with Product update 1. On the machine that is the main one (server), they get the above message when posting a combine Vendor request using Vendor Number Change. Anyone have any sugeestions as to how to proceed.

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

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…

Hi When I imported one transaction to see how reconciliation works, i got the below error. It says 1 updated but It does not reconcile that transaction, please could someone throw some light ?

Hi, I want to import bank statements into Sage 300 - I am not sure what the below fields do and what their exact column name would be for my import file. Could someone please help ? Cleared Y/N - Integer (Column Name ?) Used Y/N - Boolean (Column…

We care trying to copy the production database to a new test database and receive a database error (ec=60256). Has anyone seen this error and how do we resolve. Thanks,

We are working with a company using Sage 300 on a Pervasive SQL database. They are interested in exporting data such as GL, AR, and AP transactions and other table information, such as accounts, customers, and vendors. I'd like to know if there are…

My debits and credits equal but the GL total is out of balance and showing !!. Will File Doctor solve this?

I installed Sage 300-2019. I could not load my dumped files from sage 300- 2017. I received the following error: The company you are trying to open uses a later version of Sage 300 than its related system database uses. You must restore your system data…

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

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…

We are implementing Sage 300 ERP on premises. Due to current situation, implementation taking longer than planned. The simple question is, how can we migrate current FY data back to January from our legacy Peachtree Quantum system to sage 300? Comments…

I have just upgraded my client who has 3 databases on the server and I am having a problem with 1 of them. After activating Sales Analysis and OpsInquiry, I receive an error: Load of System Manager roto events. Load of System Manager roto events…

Dear, I am facing a problem in sage 300, I already have two companies in sage 300, but when I open a new company one old one company disconnected from data base, now my old company doesn't show any thing, kindly advise me ANY BODY HERE TO HELP OUT MY…

Dear, I am facing a problem in sage 300, I already have two companies in sage 300, but when I open a new company one old one company disconnected from data base, now my old company doesn't show any thing, but in sql server all data is avail able. kindly…

What is the correct method of permanently removing a company from Sage 300? I found the "Database Setup" utility, where it appears I could delete the two databases (data and system) associated with the company. Is that the "right" way? If yes, does…

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…

Hello, we are trying to set up a development environment for Sage300. The version of Sage300 for production use is 2020. On our development server, we are using Sage300 2019. We dumped the company database from our Sage300 2020 and restored it to our…

I have a client that is planning on changing banks. The problem is that they have over 1000 credit cards saved. They are using PAYA, but the problem is that in Sage 300 the credit card is associated with a bank. I have been told that when they change…

Hi Team, Doing an installation set up. Can I restore a sage 300 ERP backup from premium version environment into a standard version environment. comparing the variance in the version...........

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…

Looking for someone who knows their SQL tables here. How can I use SQL to identify the active fiscal period? I see the CSFSC table but what is the best way to determine which fiscal period start date to use? Looking at BGNDATE1, BGNDATE2, BGNDATE3,…

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…

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…