global List<cProductInventorys> getretProdInventory() { // get Quantity from OpportunityLineItem requiredQty = [Select Quantity, OpportunityId, pricebookentryId from OpportunityLineItem where OpportunityId = :oppId and pricebookentryId = :pbeId].Quantity ; // clear wrapper class contents retProdInventory.clear(); Map<String, ProductInventory__c> ProdInvLinesMap = new Map<String, ProductInventory__c>(); for ( ProductInventory__c p : [select name, product__c, WareHouse__c, product__r.name, id , AvailableQty__c, InventoryReserve__c, InventoryReserve__r.Sequence__c from ProductInventory__c where product__c = :id order by InventoryReserve__r.Sequence__c ] ) { ProdInvLinesMap.put(String.valueOf(p.InventoryReserve__r.Sequence__c), p); } List<String> ProdInvLines = new List<String>(); for (String ps : ProdInvLinesMap.keySet()) { ProdInvLines.add(ps); } ProdInvLines.sort(); for (String ps : ProdInvLines) { ProductInventory__c ps1 = ProdInvLinesMap.get(ps); retProdInventory.add(new cProductInventorys(ps1)); } return retProdInventory ; } global class cProductInventorys{ global String Line {get; set;} global Double ShortageQty {get; set;} global List<ProductInventory__c> PIList{get; set;} cProductInventorys(ProductInventory__c p, Double requiredQty){ Id PLid = ApexPages.currentPage().getParameters().get('id'); Line = String.valueOf(p.InventoryReserve__r.Sequence__c); PIList=[select id,name, InventoryReserve__c, InventoryReserve__r.Sequence__c , WareHouse__c, AvailableQty__c where InventoryReserve__r.Sequence__c =:p.InventoryReserve__r.Sequence__c and PackList__c = :PLid limit 1]; ShortageQty = requiredQty - PIList.AvailableQty__c; } } }

Please take a look at above code, How do I display the ShortageQty in users locale.

This can be done if we have ShortageQty on the sObject itself. But I want to check if I want to create some Visualforce pages where we want to display some values which are not stored physically and they also not a formula field then how do we leverage the user's locale settings for those columns.

Thanks