Browse By Tags

  • Option to export all Data since the last valid Backup when unfixable Database Errors occur

    When Errors occur in the Sage Database, if these cannot be repaired then the only viable option is to restore to the last valid Backup. However, the users have to first Print out any Data that they have entered into Sage since the last valid Backup and…
  • 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…
  • 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…
  • 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…
  • 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…
  • Deleting Sage X3 folder from database

    Dear Fellows, As you may all know that when you delete a folder in X3 it will not be deleted from database with all its references which will eventually increase your database size, and therefore i created an sql procedure that safely delete the folder…
  • Import of Data from WooCommerce

    Hi there, I am just new to Sage 300 and planning to use it in our next project. IF there is a WordPress website which exports it's data in JSON format, is there a provision available in Sage 300 to import that data?
  • A report which can be imported to Barclays.net?

    We have a number of clients who pay us by Direct Debit. Once a month we would input the collection amounts in to Barclays BIB manually and have continued to do this in Barclays.net but a the quantity of customers paying by Direct Debit increases the time…