Sage MAS 90 and 200 Sage MAS 500 blogs Product Feedback Support Training
Reply
Regular Contributor
kwikool
Posts: 68
Registered: 03-06-2009
0

INVENTORY GIVE INCORRECT PRICING IN SALES ORDER

I have my parts set up as AVG costing....I am using price codes that are cost plus....the calculation does NOT use my avg cost. It uses LAST COST.... does anyone know how to make this work?   IF i am using avg cost  wouldnt make logical sense that any calculations using cost should come from the costing method I am using.....IS anyone at sage thinking??

 

 

Just a thought

Super Contributor
DFeller
Posts: 2,943
Registered: 10-28-2008
0

Re: INVENTORY GIVE INCORRECT PRICING IN SALES ORDER

Cost markup % and cost markup $ go based on standard cost no matter what your valuation is.

 

Dawn

Regular Contributor
kwikool
Posts: 68
Registered: 03-06-2009
0

Re: INVENTORY GIVE INCORRECT PRICING IN SALES ORDER

how silly is that ....   standard cost is something that must be MANUALLY entered.....if i have 3000 parts and my cost changes constantly  i need to manually check and adjust this cost....again i say  is anyone at SAGE THINKING??   additioanlly it appears that if standard cost is not filled out  it then defaults to last cost.....again  how silly is this.........somebody sure is NOT thinking at sage.

Super Contributor
DFeller
Posts: 2,943
Registered: 10-28-2008
0

Re: INVENTORY GIVE INCORRECT PRICING IN SALES ORDER

You can run imports to set your standard cost equal to another value such as average cost, on a periodic basis (e.g. once per day, twice per day, etc.) using Visual Integrator.

 

You can submit an enhancement request using the link in my signature.

 

Dawn

Super Contributor
rmikolainis
Posts: 1,251
Registered: 10-29-2008
0

Re: INVENTORY GIVE INCORRECT PRICING IN SALES ORDER


kwikool wrote:

how silly is that ....   standard cost is something that must be MANUALLY entered.....if i have 3000 parts and my cost changes constantly  i need to manually check and adjust this cost....again i say  is anyone at SAGE THINKING??   additioanlly it appears that if standard cost is not filled out  it then defaults to last cost.....again  how silly is this.........somebody sure is NOT thinking at sage.


 

Visual Integrator is your friend. Have your reseller help you setup an import job for this.

 

Don't own VI? Purchase it, it will pay for itself in a couple months with the time you will save from not having to manually enter data.

Sage Employee
clfisk
Posts: 79
Registered: 09-11-2009
0

Re: INVENTORY GIVE INCORRECT PRICING IN SALES ORDER

Under Inventory/Utilities there is a program called Automatically Change Price and Cost of Items. This can update the Standard Cost based on Average Cost.

Cletis Fisk
Regular Contributor
kwikool
Posts: 68
Registered: 03-06-2009
0

Re: INVENTORY GIVE INCORRECT PRICING IN SALES ORDER

can this be automated in some way to do automatically daily??

Super Contributor
DFeller
Posts: 2,943
Registered: 10-28-2008
0

Re: INVENTORY GIVE INCORRECT PRICING IN SALES ORDER

A Visual Integrator job can be scheduled.

 

Dawn