Share your Success!

[lisle1]

I'm creating a report using SO_ SalesOrder Detail and SO_SalesorderHeader.   The report is set up to show the cost and the sell price for quotes.  We are running this report to make sure that our admins are not putting our sell price in as our cost.  The problem is the unit cost on SO_salesorder detail is pulling the average cost, not the standard cost.  Please let me know if you know a way to pull the standard cost for an item rather then the average cost.

[thebottomline]

Add the CI_item table to your report then use the standard cost field to your calculation.

Or you could create a standard cost UDF in the so detail file which would populate when the order is created.  Then use that field in the crystal report.

[lisle1]

I alreaday tried that.  I get the following error message.  Database Connector Error '50000ProvideeX)(ODBC Driver)(Fileio) unable to allocate memory to perform requested operation ( database vendor Code:14)

[thebottomline · Accepted solution]

Which did you try?  There are two suggestions.

[lisle1]

Sorry about that.  I tried the first then last night I created a UDF, which works.  However, I now have the problem if I add a line to the so it populates the standard cost in the UDF, but  if I change the standard cost on the fly  in inventory  the UDF has to be manually changed or create a new line and delete the old line.  Any suggestions.....

[thebottomline]

You can't override the UDF value?

What version of MAS are you running?  In v4.4, changing standard cost is more difficult to change on the fly.

[lisle1]

I'm running 4.4.  I just tested my UDF and it's pulling the average cost rather then the  standard cost.  It will pull the standard cost if there is not an average cost for the item.  Any suggestions?  FYI the it checked the UDF is set up to pull the standardunitcost.

[lisle1]

Sorry about that last posting. I'm doing too many things.   It should have read   

FYI Ichecked the UDF it is set up to pull the standardunitcost