Payables invoice - Query based on Invoice GL account or department
Summary
Payables invoice - Query based on Invoice GL account or departmentContent
Hello,
We need to build the a query to show invoices for a certain GL account or department which will be part of the COA and distribution entered on invoice. I know we have DIST_CODE_COMBINATION_ID in the AP_DISTRIBUTION_ALL, but where can I find the details of the COA in distribution to query specifically for an account or department.
Appreciate response at the earliest
Version
19C
Tagged:
0