Difference between revisions of "How do I output information from list boxes?"

From Catalyst
Jump to: navigation, search
(Bulk update)
Line 4: Line 4:
 
Many screens in Platinum are in the format of a ''' List Box''' e.g. {{Menu|Add or Edit Stock Items}}, {{Menu|Add/Edit/Process Purchase Orders}}, {{Menu|Nominal Review}} or {{Menu|Unit Sales Documents}}.
 
Many screens in Platinum are in the format of a ''' List Box''' e.g. {{Menu|Add or Edit Stock Items}}, {{Menu|Add/Edit/Process Purchase Orders}}, {{Menu|Nominal Review}} or {{Menu|Unit Sales Documents}}.
  
Each of these screens has the option to output the display to a printer or to create an Excel or CSV file.  
+
Each of these screens has the option to output the display to a printer or to create an Excel or CSV file.
  
 
== More Information ==
 
== More Information ==
When the data is on screen press {{KeyPress|C-P}}.  
+
When the data is on screen press {{KeyPress|C-P}}.
 
* Select either {{Button|Print}}, {{Button|Excel}} or {{Button|CSV}}.
 
* Select either {{Button|Print}}, {{Button|Excel}} or {{Button|CSV}}.
 
* If you choose to create a file, Platinum will default to saving the file in {{FilePath|P:\SX\SXICONS\OUTPUT}}. You may override this and save to a different location if you wish.
 
* If you choose to create a file, Platinum will default to saving the file in {{FilePath|P:\SX\SXICONS\OUTPUT}}. You may override this and save to a different location if you wish.

Revision as of 05:30, 2 April 2019

Summary

Many screens in Platinum are in the format of a List Box e.g. " Add or Edit Stock Items", " Add/Edit/Process Purchase Orders", " Nominal Review" or " Unit Sales Documents".

Each of these screens has the option to output the display to a printer or to create an Excel or CSV file.

More Information

When the data is on screen press <Ctrl+P>.

  • Select either [Print], [Excel] or [CSV].
  • If you choose to create a file, Platinum will default to saving the file in 'P:\SX\SXICONS\OUTPUT'. You may override this and save to a different location if you wish.
Platinum will attempt to open an Excel or CSV file for you using the most suitable program i.e. Excel or Notepad.
If your PC does not choose the most sensible option you may need to manually open the file. To do this start your spreadsheet software and open the file from the default location or location you selected.

See also