Hi, we scan and attach our proof of delivery to our invoices for easy reference. Our administrators in each branch have been instructed that all invoices need to have the POD attached, but this is not always done. I need a report which will show me which Invoices do not have attachments so I can address this with the branch manager.
Solved
Report needed to see which sales invoices have attachments
Best answer by lauraj46
Hi
If you need this to be searchable, you could create a generic inquiry based on the NoteDoc and UploadFile DACs. If you use a left join then you can add a condition to search for SOInvoice records that do not have any attachments. See the attached XML for an example of the GI.
Hope this helps!
Laura
+20Hello,
It’s easy to see the difference between NO attachments and YES - Attachments exist, in the Invoice Preview List:
If your Invoices have many attachments, it will be tricky to see in a report, whether Proof of Delivery attachment is specifically missing among other attachments.
Laura
Translate
+9Hi
If you need this to be searchable, you could create a generic inquiry based on the NoteDoc and UploadFile DACs. If you use a left join then you can add a condition to search for SOInvoice records that do not have any attachments. See the attached XML for an example of the GI.
Hope this helps!
Laura
Translate
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.