Skip to Content

Free of charge AP Reserve Invoice - Document status closed but rows still open!?

Hi all,

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!

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Apr 13, 2016 at 10:43 AM

    Hi

    the reserve invoice will be closed when you copy the full document to goods receipt.

    I think you have to check the open quantity in each row.

    Kind regards

    Agustín Marcos Cividanes

    Add comment
    10|10000 characters needed characters exceeded

    • Hi André,

      A sales order is closed once it is fulfilled from a quantity perspective. An invoice however is closed once its complete monetary value is payed and/or credited.

      Thus, as Agustin said, if the total value is zero, then there is no value to pay and/or credit, and therefore it closes automatically.

      Regards,

      Johan