Operation steps are as follows
The main interface is divided into: basic information, daily registration, book inquiries, the three major categories under the link to a variety of specific operations, respectively.
One of the Excel software requirements and settings
1, the use of this form Excel2003 production, before using the computer to ensure that Office2003 software has been installed
2, in Excel to enable macros, click on the "Tools - Macro - Security
1, in the main interface, respectively, click on the "goods information", "supplier information", "customer information", improve the three worksheets in the basic information.
2, these are the warehouse must be the basic information for the accounts, which the goods information in the code needs to ensure that each goods to ensure the unity.
3, if the original goods have been using Excel accounting, you can copy the original data to this system, pay attention to maintain the structure of the goods information worksheet, so as not to cause formula confusion.
Three, the inventory list and the inventory list data entry
This set of warehouse accounting form in the inventory list and the inventory list operation is basically the same, here to the inventory list as an example of how to operate.
1, in the main interface, click on the "inventory list" into the operation of the worksheet, the system has been automatically numbered for this document, and automatically use the day as the date of entry.
2, from the drop-down list, select the supplier, fill in the warehouseman, bookkeeper and other information.
3, respectively, select each line of the product code, product name, specifications, units and other information will be automatically entered. Enter the quantity and amount of goods, the unit price will be automatically calculated.
4, enter all the records of the current inventory list, check whether it is correct, and then click "Save" button to complete the inventory operation.