Small software made by AutoIt

Source: Internet
Author: User
Tags mssql server money back

First of all, I am not a computer personnel, but a financial personnel. Just hobby programming. So he taught himself the simple grammar of c,c++,c#,vba,autoit and so on. You can also use these programming languages to write some simple programs through VS (mfc,vc#), qt,excel, etc. (see my download resources). Some of these programs are designed to familiarize themselves with programming processes such as the simple version of the calculator (C++->MFC), and some are small tools for productivity (Excel Auto-match program, Bank Reconciliation tool). One of the most useful, can really be called the software incredibly is AutoIt write an accounting on the AR Account Reconciliation, SAP and other ERP software can not meet the requirements, because it is called a software, so involved in more aspects. I didn't upload it. Need to leave a message. Thank you!

I don't have a name for the software above. The function is mainly 2 chunks:

1, automatically do the account and clear the account. That is, the company's bank back to automatically do in the ERP system such as SAP or financial system. The accounting voucher number is automatically saved to where you want it.

2, the prepayment of the clearing account. If the bank return in 1 is a prepayment. In 1, the accounts are not cleared directly. The module is automatically cleared later by 2.

3, the Clearing account inquiry. If the customer wants to account for the money back. In this software is very easy to query, SAP and other software is very difficult, because the ERP software such as SAP are in your account on the basis of the query, if you did not reconcile it? For example, a customer's return is accidentally placed in the account of the B customer. When a comes to reconcile with you, you do not know the existence of this money back. You can say check the bank account. Since doing this software is because many enterprises of the bank every day a lot. Especially trade enterprises. SAP checks the bank account function is many, but is inconvenient, the speed also is too slow. For example, there is a customer called ABC company, they said we paid you 1000 yuan last month, let you check the account is not. SAP first in the XD03 to find out the ABC customer code, and then in the fbl5n to see the customer's account, if the account is indeed 1000 yuan is OK. What if not? I had to use GL's fbl1n to check the bank ledger. Then enter the amount and look for 1 months. Large amount of data. Wait a 3-5 minutes is normal. There are a lot of 1000 dollars. You can not immediately see which is the customer's payment and do other clients account, or simply put in the unknown.

Above 3 functions to improve the efficiency of accounting audit, input accuracy (can be said to be 0 error input).

3 Big functions also have specific small functions such as data upload, data export, edit the record of the account. The variety and fuzziness of query conditions, and so on.

Of course, there are imperfect places, for example, SAP in the clearing record only with the voucher level of the number information, and no specific billing number information, or even order goods invoice number information. Because the company also does not let us casually install software. I am using the SQLite file type database. If it's MSSQL SERVER, or MySQL, it can be extended a lot. Otherwise the DB file is too large after the amount of data is large.

Look at the software interface diagram:

The functions of 1 and 2 are all in the Command menu. Basically no interface, that is, you click on the menu, will automatically open SAP or activate SAP-related T_code, and then automatically enter or clear the account.

Small software made by AutoIt

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.