Browse By Tags

  • How to set up equipment on Sage 50 Premium to track expenses?

    How to set up equipment on Sage 50 Premium to track expenses (finance payment, maintenance, repairs, etc) towards the equipment, but also be able to cost a pre-determined hourly rate to a project ID cost code? Hopefully I can explain this clearly. I…
  • Costing

    hello i need your help when i produced a product another semi finish product produced like in the example: Raw Material: Sheet of steel, 100 cm x 100 cm Semi Finished Product 1: Metal bracket Amount of raw material needed: 50 cm x 50 cm Semi…
  • Can x3 make maintenance management ?

    Can x3 make maintenance management or it's necessary to establish the link to a CMMS software ? The ideia is to make projects, establish deadlines, objectives, costs and maintain process connected, and if it is possible all in the ERP.
  • Projects & Departments

    Hi All, I am after some advice. We currently use projects in SAGE 50 for costing purposes. We have, in the past had 5 or 6 projects (installation of different energy saving measures) under one contract for which we have separated out the costs & revenues…
  • How are Expected Costs calculated in Sage X3?

    Hello! We are finding that it's become near impossible for us to Close and Cost our work orders prior to our shipments. We run on average costs. To ensure our actuals are close to the expected, does anyone have a breakdown on how Expected Costs are…
  • UNIT COST

    Hi, I am sure this is a simple process, I need to update the unit cost of an item. I am only able to change selling price. When we enter a inventory adjustment the Unit Cost can be changed however we would like to change it so we can set it to default…
  • Sage 200 Costing Method

    Hi all We are a manufacturing company that currently uses Standard Cost for components, Standard Cost for Finish Items ( Batch production), and Actual Cost for Bespoke Finish Items. The problem we are having is regarding the Cost of Sales. We have…
  • Import Material Cost Variance

    Hello, We are on Sage X3 2019 R4 (12.0.19). We are importing raw materials and when the stocks are arrived, we need to issue those into production as we are in a tight planning schedule. Received materials will be issued to production with the average…
  • Expanding our use to include Sage Projects

    The company I work for is looking to ditch a separate job costing software it uses and replace it with Sage Projects. One of the biggest factors for picking the other package was not having to duplicate information but I am aware that there wont be able…
  • Sage 200 MRP BoM costing out of memory error

    Hi, We have about 8000 BoM's in our MRP system and we have been trying to get them costed for quite a while. But every time we try and do a full cost roll up, it errors with an out of memory exception error. Now I know you can do them by product group…
  • Manufacturing costing report (MFGCOST) not showing actual and expected values in operations

    Hi all, Our client uses the Calculate Expected cost function (Manufacturing) That prints the Expected cost type report without the actual and expected costs for these workcenters. I've attached reports how it is blank in the first image. However a few…
  • Cost Tier Adjustment

    Adjustments to inventory value are made using Process Cost Tier Adjustments task. Here are some important things to know about cost adjustments : Inventory Quantity cannot be adjusted through Cost Tier Adjustments. Quantities in the cost tiers are…
  • BOM component should not be consumed, but cost should be included in calculations

    For a customer we need to include regular stock managed components on a production BOM, but they should not be consumed when doing Production Tracking or when closing a Work Order. They do want to see the cost of these materials included in costs, and…
  • Standard Cost Calculation and BOM Codes

    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…
  • PJC Material Return Using different Costing Method

    When i do a materials return in PJC it is using the Most recent cost instead of the Average cost set on that item. Is there something that am doing wrong or a setting that i should change in PJC? Sage 300 2020
  • Are nested routings possible in a way that does not cause a cost composition issue when hitting the GL upon invoicing?

    Thanks to everyone for reading ahead of time! Question Is there a Sage, E2B, or other third part plugin, configuration, hotfix, or other solution that would allow for creating routings that nest other routings to help allow for machining of parts…
  • What is the difference between the Inventory Cost report and the Inventory Valuation report?

    What is the difference between the Inventory Cost report and the Inventory Valuation report? Why is there an option for both Cost and Valuation in the Cost report? The differences between the Inventory Cost and Inventory Valuation reports are primarily…
  • Cost Tier table schema

    The cost tier is an important costing feature provided by IM which allows the system to track the actual cost at which an item was purchased every time. Sage 500 stores the cost in table timCostTier . Here is the schema for that table: A cost…
  • WIP unbalanced journal

    Hi, on Sage X3 v11, we are getting an error when posting the WIP of unbalanced journal all the accounting codes are setup correctly. we've even put a default GL account on the chart of accounts to post to that account in case we've missed any important…
  • How to apply overhead?

    Hello everyone, I have been asigned to find a way how to apply our average over head cost, $1.62 a gallon, to our finished goods...(keep in mind i do nothing with this part of X3 in my position so im just walking through the dark) On the "standard…
  • Adjust cost of finished goods after WO closed and costed

    Hi, On Sage EM v11. we have a case where the users have created a WO, tracked it but did not track the labor time. They then completed, closed and costed the WO. which resulted in getting finished goods but with unreal cost. these finished goods…
  • Overhead cost rules for production

    Hello, I need to add an overhead cost on raw material used in a work order. We use the AVC valuation method with a calculated cost. Simple example: I need to add an overhead of 0.05$ per gram, based on the total Raw Mat 1 quantity ALLOCATED in…
  • Sub Contract - Cost variance not creating or posting to GL

    Hi; Verision 6.5 patch level 36 We have set up subcontracting for purchasing; the provisional cost is calculating correctly and the receipt value to GL and stock is correct. However; if the average cost of the raw material changes during the contract…
  • Average cost calculation

    Client has a few items with really far out Average costs. Supposed to be $1 and shows $950 Average cost. The MRC is good and last cost is good. Is there a way to fix the average cost? There was an adjustment done a few months back that was in error…
  • Trying to create a report in SQL that pulls all costs for an item.

    I am trying to create a report that pulls all OE sales by month and includes standard cost, average cost, most recent cost, last cost, alt cost 1 and alt cost 2. I can't seem to find which table or view has all of these costs. It looks like they are…