• where can I find the file for my saved import field choices?

    I want to copy my saved templates for import to another company - can you tell me where the files are.
  • Export / Import Help

    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.
  • Sage 50 Purchase Order Journal Import Question

    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…
  • Account Reconciliation import

    I am trying to figure out this bank reconciliation process in Sage. I'm coming from Xero so I think I am having a hard time due to having the old systems' process stuck in my head. When importing a bank statement, Sage attempts to 'Autoclear' records…
  • Importing CSV

    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…
  • Import Unit Cost for Inventory Adjustments with the COM API

    I'm trying to import the Unit Cost field among others for Inventory adjustments via the COM Interface. For some reason this one field likes to remain at 0.00 even when making a positive adjustment with a value greater than 0.00. Here is an example of…
  • Account assignment to imported bank statement file

    How do I assignment accounts to imported bank transactions?
  • Import error message

    Does anyone else get error messages when they import cash receipts? I have been using the same template for years, and now I get an error message
  • Time TIcket imports

    Hello everyone, I have started using time ticket imports, and had a question concerning annual and sick time. We are using the, "Duration," field to keep track of employee's time, but at the moment, I am having to manually go through and look up their…
  • import into payroll journal

    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…
  • Importing Assembly Data

    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…
  • Can the un-required fields in an import be left blank?

    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? …
  • Importing Customers/ Vendors from CSV

    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…
  • Import of sales is reversing debit and credit amounts?

    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.
  • Payment from one source for MULTIPLE clients (50+) at a time

    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…
  • IMPORT TEMPLATE FOR GENERAL.CSV

    don't understand how to fill in the "Transaction Number" in the import template for GENERAL.CSV
  • Sage new build 26.2.0.0 has an issue with COM APIs

    Hi All, I am facing an issue with the login programmatically (Interop COM DLLs) with new version 2019, build 26.2.0.0. of Sage 50 US. Is anyone also facing the same issue? Is there anyone has any idea to solve the issue? Please advice, It's urgent…
  • Allow User to Import AR Invoices without a Due Date

    Submitting request on behalf of a customer: Please allow users to import AR Invoices without due dates. Currently the Due Date is a required field and the only workaround for importing is to add an additional column to the imported file with duplicate…
  • COM API - New build issue.

    Hi All, I am trying to connect the Sage 50 US COM APIs 2019 - version 26. when I run my program which is written in the C#.Net is giving the below error. Creating an instance of the COM component with CLSID {49073E6E-C47A-41DD-BF5A-01184439577C…
  • Inventory Adjustments Journal Field Import descriptions are incorrect

    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…
  • Importing a journal.csv file into Sage.

    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…
  • Update records throw sage 50 U.S Edition 2013 Application

    Hi, I am using sage 50 U.S Edition 2013 version. How can update records in sage 50 Accounting Software?
  • Automating/simplifying labor distributions for salaried employees

    All right. This is gonna be a long one, so bear with me here. Let me start by establishing that my background is mostly technical. I have very little accounting knowledge. I have a non-profit customer that works with several different funds. Their accounting…
  • Import not appearing on a day

    Hi - Thank you in advance for your time! I imported some data last night (general journal) using a date of 4/30/2017, but the data appears to be sitting in between 12/31/2014 and 1/1/2015 (my ending balance on 12/31/14 and beginning balance on 1/1/15…
  • Export sales order out of sage 50 US Edition?

    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.