• Can X3 handle purchases where cost is negative?

    We run Sage X3 Update 9 Patch 9. The cost of a product we buy is going negative. This occurs from time to time because the product is a by-product- sometimes the supplier can sell the by-product, but other times they have to pay us to take it. …
  • Chronological stock - when it is used?

    I hadn 't been paying attention before . The system contains a numerator tethered to the Chronological stock (Sequence number assigment>Stock>Chronological stock) . When it is used / worked ?
  • Disputed Stock

    Hi, anybody knows about disputed stock in purchase receipt screen? I cant found in online help and training material too, hope u all could give me some help. Thx
  • 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…
  • Stock Backflush and WO Closing

    Can someone provide more of a guidance to the backflushing feature when it occurs in work order closing? at what point does it trigger the new stock transaction to consume the "remaining" quantity of the components? outside of the product-site record…
  • 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…
  • Allocate Cases before Eaches

    The business need is to set up allocation rules that always allocates cases of product, regardless of the setup on the product record. For example, on the customer tab of the product record the unit is EA (each) If a case of that product is equal to 12…
  • 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?
  • Mass Update Product Pricing

    What would be the safest way to mass update the pricing for all the product in the system. On the product site- Under the cost tab I want to update Standard cost for all the products.
  • Tables Being Used in A screen Stock Location Inquiry

    On of the inquiries under stock is "Location. How can I add the price to this inquiry. Also, if I can setup a query without altering the screen that would be ideal as well..
  • Inquiry Screen Product Pricing Stock

    Is it possible to get the product prices to show up on this screen. Or does anyone have an SQL Query setup that would do the trick?
  • 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.
  • Intercompany Import SCS

    Has anyone been able to import using SCS and for an intercompany transfer? We modified the import a little and we are stuck with an error: :Non-existent Stock
  • Global Allocation and Cycle Counts

    I have sales orders that are globally allocated. I’ve allocated the entirety of the stock to sales orders Then I run a cycle count, and I decrease the stock I get no error message saying that the stock is globally allocated And then I check my sales…
  • 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…
  • Vendor Lot Number on Count

    Does x3 have a field where we can enter the Vendor Lot number on the count?Currently it only has the system generated ones.
  • 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…
  • 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…
  • 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…
  • RE: Stock Selection Object - How to display "Q" stock

    I am also on V6.5.This is what my window and screen look like. I do have a "SELECTION CRITERIA" button on the bottom right, which does allow the option to display all lots (A & Q). I just wanted to be able to view only stock coming off QC release and…
  • Stock Selection Object - How to display "Q" stock

    Hi, I want to add "Q" status stock to the STOCK SELECTION object (STO), so that customer service can view all lots (A and Q) WITHOUT being able to pick the "Q" status lot numbers. Is there a way to do this? I know under Setup - Stock - Allocation and…