Sage X3

Hi all, I need to set up a special sale rule: buy 3 product A, get free 1 product A & 1 product B. How to add 2 different types of product free in the same sale order? Thanks in advance for any advice,

Hi all, I need to set Sales policy with the criteria as below: Customer will get a discount of 10% if their invoice/ PO amount during last 6months reach 1 Million Does anyone know how to set this rule in Sage X3? Thanks in advance for any…

When calculating 1099 information payments which were imported is being ignored. On the log we do get a message warning "Payment currency differs from ledger currency" This is not a multi-currency environment Any ideas ? Thank You

Hi, We've noticed a few funny jumps in our average costs. Please see the attached example. Is this being calculated correctly? The product is set the FIFO costing valuation method so not sure why it's using order price here and then decreasing…

We noticed an interesting yet problematic scenario. We have two sites, let's say A and B. B supplies A(mfg suggestions), and A is set up as an intersite to B(intersite suggestion). The system allows a SOF with a ship site of B for a product even though…

Hey Everyone, About a year ago, someone had set up a "Fuel Surcharge" invoicing element that applies a $5.00 charge to every order. However, it was supposed to have tax excluded. To this day, the $5.00 charge is actually $5.60 because it is being charge…

Hello good neighbors of Sage City, I have a case where, for a direct type interco sale invoice, we need to "ventilate" and percentage type invoicing element on multiple analytical dimensions for multiple item lines. Let me try to explain a bit better…

Hi folks! We're in the middle of converting some of our products from MRP to MPS. We noticed on one product the MPS processing wasn't recognizing an existing WOF for supply and suggested an order(EOS) which it really shouldn't. We tested a few scenarios…

I've been trying things out in a testing environment to see how the MRP system works for making suggestions for orders and such. My company has a problem of seeing duplicate demand requirements if dates don't line up quite right. I have changed the bucket…

Hi, We both purchase and manufacture (it is a by product) the same product, however the WO costing always defaults to the Purchased cost, is there any around this to force the manufactured product to use the standard cost rather than the cost of the…

Dear All, I need your assistance on the below issue. Our client runs the Stock Valuation Report (STOCK12G) on a backdated date with 2 different configurations. Total Stock Valuation Report. (No checkboxes under ‘Subtotals’ are ticked) Total…

Hi, Question: Is there a simple formula for setting up the Maximum active queries number and its single main runtime limitation before considering Application Clustering with multiple main runtime? I usually observe Maximum active queries settings…

Here is my situation: - I am looking at the Costing > Production costs > WIP cost inquiry screen - For a particular work order, I want to know what version of standard costs for the product is used to calculate the standard cost numbers given on the…

Hello, I have genrated WOF with date 01/04/23. Let's imagine this article calls in BOM to one component XYZ. I would like to get a need for this material not with date 01/04/23 but 2 weeks before. How I can do it in sage X3? Should I look for this…

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. …

Hello fellow citizens, For a sold product we have a customer/product sales price list using a minumum quantity of 10 items. The same item can also be consumed in service requests, but there we do want to allow quantities less than 10; a single item…

Hello, We use Netstock which has a "velocity" identifier that tells you in layman's terms how fast a product sells. It is separated into three main classifications: A, B and C and then three velocities: High (H), Medium (M) and Low (L). I am not sure…

Hi - I have a client that uses Average Cost valuation for inventory and wants to calculate Actual Cost for work order completions. I understand that the Provisional Cost can be calculated either at creation of the work order or manually. There are 3…

Hi team, We are facing a situation where user created a PO that was full approved and started receiving invoices. The invoices were to be offset from that PO. The first two invoices went in correctly now we have received the third invoice but unfortunately…

We're exploring using the subcontracting functionality in X3. First thing I noticed is I'm not getting any supply suggestions from MRP. The product site record is set to subcontract suggestion and there is a subcontract BOM. Other than being a subcontract…

Hi can anybody clarify for me how MRP handles the safety stock level on the product-site record where the product is version managed? if we have multiple active versions of the product - lets say 3 and we have a safety stock level set at 10. does…

In the cases of manufacturing where we have multi-level BOM's for a brand new product. We had one of the levels that was not closed and costed before it was consumed to the next level. As a result the last receipt cost of the top level is off by the variance…

We have changed the MD6 data type to accommodate 6 decimals (11.6#). The field will accept the 6 decimals but when entering a Purchase Order however the price (GROPRI) rounds to 5 decimals when we save the order. (5.123456 saves as 5.123460) Any idea…

Does X3 create operations for suggested work orders? I have the ROP set for MRP pegging and have the load calculation on for the requirements parameter but not seeing operations for suggested work orders. Routings are out there.

As of July 1, 2022 Colorado has imposed a Delivery Fee of 27 cents on every order with a Delivery Address in Colorado. Sage does not pass Zero Invoicing Elements to Avalara, so the way around was to add two invoicing elements one with +1 cent and the…