Browse By Tags

  • Item Imports keeps failing

    Hi all, I am trying to import an item list but the error log keeps telling me that every line and column is in the incorrect format. It seems that the import is not separating the columns because I can't select specific columns on the mapping stage. On…
  • Template for Importing Job Costs

    Can anyone assist with a template for importing to Job Cost, including GL Only entries? Below is a snip of the fields we use. I currently import invoice in AP using an Excel template with Office Connector to convert to a .txt file but I cannot figure…
  • 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…
  • Time Tracking

    Good day We are unable to import our monthly time sheets and Your Call center is no help. Please assist
  • Direct deposit File Error

    I sent a "test" direct deposit file to be uploaded to the CAFT system we use for payments. The file came back with 4 errors. I'm not sure what they are or how to fix them. Where do I start? Thanks! 1. Please ask Client to update the following…
  • 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/Export Search Categories

    One to save some time, if you could export and import Search Categories/values, then this would save a whole heap of time because if you're moving the contents to another database then you can save the details to SQL using a script but you have to manually…
  • To be able to import multiple contacts on PL/SL accounts

    On importing Customer or Supplier accounts, you can only import one contact per account, despite being able to input multiple manually. It would be good to be able to import them on the Customer/Supplier Account import or a separate import
  • Importing Absence/Leave/Sickness via CSV File

    I am attempting to mass import leave/sickness for our employees using the Advanced data import tool, but cannot find the appropriate template to do so. The data I wish to import is: Employee ID Type of Leave Start Date End Date Deducted Hours …
  • 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…
  • Is it possible to import employee pay into Sage using the SDK?

    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…
  • SDKInstanceManager OpenDatabase always returns false and has no error messages

    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…
  • Importing in AR Receipts using single line items

    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…