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
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"
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
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.............
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:BeforeBC 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
By this.............. $StkSrno:StkItem:$StkItemName ............what value you are trying to get and from where??? Part #???
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.
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.
Also send me a screenshot of your invoice, where you say that you are getting the serial.............not photo....screenshot please.
Dear Amitji, I posted code above because i can not attach the file, else which code?Pl tell I will send. Thanks and Regards
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)
In the code u attached here...can't find the code in which you enter the serial number in the StockItem Master.
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
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.
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
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
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
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??????
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???