Record Layout to import Supplier (purchase) invoices from multiple retail outlets summarizes by Acct/dep.

hi there,

I am helping someone who needs to import Supplier (purchase) invoices summarized by product inventory inventory Acct and Department to allocate to the Division (which is the individual store).   Does anyone have a record layout and advice/experience with this?  Much appreciated!