Item group details in posted lines of Purchase order

(3) Share

Report

Posted on by NaveenKumar S

3,477

Hello,

Is there a way where we can find the item group details of the purchase order line that is already posted. because the item's current item group is changed. how can i get the group detail at the time the purchase order was invoiced?

Kind Regards,

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (5)

Answers (2)

Sort by

Suggested answer

Arvind Bharti 789 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi,

You can not find the item group on PO line because it uses lookup during posting of transactions from Item master.

You might need to do some analysis like taking inventory transactions posting for those PO and fined which GL code it posted and then compare what is current GL code and find corresponding item group for those GL accounts

Also use report under inventory for subleder to ledger variance that might tell the changes

Was this reply helpful? Yes No
Suggested answer

Raj Borad 1,560 on at

Like (1)

Report
Copy link

Link copied!

Hi @NaveenKumar S,

As per my knowledge, the FO does not store the item group details on the purchase order line at the time of posting.

I think to retrieve the item group details as they existed when the purchase order was invoiced, custom development is necessary. This would involve adding a field to the purchase order line table and populating it with the item group at the point of invoice posting. Without this customization, historical item group information for posted purchase order lines is not available.

Thanks.

Was this reply helpful? Yes No
Atul_0215 60 on at

Like (1)

Report
Copy link

Link copied!
Hi @NaveenKumar S,

You cannot directly view historical item group details for a posted purchase order line unless database logging was enabled beforehand. If logging is enabled, you can check the database log to retrieve the item group details as they were when the purchase order was invoiced. To enable database logging, go to System Administration > Setup > Database log > Database log setup, and use the wizard to select the tables and fields you want to track. To view logged changes, navigate to Product Information Management > Products > Released Products > Options > Record Info > Database Log.

Was this reply helpful? Yes No
Verified answer

Zain Mehmood 4,189 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi,

In my opinion, the system doesn’t store the item group historically once it changes, it's always pulled from the current value

That said, you can still check:

VendInvoiceTrans, InventTrans, or the voucher postings to see if the account structure or posting profile gives clues.

Also check if there's any custom logging or an ISV that captures this detail at the time of posting

But by default, item group history isn’t tracked so if it's critical, you may want to consider enabling database logging on that field for future use.

Hope this helps

Zain

Was this reply helpful? Yes No
Verified answer

André Arnaud de Cal... 303,765 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi Naveen,

As mentioned below, the item group used historically is not stored. When posting the receipt and invoice, it stores the ledger account used in the table InventTransPosting.

Was this reply helpful? Yes No