Item wise EIDiscountAmt in columnar report

Discussion in 'Requests' started by Piyush Kankaria, Mar 25, 2023.

    
  1. Piyush Kankaria

    Piyush Kankaria New Member


    Code:
    [#Line : DSP ColVchTitle]
    Add : Field: Before: DBC Qty : MRP
    Add : Field: after: DBC GrossAmt : Scheme
    Local : Field : MRP : Set as : "MRP"
    Local : Field : Scheme : Set as : "Scheme"
    
    [#Line : DSP ColVchDetail]
    Add : Field: Before : DBC Qty : MRP
    Add : Field: after: DBC GrossAmt : Scheme
    
    [Field: MRP]
    Use : Rate Price Field
    Style : Normal Bold
    Width : 10
    Scroll : Yes
    Set as : $$GetEIStkItemMRP:$StockItemName:$Date ;$(StockItem, $StockItemName).MRPDetails[Last].MRPRateDetails[1].MRPRate
    Border : Thin Left
    
    [Field: Scheme]
    Use : Rate Price Field
    Style : Normal Bold
    Width : 10
    Scroll : Yes
    Set as : $EIDiscountAmt
    Border : Thin Left
    
    
    I want EIDiscountAmt to appear in columnar report, Please help
     


  2. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Just as you have added the above fields..... ADD them in the columnar report also.
     


  3. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Just as you have added the above fields..... ADD them in the columnar report also.
     


  4. Piyush Kankaria

    Piyush Kankaria New Member


    In the above field, I'm getting the value of MRP but the discount value I'm not able to fetch. Please guide me with the same.

    I've mentioned it as
    Set as : $EIDiscountAmt ; But its not fetching that value from voucher and its appearing blank in that column.
     


  5. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    fetch the values in the COLLECTION of columnar vouchers...........
     


  6. Piyush Kankaria

    Piyush Kankaria New Member


    Could you please guide the same?
     


  7. Piyush Kankaria

    Piyush Kankaria New Member


    Could you please help?
     


Share This Page