Another Form Question : Purchase Statistics

madm
Member Posts: 92
I have added a variable to the purchase stats form, which shows the LCY vat amount, as this helps with the invoice authorization process. (We buy "local" products in different currencies).
I have bascially put
TotalVATAmountLCY := TotalPurchLineLCY."Amount Including VAT" - TotalPurchLineLCY.Amount;
Which works fine, but there are cases we change the VAT amount (by 1p etc) but this fails to update the field until we exit out of the form. The other fields on the form are updated when clicking into the header.
I guess it is something to do with the LCY "Amount Including VAT" not refreshing till we exit the form.
Any suggestions?
(I have tried running the pre calculated amount with the exchange currency, but this gives slightly different figures to the Unposted Purchases Report, which then causes differences in the balancing process!)
I have bascially put
TotalVATAmountLCY := TotalPurchLineLCY."Amount Including VAT" - TotalPurchLineLCY.Amount;
Which works fine, but there are cases we change the VAT amount (by 1p etc) but this fails to update the field until we exit out of the form. The other fields on the form are updated when clicking into the header.
I guess it is something to do with the LCY "Amount Including VAT" not refreshing till we exit the form.
Any suggestions?
(I have tried running the pre calculated amount with the exchange currency, but this gives slightly different figures to the Unposted Purchases Report, which then causes differences in the balancing process!)
0
Comments
-
It sounds like you have both the statistics and purchase form open at the same time. The problem is that the statistics form does not retrieve the record again just because you activate it. You would have to add a GET statement to the OnActivate trigger to re-read the data.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