Free of charge AP Reserve Invoice - Document status closed but rows still open!?
I need your help to determine if this is as designed or a bug in our Business One 9.1 PL11.
For free of charge AP Reserve Invoices the document status in B1 is showing as "Paid" and on table level the DocStatus shows C.
We're using the AP Reserve Invoice process for imports that have a long transit time because of sea freight etc. Means Purchase Order -> AP Reserve Invoice -> Goods Receipt PO. Recently I noticed that free of charge deliveries do not appear in our in transit reports and are also not showing up in our barcode scanner solution for upcoming goods receipts.
Problem is that our queries are checking for Docstatus O on header level. This works as long as there is a value in the invoice. When the total is zero then B1 sets the invoice to paid (what is ok) but is sets the docstatus also to closed (what is wrong in my opinion). It gets really strange because the row status is still open.
Is it as designed or is it a bug?
How can I easily determine if an AP Reserve Invoice is still open besides checking all row status separately in my queries?
Thanks for your help!