Vendor Invoice Journal - Print Balances report incorrect

This question is answered

If we enter an invoice in a Vendor invoice journal, and we wish to view the impact on our balances, we can use the Print - Balances report.

However, this report does not seem to take into consideration the sales tax on the invoice.  I have attached an example:

The invoice is for EUR 239,59 to be posted to vendor 100001. We are offsetting ledger account 6110, and we have sett AP-DOM (accounts payable domestic) sales tax FULL-S (Full services = 21%) on it.  The calculated sales tax, EUR 41,58 is not displaying in the report, and the impact on 6110 is 239,59.  This is however not correct.

Anyone else experiencing this in AX 2009?

[URL=http://imageshack.us/photo/my-images/6/lq6y.jpg/][IMG]http://img6.imageshack.us/img6/2760/lq6y.jpg[/IMG][/URL]

Uploaded with [URL=http://imageshack.us]ImageShack.us[/URL]

Verified Answer
  • Hi Thor,

    This is standard behavior of AX. It is like this since I started working with AX in 2001.

    When printing not posted journal lines, no report will look further for the sales tax (account or amounts).

    It might be an idea to extend this report with a sales tax column.

    kind regards,

    André Arnaud de Calavon  |  Microsoft Dynamics AX Solution architect  |  My blog  |  My company

    This post is my own opinion and does not necessarily reflect the opinion or view of my company, Microsoft, both its employees, or other MVPs.

All Replies
  • Hi Thor,

    This is standard behavior of AX. It is like this since I started working with AX in 2001.

    When printing not posted journal lines, no report will look further for the sales tax (account or amounts).

    It might be an idea to extend this report with a sales tax column.

    kind regards,

    André Arnaud de Calavon  |  Microsoft Dynamics AX Solution architect  |  My blog  |  My company

    This post is my own opinion and does not necessarily reflect the opinion or view of my company, Microsoft, both its employees, or other MVPs.

  • Thanks AndrĂ©,

    Fantastically strange report :)

    /Thor