Sage X3

Hello, I am building and SQL query with itm ref and standard cost. We use simple manual standard cost (FY, dates and cost). I can join ITMFACILIT and ITMMVT, but what is the ITMMVT register applied to the aricle-site?

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…

I have been an X3 users for over 10 years (currently on v12; P18) but I am stumped on this one. It has to do with the standard cost calculation function (CALCSTSTD). I want X3 to calculate the std cost for items which all are contained in a single product…

The client would like to start using version management for products. Is it possible to have various versions for a product and yet the standard cost be based on Site and Product code without version? In other words version management only on the…

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…

Hello All, i am at a point of time where I need to update the standard costs of my items. Once I do that, how do I revalue my inventory stock so that my stock gets valued at the most recent standard cost and for any changes from the previous balance…

Hello All, I was wondering if there is a possibility to revalue "In Progress" work orders. This situations arises from the fact of changed standard costs for the new year. I would like to revalue my "In Progress" work orders using the new standard costs…

Hello, my question is in regards to which costing method is the correct/preferred method when working with subcontract orders. My company recently acquired SAGE X3 v.9 and we will start issuing subcontract orders. To add a little more complexity to…

I have a work order that did not have the correct routing for one of the components. Now that I have created the correct routing, how do I update the existing work order standard cost to reflect the updated routing? Thanks!

Hi, Is there a way to join the two tables ITMMVT and ITMCOST such that values of ITMREF,STOFCY from ITMMVT display when these are NULL for ITMCOST and values of ITMREF and STOFCY for ITMCOST display when these are NULL for ITMMVT. I can get the first…

I am trying to locate an X3 user that is utilizing standard cost on X3. I am trying to find out how standard cost works in X3. Kevin Brown Director of Finance All Systems Broadband 408-202-4445

Hi, We are using AVC valucation method for the raw material.. To calculate the standard cost, we are try to upload the standard cost.. but I got error "multi cost error" when i try to upload (ITC import template) the stand cost for the new product…

Does anyone have a template for any of these that they would be willing to share with me?

I was brought the question of why a dramatic change in the standard cost of an item that is in inventory did not create a journal entry to reflect the change in value. I noticed that the valuation methods on this particular product are setup as follows…

Hi All, I am a new to Sage X3 ERP. I also have extensive experience of SAP (FI/CO, SD, MM, PP, PM, HCM, modules) and have good understanding of how ERP systems work. As I mentioned earlier I am new to X3 with almost no training and struggle in pulling…