How can I find the G/L Expense Account rlated to an F0414 record?

[frankieg73]

Trying to determine G/L impact of A/P transactions from F0414. There could be multiple F0414 records with the same RPDOC/RPDCT/RPAG, the only difference being the RPSFX value. How can I automate the join between the F0414 and F0911 for use in a UBE to find the exact F0911 G/L expense account record for each F0414 record?

 

[peterbruce]

frankieg73,

Have a look at the thread entitlted: "Accounts Payable Questions". It may provide you some information that will help you.

 

[frankieg73]

Thanks for the response. It's not quite the simple answer/solution I was hoping for, but it does answer my question.