Report for items purchased (sorted/totaled by supplier) (Page 1 of 2)

This seems to be a good report, I will include it in core FA to next minor.

/Joe

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.

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

I downloaded the new rep306.php1 and put it on the server (after renaming the original one).  Still no data.  (SIGH!)

Regards,

Chris

@Chris

Regarding the Wiki, you must login before editing. You can use the same credentials as you use for this forum.

/Joe

Please note that both Inventory Planning Report and Inventory Purchasing Report use the Alt-P keyboard shortcut in the current codebase as of Mercurial Build 3133.

Also the report details exceed the headings on the right side. Attached screenshot.

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

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

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

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

@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