Forum Discussion

DanMcLaughlin's avatar
DanMcLaughlin
Qrew Trainee
18 days ago

QUICKBOOKS BILL PAYMENTS PARSING

I have have app that my team can monitor Quickbooks activity without letting the entire user team into our accounting.

I have a connected table to Bill payments. When I try to set up a report link In by Bills table I have to mine a record in  the Quickbooks table that has the Bill ref # and applied amount. 

Once Record looks like this:

[(null,null,null,'978.00',{('162021','Bill',null)},null)]

978 is the applied amount 

162021 is the Quickbooks bill ID

Multiple records look like this:

[(null,null,null,'97199.28',{('163251','Bill',null)},null), (null,null,null,'37784.30',{('163351','Bill',null)},null), (null,null,null,'8100.00',{('163364','Bill',null)},null), (null,null,null,'12658.44',{('163352','Bill',null)},null), (null,null,null,'1092.00',{('163432','Bill',null)},null), (null,null,null,'1103.00',{('163433','Bill',null)},null), (null,null,null,'130.00',{('163439','Bill',null)},null)]

How do I parse this into a Useable Form?

I need [DATE],[Bill ID],[And Applied amount]. in a table that I can plug into my Bill View.

No RepliesBe the first to reply