• Which export/import do I need? (restaurant POS integration)

    I work for an organization that makes a restaurant Point of Sale. We have a customer with Peachtree 2011 and they've sent us information from the help files about importing into that version. We want to import sales information into the G/L but I'm not…
  • Inventory module

    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…
  • Inconsistent date format when export data to excel

    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…
  • Relative path for file imports

    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.
  • Upload Inventory List

    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…
  • Account assignment to imported bank statement file

    How do I assignment accounts to imported bank transactions?
  • 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 old data into Sage 50 2020 with NEW Actian Zen?

    Are there any issues with loading previously saved Sage 50 / Peachtree data from Prevasive SQL database into the newer 2020 Actian Zen database?
  • 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…
  • what is the field for selling price and cost price of the product in line item table in sage 50 database ?

    I want to export data from sage 50 for product (LineItem table in sage 50), but don't know what is the field for hold it's quantity, selling price and, cost of item. i was found link related to LineItem table please have a look, http://help.sage50.na…
  • massive changes in account ID of the COAs

    Hi, Can we change the AccountID of the COAs in a massive way? we need to correct the accounts
  • copying vendor records

    FormerMember
    FormerMember
    I am wanting to copy all of my vendor records from one Sage company to a new sage company. The companies are different, they just happen to have most all of the same vendors and this would save on significant duplicate input. My question is, should…
  • Import Receipts with Automatic Apply to Invoice?

    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…