Myob accountright Ship to

Question

Hi all,&nbsp;We deal with a large scale business who has a head office and multiple different sites we deliver to.&nbsp;We have "Bill to" as head office, we then have "Ship to" as 4 of their stores, from there each other store has their own individual card with store number, and we select "another card" when doing the invoice.My question is around reporting of these sites, is there anyway to report on which store has spent which amount? As currently it only shows the company head office name, not the individual stores.&nbsp;IE for example, having Bunnings as the head office/card and then having&nbsp;2. Clyde store (store number)3. Berwick store (store number)4. Narre Warren store (store number)5. Frankston store (store number)then we have other sites as other cards.How do i find out on a report how much the Berwick store has purchased without it being under the Bunnings banner?&nbsp;*bunnings used purely as an example

mike_james · Answer

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.
&nbsp;
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".
&nbsp;

Forum Discussion

Myob accountright Ship to

1 Reply

Looking for something else?

Learn, solve, grow

Related content

MYOB accountright not starting

MYOB SSO Login Issues - Accountright SE

MYOB Accountright will not complete login this morning

MYOB AccountRight desktop templates

Using MYOB Accountright Overseas

AccountRight Attachments

Using offline version of MYOB AccountRight Standard v19.1

MYOB Accountright Certificate error