Sage X3

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…

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

[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