Browse By Tags

  • Excel to Update Vendor Info

    Can you update vendor information in Excel and have it import back to Sage? If yes, how?
  • Link JrnlHdr to itself

    I added the JrnlHdr to the report twice in hoping the link the second JrnlHdr to itself. How do I do this? My first instance JrnlHdr is restricted to JrnlHdr.JournalKey_Journal 11 - Sales Orders. While my second is restricted to JrnlHdr.JournalKey_Journal…
  • Error when opening payroll reports - Access violation in module Task0150.exe

    Hello! We process our payroll in Sage BusinessWorks. After printing checks, we print out the Check Register report. We had no problems last week; however, after printing checks and attempting to open the register report today, we got the following error…
  • Changes to Master Vendor via Excel

    Can you change vendor master files (ie: Inactive) via Excel and import back to Sage (Easier and faster) if so how? I know I did this years ago but with all the version upgrades it must look totally different.
  • AP - This program is about to close. See the journal in the following location

    We started experiencing this issue 2 days ago and it seems that we are unable to get past the error. When trying to make a payment in Sage AP, my user gets the following error when trying to submit: This program is about to close. See the journal in the…
  • Can't import stocks data SAGE 50 Canadian version

    Hello, I can't import products correctly in SAGE. It works if I only have the coloumns this way : Exporting and importing inventory and services data using CSV format (sage.com) withtout the cost or category or anything But if I do it this way…
  • Unable to retrive purchase order and lines using the dispatch object mentioned on the description

    using (DispatchObject poObject = new DispatchObject(pvx.InvokeMethod("NewObject", "PO_PurchaseOrder_bus", oSS.GetObject()))) Could any one of you suggest, which dll or nuget to be used for this dispatch object. We are using the below object management…
  • Lack of data in Data Model and Views

    Hello, After verification, I found in a worksheet of Data Model and View, it lacks the data of one day from Sage X3. The specific is: In a purchasing worksheet in SEI, it only displays the data of February 1, 5, 13 and 27 from Sage X3. However,…
  • Import sales invoice to SAGE50

    Dear, I trying to import sale/invoice to SAGE50, but I getting warning message each row, but all row still success import. The reference number "TP24-0304C" is available, but getting warning. The data CSV below: anyone know the problem?
  • Job list disappeared from Timberscan

    All of our jobs have disappeared from Timberscan and we can no longer select for routing. Any advice?
  • Importing Data into Sage 50 Cloud vs Sage 50 Desktop - Any differences?

    Hello everyone, Are there any differences in importing data into Sage 50 Cloud vs Sage 50 Desktop? Such as General Ledger Journal Entries and Vendor Invoices. Any information or advice would be greatly appreciated. Thank you, all. Mike S.
  • Data Migration from Oracle to Sage

    Good day We have a customer that wants all data (including the attached supporting documents.) from Oracle migrated to Sage. We proposed Using Sage Import template but they insisted they prefer using a data migration tool( for efficiency and data integrity…
  • Setting up a Chart of Accounts Backup for a Sage Business Cloud account.

    In regard to a Sage Business Cloud account, is it possible to set a restore point or backup of my Chart of Accounts in case I want to revert back to it? Thanks for your help!
  • Bulk Add Images

    Hello, I have over 2100 items. In IC>Parts>Maintain Parts there is a section to turn "Picture On." Is there a way I can add all of the images of my items in a bulk upload of images? Instead of adding the images one-by-one over 2100 times? Thanks…
  • @X3.TRT/GOBJET1$adx (163) Erro 76 : Erro SQL server (Microsoft) [ODBC Driver 17 for SQL Server[SQL Server] Invalid object name

    Hello, After updating to p34, when trying to create a client (GESBPC) the following error appears: Checking the database, the table in question does not exist: What do we need to do to adjust this information, is it on the X3 or SEI?
  • Character input - not a keyboard issue

    We have been having this issue for YEARS. We have called multiple times, it is happening on multiple computers, and is not the keyboard. We have even had a video conference with Sage. We are entering invoices and all of the sudden, our letters and numbers…
  • Invoice Matching Data

    Can anyone tell me where, in the database, I can find the invoice matching data? I am looking at the GACCENTRYD table but it seems to have some holes in the data. Any guidance would be much appreciated. Regards, Dave
  • import qty cancel at PO Receipt

    Hi All, can we import Qty Cancel at PO Receipt? Or any macro or tools for this?
  • dé-comptabiliser une facture

    Bonjour Je suis débutante sur Sage et j'ai accès à une base de test SQL "bijou". Je souhaite de dé-comptabiliser une facture et apporter les modifications nécessaires. Serait-il possible de me fournir la requête SQL appropriée ? Merci d'avance.
  • VI Import to SO_InvoiceTracking with multiple packages from UPS Worldship export

    Hi Sage 100 Community, I'm trying to help our warehouse cut some manual entry time with their UPS tracking numbers. There is currently a process in place with UPS Worldship that exports a CSV at EOD to our Sage server and then a series of VI Import…
  • Erreur de connection

    Bonjour, J'ai installé la nouvelle version 2024 en février dernier. Je n'avais pas fermé mon application Sage 50 comptabilité depuis ce temps. Je l'ai fermé et quand je veux ouvrir voici le message que je reçois: Et quand je veux aller chercher…
  • Payroll syncing getting error

    At the end of December, I replaced all of our computers - server went from 2012 to 2022, and workstations went from 10 to 11. Ever since then we have had this problem and nobody has been able to tell us what the problem is so far. When we go to do payroll…
  • Balance Update column in Accounting Tasks

    We are seeing a value in the "Balance Update" column in Accounting Tasks and we can't get rid of it no matter how many times we run the resynchronization functions. When we try to run the "Account Balances resynchronization, we get this error which also…
  • ibdata1 file is 900GB how do i make it smaller

    The ibdata1 date file is growing very large and seems to keep running - any ideas on how to stop it and reduce it
  • Importing transactions

    We use a custom made application that stores our invoices. Is there a way to import these transactions? The files can be converted to CSV or Microsoft Excel. Is there an application that do the import? Are there templates available showing how to…