Announcements
Hi Experts,
I was trying to calulate quantiy id same item taken twice in line level , or trice for by using Record Variable RecPurchaseLine1 and Repeat until for that item total quantity will calaculated for single item single quantity taken no need to use Repeat now problem is Repeated item in linewasie it will again add value in quantity and makes it double if same item comes trice it will triple total quantity can i calculate quantity only once if item repeated for next same item iteration it will not calculate value as double or tiple
Hi Dinesh,
you need to use Rec.Setcurrentkey("Item No."); in the Report OnPreDataItem after use the same code that will definitely work.
if you face issue then mail me your contact detail i will help you on call.
Have a great day!
Don't forget to help the community by verifying the answer if your question has been answered. It will let others know that the topic has verified answer.
Thanks,
Contact Info: kuwalpankaj97@gmail.com
Hi Pankaj ,
thanks for Response but i am not able to understand how to sort and why we need variable so i add same code in Rep but not able to getting can you please elaborate
Hi Dinesh
i check you requirement as per your requirement you need to skip your same item.
PFA based on screenshot you need to Modify your code and Sort Data Item No. Wise
Step1: Create one variable For storing Last Item No.
Step2: Sort Data based on Item No wise.
Step3. put the IF Condition based on Screenshot
Have a great day!
Don't forget to help the community by verifying the answer if your question has been answered. It will let others know that the topic has verified answer.
Thanks,
Contact Info: kuwalpankaj97@gmail.com
André Arnaud de Cal... 291,359 Super User 2024 Season 2
Martin Dráb 230,370 Most Valuable Professional
nmaenpaa 101,156