help require on Import

Discussion in 'Tally.ERP 9' started by Johar, Nov 1, 2018.

         
  1. Johar

    Johar Member


    Dear Expert,

    i can import stock item from excel to tally, but the problem arise in MRP Rate i am unable to SET VALUE

    can anybody provide me exactly what to mentioned, attached the image file what error it gives

    Thanks
     

    Attached Files:



  2. Johar

    Johar Member


    i tried this also but same INVALID METHOD it shows

    ; 1491 : WALK COLLECTION : MRPDETAILS
    ; 1492 : INSERT COLLECTION OBJECT : MRPDETAILS
    ; 1493 : SET VALUE : FROMDATE : $NSDATE
    ; 1494 : WALK COLLECTION : MRPRATEDETAILS
    ; 1495 : INSERT COLLECTION OBJECT : MRPRATEDETAILS
    ; 1496 : SET VALUE : STATENAME : $NSSTATE
    ; 1497 : SET VALUE : MRPRATE : $NSMRP
    ; 1498 : SET TARGET : ..
    ; 1499 : END WALK
    ; 1500 : SET TARGET : ..
    ; 1501 : END WALK
     


  3. garima

    garima Active Member




    Error Does not pertain to code posted here
     


  4. Johar

    Johar Member


    SET Value : MRPRATE or MULTIMRPRATE

    its not working
     


  5. garima

    garima Active Member



    ($$TgtObject:$MRPRATE)*1
     


  6. knsivam89

    knsivam89 Active Member


    R u Declare MRPRATE Anywhare...?
     


  7. Johar

    Johar Member


    no sir using default MRP
     


  8. garima

    garima Active Member


    $$AsAmount:($$TgtObject:$MRPRATE)*1

    try different variations..

    it will work.. problem is around this statement.. I have faced similar issues
     


  9. Johar

    Johar Member


    ok i will try and inform, thanks
     


  10. Johar

    Johar Member


    nope not working, i am working in VAT Mode & Not GST, please help
     


  11. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Dear Experts, (For experts only)

    I think we should have some sort of admission form or a questionnaire......

    Beginners and developers should fill up the relevant details and THEN post their queries.
    e.g.
    1. Tally version :
    2. Licensed/Pirated : ..................................... personally i ignore all pirated users because most likely the TDL will not work in their version. So waste of time.
    3. What is activated : ........... e.g. VAT/GST/TDS or some features turned off or on.
    4. Proper explanation and with screenshots, if possible.

    ....... and so on. Feel free to add your own.

    Otherwise, we end up wasting our valuable time in solving queries. Also there is much to and fro questions/answers, which would have been avoided, if proper information were furnished in the first place.

    One cannot blame them as they are beginners or inexperienced.

    Therefore it is in everyone's interest to lay down the proper groundwork before starting to solve the queries.
     


Share This Page