I want to print a report where a customers record is computed and printed no. of times
first i took a customer ledger entry table of type invoice then on the basis of this invoice i have to give cash discount by searching customers bank payment and cash payment and provide the discount payment wise
e.x.
there is a invoice suppose (no. -- 123) and amount is 50000
so first i will check the customer balance and if we have 10000 already in customer account (i.e.) advance
so we will print first line as
Doc No. | amount | received | discount(3 %) | Balance
1 | 50000 | 10000 | 300 |40000
now i will check customers bank account if it already has 15000 in the acc
then we will print next line as----
Doc No. | amount | received | discount(3 %) | Balance
1 | 40000 | 15000 | 450 | 25000
how can i print multiple lines on the basis of same record then move on to next
anybody with some trick ?
note-- i have gone through integer virtual table but not able to find a solution
With thanks
Anand Kumar
Navision Technical Consultant
0
Comments
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n
alright
but what about if we dont know how many times to loop, will it be right to pre decide the loop length.
Anand Kumar
Navision Technical Consultant
DynamicNumberOfLoop is of type intger that you can calculate how many times you want integer to loop.
setrange(Number,1,DynamicNumberOfLoop);
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n