Stock Item Picture

Discussion in 'Free Source Codes' started by JObimon Arackal JOhn, Nov 11, 2013.

    
  1. JObimon Arackal JOhn

    JObimon Arackal JOhn Active Member


    One of my closest friend is working auto spare parts shop.He wants to see the picture of stock item when he enters part

    no.

    I gave him this Solution

    For this solution a folder is to be created in \tally.erp9\data\Company Number folder\
    Folder Name must be "Itempic"

    Eg:= I:\Tally.ERP9\Data\10000\Itempic\

    then Image files must be saved as partname.jpg in that folder
    Eg:= I:\Tally.ERP9\Data\10000\Itempic\56478.jpg

    When we create Stoc Item we need to give the part number in part number
    then a window will show you the image of that partnumber

    when we do the sales entry , the sane image will be shown once again to make sure that he has selected correct item by selecting correct part no
     

    Attached Files:

    • 0.png
      0.png
      File size:
      136.4 KB
      Views:
      1,245
    • 1.png
      1.png
      File size:
      446 KB
      Views:
      1,199
    • 2.png
      2.png
      File size:
      154.3 KB
      Views:
      1,155
    • 3.png
      3.png
      File size:
      443.9 KB
      Views:
      1,092
    • Item Pic.txt
      File size:
      6.6 KB
      Views:
      1,628
    Upvan, parvez, Vibhav and 6 others like this.


  2. N vinoth

    N vinoth Guest


    Thank you
     


  3. Saudi Solutions

    Saudi Solutions New Member


    Thank you....good work
     


  4. laxman

    laxman Member


    v. nice and use fully code but image showing full screen ....
     


  5. Saudi Solutions

    Saudi Solutions New Member


    I want to add in the invoice TDL as below.. Stock Item name plus Language Alias (Arabic) name of item. Can you please help me. Thanks

    [Field: SMART Description]

    Use: Name Field
    Set As: $StockItemName

    Width: 90 mms
     


  6. JObimon Arackal JOhn

    JObimon Arackal JOhn Active Member





    no clue
    I tried field attribute KBLanguage : @@ArabicLanguageId
    but it does not work I think Admin can help us
     


  7. Saudi Solutions

    Saudi Solutions New Member



    Sir,

    Even if you given example for Hindi, that's enough. I can work out the code for Arabic. Thank you.
     


  8. JObimon Arackal JOhn

    JObimon Arackal JOhn Active Member


    I am trying. but i miss something in my code. Which i could not identify
     


  9. Srinivasa Rao

    Srinivasa Rao New Member


    thank you
     


  10. JObimon Arackal JOhn

    JObimon Arackal JOhn Active Member



    01.jpg 02.jpg 01.jpg 02.jpg 03.jpg 03.jpg Hello there Please Check the code.

    This is a knowledge Exchanging forum.You can also share your knowledge here.
    May be an article about advanced TDL. It will be useful for those people who are freshers.



    regards


    jobimon
     

    Attached Files:

    • Lang.txt
      File size:
      555 bytes
      Views:
      356
    Gunasekaran likes this.


  11. JObimon Arackal JOhn

    JObimon Arackal JOhn Active Member



  12. Saudi Solutions

    Saudi Solutions New Member


    Thanks a lot for your support Mr. Jobimon. I have question also....In Ledger Account statements of Tally (D.A.L) it displays one way of balancing the total on screen whereas the printout is done differently. Can we print in the same way as we see on the screen. With Closing Balance at bottom. Kindly advice on this.
     


  13. Nandkishor

    Nandkishor New Member


    I
    Dear Sir
    I am trying this with Erp9 Rel 3.1 ,image is properly seen in Item Creation but while passing sale entry error is coming ,Pl do needful in the matter.Thanks
     


  14. T .V S RAMAN

    T .V S RAMAN New Member


    DEAR SIR

    I WAS LOADED ITEMPIC.TXT . BUT ITEM PHOTO NOT SHOWN. PLESE TELL ME PHONE TO SIZE
    AND I WAS DONE THIS WAY. D:\TALLY.ERP9\DATA\00001\ITEMPIC\PARTNAME.JPG\NEXT LOAD THE PHOTOS. THIS WAY CORRECT
     


  15. JObimon Arackal JOhn

    JObimon Arackal JOhn Active Member




    From Tally ERP on wards Company Folder Name starts with 10000 not 00001
    Tally function is taking this name as number hence you data no 00001 is taken as 1.
    but in windows 10000 is taken as string. Hence the problem.

    Instead of Changing code try to change the folder name to 10000
     


  16. T .V S RAMAN

    T .V S RAMAN New Member


    dear sir
    i was written wrong . correct data path : d:\2013-14\data\90011\imagepic\
     


  17. T .V S RAMAN

    T .V S RAMAN New Member


    dear sir

    my tally data path as under:
    D:\2012-13\data1\a\90011\itempic
    tally software :
    c:\tallyerp.9
    your txt code agree by tally. but pic not shown in tally item master, or sale invoice
     


  18. JObimon Arackal JOhn

    JObimon Arackal JOhn Active Member



    If your data folder is different it will not work. For that purpose you have to change the code Entirely.
     


  19. laxman

    laxman Member


    Mr. T .V S RAMAN please tell me full file name in part no.
     


  20. T .V S RAMAN

    T .V S RAMAN New Member


    dear sir,
    i was written full file name e.g. 1.jpg. i try also 1 data path also change but pic not shown only symble () ()
    comes in sales invoice.
     


  21. laxman

    laxman Member


    Please Type Only name (Without .JPG) for example File Name India.jpg but part name type only india.
     


  22. JObimon Arackal JOhn

    JObimon Arackal JOhn Active Member



    Dear Lakshman,

    My TDL will not work in his system
    Becuase:

    In my TDL I have given following code
    ($$LocaleString:$$SysInfo:CurrentPath+"\"+$$LocaleString:$CompanyNumber:Company:##SVCurrentCompany+"\Itempic\"+$partno:StockItem:$StockItemName+".jpg")

    I have given this code because of following reasons

    1) My tally data is in Tally Folder
    2) I am saving Picture in a folder called "Itempic"
    3) Folder "Itempic" is in my company number folder.


    For him Tally is installed as follows

    Tally software is in "c:\tallyerp.9"
    Tally Data is in "D:\2012-13\data1\a\90011\itempic"

    Hence

    1) Either he has to change the code according to the folder where he is saving file.( This he can do if he knows TDL)
    2) Or he has to change the folders in computer according to TDL code.(This he can do if he understands my TDL)


    I have told this in my previous comment.Now I am explaining it.Those people who have basic knowledge can do it.



    regards
    Jobimon
     


  23. laxman

    laxman Member


    Dear Jobimon

    I allready Use this code tally install in C: and data folder in D: then working is good .
     


  24. abbas ali

    abbas ali Member


    IT SHOW IMAGES IN FADE COLOR, ALL IMAGES SHOW IN DARK COLOR NOT ON THEIR ACTUAL FORM. HOW TO SOLVE THAT PROBLEM?
     


  25. NAGARAJKMAR SUBRAMANIAN

    NAGARAJKMAR SUBRAMANIAN Active Member


    Is it Possoble to Bring Stock Item Images in Stock Summary Report ???
     


Share This Page