Browse By Tags

We are on Sage 100 Advanced v2022.1 and I don't see anywhere a Sales Forecasting report or option to enter numbers or imported via VI. We have a new Sales Executive and he wants me to import sales forecast numbers, by Customer and Item to produce a…

What is the best way to export then import Quotes, Invoices, and PO's? I looked in the Import/Export menu but could not find anything corresponding to these three categories.

Hi all and glad to be here. I am using Sage50 to keep track of accounting that needs to be imported using QB CSV files. I don't know if there is an easier way but I finally resorted to exporting Sage files to then populate using the QB data (hopefully…

Need to import a Timeslips 2007 database into newly installed Timeslips 2020. Do not need much of the old data, but do need last several years of data. Is there a way to export the 2007 data and edit it before importing it to 2020?

I am trying to import an employees name, check #, account, amount , and pay pate into the payroll journal. I set it up in the correct mmddyy format, I created a csv file, I select ONLY the columns that I need, but I get errors for missing info like…

Has anyone successfully imported assemblies? I was attempting to rebuild our company, but when I try to import the assembly data exported, the first row in each assembly fails due to an error in the quantity built column. When reviewing similar questions…

I am trying to get a csv file to import into the payroll using Sage 50 Accounting, and I was wondering if it will still work if I leave the un-required fields--such as, Employee First Name, Check Number, etc--blank and filled in the required fields? …

We are returning to Sage 50 after not using the program for a couple years. We had a lot of corruption in our old Company file so we started from scratch on the new one. My question is if I have customers and vendors lists in CVS format, if those lists…

when importing sales to the sales journal the amounts are not going in correctly. Debits are Credits and vise versa. We are in 2016 version.

One of my clients receives payment from one source for MULTIPLE clients (50+) at a time. I am stuck now. None of the distribution lines are appearing, the full "sales" amount is being applied as Sales Tax, rather than the distribution. Customer…

Here is the field description for the "unit cost" field: Numeric (Real) - Unit cost for the line of distribution; it gets ignored for negative inventory adjustments, but gets used for positive inventory adjustments. ( Note: If this field is not included…

I have a correctly formatted .csv file to import the general journal from a Quickbooks export, into Sage Line 50. The import starts correctly, but fails at line 50 with a Date error. The date is 01/13/17 - it appears that Sage will not accept any date…

I import journal entries (JE) into the General Ledger module, some of which affect cash accounts. However, they do not depict on the Cash Account Register in the Cash Management module. I have to manually re-enter the JEs via the "Enter Bank Transaction…

Hi All, I have performed an OE import successfully in most of the cases. However, I have encountered the captioned error for some items at zero stock level at the moment which could be imported as OE successfully for one OE, but not the others at different…

Is it possible to use the SDK to import employee pay into Sage? I'm thinking it would need to be able to create paychecks but if anyone knows of a better way for employee pay please let me know. I know you can import employees but I want to take all their…

Hi, I'm trying to work through the C# sample project in the Sage 50 Accounting SDK (Simply) but for some reason I can't get the opendatabase connection to let me access the database. I have set up my user in the Sage app and I know my username and password…

I am a new user of Sage 50. I am trying to figure out how to create Purchase Orders or Sales Orders in Sage 50 via uploading an excel file (or CSV). Any help would be appreciated.

How do i export sales /purchase order out of sage 50 US edition? I have done this with sage 100 using visual integrator and i am in need to do that with sage 50.

Can anyone offer any sample SQL scripts for getting information, such as Customer Information (given a customer ID), sales order information (given a sales order number or customer ID), and/or inventory information (given an Item ID) out of the database…

I am struggling with importing the preferred vendor field in IC Vendor Details, even when I export and force the field to Yes (Check box) on re-import it still does not update the required field. When I check the ICITMV table that field does not even…

Est-ce qu'il est possible d'exporter les informations de l'onglet Débit pré-autorisé de SAGE 50 vers EFT 2015? La connexion avec la compagnie se fait correctement pour les clients; fournisseurs et employés. SAUF que l'information du compte bancaire…

I would like to have a list of all email address associated with every account, but I am not aware of a method to do this.

I'm wanting to add about 600 items to an already existing list of products in our datasbase. So, I exported 3 lists: I opened I/C “Items”. I created a script that would contain all the columns we use in that first tab (of the Items Module), and the…

Hello, Is there a way to import Vendor Price lists from excel so that the prices are updated for existing products and so that new products are added into inventory? Thanks, Dave

Hello, would like some help/advice. We uploaded a vendor selling price file into BV and there were about 8000 parts. We later found out we only use 1000 of the parts therefore the system updated 7000 additional parts. Is there an easy way to delete…