So it seems that there is a disconnect between the AP lists and the AP control account in the GL, in that an AP list as of a certain date is invoice date sensitive but the GL Control balance is period sensitive. ie. if you have an invoice dated June then it doesn't appear on your May AP list, but if you posted that invoice into period 5 (assuming fiscal=calendar) then you're out of step.

What are folks doing out there? Putting fake invoice dates to match the period? Ignoring the fact that the AP lists only match the GL if you use a future date? Just allowing the AP invoice dates to choose the GL period regardless of when the goods/benefit were received?

Thanks for any input on this.