web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

Issue in the Cost

(0) ShareShare
ReportReport
Posted on by 224

Dear All,

i have issue in Inventory unit cost, while making the Material issue unit cost is 500, but while making the return order the cost is changed to 400 (item). what will be issue? how can be rectified

Regards

I have the same question (0)
  • Suggested answer
    MahGah Profile Picture
    15,529 on at

    Hi

    What is your cost method? Also, what is the current cost if item? Is it 400 or 500?

    In Return Reason Code have you selected "Inventory Value Zero" and do you have Standard Costing? If yes "If an item's costing method is set up as Standard, it means the inventory increase is valued at a budgeted (standard) cost instead of at an acquisition cost, and the program ignores the Inventory Value Zero field. "

    Can you check Sales & Receivable setup and see if "Exact Cost Reversing Mandatory" is on or not (more info below).

    The Exact Cost Reversing Mandatory field defines whether a company wants to apply an exact cost reversing policy when processing inventory increases represented by the sales returns. This means that when inventory is returned to stock, the program values the items on the sales return at exactly the same cost as the original sale. If an additional cost is later added to the original sale, the program updates the value of the sales return respectively. Selecting this check box indicates that the program prohibits a return transaction to post unless the Appl.-from Item Entry field on a corresponding order line contains an entry.

    And more info. Do you use any of these methods?

    When entering a sales return line, the order processor must ensure that upon invoicing the order, the returned item is revalued at the unit cost of the original sale (instead of at the unit cost suggested by the program as based on either average or standard unit cost). There are three methods of assigning exact cost reversing to a return line:

    • Fill in the return order line manually, add the Appl.-from Item Entry field using the Choose Columns feature and then select the relevant line from the Item Ledger Entries page.  

    • Use the Copy Document function to fill in the return order automatically from another posted shipment or invoice document. If the Exact Cost Reversing Mandatory check box is selected on the Sales & Marketing Setup, the Appl.-from Item Entry field automatically populates on the return line with the corresponding entry.  

    • Use the Get Posted Document Lines to Reverse function to select one or more posted document lines for exact cost reversal. This function is especially useful when users need to copy one or more lines that appear in one or more posted documents.  

  • LearnBC Profile Picture
    224 on at

    Thanks for your reply.

    am just saying eg as 400 and 500. i here by attaching the screenshot and reverse actuals is not set as mandatory. Actually this issue didn't came before. so don't know what will be the correct procedure. so could you pls guide me in step by step how we can sort the issue

    cost.jpg

    cost1.jpg

  • Suggested answer
    Dallefeld Profile Picture
    211 User Group Leader on at

    You mentioned 'while making' does that mean that you are assembling or producing the item? Have you run adjust cost-item entries? Even with Automatic Adjust Cost turned on, you should run adjust cost at least once per month.

  • Suggested answer
    MahGah Profile Picture
    15,529 on at

    Hi

    I am not sure why this issue happened for this item. 

    Can you please look into this video and let me know if this is the step you followed? If yes then this could be the reason https://usedynamics.com/business-central/sales/return-orders/

    In above (last 3 paragraphs) 3 possible solutions provided. Can you test them and see which one works the best for you? If you use below no need to turn that function on. 

    For example see this video that matches solution 3  https://www.youtube.com/watch?v=hnnhOKwWgf4

    For solution 2 you need to open Sales Return and populate customer then below.

    pastedimage1655211572580v1.png

  • LearnBC Profile Picture
    224 on at

    Thankyou for the detailed Reponse.

    I have facing the issue in Job Module/Job planning lines. I have made material return on Jobs. am extremely sorry for forget to mention this

    Costjob.jpg

  • MahGah Profile Picture
    15,529 on at

    Hi

    No worries. I have no experience with Job Module. I hope S.Kawamura  or someone else can provide more info.

  • LearnBC Profile Picture
    224 on at

    Hello All,

    Anyone pls help me on this to solve the issue.?

  • Suggested answer
    Dallefeld Profile Picture
    211 User Group Leader on at

    Can you explain what you are trying to do?

    Have you run Adjust Cost - Item Entries?

  • Suggested answer
    Dallefeld Profile Picture
    211 User Group Leader on at

    We need more information. Screen shot of item ledger entries and associated value entries might help!

  • Suggested answer
    Inge M. Bruvik Profile Picture
    1,111 Moderator on at

    If you register orders at different times the system will present you an expected cost that will be corrected during posting and cost adjustment.

    Are you still having issues with the cost after everything is posted and adjusted?

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,151

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,443 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,092 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans