A return purchase order was issued for inventory that had been rejected by our quality department. The inventory was returned to the supplier and the RPO validated to remove the stock from inventory. Instead of issuing a credit memo, the supplier is going…
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.
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
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…
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…
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…
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…
1. Find below screenshot, for a particular item cost is booked while doing PO Receipt but when those items were sold it is not showing any cost for shipment entry under inventory out.
2. And for some items, it just suddenly takes some unrelated…