Howdy, Stranger!
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
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 305 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
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
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
Jens