Item Alias & Part no. Alias

Discussion in 'Requests' started by R.Raj, Aug 31, 2018.

         
  1. R.Raj

    R.Raj New Member


    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 :partno

    Add :Format :$StockIAlias
    Fetch :StockIAlias


    Add :Format :$parent
    Fetch :parent

    Add :Format :$StandardPrice
    Fetch :StandardPrice


    Add :Format :$LastSalePrice
    Fetch :LastSalePrice

    Add :Format :$closingbalance
    Fetch :closingbalance

    Not showing Item and Part No Aliases...kindly help
     
    Last edited: Sep 1, 2018


  2. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Add .......
    With Alias : Yes
     


  3. R.Raj

    R.Raj New Member


    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?
     


  4. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    OnlyPartAlias.........for Part No. Alias
     


  5. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    or PNAliasOnly
     


  6. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    It is crazy name.......but it works......

    use this........

    Add :Format : $TNetSAPNAlias
    Fetch : TNetSAPNAlias
     


  7. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Add :Format : $TNetSAAlias
    Fetch : TNetSAAlias


    And this also works for "Stock Item Alias"
     


  8. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    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.
     



  9. 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
     


  10. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Set Always : Yes ........... in your Field
     


  11. Frz

    Frz Member


    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 :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

    upload_2019-5-9_11-31-5.png

    Kindly help
    Rgds
    Frz

    PS
    i am not a programmer:)
     


  12. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Not found....means you have NOT set the GST Rate and HSN Code in the stockitem.............
     


  13. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Not found....means you have NOT set the GST Rate and HSN Code in the stockitem.............
     


  14. Frz

    Frz Member


    Dear Amitji
    i have set the details
    attached
    upload_2019-5-9_12-33-0.png

    upload_2019-5-9_12-33-32.png

    Rgds
    Frz
     


  15. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Then try to see in Voucher Entry..... is it displaying there???
     


  16. Frz

    Frz Member


    its comming at voucher entry

    upload_2019-5-9_12-48-53.png

    But we cant see it in
    list of stock items
    Rgds
    Frz
     


  17. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    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
     


  18. Frz

    Frz Member


    [#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
     


  19. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    read my previous comment....slowly and carefully..... and understand ...WHERE the variable is to be defined.
     


  20. Frz

    Frz Member


    tried & tried
    but not able to:(
     


Share This Page