Open Forum

Expand all | Collapse all

View Cash Receipt via Invoice screen

  • 1.  View Cash Receipt via Invoice screen

    Posted Jun 12, 2019 01:53 PM
    I was wondering if anyone knows of a process or how to connect a cash receipt entry once posted to an invoice on sale transaction screen (amount received).  If I apply a payment through cash receipt entry it is not showing up on the actual invoice screen as amount received.
    If I apply a credit card directly through the sales order transaction screen prior to becoming an invoice the information is visible.
    We would like that if someone other an AR looks at a particular invoice via sales that it will note that the invoice has been paid and amount and date. Currently when we look at a particular invoice we are not able to see that it was paid unless we use a smart list that only tells us the customer and amount received and then we would need to drill down to see what invoice(s) have been paid.

    Any direction or suggestions would be greatly appreciated.

    Below is the cash receipt entry screen and the invoice amount received screen.



    ------------------------------
    Yvette Cruz
    eMagin Corp
    Hopewell Junction NY
    ------------------------------
    Conference-GPUG_200x200


  • 2.  RE: View Cash Receipt via Invoice screen

    SILVER CONTRIBUTOR
    Posted Jun 13, 2019 07:32 AM
    Hi @Yvette Cruz,

    Information regarding payments or cash receipts processed (and applied to an invoice) after a sales invoice has been posted is held in RM tables, along with basic (header, tax, etc.) information from the original sales document, which is also saved in more detail in SOP tables, so this information will not be available to be viewed on the zoom window for the posted invoice.

    At our company most people that are interested in this kind of info are using SmartLists - a standard Receivables Transaction SmartList can show the original invoice amount, Tax, Sales, etc., along with the 'Current Transaction Amount' (remaining balance). We also use the Excel Refreshable reports for all of our GP companies (35 production companies currently).

    If you are interested in a SmartList of Payments/Credits and the invoices they were applied to, @Victoria Yudin has some great SQL scripts on her website - check out the AR Apply Detail view here - Receivables SQL Code - then you can build a SmartList using either SmartList Designer or SmartList Builder (from eOne) from the new view.

    Hope this helps - feel free to reach out if you need more help along this path.

    Thanks,
    Jeff



    ------------------------------
    Jeff Pfershy
    Sr Business Analyst
    BluJay Solutions Inc
    Holland MI
    ------------------------------

    Conference-GPUG_200x200


  • 3.  RE: View Cash Receipt via Invoice screen

    TOP CONTRIBUTOR
    Posted Jun 13, 2019 03:45 PM
    Hi Yvette-

    EthoTech makes an addon called Customer Service Collection that (among other nifty features) adds an Apply button to the Sales Trx Inquiry screen:


    When you click it, a screen opens up with all of the applied payments/credits:


    Here is a link to a copy of the user manual about it -- starts around page 130:

    https://www.ethotech.com/userfiles/file/EthoSeries18.pdf

    Thanks.
    -Joe

    ------------------------------
    Joseph C. Markovich
    IT Manager
    Okaya Electric America
    Valparaiso IN
    ------------------------------

    Conference-GPUG_200x200


If you've found this thread useful, dive deeper into User Group community content by role