Prices Including GST

kwajahathydro
Member Posts: 88
Hi All,
I need a small help. We are using Nav 2009 SP1 Singapore Version, last time I posted a question on making prices including GST on the creation of new customers. I got an reply and here is the code and steps to do it
1. Just go in Table 18 Customer.
2. Open Table 18 in design mode.
3. go in code by pressing F9.
4. Find the "OnInsert()" trigger.
5. Write this code at last line of this trigger,
"Prices Including GST" := TRUE;
But I forgot to tell that we have two companies in one database. Company A, Company B, and this feature is only for company B and not Company A, so how do I adjust/change the code that is above written.
Regards
KH
I need a small help. We are using Nav 2009 SP1 Singapore Version, last time I posted a question on making prices including GST on the creation of new customers. I got an reply and here is the code and steps to do it
1. Just go in Table 18 Customer.
2. Open Table 18 in design mode.
3. go in code by pressing F9.
4. Find the "OnInsert()" trigger.
5. Write this code at last line of this trigger,
"Prices Including GST" := TRUE;
But I forgot to tell that we have two companies in one database. Company A, Company B, and this feature is only for company B and not Company A, so how do I adjust/change the code that is above written.
Regards
KH
0
Comments
-
Hi,
looks like you have a global customer table... so setting up a new customer enables this property for all companies. The customer table is not global in standard NAV. Setting it to global solves one problem (the customer exists in all companies), but you have lots of dependencies which can break the system if not handled correctly. In your case the sales header would be the better place for the code. I would recommend that you do this change together with a NAV partner, or at least an experienced NAV consultant.
with best regards
Jens0
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