You’re offline. This is a read only version of the page.
434
Guys,
I would like to ask about the AX Inventory value report.
First of all, i am running my inventory cost at weighted average and financial cost at Site only.
How come i am getting a inventory value report with no physical stock but with inventory value?
My simulation as below:
1. Posted a PO00001 with financial qty of 10 and financial value of 1,000
2. Posted a PO00002 with physical qty of 10 and physical value of 1,200 (Not invoice yet)
3. Posted a Sales order SO00001 with financial qty of -10 and financial value of -1,100 (1,000 + 1,200)/20
4. Posted a Sales order SO00002 with financial qty of -10 and financial value of -1,100 (1,000 + 1,200)/20
All these happened in the same month. When i run inventory closing on 31/7/19, i can see the cost for SO00001 adjusted to 1,000 but not my SO00002
End up when i generate my inventory value report, i am getting no physical cost but with inventory value.
Wonder is there a good explanation on this or how to eliminate this?
*This post is locked for comments
As I understand it there is no physical value.
20 pieces were sold at the average cost in the system but with only 10 financially accounted so it left a negative amount.
If you allow financial negative then that is what happens.
If not then don't allow it and hold shipment until invoicing is updated.
(where would you expect the negative value of 10 pieces of inventory shipped at no cost to sit if not in inventory?
If it ships with a cost then where does that cost come from if not set off against a vendor liability?)
This is how average costing works.
Hi Dexin and Satish,
Please wait a minute to get this clarified.
You mentioned that 20 pcs were sold but only for 10 pcs of them - that is for sales order no 1 - the invoice was generated.
Right?
Don't you post the sales order packing slip in ledger?
If you post the packing slip in ledger then I wonder why the report still shows a physical inventory value of $1200.
Sales order no 2 has already been shipped if I understood you correctly and if you post the packing slip in ledger I would not expect a physical inventory value of $1200 because physically nothing should be in stock, right?
Best regards,
Ludwig
Thanks for confirmation Dexin. Please select 'Yes' against the answers that helped you to close this thread. This will help verify the answer as well.
It can have same behavior. However production is internal order and with proper procedure in place, this inventory related issue can easily be avoided. Why not end if already finished.
I don't think you want to prevent sales from invoicing, if you do check item model group parameters.
From an audit standpoint - Our system shows value of financial inventory balances if we haven't received and processed the corresponding purchase order invoice from the vendor. Once the invoice is received and processed, inventory closing will be performed and it will balance the inventory issues and receipts financially.
As a backup to this if asked, you can also print your 'Received not invoiced' report, it will have same item number as it's reflected on the inventory value report.
Thanks,
Satish Panwar
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (