Making a Mapping

Click on the "Create a mapping" button.

Click on the "Create a mapping" button.

This window should appear.

Select the action that you wish this TransPost mapping to perform.

If you are importing invoices select the MYOB invoice layout that you wish to use.

Click "Next".

This window should appear.

Click browse and select a file on which to template this mapping.

Note: The file should have the same column format as future files that will be imported with this mapping.

Select the file format, comma-separated or tab-delimited.

To ignore rows at the start of the file, set the number of rows to skip here.

If the first row the mapping will read contains headings - check this box.

Name the mapping.

A description may be helpful for remembering what your mapping does.

Select a field from your file for the TransPost log to record.

This will used to label entries in the log during an import using this mapping for each line of a file that it is used on.

Click "Next".

This screen should appear.

The settings for the Mapping you just entered are displayed here.

If you wish to change anything you may do so.

This is the section where you map the fields from the data file you have selected to fields in MYOB.

First click on a field from the file here.

Then click on the MYOB field here.

These fields allow you to set the field to a default in the absence of a mapped value.

This may be a string of characters or a numerical value.

This value will be used if this field is not mapped to a field in you data file, or when the field is mapped but your data file contains no value for that field.

Map the fields you wish to map.

Click finish to save the mapping and return to the Mapping Tab.

 

The mapping should now be available on the Mappings Tab.

From here it can be used for importing data from files.