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 cube Problem
Microsoft Dynamics AX (Archived)

Sales cube Problem

(0) ShareShare
ReportReport
Posted on by munsif 1,536

hi expert, i have question regarding sales cube, in sales cube there are measure,  customer invoice line (customer invoice line amount-accounting currency ) and customer invoice (customer invoice amount) the logic say that the value of both field should be same, but the value from both fields are different.?

customer invoice line amount is Invoiced amount per line,

while

customer invoice amount is  sum The invoiced amounts,

i believe that value from both field should be same,

if i wrong, then please guide me,

Regards

*This post is locked for comments

I have the same question (0)
  • Hariharans87 Profile Picture
    Hariharans87 36 on at

    1. customer invoice lines:

    customer invoice line amount-accounting currency measure using the field Sum of CustInvoiceJour.InvoiceAmountMST

    2. customer invoices:

    customer invoice line amount-accounting currency measure using the field Sum of View CustInvoiceTransExpanded.CommissAmountMST (Table CustInvoiceTrans.CommissAmountMST)

    I don't know where they are using these field in the AX form.

  • munsif Profile Picture
    munsif 1,536 on at

    Thanks Boss for your quick response, as i know  the invoice amount MST field coming (CustInvoiceJour.InvoiceAmountMST ) customer invoice measure and the customer invoice line amount field coming from (CustInvoiceTransExpanded.LineAmountMST) customer invoice line measure.

    now i did not understand why the data are different?

  • Hariharans87 Profile Picture
    Hariharans87 36 on at

    2. customer invoices:

    customer invoice line amount-accounting currency measure using the field Sum of View CustInvoiceTransExpanded.CommissAmountMST (Table CustInvoiceTrans.CommissAmountMST)

  • ColbyGallagher Profile Picture
    ColbyGallagher 3,668 on at

    Do you have an invoice with one line, and CustInvoiceJour.InvoiceAmountMST is greater than CustInvoiceTransExpanded.LineAmountMST?  You may have header charges that would be in MarkupTrans, they will hit the invoice, but don't have to be pushed to the line.

  • munsif Profile Picture
    munsif 1,536 on at

    boss then how it will be sort out? is that will be remain different , means that customer invoice line amount and customer invoice amount?

  • ColbyGallagher Profile Picture
    ColbyGallagher 3,668 on at

    They will remain different.  The charges would show in Customer Invoice Charges - Accounting currency.  Looking at this a bit more, you could also have discounts that were only at the invoice level, so you should look in Customer Invoice Discount - Accounting Currency as well. 

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!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Joris dG Profile Picture

Joris dG 5

#2
Alexey Lekanov Profile Picture

Alexey Lekanov 2

#2
Henrik Nordlöf Profile Picture

Henrik Nordlöf 2 User Group Leader

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans