Sage X3

Hi, With Sage X3 v11 & SEI, I'm trying to join the SINVOICED table with STOJOU using SOHNUM_0 and VCRNUMORI_0 to get the product lot number for each invoice. The only issue is that 1 sales order can have multiple stock journal entries but only 1 invoice…

Working on an advanced filter to get PO lines past due. Tried global variables @@CURRDATE and @@TODAY with no luck. Any ideas?

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…

In prior versions of SEI for X3, I could create a new process using the PINVOICE table and BPSINVLIG and BPSINVLIGA tables to see the details of BP supplier invoices. Version 9 of SEI does not include the BPSINVLIG and BPSINVLIGA tables. Any ideas on…

Hello All, We have implemented SEI UDM(Universal Data Model) in our company, we notice the below measures are not showing are data in the SEI and SEI Cube table in the database. 1. Ending Balance 2. Ending Balance LY SEI Version: Version…

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…

Hi All, How can i clear a MONGODB DATABASE, because some collection like fs.chunks are very bulky. Thanks

How are subqueries performed in SEI without creating a custom DB view ? Creating an Order Shortage Report. I have a process that pull sinformation form the ITMMVT table in summary (Orders, Item info) but I need to join to the ORDERS table to find…