Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Vendor Invoice pass so...
Microsoft Dynamics AX (Archived)

Vendor Invoice pass sometime in a wrong mainAccount !

(0) ShareShare
ReportReport
Posted on by JauB 350

Hi Everybody

Please, i'm facing a strange issue. For a particual Vendor, when I create an invoice (related the a receipt), I saw that the final operation in GL is passing in a wrong charge mainAccount.

Example :

On receipt, the mainAccount is 6666700 (with amount X > 0)

in the Invoice, the operation related to 6666700 is canceled (with amount -X  ( <0)). All is good till now

But the invoice is generating the final entry with  amount X >0 in an other mainAcount which is 6666800 (instead of 6666700 ).

When I try to reproduce the same case, I fail !

I saw also that for this specific vendor, sometime, even in my items (which are not managed on inventory for information) in PurchLine are having "VEND1" as financial dimension (for partner), but when i make the receipt (before talking about invoice), I see that the GL entry for the charge mainAccount contains an other financial dimension ('VEND2' for example) but the GL entry for the vendor is correct (has the good financial dimension). For this issue, I tried also to reproduce the case but ... !

Is these problems can be related to the user who make the receipt and the invoice ? What can be the others sources of my problem ?

Thanks in advance.

*This post is locked for comments

  • JauB Profile Picture
    JauB 350 on at
    RE: Vendor Invoice pass sometime in a wrong mainAccount !

    Hi André

    No, no default dimension for this vendor !

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,280 Super User 2024 Season 2 on at
    RE: Vendor Invoice pass sometime in a wrong mainAccount !

    Do you have default dimensions set on this vendor which might be different compared to other vendors?

  • JauB Profile Picture
    JauB 350 on at
    RE: Vendor Invoice pass sometime in a wrong mainAccount !

    I'll continue to search ...

    The problem is that this issue is related to only one vendor ! Why this special vendor, I don't know ! May be I have to block it and recreate it with an other vendor code !

    Or may be I will make this financial dimension mandatory on creating PO header. The Lines must follow the header. In that way, may be when making the product receipt, the vouchers will be created based on header level and so getting the right information (even the Lines are also containing the right ones, but ... may be AX missed some thing when it tries to get dimensions from Lines...). Just for information, all wrong dimensions in the vouchers are containing the same wrong dimension (ADxxx), and this ADxxx is the first financian dimension in the list of my financial dimensions. it's like AX tries to get the first dimension from the list ...

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Vendor Invoice pass sometime in a wrong mainAccount !

    Hello Jaub,

    If it is not a fixed findim setup or a main account allocation rule then I would assume that this is either caused by a modification or a system bug.

    Have you already searched LCS for available hotfixes?

    If you can't find anything on LCS I would ask you to get into contact with a colleague from development who can debug this behavior.

    Would be great if you could keep us informed here.

    Many thanks and best regards

    Ludwig

  • JauB Profile Picture
    JauB 350 on at
    RE: Vendor Invoice pass sometime in a wrong mainAccount !

    Hi André

    There is no fixed dimension value set on this main account.

    We don't set dimensions on headers, so all is set on lines (line by line).

    Very strange this issue !

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,280 Super User 2024 Season 2 on at
    RE: Vendor Invoice pass sometime in a wrong mainAccount !

    Hi JauB,

    Usually, the charge will use the dimensions from the header or the line where the charge has been applied. Is this a line or header level charge? Can you also check if there is a fixed dimension value set on the main account which can override the one used on the order?

  • JauB Profile Picture
    JauB 350 on at
    RE: Vendor Invoice pass sometime in a wrong mainAccount !

    Hello Ludwig

    As i explained in my last post, we have to check why the product receipt vouchers are generated with 2 differents financial dimensions instead of one !

    So let's forget the invoice issue and focus product receipt financial dimensions issue. Here as you know, no one can modify anything, because if the PO lines are containing the same financial dimensions so the vouchers generated must be generated at the same way (it means with the same financial dimensions so the vouchers are the PO Lines).

    Please refer to my 2 attached files to have and idea for what is happening in my case !

    The financial dimension generating the issue is PARTxxxx (in this case we have vouchers generated with PARTxxx = IDxxxx and PARTxxx = ADxxxx, but it must only IDxxx), so why the entry in my account 612638xxx is generated with a wrong financial dimension PARTxxx = ADxxxx ?

    Thanks :)

    Product-Receipt-Voucher.pngProduct-Receipt-Voucher.png

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Vendor Invoice pass sometime in a wrong mainAccount !

    Hello JauB,

    Can you share an example that illustrates  the issue?

    Is it possible that somebody played around with the inventory posting matrix and made some changes after for example a packing slip was posted?

    Do you see the same issue if you create new POs ?

    Best regards

    Ludwig

  • JauB Profile Picture
    JauB 350 on at
    RE: Vendor Invoice pass sometime in a wrong mainAccount !

    I'm progressing on my analysis :)

    So I remarked that when the issue related to financial dimension happened when making the receipt so the problem related to the Account happen also when making the invoice !

    So the origine of my problem is based on financial dimension generated in receipt step which are not good (for the vendor balance the financial dimension is the right one, but for the charge, the financial dimension is not !)

    Do you have any idea where can I check ?

    Thanks.

  • JauB Profile Picture
    JauB 350 on at
    RE: Vendor Invoice pass sometime in a wrong mainAccount !

    OK, let's suppose that posting profile was modified before, but what about financial dimenions which are not the same between the GL entry and my PurchLine ?

    Normally, if my PurchLine has VEND1 as Partner financial dimension so when making the receipt I must have the same financial dimension in GL, but it' not the case for many Purch Orders !

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans