• Invoicing Elements: Processing Fee Calculation Order

    Hello, I am trying to calculate one invoicing element off of another and I seem to be running into a road block. I have tried using the "Calculation order" field, but this did not work. The next step would be using the "Action" and "Processing" fields…
  • Global VS detailled allocation

    Hello! Anyone knows what is the difference between manual and detailled allocation?
  • Budget Calculation not calculating

    Does anyone know how to setup the Budget Calculation function correctly. I'd like to create a new year budget (by period or annualized) from the prior year actual ledger account/dimension balances. The function appears to be straight forward, however…
  • "Tax Excluded" invoicing element still charges tax

    Hey Everyone, About a year ago, someone had set up a "Fuel Surcharge" invoicing element that applies a $5.00 charge to every order. However, it was supposed to have tax excluded. To this day, the $5.00 charge is actually $5.60 because it is being charge…
  • Specific Sales Price List for Service Requests

    Hello fellow citizens, For a sold product we have a customer/product sales price list using a minumum quantity of 10 items. The same item can also be consumed in service requests, but there we do want to allow quantities less than 10; a single item…
  • Import Material Cost Variance

    Hello, We are on Sage X3 2019 R4 (12.0.19). We are importing raw materials and when the stocks are arrived, we need to issue those into production as we are in a tight planning schedule. Received materials will be issued to production with the average…
  • 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…
  • 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…
  • Purchase order - Gross/ Net Price rounding

    Hi We are using Sage X3 Pu8 Patch 3 We purchase in manufacturing materials in high qty eg 34344 qty of caps at $0.15075 cents each. We changed MD6 gross price field to allow 5 decimals however the Net price is still rounding to 2 decimals on each…