Example of using Custom Fields for items used in invoices and have them displaying in reports

Data RecData Rec Reckon Staff Posts: 816 ✭✭
edited December 2016 in Accounts Business Range
For Reckon Accounts Business range (desktop/hosted).

The screenshots below are from a reply by Donna Barletta to another related post 

https://community.reckon.com/reckon/topics/column-item-not-appearing-in-sales-report



--------------------------------------------------------------------------------------------------------------------


1. go to a stock line, make a custom field Batch and tick.

image

image
After you click OK,  you'll see the menu - don't enter anything in the field, just click OK.

image

Go to the home screen, and click on invoice.
On the Tab bar above create Invoice you'll see a customise button.

image

Click on Manage Templates, and select the invoice template that you use,
Then click OK
Click on Additional customisation down the bottom

image

Then click on the columns tab at the Top.  Click both boxes for Screen and Print beside Batch.
The Order Numbers are where you'd like that column to appear on the invoices from left to right.  So you can change these numbers around to suit yourself.  Then click OK.  

#you may get a error message after this telling you that the fields are overlapping  (you shouldn't, but you might if you're working on other fields).  If you do, just go into layout designer and move the lines around until the fields aren't overlapping any more. 

image

Then, create an invoice using this same invoice that you just customised, and put in your batch numbers.

Then when you want to create a report, select the report you want, then select modify up the top

image

And this menu appears.  Go through the Columns until you find Batch, and click on it.
this will give you the report and will show all the batch numbers beside each entry.
If you'd like to do this same report, but just for items in batch 3, Select Filters tab at the top,
Then on the left you'll find a Filter list - go through that until you find Batch, and then type in the batch number you want in the Batch field and press OK.
Memorise the report - so all these selections are saved and you won't need to set it up again.

image

Thanks to Donna Barletta for her clear explanation.

--------------------------------------------------------------------------------------------------------------------

For information regarding custom fields, please use the built-in product documentation. 

Click on the Help menu and select Reckon Accounts Help

The keywords custom fields will show the relevant info.
* Data Recovery Team *

Regards,

Reckon Data Recovery Team

You can request assistance via the case request web form below.

https://www.reckon.com/au/data-services-request/

Comments

  • KarenKaren Member Posts: 42
    edited April 2015
    Best help from Donna, so grateful!

Sign In or Register to comment.