What is the best way to find out material shortage/availability without creating job? There is no Sales order for it.
Idea is only create a job when 100% Material is available.
We have Bills of Material and demand Qty.
Is there any inbuild or standard EPICOR function/report which will tell us or it is a customization?
Production Planner Workbench will identify shortages (as they exist at job start date), but it requires some backup tasks - namely MRP and Production Planner Workbench Generation.
If your plan is to identify shortages based upon job start dates, that will work.
Additionally, you could constrain all items, that will definitely prevent jobs from being created prior to material availability (as defined by PO line release due date).
MRP will create unfirm jobs, and Production Planner Workbench includes all jobs - both released and unfirm - when evaluating and identifying shortages.