0

Retrieve the last invoice of fixed asset which not offset with credit memo

How do I retrieve the last invoice of fixed asset which not offset with credit memo. Ex: I have asset called FA-00001 this FA have invoice posted in 2020, lets say: Jan: PI-00001 Feb: PI-00002 Mar: PI-00003 Apr: PI-00004 then when I pull out the last invoice from the asset use NL("Last") it is showed the last invoice on my report which is April invoice (PI-00004), but this invoice already credit memo. I want in my report show the last invoice (Mar invoice: PI-00003) which is not offset with credit memo. Any help will be apprecite. Thanks

1 comment

Please sign in to leave a comment.