Expected Cost Posting

Mango
Member Posts: 4
What would happend if Expected Cost Posting was switched off and a user decides to post/invoice a purchase order. Which accounts would be affected or not affected. What batch job would you need to run in order to update the expected cost?
I'm not too clear on the whole process and what expected cost posting actually does so if someone could explain it would be much appreciated.
I'm not too clear on the whole process and what expected cost posting actually does so if someone could explain it would be much appreciated.
0
Comments
-
First of all, you need to activate "Automatic Cost Posting" ( or run Report "Post Inventory Cost to G/L", this has to be done regularly anyway even if "Automatic Cost Posting" is activated) is you want NAV to post inventory cost amounts to your inventory accounts.
If the actual cost on the inventory accounts is sufficient for your requirements , there is no need to activate "Expected Cost Posting". It is merely an option to see what is likely to happen to your inventory balance before the purchase orders are invoiced.
There are 2 accounts, Invt. Accrual Acc. (Interim) (debited), in the "General Posting Setup" and the Inventory Account ( (Interim) ( credited) in "Inventory Posting Setup", for which G/L entries are created when "Expected Cost Posting" is active and the purchase order is received. When the purchase is invoiced, a second G/L entry for the inverted amount for these accounts is created, at the same time there are G/L entries created with the actual cost for the non-interim versions of these accounts.
The other important batch job is "Adjust Cost - Item Entries". This forwards the cost from the purchases to the sales , from where they then
turn up on the COGS Account ( and the COGS Account (Interim) if "Expected Cost Posting" is active.)Kai Kowalewski0 -
In continuation with Kowa's reply, I would like to add the below:
Expected Cost Posting is explained with an example:
A User creates a Purchase Order for 10 units @ $ 10.
When the Purchase Order is posted with 'Recipt' as an option then two entries are created:
Inventory Account Interim Debit $ 100
Inventory Accrual Acc Interim Credit $ 100
When the Purchase Order is posted with 'Invoice' as the option, the above entry gets reversed and the actual stock , purchase and vendor accounts get impacted.
So please note the Interim Accounts will have a zero balance when you completely invoice the Purchase Order
Now if you are already using Expected Cost Posting and want to turn off this option, then ensure the existing Purchase Orders that have been received but not invoiced, should be Invoiced completely. This will ensure that no balance exists in the G/L accounts and no balane of expected cost appears in the Value Entries0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions