You’re offline. This is a read only version of the page.
Announcements
2
Hello,
We have a situation where for a number of items that were new, no standard cost were calculated based on the BOM and Routings. So the standard cost is 0. The product has been produced and sold in salesorders. No GL entries were mad because they are 0.
The item was made in june. I would like to set the standard cost on the first day of the item in june and then recalculate all Item entries with that standard cost price from that moment forward. I tried several things but it doesn't work.
What is the proper procedure to do this?
Thank you in advance!
I had the same issue with a recent Go-Live.
This is a known issue and it's due to BC not posting G/L entries with 0 amount.
When you post transactions for items with cost = 0, BC creates value entries with a zero amount.
The value entries cannot generate G/L entries, therefore you are stuck.
Unfortunately, the only option is to create a general journal to fix inventory and COGS.
I would not recommend using development because G/L entries and value entries are tables that I would not touch with code.
Here is an article I wrote recently about the issue
Thank you for your answer. I tried this but BC doesn't generate the G/L entries with new standard cost value on an already shipped sales order.
So the shipment of the sales order and invoicing was done at the end of june and no G/L entries were made, only revenue, but no cost of sales /inventory (credit) because the standard cost was 0. The margin on these line are infinity. Is there a way to generate these lines...?
Thank you in advance.
Sorry my bad.
With standard cost this is what you have to do to generate the revaluation journal.
I should probably update the blog post.
Hope this works.
To be able to fix this you need to do item revaluation to change the cost of your inventory transactions.
You can read more about that procedure in my blog post:
#1
André Arnaud de Cal...
294,261
Super User 2025 Season 1
#2
Martin Dráb
232,996
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
Share
Report
All responses (
Answers (
