IBM Apptio

 View Only

 Invoice Line Item Details

Jump to  Best Answer
  • CostingStandard(CT-Foundation)
Apptio Community Member's profile image
Apptio Community Member posted Thu January 07, 2021 01:53 PM

Partners,

I am looking for some ideas on how did you manage getting vendor invoice line item details for your implementation. We are able to get invoice details but are having a challenge getting individual line items from invoices as they are not captured in our ERP/Invoice Payable system. The only option available is to manually create excel files by copying data from PDF invoices and uploading those into Apptio.

Looking forward to some insights on this. Thanks in advance.

Shaun 


#CostingStandard(CT-Foundation)
Apptio Community Member's profile image
Apptio Community Member  Best Answer
Thanks for your post @Shaun Small!

In order to answer this more effectively, can you please provide some information on the product you are using/attemping to extract vendor line item detail into?

Generally speaking, the format of the invoice itself is what dictates Apptio's ability to automatically read line-by-line detail to then automatically translate that data into a usable data table which can then be appended/referenced elsewhere in your model. PDF invoices can be tricky depending on how they are formatted. In any case, there would be some configuration required in order for that data to be read accurately.

Overall this sounds like something you should engage your delivery consultant about. They will be able to view these PDF invoices and give you your best options around how to best ingest that data. It is possible that either an SFTP/REST or other DataLink connector can be set up to automatically ingest these invoices for you depending on the source. Another option your delivery team are best placed to answer.

Hope this helps. Adding @Debbie Hagen here so she is across this issue.

Thanks!​​
#CostingStandard(CT-Foundation)
Apptio Community Member's profile image
Apptio Community Member
We created an editable table and our Accounts Payable team enters the detail.  Labor vendors are required to send us detail in a file that we specify.  It benefits them because they become a preferred vendor the contract negotiations are streamlined.  Being a preferred provider gives them more business.  We get the data, they get more business.  It's a win-win
#CostingStandard(CT-Foundation)