Sage 100

AR Payment History to CR-XXXXXX journal. Ok, this is one of those questions I've always avoided. In AR you can drill-down to an invoice and find out the journal number that posted it. How do you trace a payment back to the CR journal? Someone needs to trace the payment back to the journal so they can retrieve the associated document in Paperless Office.

If they post receipts in detail, you can just search the cash account for the entry. Else, try the GL Posting Recap from AR Reports menu.

Posted in summary. The GL Posting Recap needs detail. Seems that the journal number is included in the Invoice History Header, but not the Payment History table. Any other ideas?

Can't they look at the payment detail for the customer and locate the cash receipts(s) posting date(s) and search Paperless that way? Or do they do hundreds of receipts per day?

Hundreds per day, with multiple CR journals. Only option is to retrieve the CR journals (in Paperless) and search for the customer number to confirm the have the right journal. Then, look at the associated document.

This has been a headache for me as well in times past. The workaround that I always used was to print the Cash Receipts Report and select options on that screen that suit the inquiry you're making. You still don't get a CR number, however, you do get a total deposit amount and that can usually help you pinpoint the transaction on the G/L detail listing a little faster. I know, it's crazy.

You could try install a desktop search program on one of the workstations. I have used Copernic (Link below) for the past 10 years or so. You may have to buy the standard version so you can search network drives. You can set Copernic to index the paperless folders. I just tested on my system. The search for a unique check number took less than 10 seconds for a correct hit (nearly 13K file, 66 folders). I opened the PDF from the search results field, scrolled to the last page and found the CR-xxxxxx journal number. I think I would be lost without Copernic. I use it frequently to find files that I have no clue where they could be simply by entering some key search words. It is one of those **MUST** have programs on my lap top. Simply Priceless http://www.copernic.com/en/products/desktop-search/

I am having this issue currently. Thought I could pass the journal number to AR_TransactionPaymentHistory for cash receipts but no luck in custom office. Cannot get the batch number either. Can get the deposit number, but that is not reference in the paperless office journal and register viewer so no good. Another thing. The Acctg Date shown in paperless is NOT the deposit date, which renders it useless for searching since this client enters multiple days of deposits on the same day. Has anyone found a way to do this since this was posted last year?