Issue/Symptom/Question

We put through an Initial Load for Progress Billings (ARS006). Then added an AR Retention load (ARS005) which was to record the Open Retention for the jobs / invoices that had been added in the Progress Billings load. Both loads processed through with no problem, but it looks like we missed something. All the original balances loaded through the Progress Billings are showing as being paid in full. So the Retention load created a credit with an AR type code of “J” for each invoice and a debit with an AR type code of “R”. The result is that we now have a credit balance on all the invoices loaded. But the net balance of all is zero. Should we have done this differently?

Applies To

Penta for Windows

System Management > Initial Load > Project Management > Progress Billings

Resolution/Fix/Answer

The Retention initial load creates a reversing entry of the Open AR which is then transferred to the Open Retention. Processing an Open AR Initial load offsets the Retention load.