One Record multiple Print

anand_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
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
Anand Kumar
Navision Technical Consultant
0
Comments
-
use the integer table. set a filter to number based on how many times you want to loop.0
-
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 Consultant0 -
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);0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions