Share your ideas for improving. Vote on ideas and discuss them with the MYOB product development team.

Product Ideas

Sales Register: Add additional columns

Cover User

4Posts

12Kudos

0Solutions

4 Posts
Cover User
Australia
New
New

Hi guys, I have been on the forum and noticed my idea was first presnted in 2013 by another user and repeated nearly 20 times.

I struggle to understand why you cannot add/modify the fields in the Sales Registry Window.

Account Right is designed for variances in business workings and cannot always rely on a set window for staff to work around. Our business requires (as do others it seems) to be able to (at a glance) pull up invoices based on other criterias in the fields.

We have a requirement to add a field (or can modify an existing field) to enter a customer number as this is the only way we can identify the order, otehrwise it adds 3 minutes to the query. We have found a work around by placing this number into the purchase order number field and modified the tax invoice and delivery dockets to reflect this, but not a good way to do this.

Could you please review this idea and give some importance to this request as it has been around for over 4 years and others have had to find a work around.

 

Zoran

 "Sales Register Window Customising"

13 Comments
Zoranf
4 Posts
Cover User

Hi there, I am reposting this idea again as I cannot believe that the rest of the community would not find this of immense value and cannot believe it would be difficult to implement.

 

The All Sales - Sales Register Infomation window should be customisable to allow users to add/modify the fields displayed, for example include a column showing say Journal memo, Referral Source etc.

 

This would make the window so powerful in information that the user would not have to drill down into the sale to get information whilst you have customers holding on the phone.

 

Please consider this idea as it is a simple idea with powerful outcomes.

Jennifer_Kelly
Super Partner
492 Posts
Super Partner

Hi @Zoranf

 

Yes these days it is very useful to be able to look at your sales not just by Invoice and customer but by other factors like Referal source, or the Type of Customer etc. using the Customer  Some of this will be available by running Sales reports in MYOB ( rather than on screen using the Sales Register as you are asking). 

 

If you are wanting to do some more advanced reporting then can I  suggest that you also look at some of the MYOB Add-on solutions that can provide Advanced Sales analysis righ now. 

 

As an example using our Business Intelligence software BI4Cloud you can do dynamic sales analysis where you can Filter, Sort or group your sales by many different dimensions including Customer & Customer Groups, Product & Product groups, Salesperson, Referal Source, Sales by day by week by quarter by month, comparisons to any prior period and including Sales, Qty, Margins etc.

 

Below are a couple of simple examples:

 

Sales register including Invoice Memo and margins - From here you could filter or subtotal Invoices by the many dimensions I mentioned above.

 

Sales Register - with margins.png

 

Or run a High level report Analysing by Referal Source - this summarises all invoice by each Referal source type, you can see how much each Referal Source is contributing to your Sales and Gross margin over any time frame. Simply drill down on each Row to see the Customers /Items/Invoices that came from each Source.

 

Sales Register by Referal Source.png

If this is of interest please do try the 14 Day Free trial of BI4Cloud at www.BI4cloud.com

 

Jennifer Kelly CA

BI4Cloud.com

02 8011 1511

AndrewSimms
Experienced Cover User
24 Posts
Experienced Cover User

in following from above, our company would like to be able to find sales according to the shipping address. We have multiple sales for single customers. A date, price and quote number isn't very useful in trying to locate a particular sale from the sales register window. let alone anywhere else in myob.

Jayde1
2 Posts
User
 
Jayde1
2 Posts
User

I think it'd be a great idea for users to be able to personalise the columns shown to them in the sales and purchase registers. e.g. add in the column that shows an invoice due date, journal memo note, even the invoice/sales description. take out columns that you don't need. 

 

I know we can do this in reports but not all users need to run reports and the registers provide the info needed for general tasks. 

Butch_Dixon
Experienced User
58 Posts
Experienced User

Currently using BI4Cloud and thoroughly recommend it.

 

But we have multiple users and it would be so handy if we could have the option of just adding one column of our choosing to the Sales Register. 

 

I understand the limitations of Accountright, but the addition of these small variables open up doors which make Accountright so much more useful - and therefore eliminates the need to upgrade to a more advanced product.

 

For example we use the Cust PO No. field for courier tracking numbers. This has been really handy for our sales team when handling inquiries. But Starshipit doesn't communicate with this field. We could use the comment field, but that does not display on the Sales Register. 

dOrepast
Contributing Partner
8 Posts
Contributing Partner

I would like to add a column to the sales register window too.  Has this issue been resolved since this post?  If so, please advise how to do this.

 

Thanks 

Heidi

SalesEurovap
8 Posts
User

Hi Guys,

 

It would be great if we had the ability to add further columns to the Sales Register based on fields from the Sales Invoice.

 

Eg. Salesperson, Journal Memo Fields or the "Ship to" Field name...

 

We invoice out to a "parent company" and ship to another "child" branch but details available in the sales register only show the "parent company". We change the Journal Memo Field and Salesperson Field (Work Around) on each invoice to reflect the branch that we have sent to.

 

This would allow you to see the Parent Company that was invoiced and the Child Company sent to which would be great.

 

Surely other companies are in the same boat as us?

 

Thank you.

DazzaB
Experienced Cover User
141 Posts
Experienced Cover User

Hi 

If you manage to get them to add the ability to add or customise any columns in any onscreen report/sales /purchase then please let me know how you managed it 

I have been asking for column customisation for all onscreen entities for about 15-20 years and so far ZIP has been done 

So best of luck 

Darryl

ps 

Great idea but I dont think they have the programming skills to do it 

DazzaB
Experienced Cover User
141 Posts
Experienced Cover User

When will myob allow the user to pick what fields are required in the onscreen display for 

1. sales

2. purchases

3. auto ordering 

and probably most of the other screens as the fixed ones are only half usefull as you are constantly going to the parts card to find the rest of the information that you require

Dont they realise that every business is different and that what works for one doesnt for another

Even within a business different people could require customised arrangements of sales/purchasing/ordering etc to make their job more efficient

Hope this gets some traction and something done soon

Darryl