Buyer Creation

Buyer Creation

•         SELECT * FROM PER_ALL_PEOPLE_F WHERE EMPLOYEE_NUMBER=‘9’

•         SELECT * FROM FND_USER

•         SELECT FU.USER_NAME,PAPF.FULL_NAME FROM FND_USER FU,PER_ALL_PEOPLE_F PAPF WHERE FU.EMPLOYEE_ID=PAPF.PERSON_ID AND USER_NAME=‘3USER’;

•         SELECT * FROM PO_AGENTS

–        PK=AGENT_ID

•         Select the responsibility called HRMS management HRMS Managerà Peopleà enter and maintain à select New Button

•         Enter the employee details select as buyer save the transactions and attach the employee name to the user name in system administrator

•         Open the users form select person field enter the employee.Attach the emp name in the buyer list

•         Purchasing vision operations USA

–        Setup

•         Perosnal

•         Buyer

•         Include the employee name into the list

•         Requisition

•         RFQ (Requisition For Quotation)

•         Quotation

•         PO (Purchase Order)

•         Receipt

•         AP Interface and INV Interface

Supplier Creation

Supplier Creation

•         SELECT * from po_vendors where segment1=‘5078’

•         PK=Vendor_id

•         Select * from po_vendor_sites_all where vendor_id=989

–        PK=Vendor_site_id

•         Select * from po_vendor_contacts where vendor_site_id=2194

–        PK=Vendor_contact_id       

•         Select the responsibility called purchasing vision operations

–        Supply Base

–        Suppliers

–        Enter the supplier name+save no generates

•         Select the sites button

•         Backend:

–        PO_VENDORS

–        PO_VENDOR_SITES_ALL

–        PO_VENDOR_CONTACTS

P2P- Item Creation

•         Items Creation                       à Inventory

•         Supplier creation à Supplier,Site,Contacts

•         Buyer Creation                      à Employee of the comp, authority

Item Creation

•         Select the responsibility called “Inventory vision operations ”

–        Items

–        Master Items

–        Enter the item name and item description

–        Go to inventory tab and select the check check box inventory item.

–        Go to purchasing tab and check purchased.

–        SELECT * from mtl_system_items_b where segment1=your item name.

–        Select msi.segment1,msi.item_description, ood.organization_name from mtl_system_items_b msi, org_organization_definitions ood where msi.organization_id=ood.organization_id and msi.segment1=‘ur item’