API dropping a line in an invoice
Hi MYOB API
I will post directly to you but thought I would drop this on the general post forum for the developers and API people for interesting information.
I have a client using a Job Costing package I developed in 2007 - modernised to the latest AR & API.
It was modernised to use the latest API previously using the ODBC drivers to connect to the MYOB file.
All has been working fine - 100% perfectly - and suddenly the API cannot see a particular line in a Service invoice.
The program imports all Sales - Service only - Job Numbers - Purchases
It does a cost analysis on a quoted job vs actual costs - and also informs of payments by the customer on the job - identified by 3 digit job numbers.
All has been working perfectly since May last year - but suddenly - the API cannot see a particular line in a service sales invoice.
Change the description in the description field; change the job number; change the amount - the API will not see it. Delete the description - i.e. make it Null - and it sees it.
So to be precise - a customer - who has a lot of jobs running may pay 280,000 - and an invoice (service) is raised and this total may be split over 10 jobs
varn 40: remove this item from estimates - $4300 job 322
varn 39: ............. $2300 job 318
varn 40
varn xx: $15,000 job 317
Varn 40: remove angle on window $1138 job 322
The $1138 will not import - delete the line and rebuild - doesn't work
Reduce description - doesn't work
All other lines are imported fine
I have deleted the line entirely added it to the end or front - it will not import.
Change the job number - will not import.
Delete the description (only on this line) - and it imports fine
This sort of bug has me worried - I cannot identify what is causing the API to drop it.
I have yet to check the JSON page to see if it is there - and my JSON read code is missing it for some strange reason.
I am most concerned about this bug - dropping a line in an invoice is strange behaviour.
The Doc
Hi Komal_S
Problem solved - minor bug in my JSON dictionary - my coding loop to decide whether a line in a service invoice was a "Type: Header" or "Type: Transaction" - however my lookup only said - if the word in this line is "Header" then ignore
instead of - if word in this line is "Type: Header" -
and the bug was if the line description had a word in there ........... header ........ then that line was ignored.
And the 1 in 1000 invoices - a description had the word ... header in there which resulted that line being ignored.
The bug has been fixed.
The Doc