Sage X3

Have you tried the Sage Enterprise Intelligence (SEI) Workbooks in the latest versions of SEI? Use Workbooks instead of the Excel Add-in. For more information, check out the Workbooks Preview in the SEI Online Help: onlinehelp.sageenterpriseintelligence…

Anyone know how to do that? Looking to figure leadtime as the number of days between order date and ship date. I did a calculated column in the view of ship date minus order date and it retuned zero. Did a calculated column in the design process and it…

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…

I have a process basically just using the ORDERS(WIP) table. When there is no value for MRP date, SEI shows '01-01-53'. How can I suppress that and still have a value when there is an MRP date? I've played with the calculation but no avail. Was trying…

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…

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…

Hi Team, I have created a new dashboard to display the SEI data charts in X3. I'm using Chrome browser, i refer this article to fix the issue but it doesn't work. https://support.na.sage.com/selfservice/viewdocument.do?noCount=true&externalId…

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

I have a pivot of WIP status and the values I see are firm and suggested. How can I add the two pivot columns for planned qty to get a total firm + suggested?

Is it possible to export a view definition to share with a business associate?

Has anyone calculated the week number from a date field? We're version 8.2.5.27

Is there a way to use fiscal periods rather than calendar periods when looking at invoice information?

Buenos días, Al ejecutar la función de desviaciones de conversión, he observado qeu solo tiene en cuenta las cuentas de tercero/colectivo, pero no otras cuentas como las de bancos (572). ¿Sabéis si hay algún modo de regularizar las diferencias de…

Hello Guys, I have changed the reporting code in some of the calculated columns in UDM Finance Process after making copy of the original process but I'm getting an error message when trying to create new report or view from the copied finance process…

Hello Guys, I'm getting the below error message after changing the reporting code of some calculated columns in SEI to match our Sage Enterprise Management reporting code and trying to use the columns is creating a new report. Your advise on how…

Sage Enterprise Intelligence 8.2.5 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 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…

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…

When new record for customer payment, when we select partial Invoice, system calculates exchange variance in local currency because Invoice is issued in second currency (Ledger). Can we define exchange rate variance calculation only when document is matched…

Hello Guys, I'm getting the below error message when I run the Stock Accounting Interface, I have perform Intersite BP's Purchase and Delivery. Error: Unbalanced journal Legal stat=99 KEY1=18RCGE-U4HP1-00001 KEY2=~ KEY3=~ KEY4=~ KEY5=~ Sage…

Hello Guys, Your advice on how to setup the below function in Sage X3 will be highly appreciated. 1. How to setup Retainage and apply the setup during Customer or Vendor invoice entry. 2. How to enforce some particular GL Accounts to always…

Good day We have a prospect that want to do daily periodic stock valuations: Opening stock + receipts for day 1 = average value for day 1, and all sales for the day cost of sales will be adjusted by this cost Opening stock for day 2 + receipts…

When I convert a subcontracting work order operation to a purchase order, the following error display: PJT: VARIABLE NON-EXISTENT @X3.TRT/TRTACHCDE2$adx(255) How do I resolve this?

Sage Enterprise Intelligence 8.2.0 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 Enterprise Intelligence 8.1.1 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…