Skip to main content

Notifications

Microsoft Dynamics AX (Archived)

Connect fixed asset to vendor invoice (line) afterwards

Posted on by 322

Dear community,

I'm facing the problem that in AX2012r3 it seems to be required to create a fixed asset card and connect it to the PO before posting the invoice. As my customer wants to post assets on stock and take or sell it from there (a part of it will be used in the company and the other part will be sold to customers, but at the point of purchasing, it's not assignable yet), I'm losing the connection between the vendor invoice and the asset which is needed to deduct cash discount accordingly (and automatically) at payment.

Does anybody know if there's a possibility to connect vendor invoices to the fixed asset card afterwards? Or maybe even invoice lines?

Thanks in advance and kind regards,

Katy

*This post is locked for comments

  • Katy3992 Profile Picture
    Katy3992 322 on at
    RE: Connect fixed asset to vendor invoice (line) afterwards

    Thanks Ludwig!

  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Connect fixed asset to vendor invoice (line) afterwards

    Well, there are some out of the box partner solutions available that have such an integration.

    They cost, however, some money.

    Probably check out those ISV solutions on the AppSource and compare their costs with the ones that you incur if you create it yourself.

    Best regards,

    Ludwig

  • Katy3992 Profile Picture
    Katy3992 322 on at
    RE: Connect fixed asset to vendor invoice (line) afterwards

    The bigger the company, the bigger the pain, no? ;) I just wanted to avoid some manual work for the users ...

    So you agree with me that a FA/INV connection afterwards is not possible without development?

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Connect fixed asset to vendor invoice (line) afterwards

    Hello Katy,

    You are right, the cash discount gets deducted from the FA value only if there is a link to the invoice.

    If this is not the case, it won't get deducted.

    How 'big' is this pain for you?

    Can you go along with this small overvaluation that disappears over time as the FA is depreciated?

    Best regards,

    Ludwig

  • Katy3992 Profile Picture
    Katy3992 322 on at
    RE: Connect fixed asset to vendor invoice (line) afterwards

    Hey André,

    I agree with you that cash discount is a seperate posting, but together with the setup in FA parameters, it gets posted automatically on the fixed asset (subledger account and G/L account) at time of the payment (with payment voucher), when it's connected to the invoice.

    4073.Vendor.png

    So when I create a new fixed asset and connect it with the PO, the acquisition gets posted automatically with posting the invoice via PO.

    3146.PO.png

    So far so good - I posted invoice and got the connection to the PO and the vendor invoice on the FA, AX generated automatically fixed asset transaction "acquisition".

    5074.FA.png

    And now, if I post the payment to the invoice and let the system post the cash discount, it gets posted on the fixed asset as well (as a deduction of the acquisition) - automatically.

    Here are the vendor transactions (invoice, payment, cash discount):

    4073.Vendor.png

    Settlement voucher (cash discount):

    5554.Voucher.png

    And the fixed asset transactions:

    FA_2D00_trans.png

    Sorry for the smallest screenshots ever, the quality was bad if I uploaded bigger ones....

    The only postings I did were 1.) vendor invoice and 2.) vendor payment with automatic posting of cash discount

    That's what I want. That the cash discount gets posted automatically on the FA when the payment is made and cash discount has been deducted.

    From my understanding, this can just work, if the asset is connected with the vendor invoice (how else...). So that's why I'd like to connect it after posting the invoice, because at time of buying, as I said, I don't know, if it's going to be a fixed asset or not.

    I hope you can understand what I'm talking about :)

    Kind regards

    Katy

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,253 Super User 2024 Season 2 on at
    RE: Connect fixed asset to vendor invoice (line) afterwards

    Hi Katy,

    Your scenario can be supported in AX, but not all automatic. When you first post to items, then indeed, the cash discount is not used. But this is also not applied to a fixed asset when posting the invoice directly as acquisition. Cash discount is always a separate posting from acquisition or inventory costing.

  • Katy3992 Profile Picture
    Katy3992 322 on at
    RE: Connect fixed asset to vendor invoice (line) afterwards

    Hey Ludwig,

    thanks for your input. If I understood you correctly, my problem is not solvable in AX standard?

    I know how to get rid of the items in warehouse (I'm going to do this with an internal sales order which I need anyway for e.g. the item reservation process), but my main issue is, that the cash discount on the vendor invoice won't be posted automatically to my FA-account anymore when I'm posting the payment in AX. That's what standard does if it's setup in FA-parameters and fixed asset is connected to vendor invoice. So if understood correctly, there's no chance to connect invoice with FA manually, if they didn't do it BEFORE posting the invoice, right?

    Kind regards

    Katy

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Connect fixed asset to vendor invoice (line) afterwards

    Hello Katy,

    What the standard application supports is recording all of those items in your warehouse first.

    If it is decided that the items are used internally then an 'inventory to fixed asset journal' is used, which basically reduces your inventory and shifts the inventory cost amount to a fixed asset that you have to setup before.

    In this journal, you can use e.g. a reason code or reason comment to provide additional information.

    What is not supported out of the box is that the original PO that was used for acquiring the item is inherited into the journal.

    This is something that can possibly be fixed either by making use of a reason code or by using a FinDim.

    Best regards,

    Ludwig

  • Katy3992 Profile Picture
    Katy3992 322 on at
    RE: Connect fixed asset to vendor invoice (line) afterwards

    Hey Ludwig,

    exactly, it's a mixture. You can imagine a company which buys e.g. 10 computers on stock and then first computer is used by an employee of the company (goes to fixed assets) and second computer is sold to an external customer and so on. I would post all 10 computers to the trade goods G/L account and then repost it to FA, if needed.

    Actually I don't have different items for these two scenarios (and I don't need them) because that for I'd need to know how I'm going to use the purchased items in future already at purchase process. But then I wouldn't have the connection issue anymore ;)

    Kind regards

    Katy

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Connect fixed asset to vendor invoice (line) afterwards

    Hello Katy,

    What you describe seems to be a mix of fixed and current assets.

    That is, some items are used as fixed assets and will be used by the company, while others will be kept in inventory and sold later on.

    Is my understanding correct?

    Do you have separate items configured that help you differentiating between the use of those assets?

    Best regards,

    Ludwig

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans