Multiple Lines on One Bill

Afternoon,

We have been working on an interface between a piece of software called
Spendmap and Freeagent for a while. The script (programmed in Python) is
plodding away just fine, parsing the exported text file from Spendmap into
JSON to post to Freeagent through the API. However, Spendmap exports each
item from a purchase order as a separate line along with the relevant
pricing, invoice/PO numbers etc.

Is anyone able to point me in the direction of a solution for this because
at present, one PO from Spendmap is posting multiple Bills in Freeagent. Is
the best solution to get the interface to do the work and ‘add’ the values
of each line associated with the same invoice number? If so, does anyone
have any pointers/example code or does Freeagent have any way of handling
this?

Thanks for your help.

Karl

Hello Karl,

“Is the best solution to get the interface to do the work and ‘add’ the
values of each line associated with the same invoice number?”

Yes, you’ll need to get your Python script to add together all lines with
the same invoice number and then create a single Bill using the FreeAgent
API. You could put the information from all the lines in the Bill comments
if you wanted to see it within FreeAgent.

Does that help?

BenOn Tuesday, 3 September 2013 08:04:59 UTC-7, Karl Sayle wrote:

Afternoon,

We have been working on an interface between a piece of software called
Spendmap and Freeagent for a while. The script (programmed in Python) is
plodding away just fine, parsing the exported text file from Spendmap into
JSON to post to Freeagent through the API. However, Spendmap exports each
item from a purchase order as a separate line along with the relevant
pricing, invoice/PO numbers etc.

Is anyone able to point me in the direction of a solution for this because
at present, one PO from Spendmap is posting multiple Bills in Freeagent. Is
the best solution to get the interface to do the work and ‘add’ the values
of each line associated with the same invoice number? If so, does anyone
have any pointers/example code or does Freeagent have any way of handling
this?

Thanks for your help.

Karl