Tuesday, December 6, 2016

What is Sales Price and Purchase Price in Navision?

Sales Price & Purchase Price 

These are the price which we can define for a particular item. It can be used and categorised on different basis. We can also define prices for different Dates in a month.



How to define it :- 

We can use these prices in normal indian business scenarios where we want to give some discounts to specific Customers and Vendors as per the requirement.

To define the special prices GOTO Item and search for special prices at home and navigate ribbon.

Advantage:-

In the Sales Price we can define the Direct unit cost of items according to specific customers.

We can also create different customers and accordingly we can define the Sales Price for the items.

We Can also define Price for all Customers. 

The same can be used for Vendors but here we can only define to buy from a particular vendor.

Error while defining Sales & Purchase Price :-

Now , after defining the prices in Sales Price and Purchase Price the issue arises why the sales price is defined correctly instead the system picks up the Last Direct according to the Method defined for stock. For fast solution please check these points.

1. Quantity Field must be blank for accurate transaction of Direct Unit cost in Purchase/Sales Line.

2. Currency Field must be blank or same as in sales/purchase lines.

Starting Date and Ending Date must have a value.


Please comment if still the prices are not picking correctly. or for any other customization.


Friday, December 2, 2016

How to use Temporary Tables in Navision?

What are Temporary Tables in Navision?


Temporary Tables are basically a Temporary variable which points to table and are in use until the table is not closed from Client. This image will define it much better.

For more reference , Please click here on MSDN.

Now see the use of Temporary Tables in this code.


Result :



Thursday, December 1, 2016

What is the difference between CLEAR & RESET Functions in NAV?


What is the use of RESET & CLEAR : -

Basically when we use a want to reuse a variable we need to unapply all the filters that are previously applied on that variable, this is why we need to CLEAR or REST that variable.

If its string type we use ABC=''; IF its Integer type we use ABC=0;
OR we use CLEAR(ABC);
Now, when we are using a RECORD type variable we always use


CLEAR(ABC) or ABC.RESET;

Difference is that while using RESET it clears all the filters already applied on that variable and if any key is changed it will reset the primary also.


CLEAR is 1 more step Ahead that it will Clear all the fields individually from this recor type variable.

For reference please check :-After RESET


After Clear