In FE database when I created an A/P table I used a default gl account labeled "default account". I would add information in customized transaction detail columns called Funding Source and Claim Component. Then I would save the table. As an invoice was entered, a table would be selected with the default account, funding source, and claim component populated. The default account would be changed to the gl account needed for the invoice (example rent expense, utilities). The Funding Source and Claim Component would remain in the table when the gl account number changed.

Now in FE NXT when an invoice is entered and an A/P table is selected, the default account is changed to the proper expense code and the Funding Source and Claim Component are cleared out.

Our A/P coordinator now has to print out the tables so that she can see what Funding Sources and Claim Components need to be reentered on an expense line.

FE NXT AP Table...

FE Database AP ...

Attachments Open full size