Prev
Next
Forums User Experience Lawson Add-Ins for Microsoft Office

AP45.1 Query

 2 Replies
 0 Subscribed to this topic
 1 Subscribed to this forum
Sort:
Author
Messages
Elmer Madarang
New Member Send Private Message
Posts: 4
New Member
2/26/2020 12:50 AM

I want to build a query to pull reportable amount in Ap45.1

Field name is: REPINCAMT - I can't seem to find which table this belongs to? Does any one know and how can I pull that via a .dme

thanks!

Elmer

 

 

Ragu Raghavan
Veteran Member Send Private Message
Posts: 477
Veteran Member
2/26/2020 2:25 AM
Depending on the conditions, looks like it could be from any number for source - see extract from code AP45 below 005150 IF (APP-TRAN-INC-AMT NOT = ZEROS) 005160 MOVE APP-TRAN-INC-AMT TO AP45F1-REPINCAMT (I1) 005170 ELSE IF (APP-DISC-LOST-FLG = "Y") 005180 MOVE APP-TRAN-PMT-AMT TO AP45F1-REPINCAMT (I1) ELSE COMPUTE AP45F1-REPINCAMT (I1) ROUNDED = APP-TRAN-PMT-AMT - APP-TRAN-DISC-AMT. 005200 IF (APP-REC-STATUS = 9) 005210 AND (APP-TRAN-INC-AMT = ZEROS) 005220 MOVE ZEROS TO AP45F1-REPINCAMT (I1).
JonA
Veteran Member Send Private Message
Posts: 1163
Veteran Member
3/19/2020 3:57 PM

From APPAYMENT: COMPANY, VENDOR, INVOICE, TRAN-INC-AMT, TRAN-DISC-AMT, REC-STATUS.

From Related Table APVENMAST: VENDOR-NAME

Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health