Skip to Content
avatar image
Former Member

Using 'Not equal to' in condition record

Hi

I have a requirement where some products cannot be shipped if the customer country is not equal to Italy. I wanted to create an exclusion record to achieve this but at the same time do not want to maintain multiple records for different countries.

How can I maintain the not equal to criteria in condition record?

Thanks

Kumar

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Dec 12, 2012 at 01:26 PM

    Create a new routine in VOFM > Data Transfer > Orders,  where the coding logic can be for the field COUNTRY, except country IT, system should not proceed further if it is different.

    G. Lakshmipathi

    Add comment
    10|10000 characters needed characters exceeded

    • Satish Kumar wrote:

      I don't want to code this as business may decide to export the product after obtaining the required approval soon after the order is accepted.

      Not sure I understand the requirement completely... To my knowledge, there is no option to do "not equals" to in the condition records. Any special requirements need to be in the VOFM routine, like already suggested.

      You don't have to hardcode 'Italy', but there should be some indicator maintained somewhere for what is allowed to be exported to what countries. This could be somewhere in material master or a custom table, doesn't matter. If "business decides to export", they would just change an indicator for the country / material (whatever the requirement is).

  • avatar image
    Former Member
    Dec 12, 2012 at 06:46 PM

    Dear Satish

    The best solution for this is exclusion and you can avoid maintained huge data via creating a logical access sequence.

    And there are only 206 some  countries,so it won't be that difficult to maintain it.

    Thanking you!

    Ashish Mishra

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Sathish,

      You can maintain the condition record for any combination (Sales Org./Plant or Sales Org./Material) based on the business requirement, but for accessing this condition record you can maintain the requirement in VOFM routine that "if destination country is not equal to IT". So this condition record will be accessed only when the destination country is not equal to IT.

      If destination country is IT then it will not pick this condition record, so your order will not be blocked for exclusion.