Mark_DataWise
Member
Joined 9 years ago
User Profile
User Widgets
Contributions
Re: Multiple device billing for 1 customer
Hi Karuto We at DataWise in New Zealand have written an addon to handle billing for electricity supply companies, as MYOB has no way of handling this. Mostly used by retirement villages to input meter readings, calculate various charges and send bills monthly. Also posts invoices to MYOB and can handle Direct Debits with major banks. Please contact me by email at mark@datawise .co.nz if you would like more info.210Views0likes0CommentsRe: Sales Invoices - Items not returning NextPageLink
Hi I have done a whole lot more testing on the API NextPageLink issue and found another strange result Anybodu else having issues still? MWC20221130 API Sales data retrieval notes and errors Tests done on Item and Service Sales Tests done on Cloud and Library files. NB results of json returned every call saved to a text file saved in a folder 2 Main Issues: 1 - NexPage url not being created 2 - NextPage Url correct but pattern of small set of transactions returned. 3 - Different results based on different Filters used 1 - NexPage url not being created Tested on Library and Cloud file with same result Sale Invoice Service on Library file returned no NexPage url I added my own code to generate NextPAgeUrl and data was returned correctly, so workaround solution ok. URLs used : 1) Dates between sUrl = Replace(dwrcompany.dwrMYXUri,"localhost",dwrcompany.dwrMYXServer) + "/Sale/Invoice/Service?$top=1000&$filter=Date ge datetime'"+ DateToString(gdDateFrom,"YYYY-MM-DD") + " and Date le datetime'" + DateToString(gdDateTo,"YYYY-MM-DD") + "'" 2) Date equal and greater than sUrl = Replace(dwrcompany.dwrMYXUri,"localhost",dwrcompany.dwrMYXServer) + "/Sale/Invoice/Service?$filter=Date ge datetime'"+ DateToString(gdDateFrom,"YYYY-MM-DD") + "'" I added my own code to generate NextPAgeUrl and data was returned correctly, so workaround solution ok. 2 - Sale Invoice Item Url's Used Test results below on large Cloud file In both tests exact copies of my code used with only diffrence being url 1) Filter based on "Modified" field ( Transaction modified date) Worked perfectly collecting data correctly as shown in logs below Below is result of "Modified" call which worked fine for 1,5 hours untill it was stopped at the stikjee of midnight. ( presumably deliberately by some MYOB process) start sale item_modified 400 of 60979 SKIP: 400 NextPageSkip: 400 PageSkip: 400 800 of 60979 SKIP: 800 NextPageSkip: 800 PageSkip: 400 1200 of 60979 SKIP: 1200 NextPageSkip: 1200 PageSkip: 400 1600 of 60979 SKIP: 1600 NextPageSkip: 1600 PageSkip: 400 2000 of 60979 SKIP: 2000 NextPageSkip: 2000 PageSkip: 400 2400 of 60979 SKIP: 2400 NextPageSkip: 2400 PageSkip: 400 2800 of 60979 SKIP: 2800 NextPageSkip: 2800 PageSkip: 400 3200 of 60979 SKIP: 3200 NextPageSkip: 3200 PageSkip: 400 3600 of 60979 SKIP: 3600 NextPageSkip: 3600 PageSkip: 400 4000 of 60979 SKIP: 4000 NextPageSkip: 4000 PageSkip: 400 4400 of 60979 SKIP: 4400 NextPageSkip: 4400 PageSkip: 400 4800 of 60979 SKIP: 4800 NextPageSkip: 4800 PageSkip: 400 5200 of 60979 SKIP: 5200 NextPageSkip: 5200 PageSkip: 400 5600 of 60979 SKIP: 5600 NextPageSkip: 5600 PageSkip: 400 6000 of 60979 SKIP: 6000 NextPageSkip: 6000 PageSkip: 400 6400 of 60979 SKIP: 6400 NextPageSkip: 6400 PageSkip: 400 6800 of 60979 SKIP: 6800 NextPageSkip: 6800 PageSkip: 400 ... middle lines excluded for brevity 50800 of 60979 SKIP: 50800 NextPageSkip: 50800 PageSkip: 400 51200 of 60979 SKIP: 51200 NextPageSkip: 51200 PageSkip: 400 51600 of 60979 SKIP: 51600 NextPageSkip: 51600 PageSkip: 400 52000 of 60979 SKIP: 52000 NextPageSkip: 52000 PageSkip: 400 52400 of 60979 SKIP: 52400 NextPageSkip: 52400 PageSkip: 400 52800 of 60979 SKIP: 52800 NextPageSkip: 52800 PageSkip: 400 53200 of 60979 SKIP: 53200 NextPageSkip: 53200 PageSkip: 400 53600 of 60979 SKIP: 53600 NextPageSkip: 53600 PageSkip: 400 54000 of 60979 SKIP: 54000 NextPageSkip: 54000 PageSkip: 400 54400 of 60979 SKIP: 54400 NextPageSkip: 54400 PageSkip: 400 54800 of 60979 SKIP: 54800 NextPageSkip: 54800 PageSkip: 400 55200 of 60979 SKIP: 55200 NextPageSkip: 55200 PageSkip: 400 Retry 1<\r><\n>{"message": "Network error communicating with endpoint"}1 JSON error: 0 Skipped Note below that all returned file sizes or similar and differe based on number of lines per invoice Name Date modified Type Size i. api_N1yJson_0.txt 29/11/202211:59 pm TXTFile 1 KB il api_SalelnvoiceltemMod_55200.txt 29/11/202211:59 pm TXTFile 1 KB il api_SalelnvoiceltemMod_54800.txt 29/11/2022 11:58 pm TXTFile 2,150 KB il api_SalelnvoiceltemMod_54400.txt 29/11/202211:57 pm TXTFile 1,992 KB il api_SalelnvoiceltemMod_54000.txt 29/11/202211:57 pm TXTFile 2,234 KB il api_SalelnvoiceltemMod_53600.txt 29/11/202211:57 pm TXTFile 2,277 KB il api_SalelnvoiceltemMod_53200.txt 29/11/202211:56 pm TXTFile 2,293 KB il api_SalelnvoiceltemMod_52800.txt 29/11/202211:56 pm TXTFile 2,291 KB il api_SalelnvoiceltemMod_52400.txt 29/11/202211:55 pm TXTFile 1,914 KB il api_SalelnvoiceltemMod_52000.txt 29/11/202211:55 pm TXTFile 2,201 KB il api_SalelnvoiceltemMod_51600.txt 29/11/202211:54 pm TXTFile 2,181 KB il api_SalelnvoiceltemMod_51200.txt 29/11/202211:54 pm TXTFile 2,276 KB il api_SalelnvoiceltemMod_50800.txt 29/11/2022 11:53 pm TXTFile 2,262 KB ... middle lines excluded for brevity il api_SalelnvoiceltemMod_6800.txt 29/11/2022 10:57 pm TXTFile 2,167 KB il api_SalelnvoiceltemMod_6400.txt 29/11/2022 10:56 pm TXTFile 2,245 KB il api_SalelnvoiceltemMod_6000.txt 29/11/2022 10:56 pm TXTFile 2,328 KB il api_SalelnvoiceltemMod_5600.txt 29/11/2022 10:55 pm TXTFile 2,120 KB il api_SalelnvoiceltemMod_5200.txt 29/11/2022 10:55 pm TXTFile 2,024 KB il api_SalelnvoiceltemMod_4800.txt 29/11/2022 10:54 pm TXTFile 2,125 KB il api_SalelnvoiceltemMod_4400.txt 29/11/2022 10:54 pm TXTFile 2,254 KB il api_SalelnvoiceltemMod_4000.txt 29/11/2022 10:53 pm TXTFile 1,977 KB il api_SalelnvoiceltemMod_3600.txt 29/11/2022 10:53 pm TXTFile 1,712 KB il api_SalelnvoiceltemMod_3200.txt 29/11/2022 10:52 pm TXTFile 1,839 KB il api_SalelnvoiceltemMod_2800.txt 29/11/2022 10:52 pm TXTFile 2,033 KB il api_SalelnvoiceltemMod_2400.txt 29/11/2022 10:51 pm TXTFile 2,180 KB il api_SalelnvoiceltemMod_2000.txt 29/11/2022 10:51 pm TXTFile 1,852 KB il api_SalelnvoiceltemMod_1600.txt 29/11/2022 10:50 pm TXTFile 1,473 KB il api_SalelnvoiceltemMod_1200.txt 29/11/2022 10:50 pm TXTFile 1,750 KB il api_SalelnvoiceltemMod_800.txt 29/11/2022 10:49 pm TXTFile 1,954 KB il api_SalelnvoiceltemMod_400.txt 29/11/2022 10:49 pm TXTFile 2,072 KB il api_SalelnvoiceltemMod_0.txt 29/11/2022 10:48 pm TXTFile 1,787 KB il api_TestCompany.txt 29/11/2022 10:47 pm TXTFile 1 KB 2) Url based on "Date" field (Transaction Date) https://ar2.api.myob.com/accountright/49ff204f-cf26-4fd0-9748-9acab9071154/Sale/Invoice/Item?$top=400&$skip=18400&$filter=Date%20ge%20datetime%272021-04-01T00%3A00%3A00.000%27 Note very carefully the sizes of the returned data and see how it follows a pattern of small returns of 30 transactions to 400 and back to 70 and then back to 400 every 8 or so calls YOu have to see this to believe it! The nextpage link was generated in the json in each case with a slkip value of 400 I have put blank lines to show the "waves" The suffix on th efile name shows actual number of records processed as a running total Name Date modified Type Size il api_Salelnvoiceltem_0.txt 29/11/2022 4:09 pm TXTFile 174 KB processed 33 invoices il api_Salelnvoiceltem_33.txt 29/11/2022 4:09 pm TXTFile 162 KB processed 32invoices il api_Salelnvoiceltem_65.txt 29/11/2022 4:09 pm TXTFile 153 KB processed 30 invoices il api_Salelnvoiceltem_95.txt 29/11/2022 4:09 pm TXTFile 2,750 KB processed 368 invoices il api_Salelnvoiceltem_463.txt 29/11/2022 4:09 pm TXTFile 3,098 KB processed 400 invoices il api_Salelnvoiceltem_863.txt 29/11/2022 4:09 pm TXTFile 2,939 KB processed 400 invoices il api_Salelnvoiceltem_1263.txt 29/11/2022 4:10 pm TXTFile 3,017 KB processed 400 invoices il api_Salelnvoiceltem_1663.txt 29/11/2022 4:10 pm TXTFile 2,949 KB processed 400 invoices il api_Salelnvoiceltem_2063.txt 29/11/2022 4:10 pm TXTFile 822 KB processed 110 invoices il api_Salelnvoiceltem_2173.txt 29/11/2022 4:10 pm TXTFile 262 KB processed 44 invoices il api_Salelnvoiceltem_2218.txt 29/11/2022 4:10 pm TXTFile 20 KB processed 4 invoices il api_Salelnvoiceltem_2222.txt 29/11/2022 4:10 pm TXTFile 73 KB processed 7 invoices il api_Salelnvoiceltem_2229.txt 29/11/2022 4:10 pm TXTFile 1,506 KB processed 227 invoices il api_Salelnvoiceltem_2456.txt 29/11/2022 4:10 pm TXTFile 2,901 KB processed 400 invoices il api_Salelnvoiceltem_2856.txt 29/11/2022 4:10 pm TXTFile 2,967 KB processed 400 invoices il api_Salelnvoiceltem_3256.txt 29/11/2022 4:10 pm TXTFile 2,956 KB processed 400 invoices il api_Salelnvoiceltem_3656.txt 29/11/2022 4:10 pm TXTFile 2,965 KB processed 400 invoices il api_Salelnvoiceltem_4056.txt 29/11/2022 4:10 pm TXTFile 2,138 KB processed 400 invoices il api_Salelnvoiceltem_4352.txt 29/11/2022 4:10 pm TXTFile 314 KB etc etc il api_Salelnvoiceltem_4405.txt 29/11/2022 4:11 pm TXTFile 82 KB il api_Salelnvoiceltem_4421.txt 29/11/2022 4:20 pm TXTFile 631 KB il api_Salelnvoiceltem_4510.txt 29/11/2022 4:20 pm TXTFile 3,022 KB il api_Salelnvoiceltem_4910.txt 29/11/2022 4:20 pm TXTFile 2,910 KB il api_Salelnvoiceltem_5310.txt 29/11/2022 4:20 pm TXTFile 3,045 KB il api_Salelnvoiceltem_5710.txt 29/11/2022 4:20 pm TXTFile 3,064 KB il api_Salelnvoiceltem_6110.txt 29/11/2022 4:20 pm TXTFile 2,941 KB il api_Salelnvoiceltem_6510.txt 29/11/2022 4:20 pm TXTFile 401 KB il api_Salelnvoiceltem_6572.txt 29/11/2022 4:20 pm TXTFile 72 KB il api_Salelnvoiceltem_6586.txt 29/11/2022 4:20 pm TXTFile 5 KB il api_Salelnvoiceltem_6587.txt 29/11/2022 4:20 pm TXTFile 9 KB il api_Salelnvoiceltem_6589.txt 29/11/2022 4:21 pm TXTFile 2,640 KB il api_Salelnvoiceltem_6923.txt 29/11/2022 4:21 pm TXTFile 2,884 KB il api_Salelnvoiceltem_7323.txt 29/11/2022 4:21 pm TXTFile 2,991 KB il api_Salelnvoiceltem_7723.txt 29/11/2022 4:21 pm TXTFile 2,891 KB il api_Salelnvoiceltem_8123.txt 29/11/2022 4:21 pm TXTFile 3,017 KB il api_Salelnvoiceltem_8523.txt 29/11/2022 4:21 pm TXTFile 1,477 KB il api_Salelnvoiceltem_8721.txt 29/11/2022 4:21 pm TXTFile 130 KB il api_Salelnvoiceltem_8744.txt 29/11/2022 4:21 pm TXTFile 55 KB il api_Salelnvoiceltem_8754.txt 29/11/2022 4:21 pm TXTFile 1,085 KB il api_Salelnvoiceltem_8912.txt 29/11/2022 4:21 pm TXTFile 3,024 KB il api_Salelnvoiceltem_9312.txt 29/11/2022 4:21 pm TXTFile 2,929 KB il api_Salelnvoiceltem_9712.txt 29/11/2022 4:21 pm TXTFile 2,999 KB il api_Salelnvoiceltem_10112.txt 29/11/2022 4:21 pm TXTFile 3,164 KB il api_Salelnvoiceltem_10512.txt 29/11/2022 4:21 pm TXTFile 2,805 KB il api_Salelnvoiceltem_10896.txt 29/11/2022 4:21 pm TXTFile 313 KB il api_Salelnvoiceltem_10947.txt 29/11/2022 4:21 pm TXTFile 131 KB il api_Salelnvoiceltem_10970.txt 29/11/2022 4:21 pm TXTFile 12 KB il api_Salelnvoiceltem_10972.txt 29/11/2022 4:22 pm TXTFile 1,470 KB il api_Salelnvoiceltem_11160.txt 29/11/2022 4:22 pm TXTFile 2,887 KB il api_Salelnvoiceltem_11560.txt 29/11/2022 4:22 pm TXTFile 2,936 KB il api_Salelnvoiceltem_11960.txt 29/11/2022 4:22 pm TXTFile 2,861 KB il api_Salelnvoiceltem_12360.txt 29/11/2022 4:22 pm TXTFile 2,944 KB il api_Salelnvoiceltem_12760.txt 29/11/2022 4:22 pm TXTFile 2,719 KB il api_Salelnvoiceltem_13113.txt 29/11/2022 4:22 pm TXTFile 326 KB il api_Salelnvoiceltem_13171.txt 29/11/2022 4:22 pm TXTFile 91 KB il api_Salelnvoiceltem_13189.txt 29/11/2022 4:22 pm TXTFile 258 KB565Views0likes0CommentsRe: Sales Invoices - Items not returning NextPageLink
Hi Matthew Thanks for you comments. I have this issue with one client using Local Library as well. The issue in this case is not random, As I have a log that records the api call made and result, and have had constant results over the last week. As it's month end I think I will just do my own Nextpage url generation, and move on. I will log a support call and hope ...600Views0likes1Comment