Browse By Tags

Hello everyone, I am trying to import items into a database. I have exported them into a CSV file within Sage Estimating, but I can not find out where you can import them. I was trying to merge 2 databases with the database editor, but they have different…

Hi! I have searched multiple blogs and sites for this answer (along with the online help center) and can't find a clear document that states which characters are restricted in Imports/Exports per table. I've been told by Consultants that certain characters…

Hello all, SAGE 100 Could Advanced 2020 (V6.20.1.0) I have a VI (Visual Integrator) export job that pulls fields from CI_Items out of SAGE and into a .CSV file. I use Task Manager to automate this export and then another software reads the .CSV files…

I need a Visual Basic routine that would re-format a CSV file from one application to be imported into Sage X3 V11. The application is moving invoice and payment details from one system to another. The basic difference is that the source file has one…

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…

Hi, I am writing a script for a customer to generate bulk CSVs for their Cash Receipts Journal import. They are using Peachtree 2017 (Quantum Accounting). These are sales receipts to be applied to their customer invoices (seen in Receive Money section…

Hello, I am trying to find a solution for my AR for imputing sales transactions manually. We have an Excel order form that has pricing, stock numbers, etc on it that our customers fill out. I am hoping to find a solution for my AR to be able to import…

I would like to import orders into our Sage system although the problem is that this is a very old version of sage 500 V7.2. Could anyone please confirm whether this is possible and whether it is native to the application or whether this would require…

We have been using TS import with TS 20011 both with time and expense templates without. Since converting to TS 2017, some csv files contain "phantom" entries which cannot be seen when the CSV file is opened. The only thing that stands out is when I scroll…

Hello, I need to know the values I should use for "CATEGORY" in time card import sheets,,,,can someone help pleeeease? BR

Hi, Thought I would post this as an FYI that can hopefully be found if someone searches with a similar issue in future. A client accidentally imported the XLSX version of their spreadsheet into CI_Item instead of their CSV. Normally V/I and the business…

I know how to import into AR Receipts in Sage 300. Is there a way where Sage 300 can read single line items per transaction. For example, on the import file, I just want a single line item on the CSV for every cash receipt. Right now, Sage 300 requires…

Hey Everyone, I'm sure this was answered in the past but I can't find the post, maybe someone can help me out. I have Sage 50 2015 Canadian edition, I imported over 16,000 items (yes, 16,000) as we are moving from DacEasy 9.0 to Sage. All my items are…

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 All, We are currently experiencing a bottleneck where our yearly/bi-yearly pricing increase from our 700+ vendors are not being updated in our inventory system effectively. It seems like a very manual process where we receive pricing increase…