Migrate to MYCITO

MYCITO can migrate your DATA from existing (legacy) systems using the following DATA mapping tables. DATA can be provided as DATABASE backups (dumps), wide spread DATA export files containing a high volume of columns (fields) and records or smaller self contained relationship table exports with unique inter-table-reference-keys.

 

 

PRODUCT

MYCITO supports the following base PRODUCT DATA fields, additional fields can be added as required.

DATA Comment
Number / CodeYour unique identifier
Type / Category / Area
Name
General Ledger Code
Description

STOCK

MYCITO supports the following base STOCK DATA fields, additional fields can be added as required.

DATA Comment
Number / CodeYour unique identifier
ProductSee PRODUCT
Type / Category
Manufacturer / Brand
Name
Description

CUSTOMER

MYCITO supports the following base CUSTOMER DATA fields, additional fields can be added as required.

DATA Comment
Number / CodeYour unique identifier
Legal Entity TypeIndividual, Company or Organisation
Name
Type
Account ManagerYour staff member, see EMPLOYEE
Description

MYCITO supports the following base INDIVIDUAL, COMPANY & ORGANISATION DATA fields, additional fields can be added as required.

  • INDIVIDUAL Name, Surname, Identity Type, Identity Number
  • COMPANY & ORGANISATION Name, Type, Registration Number, VAT Number
  • CONACT INFORMATION Physical & Postal Address, Email Addresses, Phones & Websites

CUSTOMER - PRODUCT (Transactions)

MYCITO supports the following base CUSTOMER - PRODUCT (Transaction) DATA fields, additional fields can be added as required.

DATA Comment
Transaction NumberYour unique identifier
CustomerSee CUSTOMER
ProductSee PRODUCT
Product Serial NumberSee STOCK ITEM
Invoice NumberSee INVOICE
Invoice Date
Invoice Currency
Quantity
Value
EmployeeYour staff member, see EMPLOYEE
Commission
ConsumerCustomer staff member, see EMPLOYEE
Consumer RoleRole / Employed Position at time of the transaction
Notes

 

EMPLOYEE

MYCITO supports the following base EMPLOYEE DATA fields, additional fields can be added as required.

DATA Comment
Employer / Company
Number / CodeYour unique identifier
Individual
Type / Category
Department / Position
Description

QUICK JUMP

PRODUCTSTOCKCUSTOMERCUSTOMER - PRODUCT (Transactions)EMPLOYEEDISTRIBUTOR (Supplier)TRANSPORTER (Courier)WAREHOUSE (Store)PURCHASER (Location)STOCK JOURNALSTOCK ITEMDEBTORINVOICEINVOICE ITEM

 

DISTRIBUTOR (Supplier)

MYCITO supports the following base DISTRIBUTOR DATA fields, additional fields can be added as required.

DATA Comment
Number / CodeYour unique identifier
Legal Entity TypeIndividual, Company or Organisation
Name
Type
Description

TRANSPORTER (Courier)

MYCITO supports the following base TRANSPORTER DATA fields, additional fields can be added as required.

DATA Comment
Number / CodeYour unique identifier
Legal Entity TypeIndividual, Company or Organisation
Name
Type
Description

 

WAREHOUSE (Store)

MYCITO supports the following base WAREHOUSE DATA fields, additional fields can be added as required. WAREHOUSES are internal or external such as customs.

DATA Comment
Number / CodeYour unique identifier
Legal Entity TypeIndividual, Company or Organisation
Name
Type
Description

PURCHASER (Location)

MYCITO supports the following base PURCHASER DATA fields, additional fields can be added as required. PURCHASERS are created from customers or can be unique locations usually subsidiaries, branches or sites of the primary (head office) customer where stock will be received.

DATA Comment
Number / CodeYour unique identifier
Legal Entity TypeIndividual, Company or Organisation
Name
Type
Description

 

STOCK JOURNAL

MYCITO supports the following base STOCK JOURNAL DATA fields, additional fields can be added as required. STOCK JOURNALS are use to track stock movement.

DATA Comment
Number / CodeYour unique identifier
StockSee STOCK
MovementIn, Move, Out, Lost, Found, Damage, Return & Void
OriginSee DISTRIBUTOR, WAREHOUSE and PURCHASER
Dispatch Date
TransporterSee TRANSPORTER
DestinationSee DISTRIBUTOR, WAREHOUSE and PURCHASER
Arrival Date
Quantity
Notes

STOCK ITEM

MYCITO supports the following base STOCK ITEM DATA fields, additional fields can be added as required. STOCK ITEMS are used when you need to assign serial numbers to individual stock items for asset projects and tracking.

DATA Comment
Number / CodeYour unique identifier
Stock JournalSee STOCK JOURNAL
Serial Number
Asset NumberYour unique identifier
Date Acquired
Acquired FromSee DISTRIBUTOR
Current LocationSee WAREHOUSE and PURCHASER

 

DEBTOR

MYCITO supports the following base DEBTOR DATA fields, additional fields can be added as required.

DATA Comment
Number / CodeYour unique identifier
Legal Entity TypeIndividual, Company or Organisation
Name
Type
Description

QUICK JUMP

PRODUCTSTOCKCUSTOMERCUSTOMER - PRODUCT (Transactions)EMPLOYEESTOCK DISTRIBUTOR (Supplier)STOCK TRANSPORTER (Courier)STOCK WAREHOUSE (Store)STOCK PURCHASER (Location)STOCK JOURNALSTOCK ITEMDEBTORINVOICEINVOICE ITEM

 

INVOICE

MYCITO supports the following base INVOICE DATA fields, additional fields can be added as required.

DATA Comment
Number / CodeYour unique identifier
Date
DebtorSee DEBTOR
Type
Sales Term
Reference
Sales PersonYour staff member, see EMPLOYEE
Notes

INVOICE ITEM

MYCITO supports the following base INVOICE ITEM DATA fields, additional fields can be added as required.

DATA Comment
InvoiceSee INVOICE
Position
Type
ProductSee PRODUCT
Serial NumberSee STOCK ITEM
Name
Description
Cost
Expense
Unit
Markup
Quantity
Commission Exempt
TAX Exempt
TAX Included

 

About MYCITO

MYCITO is quickly becoming a preferred CLOUD AMO / LMS & ERP SERVICE for SMMEs in South Africa. Locally designed, developed and supported with a pay as you go model, no infrastructure costs, quarterly updates, guaranteed levels of service and more to fit your month-to-month requirements.

Why MYCITO
  •  A Cloud AMO / LMS & ERP Service
  •  Expandable & Adaptable
  •  Locally Developed & Supported
  •  Monthly Commitment
 info@mycitoapp.com
 087 095 6171

Standard local (South Africa) office hours Monday - Friday (08:00 - 16:00) GMT+2

LEARN THE LINGO
AMO = Academy Management Office, LMS = Learner Record Management System / Software, ERP = Enterprise Resource Planning Software / System, SaaS = Software as a Service, SETA = Sector Education and Training Authorities, QCTO = Quality Council for Trades and Occupations, SAQA = South African Qualification Authority, QMS = Quality Management System, DHET = Department of Higher Education and Training, TVET = Technical and Vocational Education and Training, ESD = Enterprise Supplier Development, SMME = Small, Medium and Micro Enterprises, OFO = Organising Framework for Occupations

powered by mycito

Made in South Africa using jQuery, Bootstrap and Font Awesome.
Terms of Service, Privacy Policy, Copyright Policy, Website Disclaimer and Email Disclaimer

TOP