×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

*
*
*
*

Thanks. We have received your request and will respond promptly.

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Anyone ever done a sales by item report and show the component items underneath?

thread639-1731593

Anyone ever done a sales by item report and show the component items underneath?

Anyone ever done a sales by item report and show the component items underneath?

(OP)
Item No
10 Units

Component 1
Qty per par
Component 2
Qty per par
Component 3
Qty per par

I realize this may not work, I've looked at IMORDHST etc and It only contains OE transactions that drive Production, not 'normal' transactions per say.

Thx in advance

Ivan

RE: Anyone ever done a sales by item report and show the component items underneath?

Single level or multi-level? Are you using forced demand=Pull?

Software Training, Implementation, Programming and Support for Macola Progression, Macola ES, Synergy, and Crystal Reports. Check out our Macola tools: www.gainfocus.biz/exceladdin.html

RE: Anyone ever done a sales by item report and show the component items underneath?

(OP)
Hi Don,

I've seen only very few items that are set to forced demand so I would have to say No on pull, when I say few I mean maybe 10 or 15 out of hundreds of item nos. So I think I may be out of luck no? Single level.

Maybe I could somehow assemble the BOM components and their qtys and calculate it all in Crystal?

Regards,

Ivan

RE: Anyone ever done a sales by item report and show the component items underneath?

If you were using forced demand = pull then you are manufacturing to order and I'd link to the IMORDBLD/IMORDHST tableS. Since that is not an option, just link to the BMPRDSTR table. I'd make it a subreport so you won't have duplication of sales data.

This will not give you the true usage by component, but you cannot get that anyway as there is no correlation between the OE order and the manufacturing order.

Software Training, Implementation, Programming and Support for Macola Progression, Macola ES, Synergy, and Crystal Reports. Check out our Macola tools: www.gainfocus.biz/exceladdin.html

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login
Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close