WIP Inventory!

[cap.zadi]

Hi every one.

May some one can help for the right design to manage the WIP control.

There is are three process stages A, B & C.



* Process A to produce certain Qty of a product as table given below and entered data via FrmA:
TblA
ID
PrdnDate
CartNo
Product
Qty
Transferred (Yes/No) *Default Value "Yes"
Notes

* Process B to hold the qty being produced by Process A for certain days and major information required to be:

CartNo
PrdnDate
Product
Qty

* Process C to use the quantities as required and data entry to be used by selecting the CartNo from combobox via FrmC and make inspection of the Qty either good or rejected.

Requirements:
a. How to have central Process B WIP record? Which is produced by A but being not utilized yet from Process C?
b. If the CartNo is selected via combobox at FrmC then it should not be any more available in Process C WIP record.

How these two requirements can be met from the above scenario.

Regards

[orange]

I have no direct knowledge. I did find this on WIP via Google and it might be helpful.

Good luck

[cap.zadi]

Hi

Thanks for the feedback and efforts.

Actually its not the same as shown in link.

Its very simple to have WIP production between two processes.

Hope for any further help.

[cap.zadi]

Hi

Is it possible to generate a QryBWIP as any item produced at A and status is "Yes" would be populated by query which is much easier but the issue would be how to delete this item when selected via Combo Box at C for further use.

Kindly advise.

[cap.zadi]

Hi

Any help please?

[CJ_London]

think you need to provide some example data. At the moment my interpretation is you need one table based on processA but with a good/rejected flag, then a select query for processB and an update query for processC to update the flag. You seem to be wanting to apply an excel type methodology to your data storage

[Minty]

I'm with Ajax. We need to see a sample of your data, and your desired query result.
At the moment it sounds like you aren't applying a business process to the data but data to a process, which probably won't work.

[cap.zadi]

Hello; Thanks for your efforts and sorry for my late feedback.

I already enclosed a sample DB for your review.

Notes:

a. DCar is a steel structure carrier which carries the products from Process_A to Process_C via Process_B (*This Process is just a closed channels which provide heats and treatment to products to get it dry well before out).

b. DCar numbers are unique and marked on each frame.
c. Once the DCars reached at process_C (after 2/3 days based on pushing rate of channels) then products are unloaded and inspected. The good products again loaded at another type of big steel structure KCars.
d. The emptied DCars send back to the Process_A to reloaded again which will again loaded may at different machine line and product but will tagged with key fields like PrdnDate, Product, etc.

Requirements:

a. At Process_C: At the start of the shift via Form "FrmProcessC_Head, The Operator should be able to select the product List available in Process_B (Off course Produced by Process_A) via form "FrmProcessC_Tail". Once he select the Product then only related DCars should be shown in the selection list of "DCars No" at form "FrmProcessC_Tail1".
*The DCars which are produced at ProcessA should shown in the above criteria after 3/4 days time.

b. The loaded by products Dcars which already emptied should not be available any more in the ProcessC WIP inventory and to the selection list.
c. What is the way to maintain the WIP at Process_B which is actually virtual in DB.
b. What is the way to let the Process_A have the queue list of empty Dcars to select for uploading again.
c. Is it good method to select the reject reason as field headings? Because against one Dcars transaction, there can be more than one reasons of rejects.


I hope that i am able to explain it well now.

Once again, thanks for your efforts in advance.