Additional Info on Item Sales Invoice

Question

Hello,

How would I add additional lines of information specific to the invoice/sale on a Item Sales Invoice? I have tried adding the concatenated text to the comments section of the import file but can't find anyway of forcing line breaks in the text to have the different pieces of information appear on separate lines.

Any help would be appreciated, have wasted hours searching for an answer to something that seems incredibly trivial.

Thank you...

AF74 · Answer

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?!

Lolly · Answer

Have you tried to use delimited text to columns on excel to split out the information before or after entering it to the system or before doing that is there one character that be used to help using text to column on excels or if you want to reduce the size of what's in the cells use ctrl and F then click replace, the common words or symbols you can eliminate leaving the descriptor or text shorter but decipherable eg replace 'and' with blank, replace all or shorten dates using that function. I hope that helps.