Search options (Page 5 of 6)

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

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

@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

Actually, my problem was that I had put an expense code in the "Purchase Account" field when I set-up the supplier.  That field should be set to "Use Item C.O.G.S./Inventory Account" so that FA will pick-up that value from the item instead of posting to the default in the "Purchase Account" field.

I Wikied it in the Help.Items section.

Thanks, Joe, for pointing me in the right direction!

Regards,

Chris

Thanks to some behind-the-scenes back and forth between Joe and myself, rep306.php now works flawlessly on my system.  The report now correctly shows the data, and is quite usable in its present format although I have suggested it be flipped to landscape mode to make it a bit less cluttered and more readable.

Thanks, Joe, for your help in getting the report working!  You're the man!

Regards,

Chris

Hi, apmuthu!

Your point about the link in a printed report not being click-able is well taken.  However, with such a long URL it's a bit doubtful someone is going to type it all in manually, especially since it contains special characters (e.g. "&" for field parameters and "%40" instead of "@").  So, getting rid of all that, even though it means someone who prints the report can't type it, probably isn't that big a deal.

Anyway, I tried making the changes you suggested above and now neither the word "PayPal" nor the long URL are click-able, although the URL is blue instead of black.  If you PM me your e-mail address, I can e-mail you a PDF'ed invoice to look at (I don't want to post one online.)

***
EDIT:  Actually, the payment link now looks like this (and is unclickable):

<a href='https://www.paypal.com/xclick/business=chris%40crazychris.ca&item_name=INVOICE+146&amount=24.30&currency_code=CAD'>Payment Link</a>

In other words, it's printing out the whole URL, not just "Payment Link".
***

Thanks, again, for your help!

Regards,

Chris

P.S.  I sent you a PM about accessing my system.  I hope you got it?

Hi, guys!

@joe:

I cleared the browser cache and tried again...  still no luck.  Also, the items have been invoiced by the supplier, and the supplier has been paid.  Finally, my test report was for the full fiscal year so the purchases must have been in the reporting period.

Regarding the wiki, I was logged in at the time, so I'm not sure why it didn't display my edits even though I was able to click on the edit button and do the edit  Oh well...  doesn't matter...  I see someone else has added it.

@apmuthu:

I'm not sure what you mean by the Alt-P keyboard shortcut as I'm not use the Mercurial build, but I wanted to let you know that the headings on the right side are fine here, I'm just not getting any data.

@both:

I was looking at the report306.php1 file, particularly the section that generates the SQL query.  My SQL knowledge is limited, but I did notice that the section is hitting the stock_moves table.  When I go into myPHPadmin and look at stock_moves, all I see are items that have an item type of "service."  There aren't any items in there of item type "purchased."  This seems very strange to me as I thought that "service" items aren't tracked in inventory so why would those transactions be in there but "purchased" items aren't???

Am I right here?  And, if so, is the pointing to my having another problem somewhere???  Btw, when I try to run the Stock Movement report I get the progress bar at the top of the screen for a few seconds and then nothing, not even an empty report in the pdf viewer.

Thanks, again, for your help in looking into this.

Regards,

Chris

I don't see a way of adding an attachment to this message (maybe I don't have privileges?), so here's a link for you:

https://www.crazychris.ca/screenshot-1.png

Hope that helps...

Regards,

Chris

UPDATE:

I have entered two supplier purchases of inventory items.  The GL shows the transactions posted to inventory.  However, when I run the new report I get the headers but no data.  The Inventory Valuation Report shows the correct items, amounts and values.

Something in the new report is broken.  (SIGH!)

Regards,

Chris

Yes, I'm still getting the warning, and I can verify what I'm doing by looking at the summary list again, but looking at that list can be a bit non-intuitive if the list is long.

Selecting from the pop-up screen and having FA fill-in the field is much more intuitive, IMHO.  I like how FA does that in the Direct Invoice function, so I thought it would be useful for voiding transactions, too.

When I'm using the Void a Transaction screen, all I'm looking at is a reference number.  If the screen had a bit more detail, like adding a description field (customer/supplier/item/whatever), that would make it more intuitive.  However, in my non-programmer mind implementing that probably wouldn't be easy so I thought adding a "select" button to the pop-up screen would be easier  Was I wrong about that?

Anyway, this isn't a "make-or-break" issue for me.  I'm sure as I'm use FA more I'll get used to the Void a Transaction function and will make fewer errors.

Thanks for considering my suggestion and responding, no matter what's decided.

Regards,

Chris

WOO HOO!!!

I have managed a large purchasing department, and this report is *very* handy in analysing purchase history.  Using it, I can quickly see which supplier is giving me the best price, track price changes over time, see how much business I'm giving to a supplier, and so forth.  By adding this, you folks have just increased the purchasing module's functionality by 100%...  thanks!

I installed the changed files (backing up the originals, first, of course!), and took a look at what you've done.  Unfortunately, I haven't yet entered any item purchases yet (I'm still entering my sales), so all I can see right now is the basic layout.  The reporting screen looks *perfect* but I'd suggest flipping the printout to landscape mode as some of the fields are pretty long (e.g. description and supplier) so having more horizontal room might avoid having lines wrap.  Other than that, though, it looks just about perfect!

Thanks SO much for doing that!  I'll let you know what I think once I've entered a few purchases and can look at a "real" report.

I'm sooooooo proud of myself...  I actually contributed something to the FA project! 

Regards,

Chris

P.S.  Personally, I'd leave it in FA core.  Anyone who's doing serious purchasing is going to want this kind of report, IMHO.