• @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?
  • Blue Pop up "Empty" notification

    Hello, I'm getting an annoying pop-up where the notification is empty. I've validated the screen, table, and transactions related to the function, but the message keeps popping. It does not hinder the action or enter the process; I must press ok two…
  • How to upload a file to mark outstanding transactions?

    Hi there I have a bank reconciliation of 9,000 transactions, of which 750 of them are outstanding. I have already identified the outstanding transactions in an excel workpaper. Do you know if there is any way to upload or mark the 750 outstanding…
  • Opening Balance Formula for SEI

    Good Day I am attempting to create a trial balance that includes opening and closing balances, but I can't seem to locate where those options live in SQL or in X3. Is this something I will have to make a formula for? If so does anyone have any advise…
  • Tax Determination Rules and Alcohol Volume Tax

    Ok X3 Tax experts. This one is for you! There are now several states that are beginning to charge Alcohol Volume Taxes. The Tax determination rule function appears to be the perfect solution for the following: ABV Tax = Volume * Rate. In addition, the…
  • Can you run Year in Simulation for more than one year

    Can you run Year in Simulation for more than one year in X3 and SEI? For example, could you have 2019 and 2020 open but run year end simulation to have your 2021 balances correct for balance sheet accounts? Thank you. Cindy
  • Struggling to tie Lot # to Delivery Data

    Hello, It feels like I'm overlooking something simple, because tying lot numbers to our delivery records should be fairly straightforward. When I pull up a sample delivery record in Sage X3, I can select Stock lot and see which Lot number were included…
  • Create a view using week numbers

    Good Morning I have a customer using SEI for Sage x3 (multi-tenant cloud) and still on V8 of SEI. They need to see financial data by week number. Is there a way to add a week number into a process so we can view the data by week instead of just fiscal…
  • Standard Accounting Code and Guidelines

    Does Sage has standard Accounting Code for product which we can refer as guidelines. For example the product code for Asset (if you have multiple asset Gl code - machine, computer, etc), should you have different product code for each asset according…
  • Joining Tables with Mismatched Data Types

    I am trying to create view that shows the number of PO receipts per day. The process owner has requested to see days where no receipts were performed in the data. Since there is no data for those days, it is not represented. I tried pulling in the ZCALENDAR…
  • Are there any special character restrictions for Product Descriptions ?

    Is it advisable NOT to use certain special characters (e.g. @,#,$,%, etc...) when creating setting up product IDs and their descriptions ? Especially keeping the import/ export templates in mind.
  • Script to rename report in Preview

    Hi I have a customized report ZSORDERS I have a script that renames the pdf generated by report (SO#) and saves it in destination.But I need to modify the script so that when the user opens the report in preview the report is renames and the user…
  • Generate a report to get the list of Products without customer through SEI

    Dear All, I am facing some problem to generate a report through sage enterprise intelligence. I want information from the report is 'product without customer' but when i apply criteria/filter to the customer i.e. 'customer code=null', the output…
  • Failover Clustering/Mirroring for Sage EM

    Hi, One of our client is planning to setup a strong failover system for Sage EM, and we are planning to set up SQL clustering to achieve it. But I am not sure how Sage EM is configured to consider the SQL clustering. I would appreciate to have a guidelines…
  • Sage Enterprise Intelligence 8.2.3 for Sage Business Cloud Enterprise Management (formerly Sage X3) has been posted to Sage Knowledgebase article 77942

    Sage Enterprise Intelligence 8.2.3 for Sage Business Cloud Enterprise Management (formerly Sage X3) has been posted to Sage Knowledgebase article 77942. To access this download, log into https://support.na.sage.com/ . In the search field, enter, 77942…
  • SAGE X3/EM - error while closing period

    Hi All, I'm getting error while closing fiscal period and didn't find any solution on forums for the same. Can anyone suggest me, how to resolve below error. So that I can close fiscal period. Error - $VERF_TMP EXPE "Journal number" Entry that…
  • Information about Commerical Bom Price Lists - Price List Type Component

    Does anyone have any information on the price list type "component" and how it relates to commercial boms ? Trying to see if it can apply to a new project. thank you!
  • How can we prefix the order of a list in the representation?

    We have a representation of purchase documents, and in the list we want that by default we appear ordered by date in descending order. How can we do it?
  • Error Message: @TESTEAG.TRT/W1SDH0$adx (1464) Error 7 : Class Non-existent [F:SLT]

    Hello Guys, I'm experiencing the below error message when I'm trying to access the Sage X3, Delivery Note Screen Sage X3 Version 11 Please your advice on how to resolve the below error messages will be highly appreciated. Error Message: @TESTEAG…
  • Error patching X3 PU8 to V11

    I am setting up a new X3 with V11 and I need to use a folder that is on PU8 patch 3. I created the environment and imported the folder to the new V11 environment. When I try to do the patching from PU8 patch to be the same as the X3 folder I have the…
  • Enterprisee Management (SageX3) v7 release support

    Hi, Until when the version 7 will be supported? Thanks Hugues
  • Free Webinar - Announcement to Sage Partners in Australia

    Dear Partner We are pleased to invite you to Sage Enterprise Intelligence (SEI) Webinar that will include how to demonstrate Sage Enterprise Intelligence covering a Sales Demonstration, what's new in SEI V8 and an overview of SEI with a Q&A session…
  • Unposted Items

    Does x3 have a report or a place to find unposted items. Things to look out for (Bills, Invoices, Payments, Journal Entries, etc