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

AP Distribution User Field

 1 Replies
 0 Subscribed to this topic
 43 Subscribed to this forum
Sort:
Author
Messages
Debra Jones
New Member
Posts: 1
New Member
9/11/2018 6:21 PM
I'm new to Lawson and not sure of how the tables interact. I currently need help in creating a report which lists the invoice #, date, amount and Distribution User Field 5 that's coming from the Ap22.5 form. Is there anyone that could direct me to the correct table joins?
Kelly
Basic Member
Posts: 7
Basic Member
9/11/2018 6:58 PM
The invoice number, date and amount will be in the APINVOICE table and the Distribution User fields are in the APDSUSRFLD table. Because these are not related you will need to start with the APDISTRIB table and then select the related fields to get to both of those. Also, to find the table you are looking for use Ctrl Shift O in any field and the results will show in the status bar at the bottom of your screen. The first 3 characters represent the table prefix which you can type into the query wizard to get the full name.
Hope this helps!