I’m not sure if being dubbed the King of Analytical Accounting is a compliment or simply a sign of high pain tolerance but Sivakumar is certainly laying claim to that title with all of his great AA SQL scripts and information including his newest post Analytical Accounting Information Flow from Purchase Order to Receipts.
Analytical Accounting Information Flow from Purchase Order to Receipts | Interesting Findings & Knowledge Sharing
General Ledger & FinancialsSales, Purchasing & Inventory
Archived post from 2011. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.