Small and medium business | Business Central, N...

How to find corresponding FA ledger entry line from posted purchase invoice for fixed asset

(5) Share

Report

Posted on by Ahsan baig 123

155

Business central

I have a purchase invoice in which i have mulitple lines of same fixed asset.

I have sucessfully posted this purchase order.

Now i need a cusomization in which i have to add field in posted purchase invoice lines for corressponding Fa ledger Entiries.

It is easy to get correspoding Fa ledger entries by filtering 'Document no" and "fixed Asset No".

But if posted purchase order have mutilple lines with same fixed asset then it is not possible to pick which lines correspond to lines in 'Fa ledger entries' as there are on specific filters for lines.

Please suggest how can i find corresponding lines in Fa ledger entries.( or any work around)

Example

posted purcahase lines with same FA no.

corresponding lines in fa ledger entries

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (5)

Answers (0)

Martin Dráb 237,976 Most Valuable Professional on at

Like (2)

Report

Moved from Integration, Dataverse, and general topics forum to Small and medium business | Business Central, NAV, RMS forum.

Was this reply helpful? Yes No
Suggested answer

Jun Wang 8,202 Super User 2025 Season 2 on at

Like (2)

Report

Not sure why you use the same FA no. on multiple PO lines? Is it ok to create separate FA for such transaction? For example, you could create machine-1, machine-2 instead of using machine?

Was this reply helpful? Yes No
Ahsan baig 123 155 on at

Like (2)

Report

@Jun Wang Business central is allowing to have same fixed asset on multiple lines. As a developer, i have to make sure these issues are handled.

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 20,612 Super User 2025 Season 2 on at

Like (3)

Report

If this helps: https://ebs.com.au/blog/correcting-fixed-asset-ledger-entries-in-business-central

https://learn.microsoft.com/en-us/dynamics365/business-central/fa-how-revalue

https://learn.microsoft.com/en-us/dynamics365/business-central/fa-how-acquire

Was this reply helpful? Yes No
Suggested answer

Jainam M. Kothari 15,639 Super User 2025 Season 2 on at

Like (1)

Report

Hello,

To match purchase invoice lines with corresponding FA ledger entries in Business Central, add a unique identifier to each purchase invoice line and ensure this identifier is included in the FA ledger entries. Customize the posting routine to carry over this identifier, allowing you to filter and accurately match each line, even if there are multiple lines with the same fixed asset. This approach ensures precise identification and matching of lines in your reports or inquiries.

Was this reply helpful? Yes No