Victoria has a new SQL view for Fixed Allocation Accounts in Dynamics GP
SQL view for Fixed Allocation Accounts in Dynamics GP | Victoria Yudin
SQL & DataGeneral Ledger & Financials
Archived post from 2013. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.