• Format data on export by Adding characters

    hi, When i export some data for exemple à LOT NUMBER, i want to add a "XX" at the beginning of it when we export the data with an export template i take from the table OUTPUTM : [OUM]LOT I'm trying to use =FORMAT$ But i'm stuck on how to express…
  • Format of BP Site tax ID - help

    This is the set up for France in my X3. Please help guide me on an example of how the tax ID should be formatted for the CRN field in BPARTNER