1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

To flag customers in Oracle

Discussion in 'Oracle Financials' started by szouaoui, Feb 8, 2011.

  1. szouaoui

    szouaoui Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    55
    Location:
    Morges
    Hello,

    Customers in the customer master data section of Oracle can either be active / inactive. For customers whose contracts have not been renewed but for which we cant update to inactive customers due to incoming RMAs, balance not cleared etc, are there any ideas on how one could flag these customers for reference (active customers whose contracts have not been renewed)?

    Thank you for any inout I can get on this matter

    Samir
     
  2. Sadik

    Sadik Community Moderator Forum Guru

    Messages:
    1,906
    Likes Received:
    252
    Trophy Points:
    1,455
    Well it depends on how much control you want. We had a similar situation once, and we ended up having a Customer Status as Permanent or Temporary in a DFF on Customer Master. But the main issue is whether you want to stop anyone from able to perform a invoice/receipt related transaction on that customer or just have a descriptive status field to be used in custom report?
     
  3. szouaoui

    szouaoui Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    55
    Location:
    Morges
    Hello Sadik,

    Thank you very much for your answer - really appreciate it. The idea behind this is not so much about stopping anyone from being abe to process an order for such a customer (the customer is put on credit hold so no order can be booked) but more for a reference for the whole organisation to have - as you say as a descriptive status field on the customer master data level? Any ideas how can this be done?

    Regards

    Samir