steps to create and run macro to transfer items in gp from ...€¦  · web viewopen the recorded...

1 | P a g e

Steps to Create and Run macro to transfer Items in GP from QtyReturned to OnHand This document contains instructions to Create and Run macro to transfer Items in GP.

Njevity

2 | P a g e

ContentsNo table of contents entries found.

3 | P a g e

Steps: Record the steps in macro.

4 | P a g e

Save the macro at desired location with .mac extension.

5 | P a g e

Fill the highlighted fields and after clicking on UOM tab click on Quantity Type button.

6 | P a g e

Change its type From Returned to On Hand as shown below.

7 | P a g e

Press Tab button to fill the shown information and place the cursor to next line.

8 | P a g e

Stop the recording.

9 | P a g e

Open the recorded macro in a word document and select Mailings tab from Menu Bar, then select Start Mail Merge option and click on Letters.

10 | P a g e

Click No, if below shown Pop-up appears.

11 | P a g e

Now, select Use existing list option from the Menu Bar (Select the appropriate Excel file that contains Items to transfer).

In the header click on Insert Merge Field and select required fields at appropriate positions in file.

12 | P a g e

13 | P a g e

One can also see its results in Preview results window.

14 | P a g e

Click on Finish and merge and select Edit Individual Documents.

15 | P a g e

16 | P a g e

Save this as .mac file. Play it and do not click anywhere while macro is running. When macro stops transferring the items, Save the recorded macro batch and Proof the total with file.