Denver Research
General Category => ezPower => Topic started by: yvanchartrand on November 07, 2013, 11:36:22 AM
-
Hi Ronald,
When I access Sold Products Detail in the Report Center all records are grouped by the serial #and the serial # itself is on a separate line. This makes importing into a database impossible. How do I get rid of the serial # grouping?
Conversely, when I access Sold Products by Serial # I get a blank report regardless of the timeline I input. Thanks for your help.
Here is what I get with Sold Products Detail, don't want or need the serial # even though I have not chosen to have the serial # in the fields dialog.
Department Category Date Description Sold Price Total Tax
# 24112
BAKERY Yeasted 07/11/2013 Bagels 4 1.25 5.00 0.00
# 24113
BAKERY Sourdough 07/11/2013 Raisin-Walnut 1 5.50 5.50 0.00
BAKERY Sweet 07/11/2013 Brioche Chocolate 1 2.40 2.40 0.00
-
That is the Invoice# of the sale. The items that follow are what was sold in that sale. There's no option to remove the Invoice#
-
I will certainly not disagree with Ronald, as I certainly haven't been able to find any way to leave the invoice numbers out of the Product Detail Report. If you're willing and able to work with spreadsheets, though, there is a way to approach this outside the program. This is the part I especially like about EZP - you have a lot of different ways of working with the data, rather than it all being locked down as it is in most other software. But it does require some experience with spreadsheets.
I generate a Product Detail Report every month to find out what to pay our consignors. I generate the report and "save" it (it will save in .txt format). Then, using a program like Excel, I open the file, and a "text conversion wizard" pops up to do the conversion. Once converted, you'll see that the invoice numbers are all on separate lines than the rest of the data. So then I'll sort the entire report by date, which results in the entire upper half of the report being data I'm interested in, and the lower half all being lines of invoice numbers. Then I just delete all the lines of invoice numbers - all at one time. Then I'm left with nothing but lines of data I use for my final report, and can sort everything by whatever I want - by Product Description, Vendor, Price, or anything else - with nothing else to get in the way.
Again, I'm not disagreeing with Ronald in the least. But there are workarounds if you're willing to go a few extra steps. And for all the other things EZP does for us, this particular workaround is very minor.
-
That's an excellent method. You can also use the Copy button instead of saving the report to a text file. Then open Excel and do a paste.