Good afternoon experts, I am trying to show Quantity as per screenshot below. But unable to do so. Code is below :- [Field: Item Qty] Use: Number Field Set as : $DSPInvWithActQty Style : Small Italic Border : Thin Right Display : DSPInvWithActQty:$$ISBilledQty Color : "Dark Red" Align:Center Width : 10 Kindly help me to resolve. Rakesh Sharma
In case your Imvoice has multiple stockitems, then..... which item's quantity??? First you need to change the structure of your report........ to show all the stockitems invoiced in a explode mode....... once you have that, then you will be able to get the quantity.
Yes, Amit Sir, I have multiple stocktimes in some invoices. So please guide me little bit, how to show all the stockitems in invoice in a explode mode. Sir, I need a little bit hit which enables me to proceed. Sir, waiting for your prompt reply as always.
In the line where you are showing records of Sales Invoice.......... Add your explode part there.......... [Line : invoiceline] Explode : stkitemdets : yes (or you can specify on Key explode or explode flag) Now in PART stkitemdets.......... define your line and fields. This PART will be repeated with the collection of items within the Invoice
Hi.. Mr.Rakesh Kumar Try in this way [Field: IE Qty] Use : Number Field Set as : $$CollQtyTotal:InventoryEntries:$BilledQty ;;;;$$Total:BilledQty Border : Thin Right Format : "NoSymbol" Align : Right Color : "Dark Red" Width : 10
In the line where you are showing records of Sales Invoice.......... Add your explode part there.......... [Line : GST Purchase] Explode : stkitemdets : yes (or you can specify on Key explode or explode flag) Now in PART stkitemdets.......... define your line and fields. This PART will be repeated with the collection of items within the Invoice Just as you have made the code for details of purchase, here you should have the details of Stock items within that Invoice entry. So have a new collection to extract the stockitems from the Invoice. You begin the code and we can help you if you are stuck.
Amit Sir, I have no clue, because of lack of experience as I have made this code from the help of this platform. It is not my code. So I am not able to apply the guidance as you have provided. Moreover, I want to purchase this code by showing multiple items with different tax rates. Kindly let me know the price. Looking forward for your help Sir.
I cannot make this code, because I neither have time nor inclination to do so. Furthermore I am not in the business of TDL making. Hopefully, other experts might help you with this.... either free of cost or on commercial basis. Good luck on that. Am here for learning and am still learning and I help other serious coders also who makes efforts to learn and make TDLs. That is what this forum is for..... to gain experience, skills and knowledge to make codes. I was under the impression you had made the code, so it would be easier for you to make the extension. But you too can gain experience, if you start making on your own.