A number of useful codes may have already been defined in your SunSystems implementation, if you are using the facilities that require this information. For example, if you are using Order Fulfilment you will have identified all of your inventory items, warehouses and product groups. If so, you can use them as the valid analysis codes for an analysis dimension. Or another example can be a multi -site  customer, where a few customer records from CUS  share the same debtor account in chart of  accounts. The only option available  to  segregate the customer transactions from one another is to use one of the ledger analysis dimensions. Using linkage between existing codes and  analysis dimension Every time you create a new customer  in CUS it will be automatically created as a ledger analysis code.

How to Link Existing Codes to an Analysis Dimension
When you create an analysis dimension using Analysis Dimension Setup (ND) you can refer to an existing SunSystems analysis table and uses the codes in that table to automatically populate the dimension.
Click here to see the screenshot
In this example I have created an analysis dimension called "CUSTOMER_CODE" which I have linked to customer table by selecting it from Analysis Table Id box and linking the analysis dimension to the analysis table by checking "Linked". This ensures that any amendments and deletions to the source analysis table codes are also reflected in the analysis dimension codes. Any codes that exist on the analysis table are created as analysis codes for the analysis dimension  automatically when the dimension is created. Once you have linked the both the system will copy all your customer codes, descriptions and lookups into the  analysis codes.

• Name
• Status
• Lookup Code
• Data Access Group Code.

When you delete a code from the source analysis table, it is also deleted automatically from the analysis dimension.

Only registered users can write comments.
Please login or register.