In our implementation ,we explored + ,- , & ,% and other special characters as delimiter .Finally decided to go with '-' .One of the disadvantages of using * as a de-limter is if you are using scanning devices ,Some of the font like code 39 translates * to a different character .
Monday, 12 March 2012
Star Item...
Oracle calls the uniquely configured item as a STAR item ,But star is just one of the option as a delimiter and has its own disadvantages ...
Monday, 9 January 2012
Order Number -Manual
Is it possible to have order number manual ? Yes ...It is possible .
Whenver we create a OM transaction type ,There is a document category created with the same name .We assign the document category to a document sequence to marry the transaction type and the document sequence .
If you need the order numbering to be manual ,You have to create the document sequence as Manual and when you assign it to the document category mark it as Manual.This would allow you to enter the order number manually by the user whenver this transaction type is used .
Whenver we create a OM transaction type ,There is a document category created with the same name .We assign the document category to a document sequence to marry the transaction type and the document sequence .
If you need the order numbering to be manual ,You have to create the document sequence as Manual and when you assign it to the document category mark it as Manual.This would allow you to enter the order number manually by the user whenver this transaction type is used .
Monday, 7 November 2011
HTS code -What is it
Well ,HTS code classifies goods to categories of crude and natural products, and from there proceeds to categories with increasing complexity.
How is it related to oracle .Actually for all the export related documentation ,like commercial invoice .The HTS code for the product is mandatory .As per the trade compliance ,HTS code should be displayed in the reports .Well where do i store it and what are the guidelines to find the HTS code ?
There are no standard columns in Item Master to store HTS code ,The option is to go to Flexfield/Context sensitive Flex/Item categories etc /Item catalog etc .However establishing this code would be a huge business activity if it is not there already .
These are some of the practical problems in the implementation.Wrong HTS code on the export documents also can get penalized ....
I wish Under Order Managment table ,There is a specific sub tab for EXPORT and capture the export related fields in that ....Adding to my Wish List .
How is it related to oracle .Actually for all the export related documentation ,like commercial invoice .The HTS code for the product is mandatory .As per the trade compliance ,HTS code should be displayed in the reports .Well where do i store it and what are the guidelines to find the HTS code ?
There are no standard columns in Item Master to store HTS code ,The option is to go to Flexfield/Context sensitive Flex/Item categories etc /Item catalog etc .However establishing this code would be a huge business activity if it is not there already .
These are some of the practical problems in the implementation.Wrong HTS code on the export documents also can get penalized ....
I wish Under Order Managment table ,There is a specific sub tab for EXPORT and capture the export related fields in that ....Adding to my Wish List .
Friday, 28 October 2011
Price List with customer part no ...
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
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
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 ..)
Subscribe to:
Posts (Atom)
