Sage X3

Is it advisable NOT to use certain special characters (e.g. @,#,$,%, etc...) when creating setting up product IDs and their descriptions ? Especially keeping the import/ export templates in mind.

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…