• Table with link between invoice and order

    Hi. Is there a table, where I can find the link between invoice and sales order? Thanks in advance. MatteoS
  • Sage X3 Fixed assets depreciation Calculation done but cannot see the Changes in Journal Entry

    I have implemented the fixed asset in Sage X3 version PU9 as per the curriculum provided in the training by Fixed asset instructor from Sage University. Performed every step as per his instruction. only problem that I found was I cannot see the any…
  • How to allow negative NET price on Sales Order/Deliveries/Invoices?

    Hello, we have the requirement to allow negative NET pricing on certain lines on Sales Orders, Deliveries and Invoices without using the discount fields. I've been able to enter a negative amount on the GROSS price for a line item, but then Sage makes…
  • How to deploy the Connecticut "Gross Receipt Tax" (GRT) in Sage ERP X3 V9?

    The Connecticut GRT tax is on the first sale of petroleum products in the state. The tax is charged to the applicable line item amount up to the maximum of a price of $3. Amounts charged above this price are exempt. Therefore, we must find a way to recalculate…
  • Material Variance Calculation in X3

    I am working within the WIPCOST (Manufacturing Module) table and trying to determine the calculation of material variance. I put in my Work Order number in the MFGNUM field. The TXNTYP is 9 for Material Variance. Then the AMOUNT is what is booking to…
  • Material Variance Calculation in X3

    I am working within the WIPCOST (Manufacturing Module) table and trying to determine the calculation of material variance. I put in my Work Order number in the MFGNUM field. The TXNTYP is 9 for Material Variance. Then the AMOUNT is what is booking to…