Need vendor selection in purchase and finance module based on the category

Hi all,

I come across a requirement scenario which is a quite challenging subject for me as I am new to ERP world and the same time not in technical.

The requirement is as follows:

Vendors are differentiating by two categories only. They are  

  1. Purchase Module vendor
  2. AP Module Vendor

When a purchase module user login and perform vendor selection in any screen or any report the list of vendor information should be based on the Purchase Module vendor category not the combination of AP Module Vendor category.

When a finance module user login and perform vendor selection in any screen or report the list of vendor information should be based on the AP Module vendor category not the combination of Purchase Module Vendor category.

I hope any one can light up a solution.

  • 0

    It will not be easy but you can try following way. 

    Setup>Users>Row level permissions enter a  new row:

    - Object=BPS

    - permission code create new code or chose one from listed - let say BPR

    - field eneter BSGCOD (BPS category)

    After - Setup>User>User>Organization[Tab]  in Row level permissions grid choose permission code BPR and specify in key field your BPS categories to which you want grant access. 

    Test it - probably it will deny access to other categories - clients as well - then you will need to add additional conditions for them. 

  • 0 in reply to Girts Mazais

    Thanks Grits. Could you please tell me how can I add additional conditions and where, that you suggested in the answer.

  • 0

    Have you already decided how you will handle case when the same vendor is "Purchase Module vendor" and "AP module vendor"?

  • 0 in reply to G@G

    There is no case such Purchase Vendor in AP Module and vice versa.

    May I know why you asked a valid case which can be come up in future time

  • 0 in reply to RMT

    Ok - got a bit more time for test solution as well.

    What I did - created new Permission code [BPS] and entered into [Field] BSGCOD - which points to BPS category.

    For my test - as supplier are divided by countries - I choose BE supplier category(Belgium suppliers). 

    After -  edited user settings (module SETUP) and in Organization tab Row level grid -  entered permission code BPS and in key field specified BE as criteria. 

    As result - user was able enter invoices only from Belgium suppliers - but independent from invoice type (Purchase invoice and BP invoice).

    Ah - and it doesn't restrict any other BP category - only BPS.