Small and medium business | Business Central, N...

Cost of sales not captured on invoices

(0) Share

Report

Posted on by Lethiwe

135

Hi All

Please assit, my client has been capturing invoices at zero cost incorrectly, now they want to include the actual cost, How do we fix that in a journal entry.

Cost is at zero and gross is at 100%.

Categories:

Dynamics 365 Business Central

All responses (7)

Answers (0)

Suggested answer

Inge M. Bruvik 1,021 Moderator on at

Like (0)

Report

RE: Cost of sales not captured on invoices

What costing method do they use on the items?

If they use standard cost you can just post the G/L side of the cost for the items sold.

If they plan to use average or fifo you will have to do revaluation.
TCJ on at

Like (0)

Report

RE: Cost of sales not captured on invoices

Balance to COS (COGS) would be Inventory.

My question is do you just want to fix it going forward or are you trying to recalculate the past?

Kim and Yun give helpful information on getting value into your inventory. The adjustments would post to inventory and inventory adjustment.

If you want to build history from a manufacturing system, that's going to be VERY complex. How many transactions have already been posted? If you have an active system it may just require backing into the numbers and posting G/L entries. Then zeroing the inventory accounts and doing the revaluations Yun and Kim mention.

Doing it "right" at a minimum would mean revaluing all purchase transactions on the date of their posting, then allowing the Adjust Cost to forward that through the system.
Suggested answer

Dallefeld 175 User Group Leader on at

Like (1)

Report

RE: Cost of sales not captured on invoices

You will need to revalue the inventory which has you put a cost to every positive (addition of quantity) entry in the item ledger. Once posted and adjust cost runs, the system will take the new value and move it through to cost of sales where applicable.
Lethiwe 135 on at

Like (0)

Report

RE: Cost of sales not captured on invoices

No. They do production orders not purchases for most of their inventory. They produce it. The unit cost was just not set on item card
Suggested answer

YUN ZHU 81,489 Super User 2025 Season 1 on at

Like (0)

Report

RE: Cost of sales not captured on invoices

Hi, this is very strange. Is the amount on your purchase invoice always 0? Or is there a problem with the setting of the posting group, and it has been posted to other accounts?

You can use Revaluation Journal feature to appreciate or depreciate an item.

More details: https://learn.microsoft.com/en-us/dynamics365/business-central/inventory-how-revalue-inventory

Hope this helps.

Thanks.

ZHU
Lethiwe 135 on at

Like (0)

Report

RE: Cost of sales not captured on invoices

Yes they sell inventory this whole time the customer been capturing invoices at zero cost only capturing unit price. We just realized now that the cost was not accounted for in the system . Now I want to know if I can capture cost through a journal and if yes what would be the balancing account.? Would it be inventory adjustment or just inventory?
Suggested answer

Dallefeld 175 User Group Leader on at

Like (0)

Report

RE: Cost of sales not captured on invoices

Are you selling inventory? If so why are there no costs? Are there costs for Domestic?

Please provide more background