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…

I can import new Sales Orders however is it possible to leverage the import function to update existing sales orders? If so, where can I find information on how to accomplish? Any insight would be greatly appreciated!

Hello all, Our company is currently running Sage X3 and we are looking to build a small B2B WooCommerce website for about 30 products for our customers to purchase through. Woocommerce, with the help of some plug ins, can generate spreadsheets/csv's in…

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 attempting to import sales orders where the ship-to address is not already defined in the customer record. I added the following fields to the standard SOH import template: BPDADDLIG, ADDLIN2, BPDCTY, BPDSAT, BPDPOSCOD, BPDCRY. I expected that the…

Merged over 3,300 items to code "Z_Discontinued" after months of working with staff to make sure all items on list were approved for merging. Now they need 2 of the 3,300 items restored, historical data. I created the original item numbers and setup…

Hi, I have been trying to import new or exisiting sales order into SalesOrderHeader. However, when importing. i get these errors. it seems creating the new SO was fine. the only problem right now is the LotSerialNo.

We are considering using a 3PL company pick, pack, and ship some of our orders. The 3 PL would download the orders from us on a daily basis and each day send back a file with information on all the orders they shipped. This file would contain the line…

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…

Has anyone had experience importing data into Sales Order Entry for a credit card order that has already been pre-authorized outside of Sage 100 ERP? In particular, we're working with Sage 100 ERP Advanced 2013 PU3 and an online store that uses a third…

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…

Hello, Everyone has been so helpful in the past, I thought I would ask about another issue I am having. While trying to delete some items through the "Delete and Change Items" Module I receive the following Error Message for each of the items…

Hello, I am still having an issue with imported product item numbers being skipped. I do not know what could be causing this as I have successfully imported 250,000+ items with the same number scenarios. Has anyone else had this issue and if so, how…