web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

behavior when posting vendor joirnal invoice

(0) ShareShare
ReportReport
Posted on by 5

first, sorry for my inglish, is not my native language.

I want to know if this is a normal behavior about taxes when I post an invoice journal.

i have the following values for my journal lines (all in the same voucher number):

line     Type               invoice number        Debit                       Credit
1         Vendor           100                           0                              275
2         MainAccount  100                          0                               100
3         MainAccount  100                          0                               75
4         MainAccount  100                          150                           0
5         MainAccount  100                          300                           0

the lines debit main account lines have tax group values selected, the credit lines do not. 

when i posted the journal the expected ledger result should be:

Type                      Debit                       Credit
Vendor                   0                              347 (Journal line's credit value plus taxes calculated ... 72) 
MainAccount         0                               100
MainAccount         0                               75
Tax                        72                             0
MainAccount         150                           0
MainAccount         300                           0

but only i can acomplish that when i whrite first the vendor's line and after the main account's lines.

If i whrite first the credit main account's lines, next the debit main account's lines and last the vendor's line i get the following result:

Type                      Debit                       Credit
Vendor                   0                              275 
MainAccount         0                               100
MainAccount         0                               147 (Journal line's credit value plus taxes calculated ... 72) 
Tax                        72                             0
MainAccount         150                           0
MainAccount         300                           0

If i whrite first the debit main account's lines, next the credit main account's lines and last the vendor's line i get the following result:

Type                      Debit                       Credit
Vendor                   0                              275 
MainAccount         0                               100
MainAccount         0                               75
Tax                        72                             0
MainAccount         150                           0
MainAccount         372                           0  (Journal line's debit value plus taxes calculated ... 72) 

is this normal behavior or is it a bug? 

I have the same question (0)
  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hi,

    In general, the tax calculation should be independent of the sequence how you enter the lines in a voucher.

    Is it possible that the lines entered default to or updated with different tax settings as you enter lines?

    Another thing to look out for is how the journal is setup (including/excluding tax amounts).

    If you can replicate the issue in a different demo/test system then I would recommend having a look at LCS where MS lists the available hotfixes.

    Best regards,

    Ludwig

  • Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Good morning Eduardo,

    Did you make any progress with this?

    Is there anything else the community can help you with?

    Would be great if you could keep us updated.

    Many thanks and best regards,

    Ludwig

  • Eduardo GarFig Profile Picture
    5 on at

    Good morning Ludwig.

    I took your advice, check configurations but everything is fine. The behavior is only presented with the mentioned example, which I could replicate in a test environment.

    The user told me that this type of operations does not run regularly, so I keep investigating.

    I guess I will check too on LCS to see if a hotfixes is available

    Thank you very much for the help

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 660 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 549 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 307 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans