Share
Report
90I have a typical accountants question I think.
In the company I work for we are not using the logistical part of NAV for cost posting. I used to do this for my previous employer. I'm now in a test environment and have turned on:
- Automatic Cost Posting
- Expected Cost Posting to GL
- Automatic cost adjustment set to "Always"
All entries go as expected for PO's where we now what price we are buying for. The financial impact is booked as I expect it.
But in my company this is only a small part of what we do. I work in a marketing company for soft fruit, where we sell fruit on a commission base. Therefore 80 to 90% of our sales is done, then we calculate the price back to growers and created a pruchase invoice after all sales invoices are created.
If I look in the Item Ledger Entry there is no issue, the costs are booked to the correct sales lines, it gives a good profitability overview.
But I hoped the system would take the correct actions to show a correct financial overview on GL level, but I have the feeling it doesn't do that.
What I've done is did a receipt in 01/11, a sales on 10/11, 15/11 and 21/11.
After that I booked a purchase on 16/11, ran the "Adjust Cost - Item Entries" and "Post Inventry to GL" jobs.
After that I looked at GL with the date ..15/11. I hoped I would see the COS for the sales I did before the Purchase invoice is booked, because I expected the jobs would have created the necesarry entries to show a correct Financial overview. I'm checking this as we have a monthly period end close.
Of course I can correct the entries by accruals through the recurring journal, but I was hoping there is another job or report which could solve the issue.
But I was hoping I missed a job or function in NAV, which could solve this issue. Is there someone who can help out?
*This post is locked for comments
I have the same question (0)
All responses (
Answers (
