Vendor Report Issue
Posted: January 30th, 2012, 7:01 pmIs there any way to get a Vendor Report out of C21 that just has the vendor number and name?
You can customize mailing labels to show the vendor ID, remove the address if you like, change the number of rows and columns per page, etc, using the Report Customizer. The following are notes regarding the customizer:
This process will require a little experimenting and/or hand calculations to align the data properly.
There are three vertical guides that come into play:
Another 'vertical control', it to change the “number of rows”. The printing will do a page break after every n'th row. You can either experiment or calculate it out based on v_row2minusv_row1 size and top margin and paper size etc.
An alternative is to look at the apledger.sel file in the company folder(do not modify). This has special information at the end of the lines that is probably meaningless. However, it is a nice one-liner of ID and Name.
You can customize mailing labels to show the vendor ID, remove the address if you like, change the number of rows and columns per page, etc, using the Report Customizer. The following are notes regarding the customizer:
This process will require a little experimenting and/or hand calculations to align the data properly.
There are three vertical guides that come into play:
- @v_heading- to control the overall top margin.
- @v_row1- to control where the first line starts relative to the top margin.
- @v_row2- to control the vertical size of each label. In this particular case, it will be line height or line spacing. Just drag this or enter a position that puts this right underneath the first ID/Name pair line.
Another 'vertical control', it to change the “number of rows”. The printing will do a page break after every n'th row. You can either experiment or calculate it out based on v_row2minusv_row1 size and top margin and paper size etc.
An alternative is to look at the apledger.sel file in the company folder(do not modify). This has special information at the end of the lines that is probably meaningless. However, it is a nice one-liner of ID and Name.