0

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

Priska S.

May 27, 2020 15:25

None

Follow

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

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Bryan Robinson May 29, 2020 17:36

  In theory, you could use array calculations to determine which months have an invoice and which months have a credit memo.  From the filter of dates of Invoices, remove the months where there is a credit memo.  Will probably take some strange mixture of Excel and Jet to accomplish unless they are always posted on the same day.