azklasse
Member
Creativity Needed!
We have costs which vary depending on order volume which we pass along to the customer. In order to accurately do this, we are using lot based costing. The issue arises in the preliminary calculation of gross margin prior to ship confirm. Until Ship Confirm, the cost on the Sales Order comes from the primary location in the F4105 file which we loaded as the single unit cost -- the highest cost possible. The Purchase order correctly get the correct cost based on volume from the supplier catalog. At ship confirm, the correct price for the lot is brought into the sales order. (Cost changes are disabled for the users since this turns on the cost override flag.) How do we determine gross margin more accurately prior to ship confirm? (After Ship Confirm the lot is received at its correct cost & then assigned to the sales order.) Forecasting and monitoring of the sales team are next to impossible. We have orders which could be open for more than a year so accurately projecting profit is needed.
Has anyone creatively come up with a solution for this one?
Can Advanced Pricing be used to look up the cost from the supplier catalog and update the COST on the sales order? I am hoping that there is an easier way to do this without having to write a routine that updates the orders nightly. (I think that nightly would be frequently enough ... real time would not be necessary ... don't want to modify Sales Order Entry too much.)
Heather
IT Manager
SQL Server 2000, OneWorld 8.1
We have costs which vary depending on order volume which we pass along to the customer. In order to accurately do this, we are using lot based costing. The issue arises in the preliminary calculation of gross margin prior to ship confirm. Until Ship Confirm, the cost on the Sales Order comes from the primary location in the F4105 file which we loaded as the single unit cost -- the highest cost possible. The Purchase order correctly get the correct cost based on volume from the supplier catalog. At ship confirm, the correct price for the lot is brought into the sales order. (Cost changes are disabled for the users since this turns on the cost override flag.) How do we determine gross margin more accurately prior to ship confirm? (After Ship Confirm the lot is received at its correct cost & then assigned to the sales order.) Forecasting and monitoring of the sales team are next to impossible. We have orders which could be open for more than a year so accurately projecting profit is needed.
Has anyone creatively come up with a solution for this one?
Can Advanced Pricing be used to look up the cost from the supplier catalog and update the COST on the sales order? I am hoping that there is an easier way to do this without having to write a routine that updates the orders nightly. (I think that nightly would be frequently enough ... real time would not be necessary ... don't want to modify Sales Order Entry too much.)
Heather
IT Manager
SQL Server 2000, OneWorld 8.1