x Want to participate? Join the group to interact

  • 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…

*Community Hub is the new name for Sage City