Purchase cost posting with automatic cost posting

Now let us keep the “Automatic Cost Posting” checked and see the results.

Purchase cost posting with automatic cost posting

Let us take the same item:

Item No.:  1000
Description: Bicycle
Quantity: 1
Unit Cost: 350.60
Direct Unit Cost Excluding Tax: 350.60

Now, let us post a Purchase Order for Receiving.  NAV creates the following Item Ledger Entry:

Purchase cost posting with automatic cost posting

and the following Value Entry:

Purchase cost posting with automatic cost posting

Please note that the “Cost Amount (Actual)”, “Cost Posted to G/L”, and “Purchase Amount (Actual)” are zero; this is because we have not posted the Invoice yet

Note that the “Expected Cost Posted to G/L” is zero; this is because we have unchecked the “Expected Cost Posting to G/L” option

Since no cost posting is required at this stage, keeping “Automatic Cost Posting” checked or unchecked does not make any difference at this stage.

Once we post the Purchase Order for Invoicing, NAV makes the following changes:

Item Ledger Entry:

Purchase cost posting with automatic cost posting

and Value Entry:

Purchase cost posting with automatic cost posting

Since we have checked the “Automatic Cost Posting,” NAV has posted the Inventory to General Ledger along with the Sales:

Purchase cost posting with automatic cost posting

The positive side of keeping this option checked is, your General Ledger is ALWAYS current; NAV posts ALL costs as and when an Inventory transaction occurs.

The negative side of it is, whenever a Value Entry is created, NAV posts GL entries!  This affects the performance of the system.

If we keep this option off and run the “Post Inventory Cost to G/L” report instead, we can compress the GL entries “per posting group.”

When to keep this option checked :

Companies requires the cost to be current always.

Companies posts Inventory transactions 24×7.

There are only few Inventory transactions every day.

Share

Contact us

Related Post

The Ultimate Guide to Outsourcing Service USA Business Processes and Save Cost

Most businesses don’t waste money in dramatic ways. It usually disappears quietly

Dynamics 365 Support Services USA : Your Guide to Choose the Right Partner

Choosing a Dynamics 365 support partner sounds simple until you actually start

Dynamics 365 Offshore Development Services : Top Features & Benefits

Businesses rarely struggle because they lack software. More often, they struggle because