VinodPatel

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.