• Accessing data from Sage X3 from a shipping program using ODBC

    Hello, I have Fedex Ship Manager software and I am trying to integrate it with our Sage X3 software using ODBC and SQL. I am only able to see sys tables when trying to link. I even set up a new user in SQL manager with full rights. The Fedex software…
  • What does the create date in the STOJOU table mean?

    I'm trying to track the health of our shipping department and I just want to ensure I fully understand the create date in the StoJou table. does that mean when the delivered qty is taken out of stock ? and if yes, does that also mean when the shipment…
  • License Plate Numbers for Pallets

    I'm curious if or how other companies generate license plate numbers (LPN) for pallets. Although the STOJOU table has a PALNUM field, I'm not seeing how I can get X3 to generate a unique pallet ID barcode and store that ID. We'd like to be able to know…