• Shelf Life Management

    Hello, I am wondering if there is a way to manage the shelf life on a product based on the shortest shelf life of the items on the BOM for that product. We are mixing chemicals and the shelf life has to be based on the shelf life of the ingredients…
  • FUNSTOLTI Error

    I am trying to expire an item using FUNSTOLTI based on the Recontrol days and I get the following error message on a STOCK item that should trigger it expires. Location PTL26 A A (BG 43) The Current Location is not authorized for the new Stock status…
  • Enter backdated shipment for product that has since expired

    We have a scenario as follows Sales Order was done on 18/11/2021 The product to be delivered expires 20/11/2021 Physical delivery to the client was done on 19/11/2021 The delivery was only captured in Sage X3 on 22/11/2021 although we changed…
  • Lot numbers created based on expiration date

    Hello members, I'm looking for help on a sequence number formula that would help my customer create his lot numbers based on the expiration date or lead time. We have the following to base the solution on: Product code: ABC123: Expiration…
  • RE: Linking a Miscellaneous Table through SQL

    Hi Israel, I have yet another SQL question (sorry, we don't have a Crystal reports integration!). I want to use a subquery to extract the Average cost of each product by using the AVG aggregate, but I am unsuccessful in doing so. What I have so far…