• @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?
  • 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…
  • 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
  • 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…
  • 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…
  • Best approach to deploy configurations from Pilot folder

    Hi, I would like to ask what is the best approach to grab all the configuration from Pilot and send to X3 (Production folder). That include parameters, workflows, native setups etc. Test folder to Live folder. Thank you
  • 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…
  • SEI: How to use Application Links to open a function in Sage X3

    This article gives one detailed and one summary example on how to create an Application Link to in its web interface to open a classic function in X3 on a specific record. It does not cover how to open the Read Only pages in X3 which is covered in the…
  • How to use SEI Application Links to open a function in Sage X3

    This article gives one detailed and one summary example on how to create an Application Link to use the SEI Link To feature in its web interface to open functions in X3 on specific records. It does not cover how to open the Read Only pages in X3 which…
  • Adding a Sage Enterprise Intelligence (SEI) worksheet to X3

    Did you know you can add an SEI worksheet to open from within X3? There are two ways to accommodate this functionality, either by embedding it into a landing/home page or adding it within the menu modules as a menu item. These two knowledge base articles…
  • terminate sessions via sql

    Looking to see if there would be a way to let users terminate "their" hung sessions by showing them their open sessions where they could delete them - this would most likely be a front facing web app that would talk to the sage sql db and set a flag or…