Canon imagePROGRAF GP-300 Guide for Accounting Manage - Page 54

Exporting Cost Tabulation Results to CSV File

Get Canon imagePROGRAF GP-300 PDF manuals and user guides View all Canon imagePROGRAF GP-300 manuals
Add to My Manuals
Save this manual to your list of manuals

Page 54 highlights

Exporting Cost Tabulation Results to CSV File You can export cost tabulation results to a file in CSV format. You can use this file when you want to perform detailed analysis using tools such as spreadsheet software. You can export the cost tabulation results to a CSV file by clicking the Export button in the Cost Tabulation dialog box. 1. Open Cost Tabulation dialog box. Select Cost Tabulation in Job Cost from the File menu to open the Cost Tabulation dialog box. 2. Set tabulation criteria. Specify the Printer, Period, and Account ID/Department (Account ID2)/Owner for cost tabulation. 3. Click the Tabulate button. The cost tabulation results appear. Note • Clicking the Cancel button in the progress screen that displays the processing progress cancels acquisition and tabulation and displays blank tabulation results. • If there is even one record in the tabulation target for which a cost cannot be calculated, because the unit cost is not set, "Cannot calculate the values to be tabulated because a unit cost has not been set." appears. • If an overflow of records for a tabulation target has occurred, "Cannot calculate the values to be tabulated because a unit cost has not been set." also appears. 54

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
  • 49
  • 50
  • 51
  • 52
  • 53
  • 54
  • 55
  • 56
  • 57
  • 58
  • 59
  • 60
  • 61
  • 62
  • 63
  • 64
  • 65
  • 66
  • 67
  • 68
  • 69
  • 70
  • 71
  • 72
  • 73
  • 74
  • 75
  • 76
  • 77
  • 78
  • 79
  • 80
  • 81
  • 82
  • 83
  • 84
  • 85
  • 86
  • 87
  • 88
  • 89
  • 90
  • 91
  • 92
  • 93
  • 94
  • 95
  • 96
  • 97
  • 98
  • 99
  • 100
  • 101
  • 102
Exporting Cost Tabulation Results to CSV File
You can export cost tabulation results to a file in CSV format. You can use this file when you want to
perform detailed analysis using tools such as spreadsheet software.
You can export the cost tabulation results to a CSV file by clicking the
Export
button in the
Cost Tabulation
dialog box.
1.
Open
Cost Tabulation
dialog box.
1.
Select
Cost Tabulation
in
Job Cost
from the
File
menu to open the
Cost Tabulation
dialog box.
2.
Set tabulation criteria.
2.
Specify the
Printer
,
Period
, and
Account ID
/
Department (Account ID2)
/
Owner
for cost tabulation.
3.
Click the
Tabulate
button.
3.
The cost tabulation results appear.
Note
•
Clicking the
Cancel
button in the progress screen that displays the processing progress cancels
•
acquisition and tabulation and displays blank tabulation results.
•
If there is even one record in the tabulation target for which a cost cannot be calculated, because
•
the unit cost is not set, "
Cannot calculate the values to be tabulated because a unit cost has
not been set.
" appears.
•
If an overflow of records for a tabulation target has occurred, "
Cannot calculate the values to be
•
tabulated because a unit cost has not been set.
" also appears.
54