Find a fixed asset that was never invoiced

[#1]

Hello guys,

Say I have a table that lists all Fixed Asset Code that a company has. Then I have another table in which it lists down all the fixed asset that is invoiced (since it has an invoice number)

My question is.. how to also show fixed asset code which has not been invoiced (not with any invoice no) in the same table?

Hope to hear from you guys. Any suggestions would be greatly appreciated.

Thank you guys for your kind attention

[alexandros17]

You must add a new expression for which you have (quantity or amount not depending on invoices but depending on asset. in this way  the asset code will apeear even if invoice no is null

[Anonymous · Accepted solution]

In Dimensions tab,

You can enable Show all values for InvFixedAssetCode,

which will show all Assetcodes irrespective of whether it has been invoiced or not.

Regards

Nitin