Sage X3

Hello everyone, I am a new user to Sage SEI. I am trying the get the Year and the Month from a DateTime field and I keep getting this #BI-ERR-UNDEFINED when trying to add the calculated field to a view. When I validate the script (necResult=date.getFullYear…

Hi, I'm currently looking into some strange behavior in how SEI is subtotaling values. Specifically I have a report where I want to see the Average value of our costs. Rounding to the Nearest Dollar For illustrative purposes, I'm going to use our…

Hi everyone, I'm trying to have a SEI view that shows me a week's window of information in a way that the date is variable and not fixed using an specific date in the filter formula. I've tried to use the @@curdate variable is seems is not compatible…

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…

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…

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…

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?

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…

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…

[SEI v.8] Can I reference a Calculated Column I created in the calculation of another Calculated Column? If so, what is the syntax to refer to a Calculated Column within the SQL Scripts Builder? Usually when referring to to a field within a calculation…

Hello, can anyone tell me if there is a SEI manual that explains how formulas work? thank you