How to use GETFILTER & SETFILTER How to use it and where to use it in MS Dynamics NAV?

Basically these two filters are majorly used in reports creation of NAVISION. Howsoever I read these functions in MSDN Defination.

To get a better view of these two function I am creating a report using these SETFILTER and GETFILTER.

My readers can also see these functions in many base reports from MS Dynamics NAV.

Firstly look at the defination of these two inbuilt Functions in NAV from MSDN.

SETFILTER

Assigns a filter to a field that you specify. via MSDN

GETFILTER

Returns a list of the filters within the current filter group that are applied to a field. via MSDN.

Howsoever now I am creating a report whose filter I AM going to setup with these two functions lets have a look on my screenshots.

I hope this blog will make easier for beginners to learn this functions in details. I also request NAV seniors to comment and correct me for my mistaks in any of my blog written.

According to me,

I use GETFILTER for getting the filetrs on reports which I had defined in

ReqFilterFields I am Showing It here.

Code :

Result:You will receive this filter result 3 Times as i have 3 <>0 records in Customer Table.

In my next blog I will show you how to use setfilter in MS Dynamics NAV 2016.

How Sales Order and Sales Credit Memo & Return Order is inter linked with each other?

How to increase the inventory in MS DYNAMICS NAVISION?

So I am going to deal with   

ITEM No. 1300 which has a quantity of 152 in our inventry now.

There are two ways of increasing the Quantity

One by POSITIVE Adjustment and second by Purchasing the item from Purchase order. Lets have a look by creating a sales order and posting it with ship and invoice with quantity 52.

So our net remaining quantity must be equals to 152 - 52 = 100.

So this is my sales order which I have successfully posted with ship and invioce in NAV.

Now have a look on change in ILE.

Here  we can see that inventory is now reduced to 100 items.


Now have look in ILE.

A negative line is created for last sales order.

Before looking into the tables where these lines are created which I will do in my next blog.

Now I am going to create a credit memo for this particular item to see what are the changes on ILE and Item card.

Hurrrey Lets have a look.

Have look in ILE.

Have look in ITEM Card.

The Quantity has been incresed.

Now have a look in Customer Ledger entries for this Customer.

Posting Routines of sales order in MS DYNAMICS NAVISION at blogs.anandnavconsultant.com

While creating a SALES ORDER we can post it with 3 options in MS Dynamics NAV.

Either we can do SHIP , INVOICE , SHIP and INVOICE.

In all these 3 cases different lines are created and different tables are hitting in MS Dynamics NAV.
So have a look what are the major tables hitting in all these three different cases.
I am having WC Database in INDIAN Localisation other tables also get hit depending upon the taxation in INDIA.

But basic is always remain same.

While Shipping only these 2 tables and a document is created.

2 tables are interllinked with each other for that I will disscuss in my next blog.

While shipping only Item value is changed or I can say only quatity is chaged and no other imp

In ITEM Ledger Table for each ITEM LINE there were lines like here for 2 items 2  records are created in table.

These are the two lines created for VALUE Entries in MS Dynamics NAV.

SECONDLY IF YOU HAVE CREATED INVOICE

While creating the invoice these document and tables get hits up in MS Dynamics Nav.

There is one Document

Posted Sales INVOICE 

Other 5 tables that get hit up in MS DYNAMICS NAV and there are diffrent Lines created accordingly.

GL Entry

VAT Entry

Customer Ledger Entry

Detailed Customer Ledger Entry

Resource LEDGER ENTRY

I think this is new in MS Dynamis NAV 2016.