FrontAccounting forum — Report for items purchased (sorted/totaled by supplier)

Re: Report for items purchased (sorted/totaled by supplier)

2013-03-05T15:05:46Z

Make sure that there is enough space in the reports (forced / default landscape?) and what fields can be dispensed with and list the mockup screenshot.

Re: Report for items purchased (sorted/totaled by supplier)

2013-03-05T08:46:20Z

Quite useful. Two questions:

a) Is there a way to have it display the line item descriptions? (right now each line shows the suppliers reference)
b) I could badly use a report that shows purchase orders (open or closed) as we regularly need to run PO reports of all PO's with suppliers (even ones not delivered yet). Is there a way to use to report and modify it to show PO's only instead of supplier invoices?

Re: Report for items purchased (sorted/totaled by supplier)

2013-01-14T17:31:02Z

joe wrote:

Done.
I guess we are done with this topic now.
/Joe

Looks like it. Thanks, guys, for all your effort in getting the new report working!

Regards,

Chris

Re: Report for items purchased (sorted/totaled by supplier)

2013-01-14T13:04:20Z

Thanks Joe, Mer Build 3136 fixes the login company field width.

Re: Report for items purchased (sorted/totaled by supplier)

2013-01-14T12:42:16Z

Done.

I guess we are done with this topic now.

/Joe

Re: Report for items purchased (sorted/totaled by supplier)

2013-01-14T10:54:22Z

Yes, Joe, the fields can be spaced out intelligently - no need to scale columns like ID, Amount, and restrict scaling up from portrait to Landscape only for text fields

Also for Chris instance where his company name is quite long, the 30 character limit may not suffice - needs to be extended in atleast 2 files (for the non select textbox method as well):

access/login.inc -> Line 110
admin/create_coy.php Line 336
make maxlength from 30 to 50 atleast

Re: Report for items purchased (sorted/totaled by supplier)

2013-01-14T08:52:35Z

As they stand now, some of the standard reports are difficult to read because they're in portrait mode and the columns are packed close together. Also, data for some fields gets cut off in order to fit in the space allowed on the report for that column. So, for instance, in the GL Account Transactions report when it is printed in portrait mode for the Person/Item column for a particular inventory item purchase transaction I get this:

"Party Empire/883"

I can see by looking at that line that I bought something from "Party Empire" with a stock number starting with "883" but that vendor sells a number of items that start with "883" so I can't tell what the item is.

Now, when I flip the report to landscape mode and print the same report again, I get this in the Person/Item column:

"Party Empire/88348"

I can now see the full item number of the item, and I can tell exactly what I bought.

So, as I said earlier, having the ability to print certain reports in landscape mode instead of portrait mode would be very handy. However, if the developers have more important things to deal with I can certainly create my own custom reports in landscape mode now that I know how to do it. It's a bit of mucking around on my part, but it's no big deal.

So, I throw it back to you, Joe... this feature would be very handy, but does the development team have the time/resources to do it?

I'll live with whatever is ultimately decided. Thanks for asking my opinion!

Regards,

Chris

Re: Report for items purchased (sorted/totaled by supplier)

2013-01-14T07:43:46Z

The paper sizes should not be selectable in the form. This is set in the Display Setup / Preferences.

However one solution could be so have a selector for the portrait/landscape mode (just before the destination selector).

If landscape is chosen, then the column starts could just be recalculated accordingly to the new paper width.

If the report from the beginning is in landscape (custom report), then this portrait/landscape selector should not be there.

We could try to adapt this in the upcoming release 2.4, due to that all the reports have to be changed.

What do you say, guys?

/Joe

Re: Report for items purchased (sorted/totaled by supplier)

2013-01-14T00:27:37Z

You totally lost me there, fella! But, if the developers can do it easily and want to do it I'll sure as heck use it!

Regards,

Chris

Re: Report for items purchased (sorted/totaled by supplier)

2013-01-14T00:18:11Z

It is possibly easier than it appears.

The form input page can have a dropdown of various paper sizes - A4, Letter, etc.

The reports can remain the existing repXXX.php - no duplication is required.

The horizontal layout of the report for each page size for heading and detail can have their numbers in arrays - one of which is chosen based on the flag taken from form input data. In all other cases, where separate arrays are not available for different page sizes, the Landscape should be the same as the Portrait except that the longest field if any may be expanded to fill the slack space.

The Vertical Layout remains the same as long as the headers and detail elements add from the top and the footer elements subtract from the bottom and the page size determines the number of lines inbetween - that is all automatic in tcpdf used.

Re: Report for items purchased (sorted/totaled by supplier)

2013-01-13T23:51:33Z

@apmuthu:

Having the ability to select whether a report prints in portrait or landscape mode when printing reports would be a great feature, but implementing it would require quite a bit of work. Aside from coding the repot selection screens, all reports would have to be copied and modified so that each report had both a portrait and landscape reportXXX.php file. My guess is that the developers have plenty of other things to keep them busy. So, I don't think this is going to happen any time soon.

Anyway, I don't know if my changes will work with A4 paper or not. I haven't even printed it on letter size... I just looked at the screen layout. I suppose I should do that, but I have something else I have to do right now so that has to wait.

Regards,

Chris

Re: Report for items purchased (sorted/totaled by supplier)

2013-01-13T22:43:16Z

Joe, this can be accommodated using a flag in the form data input - Report Mode -> Portrait / Landscape.
Also hope the numbers pertain to A4 as well.

Re: Report for items purchased (sorted/totaled by supplier)

2013-01-13T20:24:38Z

Okay, Joe. I didn't realize that core reports must be in portrait mode. How about if I submit it as an extension? Would that be okay? If so, can you give me (or point me to) instructions for submitting extensions?

In the meantime, for those who want this report in landscape mode, save a backup copy of rep306.php so you can get back to normal if something screws up. Then, change line 137 to this:

    $cols = array(0, 80, 260, 325, 375, 520, 540, 605,    680);

And change line 152 to this:

    $rep = new FrontReport(_('Inventory Purchasing Report'), "InventoryPurchasingReport", user_pagesize(), '10' , 'L');

(Disclaimer: If you break something, you own all of the pieces! )

Enjoy!

Regards,

Chris

Re: Report for items purchased (sorted/totaled by supplier)

2013-01-13T20:12:35Z

Just hold it a bit, Chris. We try to keep all core reports in portrait mode. I understand that certain reports would benefit from being in landscape. You could probably just show the different lines, so other users can correct this for themselves if they need it.

Remember to make a backup of your own report, so you can restore it when updating to a new release.

Joe

Re: Report for items purchased (sorted/totaled by supplier)

2013-01-13T19:29:26Z

No problem, Joe. This report is going to be great for me in analysing my purchasing practices, so thanks to you for creating it and helping me get it working right!

Btw, I did some mucking around with the working rep306.php (shame on me!) and have managed to flip it to landscape mode and spread-out the columns so that the report is more readable. Would you like it? If so, do you want me to e-mail it to you, or can you give me upload privileges and I'll post it here?

Thanks, again, for all your help!

Regards,

Chris