Over the past year or so, I have been tasked with writing data fixes for AR Cash Receipt Transactions that do not have all their records created when they are posted.  In all cases it is hit or miss as to what records are not created such as tarCustPmtAppl or tcmCashTranLog records.  Luckily I have not had to write a script to fill in missing GL records yet.  

I've seen this with numerous customers on various versions of Sage 500.  No errors are reported to the user and I see no errors logged in tciSQLExceptionLog.   The transactions can be large as the one I fixed today that had 13000+ invoices paid or small with just a couple of invoice lines.  They can be tied to sales orders or simply manually created.  The issue when it occurs is very rare and so far on the systems I've done data fixes for it hasn't happened again (knock wood).

Has anyone else run into this issue where AR Cash Receipts transactions do not have all their records created during posting that they need?  Just curious as it has peaked my curiosity as to what the cause may be.