Dynamics Community Forum Thread Details

Cost posting when purchase invoice is booked after sales invoice

I 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?

Quick Links