• Maximum stock setup in product site

    Hello, can anyone tell me how can I setup the maximum stock quantity for a product site. I tried adding it in product site but don't know how it works, the system still allows me to receive more stock. I need such a setup that once the maximum quantity…
  • Maximum stock limit in Sage X3

    Hello, can anyone tell me how can I setup the maximum stock quantity for a product site. I tried adding it in product site but don't know how it works, the system still allows me to receive more stock. I need such a setup that once the maximum quantity…
  • Default Locations within Product-Site

    All, We have default locations setup using product-site within our system. However, there are times when we need more than one location to store products because of space & their replenishment levels. My question, can you add more default locations…
  • View Archive Folder scripts from the Web Service script editor

    Hello, I want to make some modifications to SPEITM, but I noticed that our Sage x3 provider has done some of their own in a custom file, YSPEITM which they've called at the action runtime in SPEITM: Unfortunately, this script does not exist in the…
  • Product selection fields in Stock Inquiries do not match definition in ITM object

    When using the Product selection icon in any of the STOCK inquiries (Stock by site used for example), the fields in the pop-up window for selection are not those defined by the Product ITM object selection. Where can I find the field definitions used…
  • Resolve Pending Issues for Lot Managed products

    Hello wise people of the Sage City, For a customer we had allowed negative stock on ingredients/raw materials to prevent constantly having to stop production because tracking returns an error due to stock being unavailable. Allowing negative stock results…
  • Is it possible to automatically receive product in at a different UOM than the 'Stock unit'

    Would like to automatically receive product in as a pallet, but maintain a stock unit in cases. Thank you
  • Packaging Consumption in Work Orders

    I'm looking for ideas as to the best way to consume packaging in work orders. We sell products in various packaging....totes, drums, pails, etc. Currently the packaging is relieved from inventory at time of sales invoicing.....packaging codes are…
  • 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…
  • 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.
  • 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.