Hi All - when OE orders are posted to AR, will the ARPosting field in the OE Header be set to a value (or 0 indicating it has not been posted/day-ended?

What would be the best way to see if an invoice has been day-ended (is in AR or an AR Batch)?

Many thanks
Etienne

Hi Etienne,

If your question is to determine from OrderEntry whether or not posted invoices (and credit notes) have been processed by Day End, the easiest way is to look at the 'Costed Status' field on the header record. It will be true for transactions processed by Day End, and False for those that have not. Alternatively, the 'Moved to History' field could also be used in the same fashion.

I don't believe the 'AR Posting #' field is used. The 'GL Posting #' contains the Day End Sequence value.

Hello Etienne,

Look for the "Costed Status" setting in the Sales Order Header.

Thank you Softrak Support - what would be the value of Costed Status for an Invoice what I would not expect to find in AR or in an AR batch? Can you give me the expected values for that field?

Hi Etienne,

Costing Status or Moved to History would be used to determine if an invoice or credit note has been processed by Day End.

The OE Order Header record does not store the AR batch numbers, so there is no connection to the AR invoice batch. It might be possible to do this if OE created Direct batches to AR, but certainly not if it created Retrieval batches. But it doesn't now.

From your questions, it seems you are looking for more than just IF an invoice has been processed by Day End, but also where it is in AR.

I am simply looking for a flag/field/indicator on the Invoice to indicate it has been 'sent to' AR or not. What would be the value(s) of Costing Status that would indicate that an invoice has not been day-ended?

If the Costing Status is True, then Day End has been performed on that invoice. This means this invoice has been created in the AR batch directly, or written into the Retrieval file. If False then Day End has not been processed, and thus this invoice cannot be in AR. I wrote this in my initial reply on this thread.

Day End does not process an invoice in OE to calculate costs and copy to History, but not create the invoice for AR either directly or through retrieval, unless the system crashes during day end and preventing complete record creation and updating.

Thank you very much - that gives us the info we need.