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) / Customized calculated ...
Microsoft Dynamics AX (Archived)

Customized calculated amount for sales Invoice

(0) ShareShare
ReportReport
Posted on by Community Member

Hi All,

I've customized the sales order form,

In sales line we've added new field called 'Total no.of Days', Net amount in line should be calculated as Total no.of days * Qty * sales Price(and also if any discount applied). I calculated as by the formula but if I confirm the sales order,it takes the amount by the formula as qty * sales Price. Also we've periodic invoice scenario, means we introduced from date ,to date in header. say From Date =1-Jun-17 ,to Date = 31-Jul-17. I want to invoice for june month. Total value of sales order is 12,000 means, For june month 6000 to be invoiced and for july month 6000 to be invoiced(two invoice to be done for same order).

I have two questions,

1. Where I've to calculate the amount by my way while confirm the sales order.

2. How can I invoice the sales order for above scenario?

Please give your inputs...

*This post is locked for comments

I have the same question (0)
  • Fredrik Sætre Profile Picture
    Fredrik Sætre 12,644 on at

    I think your questions got lost in translation...

    When you update the Net amount on the sales order it is simply just to invoice it like any other sales order.

    You might however want to update your confirmation and invoice documents to make the amount make sense or write some more details in the line description.

  • Suggested answer
    Rohin Profile Picture
    Rohin 4,624 on at

    Hi NiyaZf,

      After SalesOrder Confirmation, data is populated to CustConfirmJour and CustConfirmTrans and some other related tables. I think , LineAmount is not Initialized to CustInvoiceTrans from SalesLine( check initFromSalesLine() on custInvoiceTrans Table) so I would suggest you to debug and check how LineAmount is initialized while confirming salesOrder.

    For Second Scenario, I would suggest you to create new thread with appropriate title as this thread title doesn't relate  to your second issue.

  • Fredrik Sætre Profile Picture
    Fredrik Sætre 12,644 on at

    You should be able to override the line amount and not use the qty * price. I would believe that lineamount must be transfered some how...

  • Suggested answer
    Rohin Profile Picture
    Rohin 4,624 on at

    I think it is calculated by Map "SalesPurchLine" (calcLineAmountExclTax() ) which is called on SalesConfirmJournalCreate class. But better if you debug yourself then you get to know.

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