Jump to content

Transactions imported via API from ProSpend not appearing under Total Expense account group


 Share

Recommended Posts

I have a number of AP invoice transactions which are automatically imported into Intacct from ProSpend.  I am trying to create a report to show Total Expense by Vendor, however the transactions automatically allocated to the Vendors by the API from ProSpend do not seem to be appearing under the Total Expense account Group.

What am I not doing?

Thanks

Link to comment
Share on other sites

Are you sure the GL accounts on the AP bills are coded to accounts that are within the Total Expenses account group? That’s the first thing to check which you can do by running the account group hierarchy report in the general ledger module. It’s also possible that the integration is creating bills with the vendor only at the header level where it’s required, but the vendor ID field on the actual line items is blank. Lastly, you could check to make sure that the vendor dimension is enabled within the general ledger module configuration. If it’s not then the Vendor data won’t flow to the GL, which is what financial reports are based off of.

  • Thanks 1
Link to comment
Share on other sites

Hi.

Thanks for the help, it is that the integration is creating bills with the vendor only at the header level where it’s required, but the vendor ID field on the actual line items is blank.

Any ideas how to fix this.  Is there a way to manually add this information as the bills come into the system as 'Draft' bills?, or does this need to be done in the API coding?

Thanks

Link to comment
Share on other sites

 Share

×
×
  • Create New...