Browse By Tags

  • Signing Up & Migrating Data from Sage 50 CA to Sage HR and Payroll

    Signing Up & Migrating Data from Sage 50 CA to Sage HR and Payroll

    Do you want to manage your organization's Payroll from a pure cloud solution while working remotely? Are you currently a Sage 50 CA or Sage Accounting / SBCA user? Or is your business growing and you're looking for a software solution that includes Accounting…

  • Retroativo

    Boa tarde, Como faço para lançar um retroativo? Deixou de ser possível indicar no código o mês. Obrigado.

  • Looking for description data for Payment Terms, Carrier, Delivery Mode

    Hello community, I am trying to add some description data to a customer facing crystal report and noticed I am only pulling the ID/ Code of the certain fields but need to show the full description of what that id/code is. Trying to add the descriptions…

  • Looking after your data - best practice

    To protect your Sage Accounts data we recommend checking your data and backing up regularly. We've dedicated an area of the Help Centre to this very subject, covering data checking, scheduling backups and much more. Check it out now >

  • Querying the SEI database directly

    What I am trying to do is write a query that will list all SEI processes and the Folders they are located in. I can't seem to find any table in the SEI database that contains the folder structure. Is what I'm trying to do possible? My organization is…

  • Looking after your data

    To protect your accounts data we recommend you run the Check Data option and back up your data on a regular basis. Find out more in the Help Centre where there's a topic dedicated to data protection. Read more >

  • Restrict access on BSI management

    Hello, Some customers want to restrict the access of the function "Bank transaction management". Indeed, in multi-company cases, they want to display only bank statement for the company that the user is responsible. There is no way to setup this access…

  • Sage accounting data export / PowerBI connectivity

    Hey all, Brand new to Sage. Supporting our organization that has a small footprint of Sage accounting. Appears we can manually dump canned reports to csv/excel; however, is there functionality to allow for direct connectivity to the back-end database…

  • Import Excel in SageX3 v12

    Bonjour, Nous utilisons dans la grande entreprise où je travaille Sage X3 comme ERP, dans lequel nous stockons un nombre incalculable d’informations que nous générons d’abord dans Excel. Je cherche un plug in ou quelque chose de similaire qui permettrait…

  • How do I find out where a data inconsistency is between debits and credits?

    I ran a data integrity report and everything is balanced except my total debits and credits. I have run an "ALL JOURNALS" report going back to our first year of operation in 2011 and every year shows a balance between total debits and credits. Where else…

  • Protect your data the easy way

    Taking data backups doesn't have to be a chore. You can use the Backup Manager to make regular backups automatically. Meaning no more staying behind to back up, or waiting for others to log out. Read more

  • P11D v26- issues with data import - skipping records PAYEREF ?

    Just doing P11D data upload and keep encountering same error. Invalid CSV record '1': The mandatory field 'PAYEREF' is missing or has an invalid data type, skipping record... It recognizes the data but SAGE P11D skips all records and doesn't import…

  • Report Designer exporting Data to excel query

    Hi When I export a bespoke report to 'Data to excel' the data columns are not in the correct order: IE. Column G - PaymentAnalysis.Desc2 Column H - PaymentAnalysis.Desc4 Column I - PaymentAnalysis.Desc6 Column J - PaymentAnalysis.Desc10 …

  • Year-end Series - How do I run the Data Integrity?

    • https://youtu.be/K99p63_oGIo
    • View

  • Question regarding Invoice Table relationships.

    Hello, I am trying to put together a report for tax purposes and am not confident I am pulling paid invoices correctly. My initial thought was that all invoices in the ar_invoicehistoryheader table were paid, but I was told that these invoices are…

  • Nominal Ledger Activity Data import into Microsoft Power BI

    Hi, I am a Business Intelligence Developer in my company and importing data from Sage 50 accounts database into Power BI using sage ODBC driver. Nominal Ledger table has data at month level but now, our requirement is data at the invoice level. There…

  • Data error. Sage 50 Canadian Edition 2021.1 Advanced Check & Repair tool cannot adress the issue. data table TBRTR

    I am using Sage 50 Canadian Edition 2021.1 I used "open as an admin" to open the sage program. I am in the single-user mode and logged in as a system admin. I have some issue that cannot post into a future date. cannot add departments in payroll. when…

  • Protecting your Sage 50cloud Accounts data

    To minimise the risk of data corruption and the impact it has on your business we've pulled together some recommended best practice. Read more >

  • Empty Sage50 database table : Connection with Power Bi/Excel

    Hi, I am a business intelligence developer in my company, importing data from sage50 database into Microsoft Power bi right now. One specific table, Update_Ledger, is not showing any data and this is the main table for our reporting needs. Why is it…

  • Pastel Import Template File

    Good day All, I am looking for Import Templates for SAGE 50c Pastel Partner. Importing Customers Import File Importing Stock Import File Importing Cashbook or Journal Batch Import File Partner Inventory Master import file Do you know any…

  • Import data

    Hello, I am trying to update my customer information (add in their area, region and province - 3 columns). All the customers are already in my SAGE. I tried to import the csv file that contained all my updates, but it only wants to import all the headings…

  • What connectors (Data Tables) are used in Report Manager?

    How do I tell what connector (data tables) are used on a given report?

  • Can I host Sage 50 accounts data on windows server 2019 essentials?

    Hello, My company recently bought a server running windows server 2019 essentials. Can sage data service run on this OS? I would like to host my data on this server. Alternatively Could I run a virtual machine with Windows 10 on the server to host…

  • Taking care of your data

    The Optimise Data option compacts the size of your database and reduces the size of your backups. This helps to maintain organised, error-free data. We recommend that you run this routine every time that you open your data and also before you install…

  • Sage 50 Canada - data migration partners

    Good Morning! Recently we've run into an issue, where a journal entry needs to be added under December 2018. According to the Sage 50 team, we'd need to restore from an old backup, do the journal entry, then manually enter all the data that comes…

*Community Hub is the new name for Sage City