Knowledgebase article 860025 at https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?WTNTZSMNWUKNTMMYVTQUUXNNZOUKYPPPXNMNXSRWWMWKZRVOWPOYXMOVMPTSZUUV
describes how to add the Tax Detail ID to a SOP blank form, which effectively means adding all fields from the Tax Detail table; i.e. VAT registration number, VAT rate etc.
However the guide is ambiguous as to whether it refers to line item Tax Details or document Tax Details (seems to be the former). It tells you to join additional tables on Line Item Sequence, but leave the Tax Detail ID unlinked (when linking to the Sales Taxes Work and History Table, SOP10105). This leads to unexpected behaviour as we want the summary Tax Detail of the document, not that of individual line items.
As per this KB article (873931):
https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?WTNTZSMNWUKNTMMYQLYTNSUKZPXKMUNVLZZURYTPXNSZTMNKKVTWLYMLMPWXQQRY
the summary is stored with a Line Item Sequence of 0 in the SOP10105 table and so is not included in our join with the Sales Transaction History.
On an Irish invoice with line items with GB tax details, I was only seeing the GB VAT Number and Rate on my client's reports.
The method that worked for me was to remove the link on Line Item Sequence between the tables described in the first KB article. Then to add a restriction to the report definition specifying that the Line Item Sequence on Sales Taxes Work and History should be 0.
Finally this gave me what I wanted: The Irish Tax Details on a document containing items set up with GB Tax Details where previously I could only see the GB details. Repeat for the other SOP Blank Documents.
Obviously, to get separate Tax Details for individual line items, the guide should work, but it doesn't when the document tax is not based on the line items but the customer record.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.