It looks like I don’t actually have a decimal issue but I still have a problem with the veracity of the Inventory Valuation report. I do think that we should run the Inventory to G/L Reconcile more as it has so much information. So, the report does not do an on-hand * unit cost calculation to get the inventory value as I thought but does as you say a value divided by the quantity calculation.
It gets the Inventory Value by summing the values in the Cost Amount (Actual) field in the value entries for that item, and then divides that by the on hand to get the unit cost. The cost and inv value are based on the sum of Cost Amount (Actual) of the value entries at a given end date. It starts at a given begin date and calculates the value of the item’s inventory then adds the value of inventory increases and subtracts the value of inventory decreases up to a given ending date. Regards
Login
Report
There was a problem reporting this post.
Block Member?
Please confirm you want to block this member.
You will no longer be able to:
See blocked member's posts
Mention this member in posts
Invite this member to groups
Message this member
Add this member as a connection
Please note:
This action will also remove this member from your connections and send a report to the site admin.
Please allow a few minutes for this process to complete.
Report
You have already reported this .
Welcome to our new site!
Here you will find a wealth of information created for people that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!