Technology
XML (Extensible Markup Language) is the standard for information exchange with external systems. Tally supports standardized message formats for Request/Response. Tally can communicate with any environment capable of sending and receiving XML over HTTP.
Tally can act as an HTTP Server capable of receiving an XML Request and responding with an XML Response. The entire Tally Data can be made available to the requesting application. It is also possible for the application to store data into Tally Database.
Using the same interface, Tally has the capability to interact with a Web Service delivering Data over HTTP. In this scenario, Tally behaves as a client retrieving and storing data into an external database. The Web Service capable of handling Tally Request/Response serves as a layer between Tally and External Database.
Commissions are primarily calculated on Revenue. Revenues are mostly based on sales vouchers entered in the accounting system. The various attributes of sales vouchers can be used in the calculation of commissions. In many situations, sales reps are directly associated with sales vouchers. This can be used in properly crediting the sales vouchers to the sales rep prior to calculating commissions. Other data attributes useful in commission calculations include Quantity, Amount, Customer, Product, etc.
A key requirement is the ability to only import transactions for the commission period that is being currently processed. The QCommission system automatically understands the date range being processed and only brings in the transactions necessary for proper calculations.
Sales vouchers normally go through two states: Enter voucher and Pay. Some customers pay commissions on entered vouchers and some when the voucher is paid. Some pay on both events. QCommission can understand the status of the sales vouchers and bring in only the sales vouchers of the right status to process. If sales vouchers change status in Tally later, it can update the status in QCommission and properly calculate and pay the right commission.
Occasionally commissions are paid out on partially paid vouchers as revenue is collected. In this case, it is not enough to just check the paid stamp on the vouchers. The payment voucher will also have to be imported and commissions released as payment is received. In this case both sets of transactions will have to be handled.
Other Transactional Data
Other transactional data that can be imported include Receipt Vouchers, Purchase Vouchers. QCommission can import these transactions and use them in calculations as well.
Master Data
In addition to transactional data, QCommission can import master data from Tally such as Customer, Sales Item, Purchase Item etc. The data imported can include the hierarchy structure. This becomes very useful in calculating commissions based on these various criteria.