You’re offline. This is a read only version of the page.
625
I'm new to NAV 2013 R2, I am studying the functionality of NAV in accounting.
I am using average costing method in the calculation, my scenario as follow :
I have a Purchase for 5 qty of Item A at unit price 10, and continue with confirmation and receipt.
After that I sold 2 qty of Item A at the same unit price, and invoiced.
Then when I received the purchase invoice, the unit price is 12.
My question is :
How can I account the price difference of 2 ?
What happen to my remaining quantity ?
Appreciate help, thanks.
*This post is locked for comments
But, running the Adjust Cost - Items Entries it will correct it to a needed one?
Don't worry about the Unit Cost.
System will take the actual Average Cost as on date, when you post the Sales.. This batch job will adjust the accurate costing for the outbound sales entries.
You can check by posting the entries in test environment.
I noticed that before I run Adjust Cost - Item Entries, my Unit Cost has auto changed from 10 to 12 after my purchase posted, after I run Adjust Cost - Item Entries, the Unit Cost changed back to 10, which is my original value.
So at this point when I have other sales entries, it will take Cost amount as 10, right ?
But I thought it supposed to take 12 since I pay to vendor at this cost ?
Correct me if I was wrong. Thanks
You can navigate the Posted Sales Invoice and see the additional Value Entries and G/L Entries created by the system.
Alternatively you can also drill down item ledger entries and navigate the same to see the impact.
Item Register and G/L register would also show all the entries created by system.
As mentioned by Alexander, You can find the option under /Departments/Financial Management/Inventory/Adjust Cost - Items Entries.
Please note that, this batch job is absolutely mandatory to have accurate Inventory & COGS financial impact. You need to run this batch job on periodic basis (preferred daily).
Refer below link for more details.
NAV should understand when you have made a certain purchase and certain sale. Since you can do this transactions in a different sequence (not in chronological order), the actual transactions that NAV is doing might not be correct in the end. To fix this, there is a special job called Adjust Cost - Items Entries. You can find it in ***/Departments/Financial Management/Inventory/Adjust Cost - Items Entries. Run this job and system will run through the item transactions and make corresponding corrections to adjust the written cost to correct values.
You need to run "Adjust Cost Item Entries" batch job.
This will pass the difference amount to sales entries (COGS) and would give the correct financials.
#1
Sohail Ahmed
2
#1
mmv
2
#1
Amol Salvi
2
Share
Report
All responses (
Answers (
