Language:


Autotransactions - Example Automatic Autotransactions

In the previous example, when we entered an Autotransaction in a Purchase Invoice, its effects were visible immediately. As the Purchase Invoice was not saved at this point, we could then change any of the Purchase Invoice rows, including those that were added and calculated by the Autotransaction. For example, we could remove the row posting to DEPT2 and add that amount to the DEPT3 row.

In some situations (for example, calculating a second tax in addition to VAT that is not included in the price), the ability to change the effects of the Autotransaction might not be necessary or desirable. In this case, you might want the Purchase Invoice to contain a single row posting to an Account, with the results of the Autotransaction not being editable and only being visible in the Nominal Ledger.

To use this feature, first define the Autotransaction that calculates the extra tax:

Then, enter the Autotransaction in the Aut. Autotrans. field in the Account record:

Use the Account in a transaction such as a Purchase Invoice as normal:

The results of the Autotransaction are not shown in the Purchase Invoice. But, in the resulting Nominal Ledger Transaction, the Autotransaction causes the extra tax to be calculated and posted to the correct Accounts:

In this example, the Aut. Autotrans was attached to Account 440. The extra tax will therefore be calculated by applying the percentages in the Autotransaction to the amount posted to that Account (3% of 1000.00 in the example). The Don't Swap Debit & Credit option is not being used in the Autotransaction and in the first line the percentage was entered in the Credit field, so the result of the percentage calculation will be placed on the opposite side to the original. In the second line of the Autotransaction, the percentage was entered in the Debit field, so the result of this calculation will be placed on the same side as the original. This means we can use this Autotransaction in both Invoices and Credit Notes.

Unlike other Autotransactions, Automatic Autotransactions will not change the original posting (to Account 440 in the example). So, you cannot use them to distribute amounts to different Objects as was illustrated in the previous examples. You can only use them to add extra postings to Transactions. Therefore, you should not use the ! character in the first line of these Autotransactions. You can use # in the Objects field if you want to copy the Objects from the original posting to the extra postings.

This is a very powerful feature, to be used with care. It extends the reach of Autotransactions from Purchase Invoices and Expenses to Invoices, Stock Depreciations, Productions, Receipts, Payments, Personnel Payments and Cash In and Cash Out records. Each time you use an Account with an Aut. Autotrans (Account 440 in the example) in any of these records, in the resulting Nominal Ledger Transaction, the extra tax will be calculated as illustrated above. In the case of a Sales Invoice only, you can disable the application of the Autotransaction in Credit Notes using the Don't use Aut. Autotransactions on Credit Notes option on the 'Credit' card of the Account Usage S/L setting in the Sales Ledger.

A second example where Automatic Autotransactions can be used is in Poland, where companies producing their own goods need to post two sets of cost accounting postings when removing those goods from stock. The first set will debit the Cost Account and credit the Stock Account as normal, while the second set will debit the same value to a second Cost Account that depends on where the goods are produced and credit a Cost Reconciliation Account. This second set of postings will be generated automatically from outgoing stock transactions if you specify an Autotransaction in the Aut. Autotrans. field in the main Cost Account. This Autotransaction will debit 100% of the stock value to the second Cost Account and credit 100% of the stock value to the Cost Reconciliation Account.