Posting Groups #4 – Adjust Cost – Item Entries Posting

04/05/2015 atotovic Microsoft Dynamics NAV inventory, learn, Microsoft, Microsoft Dynamics NAV, NAV, NAV 2015, NAVUG, Posting Group, Tips & Tricks

When we run Adjust Cost – Item Entries batch job, system forwards any cost changes from inbound entries, to the related outbound entries. In our small example, we will see what we will get after post Item Charges to already sold items. Currently, we will use very simple example; we have only purchased and sold item.

In this example, automatic cost adjustment is not configured. We can use example with additional costs using Item Charge or using higher cost on Invoice in comparison with Receipt.

When we run this batch job, we will get G/L Entries as result. You can find completely description of them in next table:

System will post only the difference between the higher and lower costs. System will use Inventory Posting Setup from Inventory Posting Group and Location on source document. On the same way, system will use General Posting Setup from the same source document, but from General Business and Production Posting Groups from document header and line.

In some other examples, it can be more complex posting, but I will process this examples in another articles.

Posting Groups #3 – Item Charges Purchase Posting

01/05/201502/05/2015 atotovic Microsoft Dynamics NAV inventory, Item Charges, learn, Microsoft Dynamics NAV, NAV, NAVUG, Posting Group, Tips & Tricks

When we post purchase of items, we have item charges very often. We can post item charges on the same order with items or on different one. In my example, I will use independent document for already receipted items.

In this case, we have the similar rules about using posting groups as we post item purchase. Some posting groups are used from document header, and other from document line, as I already described in older post. But, in this case some of posting groups are inherited from the already posted receipt. You can see all combination on following chart:

When we post this document, we will get G/L Entries as result. You can find completely description of them in next table:

Posting Groups #2 – Item Sale Posting

27/04/201501/05/2015 atotovic Microsoft Dynamics NAV course, inventory, learn, Microsoft Dynamics NAV, NAV, NAVUG, Posting Group, Sales

Similar as purchasing, when we want to post item sale, we can do it in one step (posting shipment and invoice in the same time) or in two steps (posting shipment in the first step, and then posting invoice). You can also use some additional ways with Warehouse Management, but the G/L entries will be the same.
In my example, I have used second way with line and invoice discounts, for better example.
But, in any case as in purchase model, we have some rules about posting groups. Some posting groups are used from document header, and other from document line. In following chart, you can see how system uses posting groups on documents.

When we finish posting of shipment, we will get only two entries in G/L Ledger. These are only entries about inventory:

When we post invoice related with posted shipment, we will get more entries in G/L Entries. You can find completely description of them in next table:

Posting Groups #1 – Item Purchase Posting

25/04/201504/05/2015 atotovic Microsoft Dynamics NAV chart, course, inventory, learn, Microsoft Dynamics NAV, NAV, Posting Group, purchase

When we want to post item purchase, we can do it in one step (posting receipt and invoice in the same time) or in two steps (posting receipt in the first step, and then posting invoice). In my example, I have used second example. In my example, I also use line and invoice discounts, for better example.

But, in any case, we have some rules about posting groups. Some posting groups are used from document header, and other from document line. In following chart, you can see how system uses posting groups on documents.

When we finish posting of receipt, we will get only two entries in G/L Ledger. These are only entries about inventory:

When we post invoice related with posted receipt, we will get more entries in G/L Entries. You can find completely description of them in next table:

Reservations and Planning/Projected availability calculation

09/09/201409/09/2014 atotovic Microsoft Dynamics NAV calculation, inventory, Microsoft Dynamics NAV, MRP, MSDN, NAV, planning, reservations

Microsoft Dynamics Team Blog publish one interesting article today. This one is about impact of Reservations in the Planning and Projected availability calculation. Does planning and projecting system include or not reserved quantities in the calculation?

You can find all details on: http://blogs.msdn.com/b/nav/archive/2014/09/09/reservations-versus-planning-and-projected-availability-calculation.aspx

Excellent described processes.

Inventory Planning in Microsoft Dynamics NAV

03/09/2014 atotovic Microsoft Dynamics NAV inventory, Microsoft, Microsoft Dynamics NAV, MRP, planning

Last year I wrote about inventory planning in Microsoft Dynamics NAV (most of them is for NAV2013 or/and NAV2013R2) on my old blog. I think, I can make small reminder on these articles, because this is always current topic.

This is small ‘Table Of Content’ with links to the articles on my blog on the Microsoft Dynamics Community.

Inventory Planning – part 1 (Microsoft Dynamics NAV): The basic Microsoft Dynamics NAV 2009 planning concept as flowchart;
Inventory Planning – part 2 (Microsoft Dynamics NAV): The basic Microsoft Dynamics NAV 2013 planning concept as flowchart;
Inventory Planning – part 3 (Microsoft Dynamics NAV): Flowcharts for calculating of date for methods of stock demands and availability (Purchase Order Time Calculation, Production Order Time Calculation, Sales Order Time Calculation, Transfer Order Time Calculation);
Inventory Planning – part 4 (Microsoft Dynamics NAV): Flowchart of demand and supply situation of the item and calculation of the projected available balance;
Inventory Planning – part 5 (Microsoft Dynamics NAV): Net Actual Demand against the Forecast in Manufacturing Planning (flowcharts, descriptions and examples);
Inventory Planning – part 6 (Microsoft Dynamics NAV): The base planning setup (Inventory Setup, Manufacturing Setup) – initially global planning setup in NAV;
Inventory Planning – part 7 (Microsoft Dynamics NAV): The specific Item Card Planning Setup;
Inventory Planning – part 8 (Purchase Planning in Microsoft Dynamics NAV): Operational work in planning process for purchase.
Inventory Planning – part 9 (Manufacturing Planning in Microsoft Dynamics NAV): Operational work in planning process for manufacturing.
Inventory Planning – part 10 (Microsoft Dynamics NAV): Reordering Policy examples:
Inventory Planning using many locations – SKUs – 1
Inventory Planning with SKU – 2 (demand flowchart)

OK, I need to finish with remaining subtopics, and because of that I made this reminder here.