BI REPORT - MANAGEMENT ACCOUNTS

BI REPORT EXTRACTING DATA FROM PASTEL AND THEN APPLYING CERTAIN RULES TO SPLIT MAIN ACCOUNTS INTO STORES I.E. IF TOTAL T/O IS R1 000 000 AND STORE 1'S CONTRIBUTION IS 10% OF THE R1 000 000, THE COST OF SAY ADVERTISING WILL BE PART OF STORE 1'S MANAGEMENT ACCOUNT. MOST OF THE ACCOUNTS ARE SPLIT ALREADY BUT NOT ALL.