• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Financial Management Lawson S3 Financials

AROITEMS - Open Amount???

 2 Replies
 0 Subscribed to this topic
 43 Subscribed to this forum
Sort:
Author
Messages
apalmer77
Basic Member Send Private Message
Posts: 4
Basic Member
8/19/2015 2:52 PM
Could someone provide some insight on if whether or not the AROITEM_OPEN_AMOUNT derived field can still be used for calculation purposes, even though this field may not be viewable from within a Lawson Production Database? I completely understand that no data is stored in this field.

What is the purpose of this field being referenced on the LawsonGuru site and there is no way to reference or leverage it for invoice open amount identification purposes.

:confused::confused:

Any insight or guidance provided is truly appreciated.

Thanks so very much in Advance!!
Greg Moeller
Veteran Member Send Private Message
Posts: 1498
Veteran Member
8/19/2015 3:06 PM
According to the Lawson command 'derfldrpt prodline' the AROITEMS OPEN-AMOUNT is computed by the following forumula: ORIG-AMT - (ORIG-APP-AMT + ORIG-ADJ-AMT)

So, if you are looking to evaluate this "field". I'd do so by using this formula..
apalmer77
Basic Member Send Private Message
Posts: 4
Basic Member
8/19/2015 6:49 PM
Thank you Greg:)