How to fetch Item Alias and Part no. Alias in Item table expand screen... ;;Expand information in item table [#Collection: List of Stock Items] Use : Alias Collection Title : $$LocaleString:"List of Stock Items" Type : Stock Item Fetch : Name Report : Stock Item Variable : SStockItem Trigger : SStockItem IsODBCTable : Yes Delete : Format Add : Format : $Name,100.5 Add : SubTitle : $$LocaleString:"PRODUCT","ItemAlias","PART NO","ALIAS","GROUP","Net Rates","LastSale Price","Cl Qty" Add :Format :$MSTAlias Fetch :MSTAlias Add :Format :$partno Fetch artno Add :Format :$StockIAlias Fetch :StockIAlias Add :Format :$parent Fetch arent Add :Format :$StandardPrice Fetch :StandardPrice Add :Format :$LastSalePrice Fetch :LastSalePrice Add :Format :$closingbalance Fetch :closingbalance Not showing Item and Part No Aliases...kindly help
Sir, Not getting with this....but we get Item Alias with this... Add :Format :$OnlyAlias Fetch :OnlyAlias .....But still not able to get Part No. Alias with either $StkIAlias or $OnlyAlias... What code to use....Sir?
It is crazy name.......but it works...... use this........ Add :Format : $TNetSAPNAlias Fetch : TNetSAPNAlias
Code: [#Collection: List of Stock Items] Use : Alias Collection Title : $$LocaleString:"List of Stock Items" Type : Stock Item Fetch : Name Report : Stock Item Variable : SStockItem Trigger : SStockItem IsODBCTable : Yes FullHeight : Yes With Alias : Yes Delete : Format Add : Format : $Name, 30 ;100.5 Add : SubTitle : $$LocaleString:"PRODUCT","ItemAlias","PART NO","ALIAS","GROUP","Net Rates","LastSale Price","Cl Qty" Add :Format :$OnlyAlias,20 Fetch : OnlyAlias Add :Format :$PartNo,20 Fetch :partno Add :Format : $TNetSAPNAlias,20 Fetch : TNetSAPNAlias Add :Format :$parent,20 Fetch :parent Add :Format :$StandardPrice,20 Fetch :StandardPrice Add :Format :$LastSalePrice,20 Fetch :LastSalePrice Add :Format :$closingbalance,20 Fetch :closingbalance Use above code........Better Display screen layout.
Dear sir, if i want to fetch last sales rate of a item of same party then by this below code its okey to fetch in alter mode, but why i can not fetch last sales price of same item same party in create mode ? [Collection : ALM_VchSColl] Type : Vouchers : Ledger Child Of : #EICONSIGNEE Fetch : * Filter : ATC_SALES [Collection : ALM_VchColl] Source Collection : ALM_VchSColl Walk : Inventory Entries Compute : Date : $().Date Fetch : *,Date,StockItemName Sort : @@Default : -$Date Filter : ALM_ItemFil [System:Formula] ALM_ItemFil : $StockItemName=$$ReqObject:$StockItemName ATC_SALES : $$IsSales:$VoucherTypeName [#Object : Inventory Entry] LastSalePrice : $$AsReqObj:$$CollectionField:$Rate:1:ALM_VchColl
Dear Amitji I have tried to add the following 2 items to get the GST & HSN codes also, but its still coming blank [#Collection: List of Stock Items] Use : Alias Collection Title : $$LocaleString:"List of Stock Items" Type : Stock Item Fetch : Name Report : Stock Item Variable : SStockItem Trigger : SStockItem IsODBCTable : Yes FullHeight : Yes With Alias : Yes Delete : Format Add : Format : $Name, 30 ;100.5 Add : SubTitle : $$LocaleString:"PRODUCT","GST", "HSN/SAC","ItemAlias","PART NO","ALIAS","GROUP","Net Rates","LastSale Price" Add :Format :$GSTIGSTRate Fetch:GSTIGSTRate Add :Format :$GSTHSNCode Fetch:GSTHSNCode Add :Format :$OnlyAlias,20 Fetch : OnlyAlias Add :Format :$PartNo,20 Fetch artno Add :Format : $TNetSAPNAlias,20 Fetch : TNetSAPNAlias Add :Format :$parent,20 Fetch arent Add :Format :$StandardPrice,20 Fetch :StandardPrice Add :Format :$LastSalePrice,20 Fetch :LastSalePrice ;Add :Format :$closingbalance,20 ;Fetch :closingbalance Kindly help Rgds Frz PS i am not a programmer
I think you want to see it somewhere else..... have you created a new menu item to view the list??? It is not coming there as the variable is not defined there. In your report .......... define Variable : Stock Item
[#Collection: List of Stock Items] Use : Alias Collection Title : $$LocaleString:"List of Stock Items" Type : Stock Item Fetch : Name Report : Stock Item Variable : SStockItem<- its defined here? Trigger : SStockItem IsODBCTable : Yes FullHeight : Yes With Alias : Yes Delete : Format Add : Format : $Name, 30 ;100.5 Add : SubTitle : $$LocaleString:"PRODUCT","GST", "HSN/SAC","ItemAlias","PART NO","ALIAS","GROUP","Net Rates","LastSale Price" Add :Format :$GSTIGSTRate Fetch:GSTIGSTRate Add :Format :$GSTHSNCode Fetch:GSTHSNCode Add :Format :$OnlyAlias,20 Fetch : OnlyAlias Add :Format :$PartNo,20 Fetch Partno Add :Format : $TNetSAPNAlias,20 Fetch : TNetSAPNAlias Add :Format :$parent,20 Fetch Parent Add :Format :$StandardPrice,20 Fetch :StandardPrice Add :Format :$LastSalePrice,20 Fetch :LastSalePrice ;Add :Format :$closingbalance,20 ;Fetch :closingbalance
read my previous comment....slowly and carefully..... and understand ...WHERE the variable is to be defined.
how to fetch multiple stockitem name alias and part number name alias in my report on button call of sales voucher???? kindly provide solution thanks in advance