Fixed Asset Procurement and corresponding Inventory Transactions

(1) Share

Report

Posted on by Ankit Batra

1,561

Hi All,

I have set-up a stocked service item which is serial number enabled. It is a service item as we do not want to hold on-hand inventory for the item since it will be converted directly to fixed assets. It is stocked so as to enable receiving at serial number level and view inventory transactions.

The new fixed asset checkbox is checked on the PO line but acquisition is not posted on PO invoicing. A separate fixed asset proposal is created to post the acquisition after PO invoicing.

On the PO, the receiving is done at the serial number level and product receipt is posted followed by invoicing.

On the fixed asset acquisition proposal posting while the voucher entries and amount is correct, on the inventory transactions side only one serial number is shown as "sold" with a reference to fixed asset. See screenshot below.

Can anyone please guide if this is a product bug or any setups are missing to get correct inventory transactions?

Thank you.

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (0)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Fixed Asset Procurement and corresponding Inventory Transactions

Hello,

Are you using the inventory to fixed asset journal for the acquisition posting of your fixed asset?

If so, I would expect a negative ('sold') transaction in inventory because you are taking out an item from inventory and put it into fixed asset.

Best regards,

Ludwig

Was this reply helpful? Yes No
Ankit Batra 1,561 on at

Like (0)

Report

RE: Fixed Asset Procurement and corresponding Inventory Transactions

Not inventory to fixed asset journal. The regular fixed asset journal and using acquisition proposal.

The item is setup as a stocked service item so there is no on-hand inventory. The item is also serialized. So if I receive 5 serial numbers against a PO with "new fixed asset" checked for the PO line, post the PO invoice followed by the fixed asset acquisition journal posting, I see only 1 sold transaction against 1 of the serial numbers and not the rest 4. All 5 serial numbers are converted to fixed asset i.e. the fixed asset balance is correct but not the corresponding inventory transactions.

Please see screenshot in my above post

Any ideas/suggestions would be welcome.

Thank you.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Fixed Asset Procurement and corresponding Inventory Transactions

Hello Ankit Batra,

The standard fixed asset journal does not have any relationship to your inventory items/transactions.

Do you know how the sales inventory transaction was created?

Can you identify the transaction and posting type of the voucher that is linked to the inventory sales transaction?

Do you know if a system modification has been implemented that might be reponsible for the system behavior that you see?

Best regards,

Ludwig

Was this reply helpful? Yes No
Ankit Batra 1,561 on at

Like (0)

Report

RE: Fixed Asset Procurement and corresponding Inventory Transactions

This is standard out-of-box and transactions are bring performed in USMF legal entity. No customizations.

Providing more details:

1. Item setup: Service item but stocked, FIFO, serialized with site, warehouse and location as storage dimensions.

2. Created a PO with "new fixed asset" checked

3. Posted the receipt and invoice for the PO. This created the purchase transactions which you see in the screenshot i shared in my first post. There is no on-hand since this is service item.

4. Created the fixed asset journal using proposal functionality to get "not acquired" fixed assets and posted it. Journal and voucher shown below.

5. Overall inventory transactions - first 5 are from the PO receipt/invoice posting and the last sold is from the acquisition posting via the fixed asset journal as shown above in point 4.

6. I checked the ledger associated with the sold transaction above and it is the same voucher as i showed in point 4 above.

My expectation is that there should be 5 sold transactions and not just 1.

Please let me know if you have any suggestions.

Thanks.

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

Like (0)

Report

RE: Fixed Asset Procurement and corresponding Inventory Transactions

Thanks for this update.

Can you please check in the fixed asset base data - not in the value model - what quantity you can see in the quantity field?

From what you describe, I would assume that you expect AX to create 5 different fixed assets. Is that right?

Best regards,

Ludwig

Was this reply helpful? Yes No
Ankit Batra 1,561 on at

Like (0)

Report

RE: Fixed Asset Procurement and corresponding Inventory Transactions

The fixed asset base data has the correct count of 5 and unit cost of 90. See below. I am expecting 1 fixed asset which is what AX is creating with a count of 5 in the quantity field for this 1 fixed asset. This 1 fixed asset ID is defaulted on the PO line after the product receipt posting.The only issue is with the inventory transactions where it shows only 1 item/serial number as sold and not 5 after PO invoice posting.

Additionally, the value model balance is also correct i.e. 450

Was this reply helpful? Yes No
Ankit Batra 1,561 on at

Like (0)

Report

RE: Fixed Asset Procurement and corresponding Inventory Transactions

Hi Ludwig,

I just realized, in my earlier post in point 4 where I was showing the voucher for the fixed asset acquisition posting, the current layer is showing incorrectly a debit to fixed asset of only $90 and not $450. The tax layer is showing a debit of $450 to the fixed asset which is correct.

The surprising thing is that the fixed asset balance for the current layer is correct as $450 even when the voucher is of $90. Posting screenshots again for your reference:

Fixed assets posting voucher: Voucher showing $90.

Fixed asset balance: Fixed asset balance is $450 even when voucher is showing only $90.

Inventory transactions: Only serial number S11 is sold and other serial numbers do not have a sold transaction towards fixed asset FURN_FIX-000018

This mean that my GL balance is not correct and does not match the Fixed asset balance. This surely seems like a product bug or limitation.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Fixed Asset Procurement and corresponding Inventory Transactions

Hi, I agree that the amounts looks strange. Before saying that this is a bug I would like to ask whether you can replicate the same transactions in a different test/demo environment. My worry is that users entered something - possibly unintentionally - that created the transactions we see. Would be great if you could double check that. If you experience the same issue you can check LCS for an available hotfix and if you cannot find one, reach out to the MS support for further assistance.

Best regards,

Ludwig

Was this reply helpful? Yes No
Ankit Batra 1,561 on at

Like (1)

Report

RE: Fixed Asset Procurement and corresponding Inventory Transactions

Executed the exact same transactions in a different standard AX environment with no customization and got the same results. We will be raising a support ticket for this issue with MS. I will update once I hear further from them.

Thank you Ludwig for your help. Really appreciate it.

Was this reply helpful? Yes No