Pur Inv Line

rekhalmohan
Member Posts: 17
Hi All,,,
I am creating a report from Posted inv Header and Line table fetching the item details and so. The issue is... i am fetching the amount value from the line table as the invoice value. So when the type is item,Fixed Asset, G/L Account it comes under Invoice value. But if the type is Charge(Item).. thn i should show the amount value under Frieght charges. Jus a simple issue.. Please help me to do this..
Thanks,
Rekha.
I am creating a report from Posted inv Header and Line table fetching the item details and so. The issue is... i am fetching the amount value from the line table as the invoice value. So when the type is item,Fixed Asset, G/L Account it comes under Invoice value. But if the type is Charge(Item).. thn i should show the amount value under Frieght charges. Jus a simple issue.. Please help me to do this..
Thanks,
Rekha.
0
Comments
-
What did you try and what is not working please?0
-
In the Pur Inv Header, Header section i gave two labels as Invoice Value, Frieght Value.
1. If type is Item, FA, GL ... the value should comes under Invoice value (Amount).
2. If type is Charge (Item) .. the value should comes under Frieght value .
I want ur help to do this with some coding in the onaftergetrecord of Line.. If am correct?
Thanks,
Rekha.0 -
Yes, you can define 2 global decimal variables and based on the type you can assign the value to variables..
dont expect code from forum please..0 -
Okay.. Thanks,
Rekha.0 -
Hi All....
Please help me to find out FCY and INR coming under invoice value . I mean which are the fields in the header table wit FCY and INR as values0
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