When we try to apply “Item Charges” for multiple GRN documents taken through Get Receipt Lines. System is not allowing to apply based on “Amount”. But is is allowing to apply “Equally”.
Same issue happening when we have large no. of lines in the GRN
Thank You in Advance.
*This post is locked for comments
If you want to allocate the charge depending on the amount, then you need to do a small modification to the receipt and allocation functionality.
You can have a separate field in the receipt table to hold the updated unit cost and depending on this field you can do the allocation. This is bit tricky and if you need more clarifications please do revert us back.
Since, the receipt cost is zero, you will not be ale to assign on Amount.
However, if equal assign is not appropriate then you can assign it manually by input of qty to assign. This will allow to to assign the cost to the receipt based on specific figure input by the user
Agree with SURESH and this is not a bug and it is how the system was build up.
You have 2 options :
1. Enter the expected cost and later adjust it by posting the invoice.
2. Use the equally allocation method since you enter the 0 for expected cost.
Run the Adjust Cost report ? This should update the cost.
Departments/Financial Management/Inventory > Adjust Cost
If amount to assign is zero on the receipt lines then it cannot assign it, how would system know what to assign when it is zero. So in that case you have to use Equally. If you don't know the cost of the item, you can use the expected cost and when you invoice it will override the expected cost and will use the invoice cost as actual cost.
So ibelieve what you are seeing is not an issue, if the amount is zero how would you want system to calculate the assignment? i mean what is the proportion. Unfortunately you have to use equally in this scenario.
We do not know the cost of the item at the time of GRN so the cost is 0 in the receipt line. But at the time of invoice we enter the actual cost and post the invoice. But receipt line cost does not get update.
So how should we handle this?
Check the cost amount in the receipt line. I think in this case it is 0 value. That cause the problem.
No modifications. We are using 2013 R2 and is there any fix released for this?
We have not installed any CU for the 2013 R2 Version.
I tried it with multiple receipts and large no. of lines also but it is working fin.
do you have any customizations?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,188 Super User 2024 Season 2
Martin Dráb 230,030 Most Valuable Professional
nmaenpaa 101,156