15045 Copy As Spreadsheet To Clipboard in Stock Documents

Top  Previous  Next

(From version 1.5.045 onwards.)

 

“Copy as Spreadsheet Format to Clipboard”, now available in the following Stock documents.
 

a) Stock Adjustment

b) Stock Issue

c) Stock Receive

d) Stock Transfer

e) Stock UOM Conversion

f) Stock Update Cost

g) Stock Write-Off

h) Stock Assembly, and

i) Stock Assembly Order.

 

 

How to copy to Excel ?

 

Open/View/Edit a document, e.g. Stock Adjustment:

Go to Edit > Copy as Spreadsheet Format To Clipboard

 
    clip0205

   

clip0206

 

Click on OK and proceed to open a spreadsheet (MS Excel) blank sheet, and Paste (Ctrl + V):
 

 

clip0207

 

 

 

You may then modify the spreadsheet (adding new or modify detail row), highlight the detail portion, then Copy (Ctrl + C)...

 

clip0208

 

 

And go back to the Stock Adjustment document, and Paste the detail (Edit > Paste Item Detail only From Clipboard)

 

clip0209

 

The outcome will look like this:

 

 

clip0210

 

 

 

 

 

 

 

_____________________________________________________________

Send feedback about this topic to AutoCount. peter@autocountSoft.com

© 2013 Auto Count Sdn Bhd - Peter Tan. All rights reserved.