5 Comments for this entry

  • A3

    Hey denisfed, interested article & interested website.
    Thank you for sharing these two GL tables history.

  • Trond L

    Great article.
    We are posting huge amounts of GL transactions about 500.000 each month withing any locks.

    However we are seing locking situations on posting on compound customer accounts, (financial postings from gl journals).
    Have you done any specific tuning on cust tables in terms of indexing or programming enhancements to deal with locking situations on these tables.
    Trond

    • denisfed

      Hello Trond
      I really do not remember any customer-related tables with locking problems. I guess, you are dealing with some partner-made extension, which maintains a table with customer balance and this table, unfortunately, it locked on the same principle as ledgerBalances/LedgerBalancesDim in version 2.5.

      Regards
      Denis

      • Trond L

        Yes, I think that’s true, we have a field for balance of the customer account. I think this is a modification and not standard. So what you are saying is that this auto calculation (sum up of all transaction on custtrans) probably is the issue for locking situations?
        Trond

        • denisfed

          Hello Trond
          Generally speaking – it depends from the method of customer balance calculation. If your system has additional logic which updates a customer balance on the separate table during every update to custTrans – then locks on this separate table are unavoidable, you must change approach a bit.If your logic is just calculating customer balance by summing up custTransOpen per customer, then it should not create any issues.
          Another possibility is that you have automatic settlement enabled. Then on every posting of customer transaction, system tries to find and settle it to a suitable transaction (payment to invoice; invoice to payment). If several users are posting transactions for the same customers, they can run out into locking conflicts, because the same invoice can be suitable to several payments posted by different users at the same time.
          Did you try to find out (from SQL Blocked process report, perhaps) the name of the table which is causing locks ?

          Regards
          Denis

Leave a Reply