Follow me here
oraclesupplychaincollabrate.blogspot.com
Sunday 27 July 2014
Monday 13 August 2012
WSH :ATO Retain Reservations
There are several reasons why a shipper can backorder at the time of ship confirmation ,Some of the reasons could be ..
The material could not be found at the staging area
Customer wants to cancels the orders ,Customer service seeking the shipper to backorder to enable
cancelling
But at the same time ,Backordering removes the reservations in a normal MTS orders ,Incase of ATO ,Oracle does provides an otion of retaining the reservation ,Otherwise the ATO Would create one more supply
WSH :ATO Retain Reservations controls whether we can retain the reservations at the time of backordering .
The material could not be found at the staging area
Customer wants to cancels the orders ,Customer service seeking the shipper to backorder to enable
cancelling
But at the same time ,Backordering removes the reservations in a normal MTS orders ,Incase of ATO ,Oracle does provides an otion of retaining the reservation ,Otherwise the ATO Would create one more supply
WSH :ATO Retain Reservations controls whether we can retain the reservations at the time of backordering .
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 ...
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 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 ....
Subscribe to:
Posts (Atom)
