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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Sales Order details Re...
Microsoft Dynamics AX (Archived)

Sales Order details Report

(0) ShareShare
ReportReport
Posted on by D365 beginner 636

Hi Guys,

I am developing a report containing some Sales Order lines details. I need to include back order quantity in Kg and back order amount in company base currency in my report. Can someone help me to create a code to calculate and show back order amount in base currency.

consider the company base currency is USD, the requirement is,

back order quantity = SalesLine.RemainInventPhysical (Its already there)

1.  If the SalesPrice is in USD : Back order amount =  SalesPrice * RemainInventPhysical

2.  If the SalesPrice is other than USD: the code should check the field FixedExchange rate in the salesTable, If it contains      a value the formula should be 

     Back order amount =  (FixedExchange rate * SalesPrice) * RemainInventPhysical

3.  If the field FixedExchange rate has no value the code should consider currency from the salesline and respective latest      currency rate from the table ExchRates and the formula should be

     Back order amount =  (Currency's latestExchRate * SalesPrice) * RemainInventPhysical

Thanks in Advance.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Mea_ Profile Picture
    Mea_ 60,286 on at

    Hi Alex Antony,

    Try this:

    Back order amount = Currency::curAmount(
   SalesPrice * RemainInventPhysical,
   salesLine.CurrencyCode,
   exchRateDate,  //probably systemDateGet()
   salesTable().fixedEuroTriangulation(),
   salesTable().fixedExchRate(),
   salesTable().fixedExchRateSecondary());

    or simple 

    Back order amount = salesLine.amountCur(salesLine.SalesPrice * salesLine.RemainInventPhysical);

    However, please don't forget that you may have discounts on the line or header level that this method won't consider.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
CP04-islander Profile Picture

CP04-islander 16

#2
GiacomoRovai Profile Picture

GiacomoRovai 4

#3
Douglas Noel Profile Picture

Douglas Noel 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans