Expensify to Sage ERP 500 integration

SOLVED

We have a sage system of sage 500.Using the sdk we insert data into system.Now we need a enter data from a external source (Expensify) in to this.Is any php integration for sage available or stored procedure documentation available for porting Expensify data to sage 500.

Parents
  • 0
    verified answer

    I see that Expensify is an expense software so I am assuming that you need a way to import AP Voucher transactions to track the expenses in Sage 500.  I would suggest reviewing the Data Import Manager (DIM) procedure spAPapiAPPendInvoiceIns which creates pending vouchers in Sage 500.  It uses staging tables to process the records to be imported.  If AP Vouchers are not what you need to create, what type are transactions do you need?

    You will also need to determine how you will get the information from Expensify to Sage 500.  Will Sage 500 be pulling the data from Expensify or will Expensify be pushing data to Sage 500.    Sage 500 doesn't have any web services that interact with the DIM routines, so you will need to take that into account as well.

Reply
  • 0
    verified answer

    I see that Expensify is an expense software so I am assuming that you need a way to import AP Voucher transactions to track the expenses in Sage 500.  I would suggest reviewing the Data Import Manager (DIM) procedure spAPapiAPPendInvoiceIns which creates pending vouchers in Sage 500.  It uses staging tables to process the records to be imported.  If AP Vouchers are not what you need to create, what type are transactions do you need?

    You will also need to determine how you will get the information from Expensify to Sage 500.  Will Sage 500 be pulling the data from Expensify or will Expensify be pushing data to Sage 500.    Sage 500 doesn't have any web services that interact with the DIM routines, so you will need to take that into account as well.

Children