Thursday, 17 October 2013

Approved Supplier List

Approved Supplier List

Before Creating ASL, we’ll create items in item master. Navigate to Inventory Responsibility > Items > Master Items


Note: In order to reduce efforts copy items from finished goods template & give additional details as shown below





Now we’ll create PO for the above mentioned items with some suppliers not in our ASL


Navigate to PO Responsibility > Purchase Orders > Purchase Orders & give details as shown below



Try to approve this PO. You’ll get following error



Navigate to Supply Base > Approved Supplier List & give details as shown below



Initially the status will be new. Change that status to Approved. Go to Record Details Tab & change the Global field as Yes. With this the supplier will be marked as approved supplier for all Operating Units



Save the record.

Now again try to approve the same PO. This time you will be able to do that



Define Supplier Statuses: we can define custom supplier statuses. Navigate to Supplier Base > Supplier Statuses



Now whenever we open the ASL form to add new values we can see the custom status at line levels



ASL at Commodity level: Commodity is nothing but item categories. If we set ASL at commodity level then all items within that commodity will be covered. We can see the commodity value in Item Master > Tools > Categories



Give details as shown below



From the above form we can conclude that both the items we created will be covered in above mentioned commodity. In order to check this, create a new PO with same supplier



But when we try to approve it, we get following error



The reason why we are getting this error is because for this item we have already assigned another supplier. So we can conclude that the ASL given at item level will override the ASL given at commodity level.

In order to approve above mentioned PO (3006) we have to add Supplier 2 (with Pune Site) to the ASL of the item mentioned in line level.

Navigate to Supply Base > Approved Supplier List & add other supplier also to this list



Now create another PO with this new supplier & site details as shown below


This PO will be approved


Now navigate to ASL form & change the status of 1 supplier to debarred whereas at item level keep the status as approved




Now create a PO with this supplier details



When we try to approve this PO we get following error



Similarly if we reverse the arrangement, that is debar supplier at item level & approve at commodity level then also we’ll get same error so we can conclude that if an supplier is debarred at any level, we won’t be able to approve PO for that supplier.

The Details of ASL is stored in PO_APPROVED_SUPPLIER_LIST, PO_ASL_STATUSES & PO_ASL_ATTRIBUTES

10 comments:

  1. Nice blog. I have learnt so many useful concepts here. Keep up your gud work.

    ReplyDelete
  2. your blog is very nice, your method to explain the blog information with screenshot is very clear. Nice post.
    Supplier of Tool Steel

    ReplyDelete
  3. great post.... keep posting...

    ReplyDelete
  4. great post .... keep posting...

    www.viratsteels.com

    ReplyDelete
  5. Thanks for your detailed posts. They are rally helpful.

    ReplyDelete
  6. Very good and informative posts....

    ReplyDelete
  7. This comment has been removed by the author.

    ReplyDelete
  8. Thanq so much.your blog is looking so nice and good work keep up

    ReplyDelete
  9. This control will not be applicable in Blanket Agreement right?

    ReplyDelete
  10. Hi Vipul,

    Can I delete ASL records directly from PO_ASL_ATTRIBUTES table if I made a mistake in the "Global ?" column, i.e. instead of selecting "Yes", I selected "No".

    Thank you.

    ReplyDelete