Prev
Next
Forums Financial Management Lawson S3 Financials

AR30.3 Invoice unavailable

 6 Replies
 0 Subscribed to this topic
 43 Subscribed to this forum
Sort:
Author
Messages
KBPrizm
New Member
Posts: 3
New Member
6/26/2008 9:30 PM

    7.2.24

    An invoice visible in AR90 with an unapplied amount is not visible in AR30.3.

    In DBARARO Base applied amount = Base amount while Tran applied amount < tran amount.

    We are USD only and the latter was correct by DBARARA so I set base applied = tran applied.

    Still no show in AR30.3

    Last  DBARARA Result-fl = F so  I set to P

    DBARARO record still unavailable in  AR30.3

    Any sugggestions? Programs to run? Fields to examine?

    Files attached

    Thanks,

    KB

     

    Attachments
    John Henley
    Posts: 3353
    6/26/2008 10:13 PM
      Re: AR30.3 Invoice unavailable (6b381d61-06cc-416f-9000-169fe9361035) <!-- Converted from text/plain format -->

      Check the STATUS field. It should probably be a 1 if it has an open amount. Also check the SORT_AMOUNT to make sure it equals the open amount (tran - appld - adj).
      John Henley

      Thanks for using the LawsonGuru.com forums!
      John
      KBPrizm
      New Member
      Posts: 3
      New Member
      6/27/2008 3:48 AM
        Thanks john.
        Status is 1. I see no Sort_amount field in open item or header?
        John Henley
        Posts: 3353
        6/27/2008 10:39 AM
          Is this invoice customer part of a national account? Invoice might be missing from the AROPIVOT table.
          Thanks for using the LawsonGuru.com forums!
          John
          KBPrizm
          New Member
          Posts: 3
          New Member
          6/27/2008 1:24 PM
            Some nightly program in response to my change of base applied amount or result flag made the record available for application this morning. Problem resolved. On to other mysteries. Thanks for your suggestions. Glad I found the site.
            KB
            John Henley
            Posts: 3353
            7/8/2008 11:06 PM
              Please come back and share with us again!
              Thanks for using the LawsonGuru.com forums!
              John
              dj
              Basic Member
              Posts: 7
              Basic Member
              7/25/2008 8:55 PM
                I'm having a similar issue with AR30.1. I created invoices in BL20, released and printed them. I've run the BL123 and have run the AR560. I can see the billing invoices in various AR screens, however, am unable to see the invoices in AR30 to apply payment to them. Is there some intermitent step that I'm missing?