Skip to main content

Notifications

Microsoft Dynamics NAV (Archived)

Item Charge Issues

Posted on by Microsoft Employee

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

  • Suggested answer
    TharangaC Profile Picture
    TharangaC 23,116 on at
    RE: Item Charge Issues

    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.

  • Suggested answer
    Mosaheb Profile Picture
    Mosaheb 950 on at
    RE: Item Charge Issues

    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

  • Suggested answer
    TharangaC Profile Picture
    TharangaC 23,116 on at
    RE: Item Charge Issues

    DragosN : It will not adjust the cost of the receipt.

  • Suggested answer
    TharangaC Profile Picture
    TharangaC 23,116 on at
    RE: Item Charge Issues

    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.

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Item Charge Issues

    Run the Adjust Cost report ? This should update the cost.

    Departments/Financial Management/Inventory > Adjust Cost

  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 43,745 on at
    RE: Item Charge Issues

    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.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Item Charge Issues

    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?

  • Suggested answer
    TharangaC Profile Picture
    TharangaC 23,116 on at
    RE: Item Charge Issues

    Check the cost amount in the receipt line. I think in this case it is 0 value.  That cause the problem.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Item Charge Issues

    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.

  • Suggested answer
    Mohana Yadav Profile Picture
    Mohana Yadav 59,125 Super User 2024 Season 2 on at
    RE: Item Charge Issues

    I tried it with multiple receipts and large no. of lines also but it is working fin.

    do you have any customizations?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templates⚡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,188 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,030 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans