757
Dear All ,
good day
i have an item and when i create transactions like sold i guess it should get cost even if i not invoice the order i have checked include physical cost in item model group also financial negative amount now when we make transaction not all transaction get cost amount any one face this issue before or how we can avoid this in future
Many Thanks Dr.ludwig for your support
* as you mention above we actual receive Po invoice late is this will be an issue when i try to close the inventory
* no i don't allow people to record PO with 0$ value
* include physical value activated in item model group
* for recalculation i discusses with my colleagues to run every month but we face an issue last time we run it on 31-3 and we have one account that have 0 balance in 31-3 after we run Rec we check the balance for this account it was Debit on 1-4-2020 with amount regarding rec
Hi atef083,
Activating the latest cost price parameter might be one part of the solution.
In addition, I would recommend that you discuss with your colleagues the following:
* Do you always receive PO invoices late? If so, can/should this process be accelerated?
* Do you allow people recording POs with a $0 value?
* If you regularly post packing slips, then the activation of the 'include physical value' parameter in the item model group might help as well.
* Can you probably automate / auto schedule an inventory recalculation that runs every night?
Best regards,
Ludwig
Many thanks dr. Ludwig for your support
but can you explain to me do i need to checked the latest cost price field in item to avoid this in future if I didn’t invoice the po and create issue for the item to get the cost and after i invoice the po i run recalculation or what
Good morning atef083,
Good to hear that things are ok after running the inventory recalculation.
The reason why I asked for posting the invoice is because AX needs a basis to calculate the COGS or the issue price.
Imagine you have a new item that has been delivered with a price of $0 that was entered when posting the packing slip.
In this case you can sell the item but the COGS or issue price will be $0 because you basically got the item 'for free' when you posted the packing slip for $0.
Once you post the invoice with the correct amount let's say $50, AX knows that cost and can calculate and post an issue price, i.e. your COGS.
Hope that makes sense to you :-)
Best regards,
Ludwig
please note after i invoice the order and run inventory recalculation every thing is ok , my question why this happen do i need to invoice first if so why should i checked financial negative
i don't understand why this happen in the beginning
first of all thank you for fast respond Dr .Ludwig
the item not have cost price setup in the item master , do i need to invoice the purchase order if yes so why i checked financial negative in item model group i think this should allow me to post financial with negative amount till in invoice the item and make recalculation
i have one question do i need to checked use last cost price in manage cost for the items
Hi atef083,
Have the items that don't have a COGS assigned been purchased and has the purchase invoice been posted?
Alternatively, have the items a cost price setup in the item master?
Have you tried running an inventory revaluation to check whether this fixes the issue?
Best regards,
Ludwig
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,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (