Advanced Reporting

[Ealfardan]

There are a few examples already here on the forum.

Python module for Manager API

There are a lot of nuances to how you might want to create a receipt, but perhaps something like the below can help you: customer = business.Customer["Amazon"] r = business.Receipt( Date = dateutil.parser.parse("2025-01-28").date(), Reference = "123", PaidBy = "Customer", Customer = customer, ReceivedIn = business.BankOrCashAccount["Any Bank"], Cleared = "OnALaterDate", Lines = [business.Receipt.Line( Account = "d1489e95-bb28-4f5d-b42e-67d3291b3893", # AR …

API 2 using Power Query

Look i am not here to justify myself to you. I know what i can and carnt do with my client data. They sign a forn saying i can put there data into excel to produce reports for them. All i wanted to know is what the path was. I certainly did not need an asumed lecturer.