• Ability to Set Rules Based on Substatus in the Allocation and Issue Rules Definitions

    Currently in the system the Stock Management Rules allows for issue rule definitions based on the stock substatuses (i.e. A1, A2, Q1, Q2, R1, R2, etc), but the Allocation and Issue rules does not allow for that level of rule specification. It would be…
  • 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…
  • 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
  • Amélioration de la présentation du résultat du calcul du stock de réappro. (Fonction FUNSTKB "Stocks > Réapprovisionnement > Réapprovisionnements hors MRP").

    Pour une meilleure lisibilité du document, il serait utile que l'on ait une seule ligne pour chaque article. En présentant les colonnes suivantes : 1. Site 2. Code Article 3. Intitulé Article 4. Quantité 5. Unité 6. Transaction de suggestion.
  • Allocation priority by qty ordered vs qty in location?

    Is it possible to designate in X3 that when a customer orders x number of a product that it will look at location 1, but if it will deplete the stock to say 20% then it moves on to location 2 rather than deplete the stock in location 1 or have a split…
  • MRP Starting Stock

    MRP Starting stock What is Starting stock in MRP? A variable is used to maintain the quantity of stock available throughout the MRP process. This available stock is updated by .. initialized to the quantity of stock available at the start of the…
  • How to allocation goods of sales order by location, ignoring LOT, FIFO, FEFO, LIFO?

    The customer has several shelves as stock location. The problem is that the customer does not work with FIFO rules to allocate sales orders, he needs that when allocating a product the system takes all the available quantity in that location ignoring…
  • 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…
  • Adjustment of stock shortages: the receipt of a back to back purchase order should be allocated to the corresponding sales order.

    The receipt of a back to back purchase order doesn’t automatically be used to adjust the short storage of the corresponding sales order thru the stock adjustment. The received stock is automatically allocated to the oldest sales order, but it should…
  • 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. …
  • 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…
  • 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.