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)
- Item No.
- Item Brand
- Item Part No.
- Total Purchase- Location1
- Total Sales- Location1
6.Total Purchase- Location X
1.Number of field Total Purchase should be ‘dynamically’ changes with number of location.
2.Caption of field should reflect on location code
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?!