Normalise Tables

https://help.myob.com/wiki/x/etY6Ag

Close

How satisfied are you with our online help?*

Just these help pages, not phone support or the product itself

0

1

2

3

4

5

Very dissatisfied

Very satisfied

Why did you give this rating?

It's hard to find information

Instructions are hard to follow

Content isn't detailed enough

It doesn't fix my software problems

Anything else you want to tell us about the help?

AE Tax only

This routine is used during the installation of integration between CDS and VPM and is normally performed by your MYOB consultant.

The VPM database will only store unique codes and can therefore only store one of each type of address or number against each contact. CDS however, permits duplicates and these must be removed prior to integration with VPM. This is achieved by the normalise function.

For example:

Prior to integration with VPM, a CDS contact had 3 addresses of type BUSINESS attached. The Normalise routine will remove the duplicates by using the following address types:

BUSINESS
BUSINESS1
BUSINESS2

Refer to:

CDS to VPM mapping index
Set VPM Type

You are advised not to change this setting except on the direction of an MYOB consultant. Any errors made in association with VPM integration, will require restoring data to a data back up taken prior to the integration being changed. This may result in loss of data.

Page tree

Related topics

Was this information helpful?

Why not?

How would you improve this page?

Thanks! Anything you'd like to add?

Returns

Activity Statements

Forms and Schedules

Using MYOB AE/AO Tax