Tax Codes for requisition and purchase orders lines / distributions
Summary:
I am trying to construct a sql query to pull back details of tax_codes used on purchase orders (draft) and requisitions (unapproved) at line / distribution level.
Content (please ensure you mask any confidential information):
I am trying to construct a sql query to pull back details of tax_codes used on purchase orders (draft) and requisitions (unapproved).
I have tried to research this but the advice of where to look (cf below query) yields a large number of unpopulated results, where the PO nonrecoverable / recoverable tax amounts are populated in the data, which does not make sense to me.
0