• Just released: Sage X3 v12.0 1099 2022

    Just released: Sage X3 v12.0 1099 2022. We're thrilled to let you know that the Sage X3 v12.0 1099 for 2022 is now available to download from the Sage Knowledgebase. Head to Knowledgebase article Download Sage X3 Version 12.0 1099 2022 to download…
  • Invoice won't post and errors with "Unbalanced Distribution"

    Our Customer Service team started receiving this error when posting some invoices: "CI2200860 ZSIHI : Unbalanced Distribution 4 (ZSIHI Line 410)" and I'm not having any luck resolving it. I have run GTEST to check the posted amounts and they balance.…
  • 1) Mass delete BPS Invoices 2) DocLink/DocAlpha

    1) Is there a way to mass delete BPS Invoices? I have 1900 to delete. 2) Duplicate and triplicate Invoices have imported into Sage X3v12 p17 from DocLink/DocAlpha. This is the second or third time it has happened. Does anyone have advice on what might…
  • Short Term Rental

    I need to setup a process to manage short term rentals. I have investigated the lease contract option, but it requires Fixed Asset setup and a large amount of transaction overhead. The best option I have found thus far is to use a Loan sales order followed…
  • 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
  • Can I copy a posted Sales Invoice rather than having to re-create from scratch?

    Hi, At the moment when a sales invoice is found to be incorrect after it has been posted, we have to create a credit note for the whole invoice and then re-create then invoice from scratch. This has a few problems but in terms of resource, for invoices…
  • 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…
  • Validate PO Invoice with Webservice

    Does anyone here have any idea how to validate a PO Invoice using a webservice, or other similar method?
  • Purchase Invoice: do not allow invoiced quantity greater then receipt quantity

    We have found that when bringing over a PO Receipt into a Purchase Invoice that the user can change the quantity and invoice for more than what the receiver brought into inventory. The user in our system is presented with a warning: "Warning - Maximum…
  • 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…
  • Invoice with unfixed VAT tax rate

    Hi everyone, I am looking for a solution where I want to input a invoice with VAT. However, this vendor would issue invoice with unfixed VAT rate. i.e. sometimes Net amount = GBP 100 and VAT = GBP 12 and sometimes Net amount = GBP 100 but VAT…
  • Sage X3 Purchase Receipt/Invoice Creation

    Hi Do you know can you turn on parameters than when you create a PO receipt that the invoice can be automatically created. Or do you have to create the receipt then the invoice. thanks Stacey
  • Invoice Site mismatch

    Hello all, I had a question about the way X3 is handling our invoice create. X3 allows us to create an invoice to a purchase order outside of the site the PO was originally created. Eg. PO was created in site A Receipt was created in Site A…
  • Managing Invoice Deductions from Payment Level - Sage X3

    Hello Guys, I am currently having some problem allocating my clients deductions. I have proposed for them to manage it at Invoice level making use of the Tax 1, Tax 2, Tax 3 but they refused simply because the date at which the account codes report…
  • Sage X3 V7 - Purchase Orders Not Received But Invoiced

    Hi We have a client who uses Purchase Orders. They are not using inventory as such but we create an item code so they can raise Purchase Orders. They do a Purchase Request, it becomes a PO then they use Invoice Control to enter the Invoice. We don…