Hey everyone,
I should have clarified what i meant by All products scheduled.
The company That is interested in this Manufactures vitamins. They need a way to track when customer orders are scheduled to manufacture.
Every Customer Order has one or more items that they want us to make for them. Sometimes we call these items Products or Customer Products. We also like to refer to them as "Finished Goods" because every customer Item/Product requires a specific amount of one or more Raw-Materials/Goods. When the Raw Materials are measured and processed into a desired customer item/product we get one Finished Good. Customers refer to them as Bottles or Units .
I believe the confusion is coming from the schedule name. I think "Product Manufacturing Schedule" would be more precise to what this schedule is used for.
in my earlier question, what i meant was to see all "In Process" Customer Products aka Customer items scheduled. So that means every product for all customers that have placed an order.
"in Process" is a production status label. If a product is "In Process" then it can be scheduled for production because there is a sufficient amount of raw materials to produce it. If a Product/Item does not have enough raw goods to produce, then we label its production status according to what is missing.
Here is a list of the other the different production statuses,
tblStatusType STATUS IN PROCESS (cleared to start, Manufacturing cycle initiated)
BOTTLES/CLS - MSSING (Cannot schedule for production) LABELS - MISSING (Cannot schedule for production) NECKBANDS - MISSING (Cannot schedule for production)
POWDERS - MISSING (Cannot schedule for production) READY TO SHIP (QC passed Clear to ship)
FINISHED (Product shipped removed from Order Mngt "Active Orders list")