I need to get the tax amount based on the Invoice Detail record (Invoice Num & Invoice Line).
I connect InvcDtl and InvcTax tables using Invoice Number and InvcLine.
But for the same Company, Invoice Number and Invoice Line, multiple records are there in the InvcTax table.
I have verified all the data in the Invctax able as well. But I could not find any way to get the latest or single record from the InvcTax table.
Can you please help us to get only one record from the InvcTax table for a given Invoice Number and invoice Line?
The reason you’re seeing more than one record may be because there are different types of taxes. You can check this by adding TaxCode to your column select. For example, in Canada some provinces have a GST (Goods & Services Tax) and a PST (Provincial Sales Tax), which would look like this in Epicor:
Also, it would be nice if you included a bit more information, right now we have zero context on what you’re trying to accomplish. All we know is you’re trying to connect these two tables and display a field, but we don’t know what your BAQ looks like or what you’re trying to accomplish with this.
