Customise Items Re-Order Report

Highlighted
Contributing Cover User
17 Posts
Contributing Cover User
Australia
Contributing Cover User

17Posts

0Kudos

0Solutions

Customise Items Re-Order Report

Hi there

Can I create a report in MYOB with the following information - I know I will have to customise the report, just don't know how to add a column with the information I need!

 

Sales over a period of time - I must be able to choose the beginning and end date (at least 4 months)

Item #

Item Name

Quantitiy sold over this period

Average sold per month during this period (How do I customize a column to give me this information)

Quantity on Hand

4 Month quantity required (Quantity sold per month x 4)

Quantity to Order (based on Quantity on Hand and Quantity requird for 4 months)

 

Assistance on how to customise a report with the needed information is much appreciated!

3 REPLIES 3
Highlighted
MYOB Moderator
1,902 Posts
MYOB Moderator
MYOB Moderator

1,902Posts

215Kudos

216Solutions

Re: Customise Items Re-Order Report

Hi @PF_1 

 

Thanks for your post. I hope you're finding plenty of useful tips, advice and support on the community forum. 

 

There are multiple sales reports you can look into to see which would fit your needs.  See the linked help article for descriptions of each.  Within the reports some allow for additional information to show/hide. You can find this in the report by going to Insert/Modify >> Show/Hide >> Make selections.  I'll link Customising reports for additional reference. 

 

Let me know how it goes. If this answers your post please mark 'Accept as Solution' to help other users find this post easier. 

Cheers,
Theresa

MYOB Community Support

Online Help| Forum Search| my.MYOB| Download Page

Did my answer help?

Mark it as a SolutionHelpful? Leave a to tell others

Contributing Cover User
17 Posts
Contributing Cover User
Australia
Contributing Cover User

17Posts

0Kudos

0Solutions

Re: Customise Items Re-Order Report

Hi Theesa

Thanks for your message.  We would like to use this for Inventory management.  Insert/Modify options are not enough at this stage.  I will have to customise the report.  I will have a look at your link, thanks.

Highlighted
MYOB Moderator
1,902 Posts
MYOB Moderator
MYOB Moderator

1,902Posts

215Kudos

216Solutions

Re: Customise Items Re-Order Report

Hi @PF_1 

 

No worries, I hope the links assist in explaining the options within AccountRight.  If you decide that you would like additional Inventory capabilities there may be an add-on to assist. 

 

 

Cheers,
Theresa

MYOB Community Support

Online Help| Forum Search| my.MYOB| Download Page

Did my answer help?

Mark it as a SolutionHelpful? Leave a to tell others

Didn't find your answer here?

Try using advanced search to find a post more easily Advanced Search
or
Get the conversation started and make a new post Start a Post