I’m assuming you want to sort by your site (maybe you only have 1 site, but many others have multiple), so I added that along with some other useful pieces of information that I would consider using from IPIS:select i.contract ,i.part_no ,nvl(s.qty_on_hand, 0) as QTY_ONHAND ,nvl(s.qty_res, 0) as QTY_RESERVED ,nvl(s.qty_transit, 0) as QTY_IN_TRANSIT ,p.safety_stock ,i.unit_measfrom inventory_part ileft join inventory_part_planning p on i.part_no=p.part_no and i.contract=p.contractleft join ( select contract ,part_no ,sum(qty_onhand) as QTY_ON_HAND ,sum(qty_reserved) as QTY_RES ,sum(qty_in_transit) as QTY_TRANSIT from inventory_part_in_stock_uiv group by contract, part_no ) s on i.part_no=s.part_no and i.contract=s.contractwhere i.part_status='A'--depending how you use Part Status in your Inv Part recordorder by 2I just wrote this as i
The above sequence only works if you haven’t paid the supplier. If you’ve processed an invoice, there are many more steps and it is much harder than just what is listed above. Can you let me know the steps that need to be performed when the Supplier Invoice for the PO has already been received and pain?
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.