Browse By Tags

  • Microsoft Excel, or a 32 bit compatible version of Microsoft Excel is not installed

    Recently my workstation was upgraded from Windows 10 to Windows 11, shortly thereafter I started experiencing issues importing excel files into Ship Orders (Tairox). Whenever I try to import an excel file into ship orders I get the error "Microsoft Excel…

  • Import AP Invoice from own excel file failed

    Hi all. I create my own excel file with the same sheet name, column name as exported one. however, it failed to import with the error below. However, copy pasting the content to an exported excel file seems to works fine. The issue is: I am going…

  • What is the template I need to use for uploading a bunch of assets from excel to Sage?

    Group, is there a specific upload template I need to use to get my excel spreadsheet assets into Sage? Thanks Sam

  • Sage 50 export/import issues

    Hello all, hope you are enjoying this lovely sunshine? I bought a new desktop, yesterday. Everything is peachy, except that the fresh install of the full Sage 50 program wont export to PDF, or export/import to Excel. It will crash and close when I try…

  • Combine Excel cells on import

    Hi Sage community! So I am brand new to Sage, and have no experience with any similar programs. I am currently working to create streamlined systems between departments for my company, and one of those is the interaction between collected leads being…

  • Uploading an excel spreadsheet/csv of multiple sales orders

    Hello all, Our company is currently running Sage X3 and we are looking to build a small B2B WooCommerce website for about 30 products for our customers to purchase through. Woocommerce, with the help of some plug ins, can generate spreadsheets/csv's in…

  • Sage 300 - Import items to populate quote

    I want to import items into an O/E quotation. I have attempted to export an existing "QTxxxxx" to use as a template, but I get an error message "Can't Append Table. Error: Too many fields defined." even when I limit the requested fields to those in…

  • 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…

  • Echec import écritures comptables fichier déséquilibré

    Bonjour la Communauté. J'ai créé un import paramétrable pour importer le fichier CSV de mes factures de vente issu de mon outil de gestion commerciale. Le format d'import fonctionne. En revanche lors de l'importation, le fichier est rejeté car non équilibré…

  • Import file formatting

    Often you need to import Sage 500 data using built in Import utility in multiple modules (GL, AP, AR, IM). The data is imported as ASCII records in flat files using either fixed length or record delimited (using a specified character) source records.…

  • La date doit être comprise dans le mois de la date du mouvement.

    Bonjour à tous, Je dois rattraper ma comptabilité depuis le création de mon entreprise (novembre 2018) J'ai crée un tableau Excel avec toute mes transactions de 2018 à fin 2019 et crée un import d'écritures comptables. Mais lors de la vérification…

  • Sage 50 Pro Imports

    Hi, I am in the process of setting up a new company in Sage 50 Pro. I am struggling to work out how i can import open purchase order lines, open supplier invoice and open customer invoices. I have over one hundred open po lines which i obviously want…

  • Importing timesheet information

    Is there any way one can import employee hours into the Cloud Payroll? In the old VIP days, one could capture or import a batch when updating say hours etc? Thanks Blaise Walker

  • Uploading sales invoices that contain multiple VAT codes

    Hi, We currently use an excel template to upload our sales invoices. However, a single invoice will often contain a mix of zero rated and standard rated VAT, which means we are uploading these as 2 lines, so that the net sales figure is appearing…

  • Je n'arrive pas à uploader des fichier au format xls.

    Je ne parviens pas à uploader / importer de fichiers lorsqu'ils ne sont pas au format txt. J'ai l'erreur "File: Unauthorized Media Type". Comment puis-je ajouter cette possibilité?

  • 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…

  • Importing Employee Transaction History from Excel

    We have many employees with pre-tax 3rd-party short-term disability deductions. When those employees receive payments for short-term disability, some employer-related taxes must be calculated. I have a custom Excel workbook to carry out these calculations…

  • Add Import Field 'Due Date' to Sage 50 Cloud Accounts

    Can the 'Due Date' field be added as an option/field when importing data from excel. It is not currently possible to import the 'Due Date' field. Thanks!

  • How to import bank receipts into several nominal codes using Excel

    We are trying to find a way to import bank payments from Excel into Sage50 Essentials (Version 24). Each single bank payment represents several sources of income and need to be split into several nominal codes. If we use the standard input form we have…

  • Excel import into Sage 50 - editing entries in Sage

    Currently whilst it is possible to import journals into Sage 50 using the Excel/CSV import option, it is not possible to edited either values in Sage or to delete the entries. Whilst I appreciate that in some environments to be able to do this would…

  • Excel import in Sage 50

    It is possible to import journal entries into Sage using the provided Excel template, or indeed any other template file providing we map it correctly, but such journals are brought into Sage as individual transactions (or at least appear to be so) rather…

  • Excel import into Sage 50 forms

    Excel import is available into Sage, but presently only at system level. It would be helpful if Excel import were available at any and all of the forms levels. so eg when entering a journal all entries must be typed in (or chosen from the pick lists…

  • VI Job HS Record Failure (All lines have not been distributed)

    I'm running into a problem with an import job from Excel where the VI Job passes in Test mode but not when executed. If there is more information needed please let me know and I will try to get it. Keep in mind that I was not fully trained in this…

  • 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…

  • Sage 300 ERP UI Container has stopped working

    Hi, I am having a hard time importing transaction on AR module, this notif. keeps on prompting while i keep on trying. I have searched some trouble shoot for this but still I can't proceed to what I am doing. Any help? Please! Thanks, B…

*Community Hub is the new name for Sage City