Sage 50 US

I need to import a general journal report to Sage 50 US edition. The report I am trying to import has debit and credit columns. However, in the Select Import / Export > General Ledger > General Journal the only option is "amount". How do I bring debits…

I am trying to find a way to import from Clover to Sage on a daily basis. Is there an app capable of doing this?

Remove post

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've just upgraded Sage 50 to the 2023 version. Now when I try to Export to Excel, I get the message "An unexpected error occurred while copying your report to Microsoft Excel". I have previously used this feature daily. I have restarted my computer several…

Which version of Sage accounting do I need in order to be able to import journals from text, csv or excel type files? Does Sage50 have that capability? This is only for a small business application, so I'm looking for the minimum version of Sage that…

Hello! We are in the process of building a website solely for our wholesale customers. We need to be able to put in the Quantity Discounts per item/ group of items. How can you export a list of Quantity Discounts including the Minimum Qty for Discount…

We are on Sage 50 We have monthly sales of a few products (non-inventory) with a varying quantity & unit price but same customers & same repeat products. We use job ids in all of our sales orders (this drives our commission reporting). We are looking…

Hi, I'm able to import a sales journal (invoice) when I have Apply to Sales Order as FALSE, but when it's set to TRUE, it receives the import error: This happened on Line Number: 2 with Field Name: Apply To Sales Order. I double-checked that the SO/Proposal…

We updated to Sage 50 2023 this past Thursday. Now we can not import general journal entries. After spending almost 2 hours on the phone with Sage Help Live Chat on Friday, I was told my file was corrupted and to have our third party vendor send the file…

I am trying to import Sales journal from Excel/csv. I can see it cycle through the records, notifying me of errors that are legitimate and need correction. After it seemingly goes through all records, it appears to start over and I get an error that the…

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.

Any idea which of these three (or possibly others?) Sage uses for its exports: Windows-1252 ISO-8859-1 (latin1) ISO-8859-15 (latin9) I know it's not UTF-8 Thanks! Richard

Hi, Could anyone please provide the Account Type number mapping to the descriptions on this page ? Here's the list to make it easier, with my guesses: 10 Accounts Payable 1 Accounts Receivable ? Accumulated Depreciation 24 Expenses 4 Fixed Assets…

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

Is there a way to export customer data from Peachtree DOS 11 into a format that is usable in other windows based accounting programs?

My excel version is Office 2016. When I export data from Sage 50 to excel, there are different date format in the date column (as below image, different date format for 12/4/2022 and 14-4-2022). It is difficult to use Excel Power Query to do some analysis…

I'm trying to import an invoice into Sage and I keep getting the same error message. Does anyone have any ideas ? Here is the CSV file I'm importing. The 'Number of Distribution is the column with 6 in it.

There is a field for Sales rep ID in the maintain import/export screen for sales journal, however when I upload the data it does not change. I cannot figure this out, can anyone help?

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.

Is there a way to specify a relative path for imports/exports? If not, there should be, it would make it much easier for multiple users to use the same import task.

Is it possible to add line items to existing Purchase Orders through Sage 50 Accounting Software's built in import tool? I can import multiple line items upon the initial upload but I cannot seem to figure out a way to add a line item to existing POs…

Does anyone have any suggestions on what to do if I am trying to import a journal entry that has multiple dates in it. We just started with Sage 50 Premium Acctg and I thought I used the correct template to import one large entry for the entire year's…

We have used Sage50 Quantum (and its predecessors) for many years. In the item data, we have uploaded .pdf attachments of customer signed drawings that we need to release to vendors when placing purchase orders, as well as sometimes notes. We have around…

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…