Table Column Name to show Location code

nikeman77

hi guys,

as we have a different geographical locations (by countries) end user. i am creating a report to update an item history (eg: purchase, sales,availability qty) by location.

eg (Item Balance By Location)
1. Item No.
2. Item Brand
3. Item Part No.
4. Total Purchase- Location1
5. Total Sales- Location1
.
.
.
6.Total Purchase- Location X

Challenges:
1.Number of field Total Purchase should be 'dynamically' changes with number of location.
2.Caption of field should reflect on location code
eg:
Item No. |Total Purchase-Bangkok|Total Purchase-Chiang Mai|Total Purchase-Pattaya|
A001 |10 |7 |34


I tried not to modified codeunit 1, so i used a function to return code of location
so in my table field
total purchase-location1, caption class i place: 'Total Purchase -' + GetName(1)
total purchase-location2, caption class i place: 'Total Purchase -' + GetName(2)

Result? When I run my table... the field caption is missing?!

GetName(LocationNumber)Text:30
Location.SetRange(Code);
Location.Next(LocationNumber);
Exit(Location.Code);