Customer Master Accounts & Sub-Accounts

Tue, 14 Dec 2010 11:10:31 GMT

Hi guys

When we have a customer that operates in more than one geographical area, we create a sub account for each area. In other words customer ABC (Master Customer Code: C01) will have a sub account for each area like this: ABC (AREA A) (Sub Account Customer Code: C001).

The problem I am having is when starting to do a Customers Receivables Model. All invoices & credit notes gets done on a Sub Account Level. This means that the tables relating to Invoices & Credit Notes all reflects the Sub Account Code of the Customer. This gets posted to the Master Customer Code as a Balance.

There is thus a balance on the Master Customer Code but no Invoices & Credit Notes history becuase this is done on the Sub Account Customer Code.

I do have a table which connects each Sub Account Code to a Master Account Code.

How could I load all the Sub Account Customer Data into Qlikview so that it relates to the Master Account Customer Data.

At the end I would like to select a master account and this will automatically show all the invoices & credit notes that was done on the sub accounts.

Any help will be appreciated.

Regards

topic Customer Master Accounts & Sub-Accounts in QlikView

Customer Master Accounts & Sub-Accounts