A/R Reserve Invoice: Scenarios affecting the Header and Row status
There have been questions raised recently regarding the status of A/R Reserve Invoice. The A/R Reserve Invoice can be in several stages and the status of document header or rows may seem unclear for a user.
The logic behind the different A/R Reserve Invoice status is based on the nature of this document. An A/R Reserve Invoice only updates the BP Balance but does not create any stock postings. The presumption is that it will be followed by a Delivery note. The latter does the necessary postings to the stock. Therefore, we have to distinguish undelivered Reserve Invoice and the one that had been copied to Delivery note.
Undelivered A/R Reserve Invoice header and rows status is ‘Open’. This can be seen from the combination of fields’ values as follows:
- OINV.DocStatus = 'O'
- OINV.InvntSttus = 'O'
INV1.LineStatus = 'O' INV1.OpenQty = INV1.Quantity |
This open document can then be copied to Delivery note or paid.
As soon as the A/R Reserve Invoice is fully copied to Delivery, its status is changes to ‘Delivered’. This happens when the ‘InvntSttus’ field is changed to ‘C’:
- OINV.DocStatus = 'O'
- OINV.InvntSttus = 'C'
|
INV1.LineStatus = 'O'
INV1.OpenQty = (INV1.Quantity - [Delivered Quantity])
Partial delivery has no effect on the document’s status. It is kept ‘Open’ to allow further deliveries to be based on it. A document with ‘Delivered’ status cannot be copied to Delivery note anymore. However, a payment can be based on it. The status ‘Delivered’ is specific for A/R Reserve Invoice only. The behaviour is the same when using Pick & Pack functionality.
When the delivered A/R Reserve Invoice becomes fully paid, its status is changed to ‘Closed’. The document rows remain ‘Open’:
- OINV.DocStatus = 'C'
- OINV.InvntSttus = 'C'
|
INV1.LineStatus = 'O'
INV1.OpenQty = (INV1.Quantity - [Delivered Quantity])
Partially paid document retains its previous status (i.e. ‘Open’ or ‘Delivered’) to allow further payments to be based on it.
Undelivered but fully paid A/R Reserve Invoice has status ‘Paid’ with row lines as ‘Open’.
- OINV.DocStatus = 'C'
- OINV.InvntSttus = 'O'
|
INV1.LineStatus = 'O'
INV1.OpenQty = INV1.Quantity
A/R Reserve Invoice cancelled with a Credit Note has both header and lines status ‘Closed’.
- OINV.DocStatus = 'C'
- OINV.InvntSttus = 'C'
|
INV1.LineStatus = 'C'
INV1.OpenQty = 0
In the last scenario, the whole sales case is closed definitively. The same system logic can be observed in A/R Invoice where the rows remain ‘Open’ in all cases except when the document is cancelled with Credit Memo.
An A/R Reserve Invoice partially copied to Credit Memo remains ‘Open’. Only lines copied to Credit Memo have status ‘Closed’ with zero Open Quantity.
The table below shows a summary of the different header and line status:
Scenarios
Header Status
Line Status
A/R Reserve Invoice is fully delivered.
Delivered
Open
A/R Reserve Invoice is fully paid.
Paid
Open
A/R Reserve Invoice is fully paid and fully delivered.
Closed
Open
A/R Reserve Invoice is fully credited.
Closed
Closed
