Need Export of Items Sold per Bill

[AM SD]

Hi I would like to get an export of all items per bill no and date. Can you please let me know how is this possible ? Thanks.

[elk]

Hi,

Please be informed that  Copper's reporting ability can be used as a valuable performance analysis tool. To access Copper's reports, click on the Reports button on the main window toolbar. Then, select the menu item for the report you wish to view. You will then be asked to select a report category and to provide a date range for the reporting period.

Copper provides the following reports for both sales and refunds categories:

*Transactions - View all transactions within the selected reporting period, including salesperson and amount.
*Salespeople - View total sales made or refunds processed by each salesperson within the selected reporting period, including percentage by totals for each salesperson.
*Items - View the total quantity of each item sold or refunded within the selected reporting period, including total values for each item. The item values do not take into account coupon discounts or taxes.
*Taxes - View the total taxes of different types applied on transactions within the selected reporting period.
*Payment Methods - View the report of payment methods of different types (such as cash, check, credit, etc.) applied on transactions within the selected reporting period.

Each reporting screen provides the following actions:

*Preview - Preview the report to see how it will be printed.
*Print - Send the report to a printer.
*Save as PDF - Save the report as a PDF file.
*Save as CSV - Save the report as a CSV file, which can be opened in a spreadsheet application.
*Email - Send the report as a PDF file to a recipient via email. You must set up email settings from the General tab in Options before you can send email from Copper.
*Fax - Send the report to a recipient via Fax. You must set up fax settings from the General tab in Options before you can send faxes from Copper.

Regards

[AM SD]

Hi Elk many thanks for your reply. But I still have the issue. I need report which gives me Items per transaction for a certain number of days. I tried to look at other reports but they dont give details of Transactions. Rather just bill no and date with amount. I need date, bill no., items in each transaction. I can see in transactions folder that it creates .dat files for each bill no. but there's no option to merge them all and have a look. 

[AM SD]

Hi Guys really appreciate if you can please help me with my query above. 

[Telephony]

Hi,

Copper does not include a report that displays Items per transaction for a certain number of days, but you can run the Transactions report and save it as a .CSV file, and then run the Items report and do the same, this allows to place the data on an Excel sheet. 

Regards, 

 

[AM SD]

Hi Telephony

Thanks for your reply. I agree that's possible separately and then place the data in excel sheet but how will you know which item was sold on what date?

[Chris75]

Hello AM SD, sadly as Telephony stated this program does not have a report that will fit your needs, and the workaround offered does not really get you all the details linked as you already figured. I don't believe it would be possible to get the data you request from Copper.