Prev
Next
Forums Lawson S3 Financials

Unapplied cash by day (AR)

Sort:
You are not authorized to post a reply.
Author
Messages
Barry Ghotra
Veteran Member
Posts: 63
Veteran Member
6/9/2008 2:07 PM

    we are looking for a way to get the data out of AR for unpaplied cash by day (by customer, is possible) . Accounting folks want to find the variance and I have looked at the tables involved but can't seem to make any sense out of it. Has anyone ever had a need for this. Any pointers/help with SQL if it's possible to do. Don't know if lawson keeps the history or is there any way to figure this out based on the check/cash applied and distribution?

    Thanks.

    Barry Ghotra
    Veteran Member
    Posts: 63
    Veteran Member
    6/10/2008 5:20 PM

      John, Any pointers please ?

       

      Thanks

      John Henley
      Senior Member
      Posts: 3348
      Senior Member
      6/10/2008 5:33 PM
        You would need to look at the ARPAYMENT, and ARAPPLIED tables in order to get that information.
        I will tell you it is very difficult, if not impossible to go back in time to reconstruct if they are trying to see what was unapplied at a point in time.
        Thanks for using the LawsonGuru.com forums!
        John
        You are not authorized to post a reply.