Pages

Tuesday, May 30, 2017

Order Management Setups

Order Management

RFQ --> Quotations--> Receive po from customer
Enter Sales Order --> Book Order --> Pick Release -->
ship Confirm. --> Create AR Invoice--> Create Receipt -->
Trasfer to GL --> Post to GL

--//AR Setups for Order Management---------
1. Define AR Responsibility
2. run replicate seed data
3. System Parameters (If not defined OM form will not open)
    AR --> Setup --> System --> System Options

Realized Gain Account
Realized Loss Account
Tax Account

--//Define Customers----------

--//Define Transaction Types-------
Sales order Line
OM -> Setup --> Transaction Types --> Define
1. Transaction Type
2. Document Type - Sales Order
3. Order Category - Order
4.  Transaction Type code - Line

Same need to do for Header Transaction
OM -> Setup --> Transaction Types --> Define
1. Transaction Type
2. Document Type - Sales Order
3. Order Category - Order
4.  Transaction Type code - Order
5. Fullfillment Flow - Workflwo - Order Flow Generic
6. Effective Date
7. Default Order Line Type
8. Select Assign Line flows - Line flow Generic

--//Defind document sequnece (To Generate Order Sequence Number)
OM -> Setup--> Documents --> Define
OM -> Setup--> Documents --> Assign

--// Define Pricing Responsibility
sysadmin -> security -> responsibility-> define
menu: QP PRICING MANAGER
Name : QP Concurrent Program
QP: Item Validation Organisation


Define Price List
Pricing -> Price list --> Setup
Name : Price List Name
Currency : Default
Global - Check
Product Context : Item
Producct Attribute - Item Name
Product Value : Item
Value : Cost of goods

--//Define Shipping Method
OM->Setup-> Shipping-> freight Cariers Cast Type -> Freight Cariers
Define the New Freight and Assign to Organisation

--//Define  Item Validation Organisation
OM -> Setup -> System Parameter -> values
Item Validation Organisation

--// Define Document Set for Pick Release
OM-> Shipping -> Setup -->  Documents -> Document Sets
Usage : Pick Release
Application: Shipping Execution
Report Name :
1. Pick List Report
2. Pick Selection List Generation

--// Define Document Set for Ship Confirm
OM-> Shipping -> Setup ->  Documents -> Document Sets
Usage : Ship Confirm

Report Name :
1. Bill of Lading (Staging to customer)
2. Packing Slip Report
3. Vehicle Load Sheet Details
4. Commercial Invoice

--//Define Release Sequence Rules
OM-> Shipping -> Setup ->  Picking -> Define Release Sequence Rules
Shipment Priority 1
Schedule Date 2
Order Number 3

--//Define Pickslip Grouping Rules
OM-> Shipping -> Setup ->  Picking -> Define Pick slip grouping rules
Order Number
Customer
Shipment Priority

--//Define Staging Sub Inventory
Inventory -> Setup -> Organiations -> subinventory
Name : Staging Sub inventory

--//Define Ship Confirm Rules
OM -> Shipping -> Setup -> Shipconfirm Rules
Ship Confirm Rule - l&t
Defer Inteface - No
Create Bill of Lading - Yes
Document Set - L&T ShipConfirm Document Set

--//Create Shipping Parameters
OM -> Shipping -> Setup -> Shipping Parameters

--//Define Transaction Type for AR Invoice
AR-> Setup -> Transactions -> Transaction  Type

--//Define Source for AR Invoice
AR-> Setup -> Transactions -> Sources
Name:
Type: Imported
Description:
last_number : 1000

--//Assign Finance Information to the OM Transaction Type
OM->Setup -> Transaction Types -> Define
Finance Tab:
Accounting Rule :Immediate
Invoice : Arriars Invoice

--// Define Role
OM-> Shipping -> Setup -> Grants and Roles Definitions -> Define Rules
Name:
Disable all Trips Stops

--// Define Grants
OM-> Shipping -> Setup -> Grants and Roles Definitions -> Grants
User : L&T Ravi
Role : Upgrade Role

--// Create Sales Order
Enter Sales Order
Book Sales Order
Pick Release
Inventory  -> transaction -> Transact Mover order
Find Move Order with MO nuber
select line and transact.

OM -> Shippping Transactions
Action -> Auto Create Deliveries
Action -> Ship Confirm
Find Shipping Transaction line status
Find Sales Order line stats
Submit wf bg process


--//ATP Rules (Available to Promise)
Schedule Date

Primary and Secondary Price list

Define Primary Price List
Pricing -> pricelist -> pricelist setup

Define Secondary Price list
Pricing -> pricelist -> pricelist setup

Define Item Cost Values in Second Price List

Assign Secondary Price list to Primary Price list
Pricing -> pricelist -> pricelist setup

Query for Primary Price list
Go to Secondary Pricelist Tab  and assign to it
Give Precedence: 140

Create New Secondary Price list (for RMA)
--> copy pricelist (secondary pricelist)
Precedence : 130

Precedence is the main thing which will decides to pick the price list


Modifiers & Qualifiers

Discount is example for Modifiers. We can Increase or Decrease the cost based on modifiers.

Types of Modifiers
1. Discount
2. Freight charges
3. Surcharges (service Tax)
4. Promotions

Criterial to give discount to customers: 
1.) Based on amount , If the customer qualify then we will give the discount to the customer. If amount > 10000 then will get 1000 discount.

2.) Based on Item : If you purchase any item you will get flat discount 30%.

3.) Based on Stock (category) : If you buy perticular items. (dead stock category). For new stock we wont' get discount.

4.) Based on Location ( anniversary sale) : If any branch opens and need to give discount on whole items.

5.) Based on Customer: Giving discounts to only perticular customer who shops regulary.

Types of Applications
Percentange
Amount
Lumsum
New

Define Discount Modifier
Pricing -> Modifiers -> Modifier Setups

Promotional Modifier

A promotion item is a free item which is giving while you purchase an item. It may be service item when you buy any item. If you buy AC you will get the installation free. Installation is service item.

If customer buys LED Tv he will get the DVD player as Promotion Item.

Buy 1 Get 50% Discound on Second One

Create Item --> Purchased Item --> Assing item to organisation
Define Promotional Modifier

Deals 
are same as promotions

Processing Constraints

Create Order
Delete Ord)er 
Update Order
Cancel order ( Can be cancelled before picking material Shipping)


RMA Sales Orders

(1) Enter SO -> Book SO -> Create Receipt -> Create Credit Memo
2) Enter SO -> Book SO -> Create credit Memo
3) Enter SO -> Book SO -> Create Receipt -> Credit New Line -> Pick release -> Ship Confirm

1. Create Transaction Type
OM -> Setup -> Transaction Types -> Define
Transaction Type : PR_so_line

2. Create Transaction Type for Ship Only
OM -> Setup -> Transaction Types -> Define
Transaction Type : PR_Ship_only
Trasaction Type code : Line

3. Create Transaction Type for retrun with receipt credit only
OM -> Setup -> Transaction Types -> Define
Transaction Type : PR_retrun_with receipt credit
Trasaction Type code : Line

4. Create Transaction Type for retrun with credit Only ( sevice items)
OM -> Setup -> Transaction Types -> Define
Transaction Type : PR_retrun_with credit only
Trasaction Type code : Line

5. Create Mixed Transaction Type
OM -> Setup -> Transaction Types -> Define
Transaction Type : PK_mixed
Order Category : Mixed
Full FLow: Order Flow : Generice
Price List : PR_Price List

6. Select Workflows for the Line Transaction Types
Query : SM_MIXED Trx Type

Assign Line flows -> 
Line Type : PR_STED_LINE
process_name : Line Flow Generic

Line Type : PR_STED_LINE
process_name : Line Flow Ship Only Generic

7. Define Document Sequencing
OM -> Setup -> Documents -> Define
Name : PR_MIXED_SO
Initial Values : 100

8. Create Document Assignments
OM -> Setup -> Documents -> Assign
Category : PR_Method
Ledger : SK _Ledger
Sequence : PR_MIXED_SO

9. Enable Item retunable
Inv -> Item -> Master Items
Query item -> OM Tab -> Returnable

10. Select Receipt Routing for RMA
Inv -> Setup -> Organisation -> Organisations
Query Organisation -> Receivable Information
RMA Receipt Routing -> Direct Delivery

Downloads:

OM SETUPS
https://www.youtube.com/watch?v=xa_iDFuUrcw
https://www.youtube.com/watch?v=IHbLldaSnZ4
https://www.youtube.com/watch?v=CvmrH-JyU1U&spfreload=5
Mixed Order Type
https://www.youtube.com/watch?v=4-PRnsurhUY
Oracle Pricing
https://www.youtube.com/watch?v=bv8HJ9FRk9w
https://www.youtube.com/watch?v=v06i4m2c0zY

Modifieres
Discount Types :-           https://www.youtube.com/watch?v=NJig84m3jBE
surcharges (service tax) :- https://www.youtube.com/watch?v=qLImbq-Dkzg

Processing Constraints
https://www.youtube.com/watch?v=ik0y4kaPCO8&spfreload=5

Internal Sales Orders
https://www.youtube.com/watch?v=Xt8nzlMQiIg
https://www.youtube.com/watch?v=T2QRUoDPiBE


Inventory Setups
https://www.youtube.com/watch?v=eVeHY04TiaE

RMA
https://www.youtube.com/watch?v=CvmrH-JyU1U&spfreload=5
https://www.youtube.com/watch?v=drUFii5xM4Q


Explain about Processing Constraints.
Processing Constraints are a security framework where you can define rules in Oracle Order Management that validate back-end operations such as Create, Update, Delete and Cancel.
a) You cannot change the Order Type in the order header once the order is Booked.
b) You cannot delete the line in an order once the Order Status is Closed (if the order is ship confirmed or invoice interfaced).

What are Defaulting Rules?
Defaulting Rules will autofill the attributes based on the rules which we define earlier.

What are Modifiers and Qualifiers?
Modifers are the discounts where we will apply for customers who are eligibile.
All the eligible customers were called as Qualifier.

No comments:

Post a Comment