Personal tools

Difference between revisions of "23 Load Values"

From TrueERP wiki

Jump to: navigation, search
(Created page with "Load Values How do you load values back into the grid? One advantage of the attribute grid is the ability to import individual prices for each product in the grid as a single b...")
 
m
 
Line 1: Line 1:
Load Values
+
'''Load Values'''
  
How do you load values back into the grid?
+
How do you load values back into the grid?  
  
One advantage of the attribute grid is the ability to import individual prices for each product in the grid as a single block.
+
One advantage of the attribute grid is the ability to import individual prices for each product in the grid as a single block.  
  
How to load values
 
  
Select Inventory tab
+
 
Select Products Attributes Button  
+
'''How to load values'''
Double click the desired product group
+
 
Select Import_Values tab
+
*Select '''Inventory tab'''
Select the Import Type (Cost or Price)  
+
*Select '''Products Attributes '''Button  
Select the Type (Inc or Ex)
+
*'''Double click '''the desired product group  
Open a your spreadsheet where you entered the values to be loaded
+
*Select '''Import_Values '''tab  
Select the entire grid within the spreadsheet, right click and Copy
+
*Select the'''Import Type '''(Cost or Price)  
Select the top left field of the grid in the Import Values screen. right click and Paste
+
*Select the '''Type '''(Inc or Ex) Open a your spreadsheet where you entered the values to be loaded  
Select Update button
+
*Select the '''entire grid '''within the spreadsheet,  
 +
*'''Right click and Copy'''
 +
*Select the top left field of the grid in the Import Values screen.  
 +
*right click and Paste  
 +
*Select '''Update''' button

Latest revision as of 08:46, 16 November 2011

Load Values

How do you load values back into the grid?

One advantage of the attribute grid is the ability to import individual prices for each product in the grid as a single block.


How to load values

  • Select Inventory tab
  • Select Products Attributes Button
  • Double click the desired product group
  • Select Import_Values tab
  • Select theImport Type (Cost or Price)
  • Select the Type (Inc or Ex) Open a your spreadsheet where you entered the values to be loaded
  • Select the entire grid within the spreadsheet,
  • Right click and Copy
  • Select the top left field of the grid in the Import Values screen.
  • right click and Paste
  • Select Update button