Connect fixed asset to vendor invoice (line) afterwards

(0) Share

Report

Posted on by Katy3992

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

I have the same question (0)

All responses (10)

Answers (1)

Katy3992 322 on at

Like (0)

Report

RE: Connect fixed asset to vendor invoice (line) afterwards

Thanks Ludwig!

Was this reply helpful? Yes No
Verified answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

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

Was this reply helpful? Yes No
Katy3992 322 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

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

Was this reply helpful? Yes No
Katy3992 322 on at

Like (0)

Report

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.

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.

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".

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):

Settlement voucher (cash discount):

And the fixed asset transactions:

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

Was this reply helpful? Yes No
André Arnaud de Cal... 297,200 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Katy3992 322 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

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

Was this reply helpful? Yes No
Katy3992 322 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

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

Was this reply helpful? Yes No