• Search Forums
    Advanced Search Topics Posts
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 Send Private Message
Posts: 0
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
Send Private Message
Posts: 3351
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 Send Private Message
Posts: 0
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
Send Private Message
Posts: 3351
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 Send Private Message
Posts: 0
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
Send Private Message
Posts: 3351
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 Send Private Message
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?