Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV (Archived)

Unable to Calculate the value of amount

Posted on by 215

Hi everyone,

I had faced one problem which is to calculate the amount (formula:direct unit cost * quantity).

I had try to put above formula into the layout (Format textbox), but after run it, the amount still is zero. (Refer to picture)

So may I know where I can put the formula in order to generate the amount?

0564.Capture6.PNG

0564.Capture5.PNG

Thanks.

*This post is locked for comments

  • Jade Ng Profile Picture
    Jade Ng 215 on at
    RE: Unable to Calculate the value of amount

    Hi all,

    I had settled my problem already.

    Thanks.

  • Jade Ng Profile Picture
    Jade Ng 215 on at
    RE: Unable to Calculate the value of amount

    Hi,

    Thanks for reply.

    I have check again the expression, I no used wrong field name ( the picture above is the header actually).

    And one more thing i have to say that, in my return shipment line actually does not have the field of amount, but now i have create the field of amount into the table of return shipment line, then i pull out and put into the report layout.

    But then it does not work, the amount still remain zero (actually the value of amount is direct unit cost * quantity).

    And when I create the formula direct unit cost * quantity in the page of return shipment lines, the value of amount able to work, but when generate the report, it still remains zero.

    Anything i forget to insert?

    So, can anyone give me some suggestions?

    Thanks.

  • Suggested answer
    I Gusti Made Ari Profile Picture
    I Gusti Made Ari 3,594 on at
    RE: Unable to Calculate the value of amount

    Looks like you are using wrong  field name for the formula ,  Check the expression of Quantity and Direct Unit Cost  column which field name  it is using

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!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans