Microsoft Dynamics GP Macro Automation

(0) Share

Report

Posted on by Community Member

Hi All,

I am trying to automate my work in Microsoft Dynamics GP. I am currently using mail merge to make macros and make invoices, credit memos etc. in different modules of Microsoft Dynamics GP.

One thing that I am unable to do is that I could apply different Analyticals in one invoice because of limitation of mail merge. Please view the following example for explanation...

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

Now here Mail Merge do the following because it reads one line at a time. I need that mail merge could sum these values in Amount column i.e. 10000 and than break this 10000 in amounts 5000 of Job A, 3000 of Job B and 2000 of Job C. But with mail merge I cannot do it.
Total: 10000
Job A: 5000
Job B: 3000
Job C: 2000

I have tried to explain what I need in the following videos as well...

Is there any other way to do what I am trying to do? Or if anyone can help me to do this with mail merge I will thankful and give it a try.

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (1)

KirkLivermont 5,985 on at

Like (0)

Report

Hello Sajid,

Where in GP are you trying to enter this total? I normally rely on the application to total the input.

Regards,

Kirk

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

In Purchase Module/Financial module voucher/general journal entry main window this amount is needed to justify the invoice amount. Like if you receive bill of 10000 and it belongs to three different jobs A, B & C than I enter the amount 10000 in main window of Purchase Module/Financial module voucher/general journal entry window and that distribute this to job A, B & C in Analyticals Window.

Was this reply helpful? Yes No
Syrus 4,156 on at

Like (0)

Report

My poor knowledge and I could be wrong too.

while looking at your recordings, I don't think that macro is that intelligent (at this level) to know what is the Total credit and what is remaining to balance it.

Or it knows that the JE is same but different job #s will sum up. I see macro is using different keys but not able to figure out that total Credit needs more line items (keys #) to balance.

You may need to use multiple JEs for that purpose.

Was this reply helpful? Yes No
Suggested answer

L Vail 65,271 on at

Like (0)

Report

Hi,

The Macro language only repeats keystrokes. You cannot ask it questions, it cannot do computations, it will not evaluate results. If you want the macro language to enter transactions with computations included, you have to do the computations first. The macro language is nothing like VBA. It is not a programming language of any kind; it simply repeats the keystrokes you tell it. If you didn't tell it, it cannot decide for itself. If you need decision or calculation related actions, you need to move over to one of the programming languages like VBA, Dexterity or VBTools.

Kind regards,

Leslie

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks for your reply.

Actually I want mail merge to co calculations not Macro.

And I was trying to apply different jobs in different vouchers, But its restriction that invoice number can be entered in GP only one time. if you will put invoice number twice than it will give error and will not proceed.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hey,

Yes I want the same i.e. Mail Merge or VBA to do calculations. Actually there are two macros that are involve. One that will run on MS Excel or MS Word and make the second macro that will I run on MS Dynamics GP.

Was this reply helpful? Yes No
Verified answer

L Vail 65,271 on at

Like (0)

Report

Hi,

You will need to run code against your data table and use that code to modify the numbers in your data source. I suppose you could do it 'on the fly' but, sadly, I have never done that with a Word module. You may be better served to put your question in the Word experts forum. You're needing to modify your mail merge source. This isn't a macro problem, because the macro language simply cannot do it. I've also used SQL to create my macro source, but it can be a little more challenging.

Kind regards,

Leslie

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hey,

Thanks. I will get help from a MS Word forum.

Was this reply helpful? Yes No