Item Sales - Need A Developers Help
I have a client who needs a csv file created with Item Sales invoices based on entered dates using an small App developed using the AccountRight API....
Yes, I know this could be satisfied by using the AccountRight Export but the Item Sales export has one major flaw... The Shipping address is only available in four address fields. The first of these fields (Address Line 1) contains the Customer Name albeit it is included in the Customer Name export field(s) - I think the analysts might have been a bit Tipsy at the time !! The remaining three export fields (Address Line 2... Line 3... Line 4) are just poplulated by the 1st three lines of the Shipping Address. This means that when there are more shipping adddress lines then the shipping address in incomplete such that the Suburb, State and Postcode may not present in the export.
I examined the MYOB API Item Sales Invoice Endpoint where the Shipping Address is String (255). I have confirmed it contains /r/n characters implicit in the Shipping Address on the Invoice which means it caters for the more than 3 lines (assuming the same export file data analysts were not involved in the spec !)..
If there is any developer who could help with an App, please contact directly me on 042450XXX..
John Wallace
Certified Consultant
Sydney
[Phone number removed by Administrator HB]