TOTAL UNITS

Discussion in 'Requests' started by murtuza shakir, Jan 17, 2018.

    

  1. SIR
    I WANT TO ADD LIKE BELOW EXAMPLE

    5 PKTS
    10 PCS
    3 CTN
    8 PCS
    4 PKTS

    TOTAL 3 CTN , 9 PKTS , 18 PCS

    ITS TOTAL OF SAME UNITS , IS IT POSSIBLE ?? KINDLY PROVIDE THE HINT SO THAT I CAN DEVELOP

    REGARDS
     


  2. narayane88

    narayane88 Active Member


    share your code
     



  3. [#Part: EXPINV Terms]
    Add : Lines :after: EXPINV Terms : rEXPINV NarrPrompt, rEXPINV Narration ,rtEXPINV NarrPrompt, rtEXPINV Narration
    SpaceBottom : 0.25 ;;1
    [Line: rEXPINV NarrPrompt]
    Fields : Info Field
    Local : Field : Info Field : Info : $$LocaleString:"Remarks" + ":"
    Invisible : NOT @@InvWithNarr OR $$IsEmpty:$Narration
    Local : Field : Info Field : Style: Small Italic
    Local : Field : Info Field : Cells: 6 * ($$Quotient:mad:@ExcelCellColumn:8)
    [Line: rEXPINV Narration]
    Fields : Simple Field
    Local : Field : Simple Field : Set as : $Narration
    Local : Field : Simple Field : Style : Normal
    Local : Field : Simple Field : Full Width : Yes
    Local : Field : Simple Field : Lines : 0
    Local : Field : Simple Field : Cells : 6 * ($$Quotient:mad:@ExcelCellColumn:8)
    [Line: rtEXPINV NarrPrompt]
    Fields : Info Field
    Local : Field : Info Field : Info : $$LocaleString:"Total Packages" + ":"
    Local : Field : Info Field : Style: Small Italic
    Invisible : if $$isempty:$$Total:EXPINVActualQty then yes else no
    [Line: rtEXPINV Narration]
    Fields : Simple Field
    Local : Field : Simple Field : Use : Qty Primary Field
    Local : Field : Simple Field : Set as : $$Total:EXPINVActualQty
    Local : Field : Simple Field : Option : QtyWithCmdUnitTot : not ##ICFGStkCmdunit
     



  4. ADMIN HOW TO USE THIS CODE

    Syntax -
    - [Field: <Field Name>]
    Type : Quantity : Primary Units
    Format : "Tail Units:" + <String Expression evaluating to Unit Name>"


    KINDLY GUIDE
     



  5. ;; Total Quantity of raw materials for the Finished goods - considering duplicate Stock Items
    ;; When Show All is enabled, add up all matching Item Quantites of all BOM, else the 1st BOM only
    Compute : ComponentBasicQty : If ##ShowAllBOM AND $$NumItems:MultiComponentList>1 Then $$CollQtyTotal:MultiComponentList:mad:@TotalBOMQty +
    Else $$CollectionField:mad:@TotalBOMQty:1:MultiComponentList

    same concept just need help in forming the code
     


  6. hprahul

    hprahul Member


    Or if any row can be added before terms of supply (in print), where manual entry can be done for same, it will be really useful?

    Please share, if you have any such code!!
     


Share This Page