Database

[zsyed]

We've an ERP application built on SQL 2008 Database. We've peculiar issue with our database in one aspect.
We've configured to use Average cost as our inventory costing method. Sometimes part issue to job / sales order transactions take last receipt unit cost as against an average unit cost.

The problem is sporadic. We cannot replicate in isolation. Wondering any database maintenance required? Appreciate any thoughts.

Cheers,
Zaheer.

 

[Borvik]

There isn't anything in here to indicate what kind of SQL problem you are having. Instead it sounds like you are having an issue with your ERP software (which sounds like it could be forum632). Please try the correct forum for your ERP software.

 

[zsyed]

I was not sure whether it is database / ERP issue. since, it is a SQL database I thought to post in this forum. Anyhow, Thanks for pointing me the direction.