multiply fields

Discussion in 'Free Source Codes' started by nasir, Jun 19, 2023.

    
  1. nasir

    nasir Member


    HI EVERYBODY KINDLY GUIDE REGARDING THIS CODE
    GIVE ME SOLUTION PLZZZZ



    [Field: mdiFld]
    Use: Short Name Field
    Storage: MDIStorage
    Set as: ""
    Set Always: No
    Skip: No

    ; Invisible: ##SVvouchertype<>"ElectricityBill"
    Background : @@SV_VCHCOLOR
    Color : "Blue" ;@@SV_VCHTYPE


    [Field: mdirateFld]
    Use: Short Name Field
    Storage: MDIrateStorage
    Set as: ""
    Set Always: No
    Skip: No
    width:12

    ; Invisible: ##SVvouchertype<>"ElectricityBill"
    Background : @@SV_VCHCOLOR
    Color : "Blue" ;@@SV_VCHTYPE




    [Field: mdiamtFld]
    Use: Short Name Field
    Storage: MDIamtStorage
    Set as : HERE HO CAN I ADD A FORMULA
    Set Always: No
    Skip: No
    width:12

    ; Invisible: ##SVvouchertype<>"ElectricityBill"
    Background : @@SV_VCHCOLOR
    Color : "Blue" ;@@SV_VCHTYPE


    I WANT TO ADD MDI to multipy mdi rate = mdi amount

    KINDLY GIVE ME FORMULA PLZZZZZZZ
     


  2. nasir

    nasir Member


     

    Attached Files:

    • MDI.JPG
      MDI.JPG
      File size:
      27.5 KB
      Views:
      51


  3. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    #Field1 * #Field2
     


  4. nasir

    nasir Member



    not workign sir




    [Field: mdiamtFld]
    Use: Short Name Field
    Storage: MDIamtStorage
    Set as : #mdiFld * #mdirateFld
    Set Always: Yes
    Skip: Yes
    width:12


    upload_2023-6-19_19-2-21.png
     


  5. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Chnge -- short name field to -- amount field
     


  6. nasir

    nasir Member


    THANKS FOE REPLY

    SORRY TO SAY ITS NOT WORLING
    upload_2023-6-20_12-40-57.png
     


  7. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Make the Storage TYPE same as the one you use in a field.......
     


  8. nasir

    nasir Member


    upload_2023-6-20_15-48-28.png

    sir this is storage
     


  9. nasir

    nasir Member


    THESE ARE THE LINES SIR

    KINDLY CHECK PLZZ



    [Line: MDI]
    Fields: Medium Prompt, mdiFld,name field,mdiratefld,simple field,mdiamtfld

    Local: Field: Medium Prompt: Info: $$LocaleString:"MDI"
    ; Local: Field: Medium Prompt: Invisible: ##SVvouchertype<>"ElectricityBill"
    Local: Field: Medium Prompt: Background : @@SV_VCHTYPE
    Local: Field: Medium Prompt: Color : @@SV_VCHCOLOR
    Local: Field: Medium Prompt: Style : Normal Bold Italic



    Local: Field: name field: Info: $$LocaleString:"MDI Rate"
    ; Local: Field: name field: Invisible: ##SVvouchertype<>"ElectricityBill"
    Local: Field: name field: Background : @@SV_VCHTYPE
    Local: Field: name field: Color : @@SV_VCHCOLOR
    Local: Field: name field: Style : Normal Bold Italic
    Local: Field: name field:width :12

    Local: Field: name field: Info: $$LocaleString:"MDI Rate"
    ; Local: Field: name field: Invisible: ##SVvouchertype<>"ElectricityBill"
    Local: Field: name field: Background : @@SV_VCHTYPE
    Local: Field: name field: Color : @@SV_VCHCOLOR
    Local: Field: name field: Style : Normal Bold Italic
    Local: Field: name field:width :12



    Local: Field: Simple field: Info: $$LocaleString:"MDI Amount"
    ; Local: Field: Simple field: Invisible: ##SVvouchertype<>"ElectricityBill"
    Local: Field: Simple field: Background : @@SV_VCHTYPE
    Local: Field:Simple field: Color : @@SV_VCHCOLOR
    Local: Field: Simple field: Style : Normal Bold Italic
    Local: Field:Simple field:width :12



    [Field: mdiFld]
    Use: Short Name Field
    Storage: MDIStorage
    Set as: ""
    Set Always: No
    Skip: No

    ; Invisible: ##SVvouchertype<>"ElectricityBill"
    Background : @@SV_VCHCOLOR
    Color : "Blue" ;@@SV_VCHTYPE


    [Field: mdirateFld]
    Use: Short Name Field
    Storage: MDIrateStorage
    Set as: ""
    Set Always: No
    Skip: No
    width:12

    ; Invisible: ##SVvouchertype<>"ElectricityBill"
    Background : @@SV_VCHCOLOR
    Color : "Blue" ;@@SV_VCHTYPE




    [Field: mdiamtFld]
    Use: Short Name Field
    Storage: MDIamtStorage
    Set as : #mdiFld * #mdirateFld
    Set Always: Yes
    Skip: Yes
    width:12

    ; Invisible: ##SVvouchertype<>"ElectricityBill"
    Background : @@SV_VCHCOLOR
    Color : "Blue" ;@@SV_VCHTYPE
     


  10. nasir

    nasir Member


    [Field: mdiFld]
    Use: Short Name Field
    Storage: MDIStorage
    Set as: ""
    Set Always: No
    Skip: No

    ; Invisible: ##SVvouchertype<>"ElectricityBill"
    Background : @@SV_VCHCOLOR
    Color : "Blue" ;@@SV_VCHTYPE


    [Field: mdirateFld]
    Use: Short Name Field
    Storage: MDIrateStorage
    Set as: ""
    Set Always: No
    Skip: No
    width:12

    ; Invisible: ##SVvouchertype<>"ElectricityBill"
    Background : @@SV_VCHCOLOR
    Color : "Red" ;@@SV_VCHTYPE




    [Field: mdiamtFld]
    Use:SHORT NAME field
    Storage: MDIamtStorage
    Set as : #mdiFld + #mdirateFld
    Set Always: Yes
    Skip: Yes
    width:12

    ; Invisible: ##SVvouchertype<>"ElectricityBill"
    Background : @@SV_VCHCOLOR
    Color : "Blue" ;@@SV_VCHTYPE



    WHEN I ADD TWO FIELDS GOT ERRERO 20+10=30 BUT ITS SHOWS 2010 SEE SCREEN SHOT PLZZ

    WHEN I USE=AMOUNT FIELDS STILL EROR

    upload_2023-6-21_17-5-57.png
     


  11. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Use Number or Amount Field for all the 3 fields -- MDI, MDI Rate and MDI Amount.

    Accordingly change the storage type also.
     


  12. nasir

    nasir Member


    i cant under stand storage type can u guide me plzzzz
     


  13. nasir

    nasir Member


    THERE ARE THE UDF STORAGE

    [System: UDF]
    DueDateStorage: String: 8500
    LateFeeStorage: String: 8600
    AftDueDtStorage: String: 8700

    CurrentPeakStorage: String: 8501
    PreviousPeakStorage: String: 8601
    TotalPeakStorage: String: 8701

    CurrentOffpeakStorage: String: 8901
    PreviousoffPeakStorage: String: 8902
    TotaloffPeakUnitsStorage: String: 8903

    MDIStorage: String: 8904
    MDIrateStorage: String: 8910
    MDIamtStorage: String: 8911

    Billmonthstorage: String: 8905

    readdatestorage:String: 8906

    GSTtaxstorage:String: 8907
    INCOMEtaxstorage:String: 8908
    staxstorage:String: 8909

    Fcsurchargestorage:String: 8916
    FPAstorage:String: 8915
     


  14. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    In the 3 MDI udf -- replace string with number, if you are using Number field in the FIELD
     


  15. nasir

    nasir Member


    thank u very much its working


    i have a little query 2

    i want add 5 fields

    just confirm me same situation i have to set for all fields

    Fld1+fld2+fld3+fld4

    Storage type must be number right sir?
     


  16. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    yes same process .......... storage can be number or amount.
     


  17. nasir

    nasir Member


    thank u sir
     


  18. nasir

    nasir Member


    THANK YOU SIR ALL DONE
    upload_2023-6-21_22-3-17.png
     


  19. nasir

    nasir Member


    upload_2023-6-22_12-51-3.png





    GOOD AFTERNOON
    ALL RESPECTED MEMBER

    KINDLY SEE SCREEN SHOOT
    I HAVE MODIFYING A CODE FOR ELECTRICITY WHICH POSTED A VALUABLE MEMBER ROHIT KHEDAR THANKS FOR U

    IN THIS CODE I AM USING SOME FORMJULAS FOR TAX CALCULATION

    CURRENTLY I AM USING A FORMULA #EITOTALVALUE*10%
    THIS IS ON TOTAL VALUE WHICH U CAN SEE IN SCREEN SHOOT 117660/-

    BUT I WANT TO ADD FORMULA ON ANOTHER VALUE
    OFFPEAKCONSUMPTIO+PEAKCONSUMPTIO WHICH SHOWING IN SCREEN SHOOT=70000

    SIMPLE I DONT WANT TO APPLY FORMULA ON 117600/-
    BUT I WANT TO APPLY FORMULA ON 0=70000/-

    KINDLY GUIDE PLZZZZZ
     


  20. nasir

    nasir Member


    suggest me plzzzz
     


  21. nasir

    nasir Member


    ANYBODY GUIDE ME PLEASE
     


  22. Hems

    Hems Member


    (#OFFPEAKCONSUMPTIO+#PEAKCONSUMPTIO)*10%
     


  23. nasir

    nasir Member


    OFFPEAKCONSUMPTIO AND PEAKCONSUMPTIO

    IS A ITEM NAME
    NOT A FIELD NAME
     


  24. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    make system formula
    form01 : If stockitemname="offpeakconsumption" then $amount Else 0
    form02 : If stockitemname="peakconsumption" then $amount Else 0
    TotalCalc : @@form01 + @@Form02

    Then use @@totalcalc * 10% in your field.
     


  25. nasir

    nasir Member


    thanks fore reply

    sir in which place i have to put thus formula plzz

    [System:Formula]
    form01 : If stockitemname="offpeakconsumption" then $amount Else 0
    form02 : If stockitemname="peakconsumption" then $amount Else 0
    TotalCalc : @@form01 + @@Form02
     


Share This Page