Browse By Tags

Dear, I trying to import sale/invoice to SAGE50, but I getting warning message each row, but all row still success import. The reference number "TP24-0304C" is available, but getting warning. The data CSV below: anyone know the problem?

Hello everyone, Are there any differences in importing data into Sage 50 Cloud vs Sage 50 Desktop? Such as General Ledger Journal Entries and Vendor Invoices. Any information or advice would be greatly appreciated. Thank you, all. Mike S.

Hi, Before importing the AP invoice with PO, the Purchase Order # 100 was Received (qty ordered = qty received) and marked as "Waiting on Bill". Let's call this transaction A. I have then successfully imported the AP Invoice# 200 with PO #100 through…

Hi, I have successfully imported an AP invoice with Purchase Order. I have a Purchase Order that is already Received (all qty ordered have been received) and marked it as "Waiting on Bill". When importing the AP invoice (which includes the PO #) I would…

We recently purchased Sage software to manage inventory items. I have a few questions, 1) is a way to upload inventory items from an excel spreadsheet? If yes, could you please send me instructions? Or do we have an email for support? 2) If we are only…

I tried to purge receivables and it froze. I restored and tried a smaller dfata amount and it worked. Now I am trying to purge the payables and it froze several times. After restoring I tried a smaller file size (6 month) and it froze again. What…

I am the treasurer of a none profit and I am trying to export/import data to update an older file 2019-2021 from a newer file so I have all of the data in one place. I export the data from the new file and then import into the older data. I use invoices…

Does anyone import time tickets and have simple instructions for doing so? Rick

Hi all, I keep on encountering the error below while trying to do my database setup on Sage 7.0 Can anyone help with this please? Thank you.

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 am new to Sage 50 and trying to help this small business to import sales order information. I started by identifying the fields that I thought we needed and then I exported that so that I had everything in the right sequence. I don't see a place when…

I am trying to export the component list for parts within Business Works. There is no way to do this through the program, but was told you can do this through a query in excel. Does anyone have experience with this? Can someone provide steps to query…

Hi all, On my Sage 300 v2023 > Database Setup, I have 2 existing System databases for testing, which is PCISYS and SAMSYS below. I wanted to create another 1 but get this error instead. I have run RVSpy & DBSpy but no error visible. Anyone know…

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.

I'm installing Sage 50 Premium in a Convenience Store which has a POS system. This POS system generates a plethora of reports & data, all of which is available in Excel format. The daily sales report it generates would be the feedstock for the SAGE invoicing…

What is the Procedure to import various customer beginning balances when a new company is just set up in Sage 50

Hi, Could someone please share what fields are necessary to do a payment import into Sage 300. It keeps giving me the error that 'Invoice Number Cannot Be Blank' but the IDINVC field in the Applied_payments tab is not blank. Could someone share…

How are these sorted in the "Select Import/Export" screen? I have many saved import and export tasks, and I can't seem to figure out how to organize them and find them quickly in the long list.

If this is not possible what would the best way to accomplish this? I have the Certified Class description i want to assign to the Occupation field on the Master Employee Record, we would like them to match and currently they do not. Thanks V

We are in the process of moving to Arcoro HR and I have been building imports for this. Two of the imports concern pre/post 2020 employee tax info, and some of the data required is Year, Additional Withholding, Filling Status for that year, Exempt or…

Good morning gentlements and ladies, We are a manufacturing company with a homebrew ERP that manages clients and invoices, but Sage50 for our accounting. Discovering the Sage50 SDK, we jumped on the occasion to use the Import feature (by producing…

Is there a way to upload an Inventory List into Sage 50? I have around 70 items that would be a million times easier to upload once, in lieu of keying them in individually. I have searched the Sage Knowledge Database, but cannot find any articles…

How to Migrate company data from Sage 50 Premium 2015 to Sage 300. How do I extract data from .DAT file?

I am going to use an excel file and only need to enter new GL Account numbers and description of the each account. What should I name the 2 columns in the excel spreadsheet so that GL import process will except it? Is there a sample GL Account import…

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 ?