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