De-activating payment terms

SUGGESTED

We have some payment terms we no longer wish to use. 

How can you de-activate those particular payment terms so that they cannot be used during order entry?

  • 0

    You can find all the BP customer or suppliers using this payment term and change it to the one you need. Most likely you can filter the left list of the BP using the advanced selection and selecting the related payment terms field as a filter.

    Alternatively, I believe there is an 'active' selection box on the actual payment term. However, then you may receive a validation error on entering transactions with a BP having this inactive code. So then you can just change the term on the transaction. It is better to use the first approach above and also set the term to inactive if you will not use it going forward.

  • 0 in reply to Phil Kennedy

    We are changing the payment term in the customer records, however, unless I am completely overlooking it, I did not see an "Active" check box or any validity date fields in the payment term screen.  The unwanted payment term is still available as a selection during order entry if the order requires an alternative payment term to the one defaulting from the customer record. 

  • 0 in reply to lcollari
    SUGGESTED

    You are correct, there is no active option. Also, you may not be able to delete the payment term since it is tied to prior BP transactions. So what you can do is rename the payment term to 'Do Not Use' or similar and also select the exclusion boxes for all 7 days of the week. If you need clarification on this suggestion, please create a support ticket; which I can no charge and review this with you.

  • 0 in reply to lcollari
    SUGGESTED

    Are you open sunday?  

    Set all the days excluded on except Sunday.  You can't exclude all days.  

    Set up a bogus company group and assign the one you don't want. Call it "BOGUS"  

    By entering a company group, you can limit the scope to companies in the selected group only. When this data is used for another record or with a setup element also defined in the group, a control checks that the groups have at least one company in common when the groups are different.  

  • 0

    On most object-managed records, there is a field in the table definition called ENAFLG. By default, within the record selection lookup, records with a column value of ENAFLG=2 will not appear as they are always filtered out.

    While I have not tested this, you could attempt to add the field ENAFLG to the table TABPAYTERM, validate the table, and then set the ENAFLG column to 2 for the payment terms you do not want users to use. You can do this through SQL or the table maintenance function. These records will still appear in the Payment Methods (Common Tables > BP Tables > Payment Terms (GESTPT)) menu, but they will not be selectable by users due to this field being set.

  • 0 in reply to Phil Kennedy

    Thanks.  The exclusion boxes did not prevent the term from being used during transaction entry.  I believe those are just used for due date calculations.  I may enter Do Not Use in the description but I'm looking for an option that doesn't rely on a user reading the description field.  

  • 0

    I attempted to set an Alt. Payment Terms and the less than amount at a very large amount but that did not prevent the term from being selected during order entry either.  I'll bring it up with our consultants and see if they have any suggestions.

  • 0 in reply to Regard Hulsbos

    Interesting proposal, Regard. Mr. Collari, I would just caution this is a change in schema and may also require additional source code modification, depending on the test results. This customization would then need to be maintained in any future upgrades and documented as part of your change control process.

  • 0 in reply to lcollari

    Then the only alternative is to add a custom Control action defined on the datatype. In doing so, it will apply everywhere the datatype is used, and you can restrict the use of certain Payment methods within the code.

  • 0 in reply to Stephen

    I cannot associate any group of companies with the payment term.

    I am trying to associate a group of Portuguese fictitious companies, in a payment term. The payment term is under the POR legislation; the payment method is under POR legislation, and the following error appears when I try to associate the group of companies:

    "Payment method: TRF & Legislation 'POR'
    Different company/site groups ( GRZ99 <> )"


    What am I doing wrong? There is a solution for this problem?

    Thank you for your help in advance.