last positng date from 123 purchase invoice line


I want to calculate last imported item quantity from 123 purchase invoice line table.

I need to find out last date and total quantity. how can i find out last posting date?


The posting date is on the Purch. Inv. Line table but is not part of a key, so your options are:

Filter down to the item required and loop the records


Add a new key with posting date in the key.

Filter on the item and find the last record