Showing posts with label Sales Posting Routine. Show all posts
Showing posts with label Sales Posting Routine. Show all posts

Saturday, June 25, 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.











Thursday, June 23, 2016

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.