Hi Lolly,
I'm familiar with the text to columns function in Excel but I'm trying to go the other way. I have several field in my bookings system (longhaul car carrier) that I wish to concatenate into the single comments field but wish them to appear on separeate lines. They are sales specific (i.e. unique to each sale) extracted from the bookings sytem to be included with other fields such as price, item number, etc. The description I'm looking for would be along the lines of:
VEHICLE: Ford Ranger (VIN: X104578)
SERVICE: Door-to-Depot
PICK-UP: 38 Account St, Townsville, QLD
DELIVER: Melbourne Depot, Altona North, VIC
From researching for hours & finding all but nothing on the subject, it appears that this functionality (along with numerous other fuunctions that were available in MYOB almost a decade again when I last used it) has gone by the way of the dinosaur. As far as I can tell line returns kill the import file dead in it's tracks. When I export a sale created manually it puts the adiditional lines directly under the first field (being any arbitary order selection at the time of export) by themselves. Of course as soon as I try to import that same file back in it tells me item number can't be blank...I just can't beat the **bleep**. Tried every possible way I can think of...but nothing.
Ho hum...any & all suggestions/guidance greatly appreciated?!
I'm starting to think MYOB of today is not the market leading MYOB I remember from a decade ago. Especially if I read too many of the comments here! Is it correct that you can't even format the default item sales invoice (AccountRight cloud version) apart from a couple of superficial header settings (e.g. logo position, etc.). There appears to be no option of changing font size, removing columns such as discount & selling unit of measure, basically it appears I can't touch the body at all...it's layout & presentation are poor at best. I created an item sale invoice in the AccountRight desktop version but then it appears I can't set it as a default in the cloud version which continually wants to go back to the amateur hour default version...what gives?!?!?! Tell me I'm missing something...please?!