We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

SQL to find the Costs used by S&OP / DM . We are stand alone implementation

Received Response
edited Jun 2, 2019 3:22PM in Supply Chain Planning and Collaboration 2 comments


SQL to find the Costs used by S&OP / DM



We are implementing S&OP using FBDI uploads (Stand alone).

We are looking for SQL to identify which items are missing the cost of the items at the Org level. How do we identify this from front end? We have lots of Organizations and this is a challenge. We are planning to develop a BIP report which can address this data exception.

Issue is -we are unable to find backend table where the item costs are stored. It does not look straight forward to me.

Looking for help from Community to provide 'sql' query to find the items with zero cost.


Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!