Forum Discussion

Royc1's avatar
Royc1
User
3 years ago
Solved

Customise Invoice form with hours column and total hours

Hi, I am customising a professional invoice and am seeking how i can add a column for "hours" with a total-hours at end of column. Now because "hours" does not exist as a column option I have used "j...
add column
add new total
customise
invoice
  • Steven_M's avatar
    Steven_M
    3 years ago

    Hi Royc1 

     

    Sorry to see that no-one has offered assistance with your query. This is a Community driven Forum so while MYOB does offer assistance and moderate this space there are times when you may not receive an MYOB reply.

     

    In saying that, the sale layout used for invoices would determine the customise form that is used. For example, if the professional customise form is used then you would need to use a professional customise form to print/email that invoice out. The Professional layout will not have a hours/quantity column you would not be able to have a total hours value.

     

    This is a similar thing with the Item layout, as that doesn't have a date column you would not be able to showcase that date. In saying that you could get around this, by adding the date onto the invoice inside a header line (Edit>>Insert Header Line). This would allow you to enter a description without needing to select an account/item. For example:

     

    Alternatively, you could look at using a Time Billing layout*. This would allow you to have a date as well as a quantity/hours to which can have a total on the invoice.

     

    *Note: A Time Billing layout would be a feature of AccountRight Plus and Premier.

Steven_M's avatar
Steven_M
Former Staff
3 years ago

Hi Royc1 

 

Sorry to see that no-one has offered assistance with your query. This is a Community driven Forum so while MYOB does offer assistance and moderate this space there are times when you may not receive an MYOB reply.

 

In saying that, the sale layout used for invoices would determine the customise form that is used. For example, if the professional customise form is used then you would need to use a professional customise form to print/email that invoice out. The Professional layout will not have a hours/quantity column you would not be able to have a total hours value.

 

This is a similar thing with the Item layout, as that doesn't have a date column you would not be able to showcase that date. In saying that you could get around this, by adding the date onto the invoice inside a header line (Edit>>Insert Header Line). This would allow you to enter a description without needing to select an account/item. For example:

 

Alternatively, you could look at using a Time Billing layout*. This would allow you to have a date as well as a quantity/hours to which can have a total on the invoice.

 

*Note: A Time Billing layout would be a feature of AccountRight Plus and Premier.

  • Royc1's avatar
    Royc1
    User
    3 years ago

    That you very much for your reply Stephen. Your work around looks good, except I have 39 lines to enter and that would mean two lines for every detail item thus forcing me onto two pages. I dont have the Accountsright plus version so i cannot see the time billing invoice. your reply is still good so i am going to mark it "foundsolution"

    However could you please add my comment somewhere that the "RefDate" field be added to the "item" invoice field options in upcomming versions.

    • Royc1's avatar
      Royc1
      User
      3 years ago

      Thought I would add a sample invoice trying to explain how I got the columns

    • Steven_M's avatar
      Steven_M
      Former Staff
      3 years ago

      Hi Royc1 

       

      Given that the time billing layout does all achieve that reference date and would allow items to be added (enabling Preferences>>System -- I Include Items on Time Billing Invoices) this would be an area that would be hard to get across the line for the item layout. However, nonetheless, I have added a note on your account that you would like to see that date added to the Item layout invoices in AccountRight.