# Auto-Apply in AR via SQL

- URL: https://dynamicaccounting.net/auto-apply-in-ar-via-sql/
- Date: 2008-10-22
- Topics: SQL & Data, Payables & Receivables
- Type: link to an external article
- Source: http://ibisinc.com/

Arun at [I.B.I.S.](http://ibisinc.com/) pointed to this surprisingly old and [surprising useful article on auto applying AR via SQL](http://archive.devnewz.com/devnewz-3-20041103ProgrammingAutoapplyinAccountsReceivable.html). Essentially it looks like the transactions to apply are added to a temp table in SQL and then the SQL routine goes through the temp table and applies the payments.

This give you a a 4th option for auto applying AR (Interface, Integration Manager, eConnect, SQL) before you have to go to custom programming. I haven’t tried this yet so all the usual use at your own risk caveats apply. If someone plays with it let me know how it works.

Note: SQL Code is included in the article.