One Record multiple Print

anand_sri12anand_sri12 Member Posts: 71
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

Comments

  • ara3nara3n Member Posts: 9,256
    use the integer table. set a filter to number based on how many times you want to loop.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • anand_sri12anand_sri12 Member Posts: 71
    ara3n wrote:
    use the integer table. set a filter to number based on how many times you want to loop.

    alright
    but what about if we dont know how many times to loop, will it be right to pre decide the loop length.
    With thanks

    Anand Kumar
    Navision Technical Consultant
  • ara3nara3n Member Posts: 9,256
    on predataitem of integer dataitem you can add the following code
    DynamicNumberOfLoop is of type intger that you can calculate how many times you want integer to loop.


    setrange(Number,1,DynamicNumberOfLoop);
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
Sign In or Register to comment.