Myob accountright Ship to
Hi all, We deal with a large scale business who has a head office and multiple different sites we deliver to. We have "Bill to" as head office, we then have "Ship to" as 4 of their stores, from t...
Forum Discussion
Hi Ashlee1001 , in my file the store name is on line 1 of the ship-to address. The Sales [Customer detail] report can have the ship-to address added (Insert/Modify tab, then Show/Hide), then you can export this to Excel. The report includes all invoice lines, so you can summarise this using a pivot table.
Each ship-to address has many lines in the cell. To use the first line, add a formula in the next cell on the right, like this:
=LEFT(J13,FIND(CHAR(13),J13,1)-1) and copy it down the whole table.
(Note in my table, row 13 is the first sales line).
Char(13) is the "end of line" character
Find() finds the position of that character
Left() extracts everything up to that position, therefore contains the store name only. Add a column heading eg "Store Name".
