Skip to Content

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:

  1. OINV.DocStatus = ‘O’
  2. 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’:

  1. OINV.DocStatus = ‘O’
  2. 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’:

  1. OINV.DocStatus = ‘C’
  2. 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’.

  1. OINV.DocStatus = ‘C’
  2. 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’.

  1. OINV.DocStatus = ‘C’
  2. 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

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply