Browse By Tags

  • VUE X3 et Opérateur Like

    Bonjour j'essaie de créer une VUE sur X3 à partir d'une requête sql server et qui contient au niveau de la clause Where l'opérateur 'LIKE', en essayant de valider la Vue sur X3 j'ai une erreur applicative qui me signale l'erreur suivante :" _INT ->…
  • What is the best way to get a GLCode attached to either an Item or a PO?

    I am trying to join one of the following tables to GACCOUNT. PORDERQ or ITMMASTER. There doesn't seem to be many ways to get from GACCOUNT to an ITMREF_0 or POHNUM. I have tried a few different options but none seem to be working. Your help, as always…
  • Where can I find GL code and descriptions of the code?

    I am building out existing access report in sagex3. Where can I find GLcode and descriptions? I've looked at the accounting data model tab and am just not really sure what I am looking for. Thank you in advance!
  • Is there a way to see how much quantity was pulled from a specific lot?

    I am creating an invoicing table that has Item, Lot and QtyOrdered. Is it possible to see per lot allocation by sales order number? I know you are able to see the qty on hand/lot. For example, if I have an item that exists in multiple lots, I only want…
  • Looking for Total Usage Qty

    Good Morning! I am currently working on swapping from Process Pro To Sagex3 and one of the columns in PP is Usage qty which is total qty used for the year. Is there a field in sagex3 for this? As always, your responses are greatly appreciated!
  • What is EOQ?

    is it estimated order quantity? Does anyone know the name of the column in sql? As always, your responses are greatly appreciated!