Customer Card - Prices including GST

kwajahathydro

Hi All,

we are using nav 2009 and under customer card, when i create a new customer, i need to go to Invoicing Tab and then put a check mark on the field called Prices Including GST, how can i make it by default appearing with tick mark, pls tell me in detail on which form to edit and which section to edit so that whenever i create a customer in navision, by default prices including gst is ticked.

Regards
KH

Purvesh_Maisuria

Hello kwajahathydro,

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;

This will solve your problem.

Thanks & Regards,
Purvesh Maisuria.

kwajahathydro

Hi Purvesh,

Thanks! I will try it out

Regards
KH

kwajahathydro

hi Purvesh,

i went into design mode, choose table 18, press f9 and found on insert trigger and went to last line and added what you have told me but when save it, system gave error as you have defined an unknown something, add in cal globals, what is this!

REgards
KH

Purvesh_Maisuria

Hello kwajahathydro,

This means your customer table don't have field name "Prices Including GST". Its your localized field, in India we have "Prices Including VAT" field.

Code Line is this only.
"Prices Including GST":=TRUE;

Or

Just assign TRUE to your field which you want to be default TRUE/Checked.


Thanks & Regards,
Purvesh Maisuria.

kwajahathydro

Hi Purvesh,

sorry! my mistake. the field is prices inlcuding VAT and not GST, i did the same like what you told me first time and saved and it went through and now when i create a new customer, the field is auto checked mark as prices including vat.

Thanks!

Regards
KH

Purvesh_Maisuria

Hello kwajahathydro,

My Pleasure, If your problem is solved then make this post to SOLVED.

Thanks & Regards,
Purvesh Maisuria.

kwajahathydro

Hi Purvesh,

I need one more help. If you can, I guess you can

We have a table called sales price. Now i want to add the brand field here, now brand is a global dimension 1 in our database. I created a new field in sales price table but not sure how to put the flow filter inside this field. I want the brand (coming from item table) to sales price table, my new field to show the same value.

can you help me the with the calc formula for flow field to capture brand into my sales price table.


Regards
KH

Purvesh_Maisuria

Hello kwajahathydro,

Write this code on trigger "OnInsert()" of Sales Price table.

IF Item.GET("Item No.") THEN
Brand := Item.Brand;

Where
Item is the record variable of ITEM table.
So
Define
Go on "OnInsert()" trigger & Go in local variables & define Item as record variable of ITEM table.

Hope this will solve your problem.

Thanks & Regards,
Purvesh Maisuria.

kwajahathydro

Hi,

I wrote the same code like you have told me to do on sales price table, design, press f9, look for insert() then i pasted the code on the last line like this

IF Item.GET("Item No.") THEN
Brand := Item.Brand;

When save, gives error message on Brand is defined an unknown variable, so define in CAL Globals so what do from here

Regards
KH

Purvesh_Maisuria

Hi,

IF Item.GET("Item No.") THEN
Sales Price Table's Field := Item."Global Dimension 1 Code";

Thanks...

kwajahathydro

Hi Purvesh,

the last time you had helped me with a small code in the customer table that allows to auto put a tick mark in the field called prices including vat, see the below

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;

This will solve your problem.


But i forgot to add one more thing to it which i have remembered now, well there are two companies in one database here my customer is using, so how to restrict this code so that it effects only company B, company A the customer dont want this prices including gst to be auto checked. So how to modify the code and what will be new line that will allow me to put this control in the place. pls write to me clearly purvesh

Regards
KH