Columnar Register

Discussion in 'Requests' started by rony, Oct 3, 2018.

         
  1. rony

    rony Member


    Dear Experts,
    I have created a field in stock item as serial no. and i want to retrieve its value in columnar register but when i give $Serno:Stockitem:$StockItem it is not showing.But same function getting value in invoice entry. Is there any option to retrieve . I tried collection and Fetch but at field level both r not working.Pl help.
    THANKS
     


  2. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    by columnar register....what do you mean.........daybook columnar register? or stock columnar register?

    depending on which columnar register and in what report...you find the collection that is made for THAT columnar report and then within that you fetch and compute your "SerNo"
     


  3. rony

    rony Member


    Dear Kamdar,
    I Was knew that u will be first 2 comment as punctuality is Ur moto thanks a lot. I was asking about sales register columnar, in that collection attribute and fetch is not working, or i could not apply correctly pl guide.
    REGARDS and THANKS
     


  4. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    would be helpful if you could post your Collection and also explain what values you are trying to get..............

    As you know doctors can't diagnose every ailments without a medical report............. :)
     


  5. rony

    rony Member


    Dear Sir,
    Surely i agree and have no issue, Attached file as well Pic.
    Thanks for Response and HELP. Sorry I cannot attache file so posting code.
    [#Part: CMP COLBasics]

    Add: Lines :Before: COLREGWithVchType:SrNo
    SpaceTop: 0.5
    Option : Small Size Part

    [Line: SrNo]

    Fields : Medium Prompt, Srno
    Local : Field : Medium Prompt : Info : $$LocaleString:"Show Serial No. ?"

    [Field: SrNo]

    Use : Logical Field
    Modifies: COLREGSrNo



    [Variable: COLREGSrNo]

    Type : Logical
    Persistent : Yes

    [#System : Variable]
    COLREGSrNo : ""


    [#Line: DSP ColVchTitle]

    Local : Field : DBC SrNo : Set as : $$LocaleString:"Serial No"

    [#Line: DSP ColVchTotal]

    Local : Field : DBC SrNo : Set as : ""

    [#Part: DBC QtyDetails]

    Local : Field : DBC SrNo : Set as : ""




    [#Line: DSP ColVchDetail]

    Add:Fields:Before:DBC VchType: DBC SrNo


    [Field: DBC SrNo]

    Use : Name Field
    Set As : $StkSrno:StkItem:$StkItemName
    Width :5
    Style : Normal
    Bound : 15
    Invisible : NOT ##COLREGSrNo
    Scroll : Yes
    Border : Thin Left

    I Tried
    [#Collection : Columnar Filtered Vouchers of Company]
    Fetch : InventoryEntries. SrNo

    [#Collection: Columnar Vouchers of Ledgers]
    Fetch : InventoryEntries. SrNo
     


  6. rony

    rony Member



  7. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    By this.............. $StkSrno:StkItem:$StkItemName ............what value you are trying to get and from where??? Part #???
     


  8. rony

    rony Member


    Sir it is serial no. field which i created in stock item master and with same function i m getting serial no. for every item in invoice but not in columnar.
    is that wrong? by the way i m using 9.1.1.
     


  9. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    There were some errors which i corrected, but i need to see the full code also. So i can check out the whole system.

    For sake of confidentiality you can email me at kamdaramit@gmail.com for analysis.
     


  10. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Also send me a screenshot of your invoice, where you say that you are getting the serial.............not photo....screenshot please.
     


  11. knsivam89

    knsivam89 Active Member


    $StkSrno:StockItem:$StockItemName

    Check your Object Type is Correct. Check With this One
     


  12. rony

    rony Member


    Thanks Nallasivamji, I tried that also not coming
     


  13. rony

    rony Member


    Dear Amitji,
    I posted code above because i can not attach the file, else which code?Pl tell I will send.
    Thanks and Regards
     


  14. knsivam89

    knsivam89 Active Member



    Hi Rony,
    You should notice the following for this

    1. The Entry Have Multiple Stock Items, Which Item Serial Number You Need..?
    2. You Showed your Serial Number in Voucher Level. But Inventory Details in Secondary Level.
    3. In case you try to show for in first Inventory item, You Should Fetch the Item Name in Collection Level(Default Report Collection)
     


  15. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    In the code u attached here...can't find the code in which you enter the serial number in the StockItem Master.
     


  16. knsivam89

    knsivam89 Active Member



    You Can Try with this it may work

    [#Object: Voucher]

    DBCItemName : $InventoryEntries[1].StockItemName

    [Field: DBC SrNo]

    Use : Name Field
    Set As : $StkSrno:StockItem:$DBCItemName
    Width :5
    Style : Normal
    Bound : 15
    Invisible : NOT ##COLREGSrNo
    Scroll : Yes
    Border : Thin Left

    [#Collection : Columnar Filtered Vouchers of Company]
    Add : Fetch : DBCItemName

    [#Collection: Columnar Vouchers of Ledgers]
    Add : Fetch : DBCItemName
     
    vinoth likes this.


  17. rony

    rony Member


    Dear Nallasivamji,
    Thanks for guide, But my every invoice has single stock item. And if i want to fetch stock item again i have to create a field name invoice item, else how only collection fetch item.
    And what you post code in that error comes "could not find original description for Columnar Filtered Vouchers of Company and Columnar Vouchers of Ledgers. pl suggest.
     


  18. knsivam89

    knsivam89 Active Member



    The Above code Take from your Sample Only.
    If you have only Stock item in your Invoice then above code is Work. Try with this One

    [#Collection : Columnar Specific Vouchers of Company]
    Add : Fetch : DBCItemName

    [#Collection: Columnar Filtered Vouchers of Company]
    Add : Fetch : DBCItemName
     
    vinoth likes this.


  19. rony

    rony Member


    Dear Amitji
    Mail sent, Pl help.
     


  20. rony

    rony Member


    Dear Nallasivamji,
    You can not take my point. I don't want stock item but in columnar register when we go with sale columnar i need Sr no. column. so i write that above columnar code. but when we open the columnar the value of serial no. is not coming and that is the point, that how to bring stock item serial no.. If i make invoice of multiple item then the code may be diff. but i m making invoice of one item. second thought that instead of single srno. column if i make 2 coll. one is for invoice item and 2 Sr no. , but there also same issue how to bring stock item and Sr no in columnar.
    thanks
     


  21. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    It is working now........ Revised Code sent to your E-Mail ID.....

    Capture.PNG
     


  22. rony

    rony Member


    Dear Amitji,
    Thanks a lot , but it is not working . I just made copy past so no possibility of any mistake, check thrice but not succeeded, some thing messing. Tomorrow again I will check and let u know mean while pl u ref any possibility of mistake. In LINE Serial No i intentionally not put Set Always: Yes and Set As :Yes because so that I can select if I want to show or not . M I correct? Is there make any diff in UdfSerial no and Serial no In Storage ? Again THANKS THANKS And Many THANKS
    Regards
     


  23. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    You should use my code as it is......nothing more, nothing less.............I sent you complete file......not just part of code.

    BTW........the Serial field is Name field..... are you inputting numbers??????
     


  24. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Do not copy paste..... save my file....and use load that file in TDL and then see...............

    I have also put up a screenshot of the success.

    The serial number will display after you explode the report. Are you exploding???
     


  25. knsivam89

    knsivam89 Active Member



    I think he not explodeing. He expect in Main line.
     
    vinoth and Jaya like this.


Share This Page