SPEEDA 3000 HOW TO IMPORT THE INITIAL DATA IN EXCEL IN THE INITIAL INVENTORY ENTRY

The specific steps are as follows:

1. First of all, turn on the computer and log in to the speedy software, click on business management - procurement management, as shown in the figure below, and then enter the next step.

2. Secondly, in the Procurement Management option, click on the "Purchase Receipt" option, as shown in the image below, and then proceed to the next step.

3. Then, pop up the purchase receipt page, as shown in the figure below, and then enter the next step.

4. Then, look at the record details below, find the column of product name and content, fill in the records in order, start from the first row, click on the blank space, a drop-down menu option will appear, you can choose to record the product, as shown in the image below, and then go to the next step.

5. Finally, click "Save New" to complete the operation, as shown in the following figure. In this way, the problem is solved.

1. First of all, open the computer and log in to the speedy software. On the left side of the software, there will be some menu bars, find "Business Management" - "Procurement Management".

2. Then in the Procurement Management option, click on "Purchase Receipt".

3. Click to enter the purchase receipt page, there will be many options to choose at the top, and the circle is required, otherwise the list will not be printed, and it will not be saved.

4. Then, see that there will be a recording detail below, find the column of the name of the goods, and fill in the order according to the order, starting from the first line, click on the blank space, and a drop-down menu option will appear, and you can choose the goods recorded in advance.

5. Finally, click "Save and Add", and a purchase receipt will be recorded.

If it is a computer system, you should first back up the account set, and copy the backup to a suitable location, redo the computer operating system, and then install the speed up to 3000pro, restore the account set;

If it is a speedy account set, the operation will be more troublesome. Two approaches are provided for reference:

1. Initial data import method (you can use this method if you check out normally every month):

1. After the end of the accounting period, close the accounts of the current period (be careful not to make any business documents for the next period in the account set, otherwise, this method cannot be used);

2. Backup account set;

3. Close the 3000Pro client program and open the 3000Pro server;

4. Press the stop button, and then press the account set maintenance button, and the system will open a new window;

5. In the new window, select the set of accounts to be processed, and then select other maintenance --- initial data import, and follow the system prompts step by step to get a new set of accounts, and the inventory is exactly the same as in the original set of accounts;

6. Description: This method is simple, but the goods code and all the account set options can only be used for the old account set, and cannot be modified.

Second, the manual import method:

1. Open the set of accounts to be processed;

2. Data - goods - goods information --- display the weighted price, after the weighted price is displayed,-- export excel to get the goods information.

3. Data--Warehouse--Sub-warehouse Storage--- export excel to get the sub-warehouse storage table;

5. Create a new set of accounts and enter the category of goods and warehouse information;

6. Import commodity information: open the new set of accounts, file - data import, open the data import window, select the product information for the name of the data to be imported, select your commodity data file for the path of the excel file table, and complete it step by step according to the prompts, then the product information will be imported;

7. Inventory quantity modification: open the inventory quantity file, delete all the lines above the warehouse and commodity code lines, delete the three columns of goods name, specification and unit, and save the file;

8. Import of inventory quantity: invoicing initialization - inventory initialization --- excel import, select the excel file of inventory quantity, open it, and then proceed step by step according to the system prompts until it is completed, and the import is successful;

9. The import of other materials is the same.

I happened to see your problem today, I don't know if you solve it or not, I'll be a warm-hearted person, because I have used it for many years, from the stand-alone version to the network version, from more than 6 o'clock to more than 7 o'clock version I am using and studying step by step, including the people who sold my software at the beginning are often related to me, Guangzhou speed company's poor service is very don't easily find him to upgrade or change the dog, the software is OK, I was in an upgrade in 2009, The upgraded dog was returned to me after a few months (I had to buy a set of high versions from the dealer to use first), and the upgraded model has not been returned to me for more than a year today, (playing ** kicking the ball).

Nonsense! Tragedy will not happen to you again.

Solve the problem: 1. The data I exported from the first set of accounts of Speed, and the second set of accounts imported from the newly created Speedy will also have the same prompt as you, the reason is: there is excess data in the excel sheet, such as:

Operator, export date, etc., i.e. don't have rows or columns that aren't relevant to the imported data, and delete the extra rows or columns if they do.

2. Speed report data is inseparable from excel, first export a data table you need from the speed demo account set and compare it with the excel sheet you want to import now and adjust the format and data (note that I 1, said delete redundant rows or columns).

3. Software problems are not something that can be said clearly, I will try my best to help you solve your problems today, financial software is inseparable from excel, this is the common denominator, there is a common point there is a contact, if you do not solve it, I will help you solve it tomorrow!

The opening data of the ledger account should also be recorded, and then the balance of the ledger account and the balance of the inventory information should be reconciled, (there should be a "reconciliation" button on the ledger account), the same, to prove that there is no error. (UF is like this, it is estimated that speed should be the same).

This header is the format, and the format is the format of the software general interface data export export, and you can supplement your own information, don't modify the header yourself.

Speed customer center 020 62827888 4007169026

I don't really understand it either, and I want to come up and see the answer.

I usually use SPSS, and I'm not very familiar with this yet.

The real ink blot upstairs is not the end of the matter directly.

1. First of all, open the financial software - enter the main page of the financial software - click "E-commerce Management" under the main console.

2. After clicking on the "E-commerce Management" module, click on the "Order Service" under it.

3. Click on the sub-function "Order Processing" under it. After clicking on the sub-function "Order Processing" - click on the detailed function "95704 Third-party platform order import" under it.

4. After clicking on the detailed function "95704 third-party platform order import" - the pop-up window "Business Document Introduction".

5. In this window, you need to add the following import files.

6. Finally, open the file in the open window and click to open.

First export the goods information from the demonstration account set of speed 3000, you will see what the format is, according to the format of your goods information are entered into the line, it should be noted that the excel is two pages, a sheet1 and sheet2 have content, the goods code to correspond.

File - import and export - commodity information - OK.