x Want to participate? Join the group to interact
  • State Verified Answer
  • Replies 2 replies
  • Subscribers 137 subscribers
  • Views 1000 views
  • Users 0 members are here
Browse Forums
Announcements
237
topics
29
replies
General Discussion
5k
topics
13k
replies
Sage Data & Analytics
56
topics
95
replies
Sage Enterprise Intelligence
211
topics
418
replies
Sage Intelligence Reporting
121
topics
322
replies
Christine T.

error- PAYLOT- record already exists

SOLVED
Posted By

I'm really hoping someone can help with this issue.  A user is receiving the below error creating a payment however she has created payments in past and she is entering the asterisk on the Batch field so a new batch record is created but seems to be reverting back to the first batch she created this year.  I don't understand why today and yesterday she is having this issue when she hasn't had before.  It is only on her user account as I can create the payment on my side.  There are no locks on the payment associated with the key in the error so I don't know what to do.

any ideas?  the user is deadlocked now as cannot create any payments due to this error.

thanks- Christine

  • +1
    verified answer

    Good day,

    Your sequence counter has become out of sync and the generated number causes a duplicate key error on insert to table PAYLOT. You have to reset the assigned sequence counter, first browse to Setup > General parameters > Sequence number definition and find the sequence number assigned to it. If it happens on payments, the counter you are looking for is defined on line 1 (or 7 depends on your setup) and if it happens on receipts then the sequence you are looking for is on line 2 (or 7 depends on your setup) under the AP/AR Accounting module.

    To reset it, browse to Development > Utilities > Miscellaneous > Sequence number values, filing in the current values and then increasing the "next value" on the screen to a higher number. Try again till you find the number that allows for creation.

    Kind regards,

    Regard Hulsbos

*Community Hub is the new name for Sage City