Forum Discussion

Black783's avatar
Black783
Frequent Visitor
9 years ago

QuickBooks Connection Duplicate Invoice Records

When a QuicBooks Online Invoice has Sales Tax and Shipping values assoicated with it, there are 3 records assoicated with that invoice on the Invoice table.  The line item amount and Sales tax amount...
Need Help
v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

Hi Black783,

 

According to your description, you should be able to use MAX Function (DAX) to create two measures to get correct line item amount and sales tax, then show them on the report in this scenario. The formulas below are for your reference.:smileyhappy:

Line Amount = MAX ( 'Your table name'[Line.Amount] )
Total Tax = MAX ( 'Your table name'[TxnTaxDetail.Totaltax] )

 

Regards