Customer Transaction History

SUGGESTED

Hi There, 

We are looking for a Customer Transaction History report, so we can see payment of invoices but also credits that have been applied and where they were used. It seems in other versions of Sage that this kind of report exists.

Thanks. 

  • 0
    SUGGESTED

    Hi,

    Try Manual matching (LETTRAGE) for that level of detail in one place. You can see what payments, credits and invoices are linked by the matching letter. There is a screen for matched and unmatched. These results can be easily exported to Excel. Upper case means fully matched and lower case indicates partial matching,

    The matching code is stored in the GACCENTRYD table. You could use the Query tool (GESALH) to extract the AR account details. The results could be exported to Excel for easy analysis. The matching code (MTC) would show you the link between the transactions.

    Your partner may have already created such a report. They may have even created a report for SEI.

    Regards,

    Pam