• 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…
  • Shipment Pre-receipt not updating expected receipt date on the ORDERS table

    Hi! I'm using the pre-receipt of shipments for purchase orders being imported. Acording to the X3 help, this function should update the EXTRCPDAT of the pre-receipted order in the ORDERS table, even though it doesn't update the original expected date…
  • 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
  • Get a new function dedicated to a mass updating of the Average Unit Cost of the product-sites.

    The Average Unit Cost of a product-site can be adjusted thru the FUNCHGVAL Value change function. But, only one product-site can be processed at a time thru this function. Suggestion : get a new function dedicated to a mass updating of the AUC of…
  • Get a new “Average lot cost evolution per movements” inquiry (as the CONSSMA inquiry) dedicated to the lot managed products with a lot average cost valuation.

    In this new inquiry, the criteria Site, Product and Lot will be entered. The stock movements will be filtered by Site, Product and Lot in this inquiry. The purpose of this new inquiry is to easily identify the evolution of a lot average cost between…
  • Suggestion to easily change the Average Unit Cost thru the stock function FUNCHGVAL “Value change”.

    The current (or earlier) Average Unit Cost of a product-site can be changed thru the function FUNCHGVAL “Value change” (Stock > Utilities > Valuation > Value change). So, the “Average cost” field should be entered in this function, in order to directly…
  • Displaying a warning message to avoid negative valuation in the purchase order and receipt lines.

    Erroneous negative valuation in the purchase order and receipt lines, when using discount invoicing elements with decrease amount. Suggestion: displaying a warning message to avoid this result. Example: purchase order with a single line. Tax excluded…
  • 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…
  • De-Assignment by Orders

    The client is utilizing assignment rules where when a PO/SO is created, the system will automatically assign it to a existing SO/PO. This is to provide them better visibility on the expected delivery to the customer. However, sometimes they will received…
  • 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?
  • Containers and intercompany orders

    Hi In U9 it is not possible to pick intercompany orders from the left list in Container function. (See Jira X3-95453). This is clearly mentioned in the GESGCTRH - Container on line help, in the Limits paragraph. So I am reporting this as an enhancement…
  • 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…