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

Product Ideas

Sales: Income Account set in Customer card to apply to item invoices

Cover User

3Posts

9Kudos

0Solutions

3 Posts
Cover User

Hi team,

 

Currently, the Income Account is defined at the Item level. This means that the sale of any particular Item can only be posted against one pre-defined Income Account, irrespective of who the Item is sold to.

 

Our Item Inventory is sold to numerous domestic distributors, export agents and some direct to retail customers. Income Accounts are grouped such that domestic distributors, export agents and direct retail customers are each distinct.

 

The available work-arounds are:

 

1) set up multiple versions of each Inventory Item, so that they are allocated an appropriate Income Account -- this doesn't work for us as our production process generates a quantity of items which are recorded as Inventory, and then the sales process determines where they are sold to; we don't necessarily know who we are selling to when we manufacture the Items.

2) for each sale, prior to raising the invoice, manually update the Income Account of the Item to reflect where it is being sold to, then change it back -- this process is time consuming, cumbersome and prone to mistakes.

3) journal to achieve the right value in right Income Account -- as per work-around 2, this process is time consuming, cumbersome and prone to mistakes.

 

Suggested change:

Allow the Income Account to be set at the Customer level, rather than the Item level, so that a sale to a particular customer will determine which Income Account the sale is posted to.

 

Cheers

Josh

 
'Income Account to be associated with Customer rather than Item"

Current Status: Open
Last Changed: October 2014

Thanks for your suggestion. So that we can get an idea of the popularity of this request, if you would also like to be able to record item sales with the income account based on customer selected, please vote for this idea here.

5 Comments
Jennifer_Kelly
Super Partner
492 Posts
Super Partner

Hi Josh,

 

I can fully understand your request however am guessing that the vast majority of businesses will need to record the GL account based on the type of items not customer.

 

I am guessing you need to split your sales in this manner by the customer type due to different tarrif or alcohol tarif calculations??

 

Can I suggest that if you report your item sales based on Customer Groupings (using the Customer Custom fields) you would be able to achive the result you are looking for and also still be able to see the Items being bought.

 

You may need to use one of the Add on Advanced reporting solutions to get  exactly what you need, see:

 http://myob.com.au/addons/category/3/advanced-reporting/

 

As an example using Business Intelligence for MYOB, if you were to use a Custome List to allocate each Customer the Customer Type then you would be able to report your P&L in the following collumns for any given date range:

                                                    Qty   $Sales    $COGS       $Profit      Margin%

- Domestic distributors   - 

- Export agents

- Drect retail customers

 

From there you could Filter or drill down to get the break down of Customers and or Items in each grouping Export etc.

 

I can't add an excel example to this post however you can see in our Online User Help how easy this is to do and the results you could get.  

See:  https://biformyob.zendesk.com/hc/en-us/articles/202778194-Use-Custom-Lists-to-Categorise-Customers-t...

 

We have a number of Wineries and Acholol distributors using our software to help with their liquor reporting requirements.

 

I hope this helps, all details are on our website at www.BIforMYOB.com or call on 02 8912 4120.

 

Jennifer Kelly CA

Business Intelligence for MYOB

 

Liam_M
3,488 Posts
Former Staff

Thanks for your suggestion. So that we can get an idea of the popularity of this request, if you would also like to be able to record item sales with the income account based on customer selected, please vote for this idea here.

MDBrewery
3 Posts
Cover User

Guys, where is this at?

Steven_M
45,180 Posts
Former Staff

Hi @MDBrewery 

Thank you for your enquiry into your idea. Currently the idea is still under consideration.

The normal process for an Idea posted on Ideas Exchange would go through a few stages. We would mark the post as "Under Consideration" and encourage users to vote and comment for this idea. If the idea does generate a number of votes and comments we mark it has high demand meaning we will investigate and attempt to implement that idea ahead of other ideas with lesser demand.

As of 15/01/2015 the idea exchange have had 63 ideas implemented from it and some of the ideas have been marked as Planned.

As to a timeframe, we can't give an exact one for the ideas posted on the Ideas Exchange as we do need to assess each idea and the demand for that usage before implementing it into the product road map.

RockOfWisdom
1 Post
User

We are a wine producer and have the same requirement. We have to report sales  by customer group ie Retail, Wholesale, Distributor, Export so we can correctly calculate and report on the Wine Equalisation Tax (WET) when we prepare our quarterly BAS statement