• 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…
  • No pegging processed on Stock Assignment

    When trying to automatically assign on Stock Assignment I get the information message, "No pegging processed", but nothing is assigned. Any answers?
  • STOJOU table - understanding

    Hello, I am trying to comprehend the structure of the STOJOU table for purposes of providing a cost history. Does anyone know the sources behind the numbers? I am finding it difficult determining how AMTDEV is calculated (Variance not absorbed) There…
  • Sales Order Line Is Under Preparation

    Does anyone know what this means? We don't use "preparation". We started getting this error message recently, sometimes we can blow by it and sometimes we can't. This particular product is not managed so there is nothing to allocate. When you hit ok it…
  • Check for stock on hand when creating a Sales Delivery

    For a stock sales order, I understand that X3 checks for sufficient stock on hand at time of creating Sales Delivery. If there is insufficient stock on hand then the Sales Delivery cannot be saved. Is it possible to delay this check until validation of…
  • 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…
  • Misc. Receipt of Stock at a Lower Cost

    Hello All, I have my stock valuation setup at Standard Costing - STD. But, I would like to bring in stock into inventory at a lower cost than standard cost whenever a misc. receipt of stock is created for a particular item. We usually do a misc…
  • What is an appropriate Valuation Method for Product-Sites used exclusively back to back orders / purchase orders?

    What is an appropriate Valuation Method for Product Sites used exclusively for back to back purchase orders? ie. Goods ship direct from supplier to customer. There is no receipt. This is not Stock. We sell a product from; 1. stock locations. Average…
  • Why does WIP include purchase orders relating to closed back to back orders?

    Update 9 Patch 8 Anyone know why WIP inquiry for a Product record includes purchase orders that have been invoiced and closed for back to back orders that have been delivered, invoiced and closed. How do I change this, or what am I misunderstanding…
  • Table: STOCK[STO] Key: #### No current records When deleting a Subcontract Order

    I am trying to delete a subcon record. I am getting the following error. Table: STOCK[STO] Key: #### No current records Nothing has been done against the subcon.
  • AUTOMATIC JOURNAL ENTRY POSTING "WIP" ENTRY

    WIP Posting automatically creates a journal entry. The entry is comes in as a temporary status. Is it possible to have the journal entries go to the final status on its on. Or setup something that will do it?
  • The quantity to be delivered is in shortage and negative stock is prohibited, or shortage quantities are not deliverable

    When trying to create a delivery for a sales order I got the following error: On the sales order, line item number one is has order quantity of 14784. On the stock by site inquiry; The product shows on sales order 14784 and available stock at…
  • The setup is incomplete : Legislation=USA Work order receipt

    When trying to run the stock interface. I am getting the following error. KB This is from our system. I do not see anything related to USA Legislation.
  • Moving Entries so They dont hit the current Period

    The system currently stops us from closing a period do the following two errors. There is still some subcontract in process that needs to be posted. Some stock movements still need to be posted. Once we identify the entries how can we not close…
  • Freezing a sku/stock despite having inventory

    Is there is a way once a sku's/product available stock reaches a certain number, we can freeze the sku so the system basically thinks that it is out of stock.
  • Recovery of field SALSTO in ITMMVT after accidental deletion of SORDER records

    Hi , I accidentally deleted a bunch of sales orders from SORDER table in the live folder. I then proceeded to back-up the table (after all the stock re-sych's were run including WIP). I am currently in the process of re-entering the orders that were…
  • Valuation Methods - AVG vs. Order Price

    Hello, We have an issue with our system where in for Work Orders, the Raw Materials are being posted to the G/L on the valuation basis of Historical AUC (Avg cost), but the Finished Good is being applied to the G/L based on a different valuation method…
  • STOCK QUANTITIES

    What's the fastest way to zero all your stock quantities (other than entering 0 in every line on the count list, tab twice select 'yes' and tab onto the next line) thanks