Macro To Make A Microsoft Dynamics Great Plains (GP) Macro :)

[fiberboysa]

Hi All,
Well my need is quite unique because I want a macro to make another macro which will run on Microsoft Dynamics Great Plains. I will be brief to explain but if you want more info please let me know

Please consider the following example for explanation...

S. No.	Voucher No	Job Number	Amount
1	3556	A	2500
2	3556	A	2500
3	3556	B	1000
4	3556	B	2000
5	3556	C	2000

<tbody>
</tbody>

I need a macro that can calculate the Total Amount from Amount column above when Voucher No. is same and then distribute them to 3 amounts separately on basis of Job Number column.

I use Mail Merge to do this work now but now I wish that it should be more automated. Please see these mail merge files which I currently use. Click Here To Download.

Now please select all text and Toggle Filed Codes and refer to the highlighted text in Word file downloaded from above link. Here Yellow text will be repeated until the amount is equal to total sum of one Voucher No. Highlighted in Green. In other words, The Yellow highlighted text will be repeated until Green highlighted text is equal to the sum of Cyan highlighted text.

This is complex for me but it should be simple for a programmer . I will try to explain it with a video as well if possible. Thanks in advance.

 

[oldbrewer]

S. No.	Voucher No	Job Number	Amount
1	3556	A	2500
2	3556	A	2500
3	3556	B	1000
4	3556	B	2000
5	3556	C	2000
6	3557	D	1577						A	B	C	D	E	F	G	H
7	3557	D	1611					3556	5000	3000	2000	0	0	0	0	0
8	3557	E	1645					3557	0	0	0	3188	3324	1713	0	0
9	3557	E	1679					3558	0	0	0	0	0	1747	3596	3732
10	3557	F	1713														27300
11	3558	F	1747
12	3558	G	1781
13	3558	G	1815
14	3558	H	1849
15	3558	H	1883
				27300				IT IS VERY EASY TO EXTRACT THE TOTALS
								can you give more info on what you want please

<colgroup><col width="64" span="19" style="width:48pt"> </colgroup><tbody>
</tbody>

 

[fiberboysa]

Thanks for your reply
I will make a video to explain what i want and than share it with you to tell u what i want. Please give me time till this weekend. Thanks again!

 

[oldbrewer]

you cannot post videos on here and I and many others never download

explain it using a simple spreadsheet

 

[fiberboysa]

It will be just 2 - 3 min video not long. Actually I need to show you the flow of data to explain what i need. If not i will use images.

 

[oldbrewer]

use my post #2 to further define what you want

and then distribute them to 3 amounts separately on basis of Job Number column. THIS IS WHAT I DO NOT UNDERSTAND

guessing - you want to end up with 3556 A 5000

 

[fiberboysa]

I have sent you the video. Please have a look and let me know if you have got what i want. Thanks!

 

[oldbrewer]

there are 100's of people on here who want to help you - read my post #6 again

 

[fiberboysa]

I am glad to know that
The thing I said in "and then distribute them to 3 amounts separately on basis of Job Number column" is that yellow highlighted text in MS Word file should repeat itself 3 times for Journal Entry No. 35582 and than 1 time for Journal Entry No. 35583 and than 2 times Journal Entry No. 35584. I have made another video which I am sharing here to let all people know what I want. @oldbrewer please view Explanation 2. Thanks again!

Explanation 1
https://www.youtube.com/watch?v=UspgqoP_EZg

Explanation 2
https://www.youtube.com/watch?v=6UQGwR3V3Zw

 

[oldbrewer]

now MSWORD is mentioned - beyond my skill set, sorry.