John_WallaceExperienced Cover UserJoined 19 years ago59 Posts1 LikeLikes received1 SolutionView All Badges
ContributionsMost RecentMost LikesSolutionsRe: Item sales invoices Thanks John Hopefully the MYOB Developer Team might be able to confirm our suspicions... Cheers John Item sales invoices I'm preparing a application development specification for a client to get item sales invoices... In viewing the Endpoint for item sales invoices the lines array does not contain a backorder field. The client needs to print backorder information on documents as now happens when printing a MYOB Invoice Form... Is anyone able to point me to where this information is located... I can see an Order field on the item sales invoice but the documentation seems to suggest that this is the Order Number from an Order that is being converted to an invoice and is not a relationship to a backorder when entering a new invoice. I'm concerned that the API does not allow for backorder information to be made available and that Accountright contains a hardcoded solution to print backorder information on the current Invoice Form If this backorder information is not available the client's requirements will not be able to be met .. Thanks John 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] Re: Item Sales - Need A Developers Help Hi Mike Thanks for your response.... I'll prepare a high-level spec and email to you ASAP... My client is keen to move forward... Cheers John.. Re: Item Sales - Need A Developers Help Thanks Hannah... I'm aware the shipping address in the EndPoint is a string (255) field which means the full address wont be cut off as happens in the MYOB import/export function. I'm looking for a freelance MYOB developer to build an App to create a csv file using data from the Item Sales Invoice Endpoint. The file will be used by a well known third party logistics company to manage the client's warehousing. needs. If any of MYOB API Developer Team know of any potential developers out there I would appreciate any help.. Re: Invoice Sales Item Endpoint - Shipping Address Query Thanks Mike..... Confirmation allows me to proceed on getting a developer to quote on an App to export the Sales Item Invoices. Cheers John Invoice Sales Item Endpoint - Shipping Address Query I noticed the Shippiing Address in the Invoice Sales Item Endpoint is a String(255).... I presume that the Address emanates from the Customer Card Address Block which is entered as Lines (and optionally Suburb/State/Postcode/Country Fields) and then captured as a concatenated single Shipping Address. The MYOB Invoice Sales Item export has 4 Address Fields (Address_Line_1.... Address_Line_4) and excludes the specific optional fields. Can anyone confirm the CRLF are included in the String ? Solved