|
Size: 1249
Comment:
|
Size: 1961
Comment:
|
| Deletions are marked like this. | Additions are marked like this. |
| Line 1: | Line 1: |
| Quote for importing vinodpatel (fiji) data. They will required two import programs - a category import program. There will be two files to import. One file to create the departments. This file will be imported as is, with no modificaions. Codes and Names will be imported. The second file (called sub-groups) will have the codes mofidied in the following way. If the code is 3 digts, a 01 will be prepended to the code. If its 4 digits, only a 1 will be prepended to the code |
==== Quote for importing Vinod Patel (Fiji) data ==== They will require the following import programs: - a category import program. There will be two files to import. One file to create the departments. This file will be imported as is, with no modifications. Codes and Names will be imported. The second file (called sub-groups) will have the codes modified in the following way. If the code is 3 digits, a 01 will be prefixed to the code. If its 4 digits, only a 1 will be prefixed to the code |
| Line 6: | Line 9: |
| * Item number * Item description * Category (made up of the subgroup field using the special transformation described above) * EAN (barcode) |
* Item number * Item description * Category (made up of the subgroup field using the special transformation described above) * EAN (barcode) |
| Line 17: | Line 20: |
| * Price Preliminary quote: 1 hr spent by bernie investigating category import - 2hrs stock import - 5 hrs time for quote - 2hrs testing - 2hrs total: 12 hrs (category and stock import) |
* Price - a debtor import. Most of the fields are straight forward. The data file will have to be split up manually into customers and suppliers (C for customers, and S for suppliers). For customers, the price list field refers to another customer with that code. If we cannot find that code, we should create it. It should then be stored in the "Customer Quoted Pricing 1" field. - a creditor import. As above, but without the price list field being imported - Add a new field to the debtor file, that will refer to a salesperson. This field will be used to record debt collector. The appropriate field from the data will be imported into this new field. ||'''Task'''||'''Time(hrs)'''|| ||Category import|| 2|| ||Stock import||5|| ||Debtor import||3|| ||Supplier import||2|| || New debtor record field|| 2|| ||Quote/Testing||5|| ||'''Total'''|| '''19''' || |
Quote for importing Vinod Patel (Fiji) data
They will require the following import programs:
- - a category import program. There will be two files to import. One file to create the departments. This file will be imported as is, with no modifications. Codes and Names will be imported. The second file (called sub-groups) will have the codes modified in the following way. If the code is 3 digits, a 01 will be prefixed to the code. If its 4 digits, only a 1 will be prefixed to the code
- a stock import program.
- These are the fields which will be imported:
- Item number
- Item description
- Category (made up of the subgroup field using the special transformation described above)
- EAN (barcode)
- Default supplier (supplier[0])
- Purchasing unit (buy units)
- No of items per purchasing unit (bufac)
- Customs group (duty field - special mapping table is provided and this will need to be hardcoded into the import program)
- Stock UoM (sale units)
- Discount levels % 1-4 (pbreaks 1-4)
- Cost
- Price
- a debtor import. Most of the fields are straight forward. The data file will have to be split up manually into customers and suppliers (C for customers, and S for suppliers). For customers, the price list field refers to another customer with that code. If we cannot find that code, we should create it. It should then be stored in the "Customer Quoted Pricing 1" field.
- a creditor import. As above, but without the price list field being imported
- Add a new field to the debtor file, that will refer to a salesperson. This field will be used to record debt collector. The appropriate field from the data will be imported into this new field.
Task |
Time(hrs) |
Category import |
2 |
Stock import |
5 |
Debtor import |
3 |
Supplier import |
2 |
New debtor record field |
2 |
Quote/Testing |
5 |
Total |
19 |