Oracle is so vast and flexible ,sometimes for simple questions many may not have answers including me !!!!
Is it possible to enter the price list by customer item ? Yeah it is possible to enter the PL by customer item ....How ? I will explain this in the next post
Friday 28 October 2011
Thursday 27 October 2011
Price Breaks and Partial Shipments?
Well ,Lets us see how we can connect these in a business scenario
I was discussing with business and we wanted to setup some price break for items .Lets say if the customer orders 1-100 the price is 150 and 100-230 is 100 dollars and
Lets say the customer bought 150 unites @ 100 dollars and suppose he wants to return 50 units
The system would suggest to give credit for 50 @ 150 which is 7500 which is 2500 more than the sold price
Well ,we might argue to use refrenced RMA's ....But these pratcial problem can still exists ....
I was discussing with business and we wanted to setup some price break for items .Lets say if the customer orders 1-100 the price is 150 and 100-230 is 100 dollars and
Lets say the customer bought 150 unites @ 100 dollars and suppose he wants to return 50 units
The system would suggest to give credit for 50 @ 150 which is 7500 which is 2500 more than the sold price
Well ,we might argue to use refrenced RMA's ....But these pratcial problem can still exists ....
Sunday 16 October 2011
Customer Service cannot change Bill-To
Customer Service cannot change Bill-To -This is one of the common requirement i heard among few clients .It does makes sense.As per SOX guidelines , a person who takes an order should not be able to chnage the Bill-To ,However there is no out of box solution for this .except to go to personalization or custom.pll change ,
It is also true that a person who creates the ship to in customer master should not be able to create the Bill to .This is also a SOX Violation ,These small issues might not look big from IT side ,But when it comes to business ...these are some real gaps .and could potentially result in a Big problem !!
It is also true that a person who creates the ship to in customer master should not be able to create the Bill to .This is also a SOX Violation ,These small issues might not look big from IT side ,But when it comes to business ...these are some real gaps .and could potentially result in a Big problem !!
Saturday 8 October 2011
No Place for Customer PO Price .
This is intresting ....?
Lets say you and your customers have pricing agreements Say for Item A Price is 100 $
and this is mainated in PL in oracle ,Now see the step by step scenario
Customer sends PO to CS with Item A as 90$
CS enters the order and find the price as 100$
CS Puts the order on hold ,Contacts customers and asks to re-issue the PO with the
correct price
How many times this can happen with the customer service and dont you think this would lead to less productivity of customer service and unwanted calls to customer on pricing errors becoz of customers not maintaining the agreed upon price in his system ...and re-issue of paper (waste of paper !!!! ) etc etc ..
When i was told ,the customer service does this process everytime when the price is wrong ,i certainly realized this would bring the productivity of the CS team down ! What could be a solution ?
I was exploring if there are any standard fields to store the customer PO price and run a report at the end of day/week to see all the orders where Original PO price and List Price does not match and take corrective actions wherever possible ,Unfortunately there is no such field and No place to store the customer PO price ...( Got to move to DFF /Other options ..)
Lets say you and your customers have pricing agreements Say for Item A Price is 100 $
and this is mainated in PL in oracle ,Now see the step by step scenario
Customer sends PO to CS with Item A as 90$
CS enters the order and find the price as 100$
CS Puts the order on hold ,Contacts customers and asks to re-issue the PO with the
correct price
How many times this can happen with the customer service and dont you think this would lead to less productivity of customer service and unwanted calls to customer on pricing errors becoz of customers not maintaining the agreed upon price in his system ...and re-issue of paper (waste of paper !!!! ) etc etc ..
When i was told ,the customer service does this process everytime when the price is wrong ,i certainly realized this would bring the productivity of the CS team down ! What could be a solution ?
I was exploring if there are any standard fields to store the customer PO price and run a report at the end of day/week to see all the orders where Original PO price and List Price does not match and take corrective actions wherever possible ,Unfortunately there is no such field and No place to store the customer PO price ...( Got to move to DFF /Other options ..)
Wednesday 5 October 2011
Sales Channel -Search
Oh my god ! This is why i call ,apps is a ocean ......and what we know is very little
Today i was trying to search orders in order organizer by sales channel ! and i could not find the field sales channel .Latter i found ...we cannot search orders in order organizer by sales channel and there is an enhancement request available for this ...WTH ????
Today i was trying to search orders in order organizer by sales channel ! and i could not find the field sales channel .Latter i found ...we cannot search orders in order organizer by sales channel and there is an enhancement request available for this ...WTH ????
Monday 3 October 2011
ATO -Supply
Well ! I have been thinking of writing ,It is mostly one of way of refreshing the knowledge base ..
Here is one interesting business scenario recently i encountered
Here is a normal ATO cycle in oracle
Enter order
Book order
Order Lines goes to supply eligible -This means ,the line is eligible to create a supply
If the item is internally built ,Then a WIP Job gets created
Once the WIP Job gets created ,WIP job is performed (I.e move transactions )
WIP Job gets completed .
Now ,the reservations moves from WIP to Inventory and Order line status moves from
Production Open to Awaiting Shipping
Picking accurs for the item
Shipping ,Now imagine during shipping ..the shipper could not actually find the item and the process for wherever he does not find the item ,he moves the goods to cycle count reservation.
The reservations moves from Inventory to Cycle count .
Here's is the catch ,What happens now to the sales order line ? The lines again becomes supply eligible and creates one more WIP ?
This sounds a little crazy to me ? and there should be some control over the supply creation ...
Just thinking of how we can avoid this problem ..
Here is one interesting business scenario recently i encountered
Here is a normal ATO cycle in oracle
Enter order
Book order
Order Lines goes to supply eligible -This means ,the line is eligible to create a supply
If the item is internally built ,Then a WIP Job gets created
Once the WIP Job gets created ,WIP job is performed (I.e move transactions )
WIP Job gets completed .
Now ,the reservations moves from WIP to Inventory and Order line status moves from
Production Open to Awaiting Shipping
Picking accurs for the item
Shipping ,Now imagine during shipping ..the shipper could not actually find the item and the process for wherever he does not find the item ,he moves the goods to cycle count reservation.
The reservations moves from Inventory to Cycle count .
Here's is the catch ,What happens now to the sales order line ? The lines again becomes supply eligible and creates one more WIP ?
This sounds a little crazy to me ? and there should be some control over the supply creation ...
Just thinking of how we can avoid this problem ..
Subscribe to:
Posts (Atom)