Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

MS - Forecast Consumption View

Status
Not open for further replies.

jdblank

IS-IT--Management
Sep 27, 2006
25
US
Progression 7.6.100a - MS SQL

Hello all:

We're seeing some strange records in the MS Forecast Consumption View. We drill down on our current period to see current demand orders, and we are getting Order Types = 'XXX' with order numbers from out of nowhere and no customer numbers. I checked OE line, master schedule, inventory transaction, mr requirements, im order build, and shop floor detail tables and those records are no where to be found. Does anyone have any insight?

Thank you.
 
I don't know about order type XXX, but what items are you master scheduling and what order types are you merging into the MS?


Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

"What version of URGENT!!! are you using?
 
Also what is the consume forecast flag set to on MS items?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

"What version of URGENT!!! are you using?
 
We forecast our finished goods and merge into MS. We also merge CO's and SO's. All items are set to = 'G'. Thanks.
 
COs and SOs?

Please Explain. OE orders and SF Orders?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

"What version of URGENT!!! are you using?
 
I think we're all set. These transactions are coming from an outside transaction and we need to fix. Thanks for the responses DG.
 
Actually, after further testing our data is coming in correctly.

For anyone that cares and future reference:

IM Transactions - Issues; these transactions actually consume your forecast in views and probably reports. However, it doesn't consume the forecast record in the msfrcfil table; it is strictly a view calcualtion.

JB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top