MC PM Transaction Posting Journal Word Template (non-modified) missing vendor/invoice info - only has distributions

(0) Share

Report

Posted on by Althea ADS

445

Our customer has been using GP for 20 years and is now on GP16 RTM and uses MC. They just began using workflow to approve PM Trx batches. When they do this they had to enable Word templates so that they can be attached to the workflow email. When we run an edit list now (not just attachments to workflow) from in GP and it defaults to this template: "MC PM Transaction Posting Journal", it only show distribution lines and does not list any vendor or invoice fields at all. We can have the GP users change to standard each time, but the workflow approvers need this information on the template in order to know what to approve. The GP standard report is not modified and neither is the template.

Does anyone else have this issue? Any guidance is greatly appreciated!!

Thank you!!

Althea

Categories:

Microsoft Dynamics GP

All responses (8)

Answers (1)

Althea ADS 445 on at

Like (0)

Report

RE: MC PM Transaction Posting Journal Word Template (non-modified) missing vendor/invoice info - only has distributions

Excellent! We will test and I will let you know.

THANK YOU, THANK YOU, THANK YOU!!
Hokuminaria 2,950 on at

Like (0)

Report

RE: MC PM Transaction Posting Journal Word Template (non-modified) missing vendor/invoice info - only has distributions

Hello Althea,

This should only effect the reports. I tested posting with this unmarked and i could still see the Multicurrency information in the MC020103 table. I also see the originating amounts in the Distributions.

From the Foundation Library on what this option does.

Include Multicurrency Information

Select this option for multicurrency information to be printed on the edit lists and posting journals for the selected series and origin. When selected, the Currency ID, Rate Type ID, and Exchange Rate print on systems with a registered copy of the Multicurrency module.

I hope this helps!

Microsoft Support Engineer | Brandon Jarrett
Althea ADS 445 on at

Like (0)

Report

RE: MC PM Transaction Posting Journal Word Template (non-modified) missing vendor/invoice info - only has distributions

I will try this. So although they do not need MC info on this edit list - this will still record the currency in payables? They do revalue every month end and it does create MC entries when they pay bills in USD when entered in Euros, etc. I don't want to turn off the functionality, just the report. Is that what this does?
Verified answer

Hokuminaria 2,950 on at

Like (0)

Report
RE: MC PM Transaction Posting Journal Word Template (non-modified) missing vendor/invoice info - only has distributions

Hello Althea,

To turn off the MC version of the Report, you can do this in the Posting Setup.

Open the Posting Setup window.

Dynamics GP | Tools | Posting | Posting

In the posting window, select the following:

Series = Purchasing

Origin = Payables Transaction Entry.

Un-mark the Include Multicurrency info.

Click Save.

Close the window.

Now print the Posting Journal and see if this will work for you.

If it does not work, re-mark the 'Include Multicurrency Info'

I hope this helps!

Microsoft Support Engineer | Brandon Jarrett
Althea ADS 445 on at

Like (0)

Report

RE: MC PM Transaction Posting Journal Word Template (non-modified) missing vendor/invoice info - only has distributions

Hi Brandon,

How can we use the non-MC version of the report? I'm not exactly sure how to do that as a work around. This customer does not need MC info on this edit list, but we cannot turn off MC as they use it extensively in PM/RM. But the regular, non-MC payables edit list would be fine. I'm just not sure how to assign it to these PM batches that automatically email in workflow.

Do we over-write the standard GP MC payables report in Report Writer with the non-MC? Then maybe associate the non-MC template? I guess this is the part i'd need direction on. I can do a case but if there is a work around like switching these reports per your suggestion i'd like to get that going sooner than later as they are using workflow now and really need this edit list attached.

Thanks again!!
Hokuminaria 2,950 on at

Like (0)

Report
RE: MC PM Transaction Posting Journal Word Template (non-modified) missing vendor/invoice info - only has distributions

Hello Althea,

Thank you for your response and pointing out i was testing the non MC report. It appears my MC registration was completely missing and had to reinstall my GP 2016. Thank you for correcting me!

I was able to further test this using the MC version of the report. I get the same issue.

Further review, i found a Product Issue. This is Product Issue 86596 'Issues in the New Word Templates created for Financial, Sales and Purchasing series'.

I tried the following to correct this:

Re-add the fields to the Template.

No change.

Re-add the XML to the Template.

No Change.

Verified the Bookmarks were correct and compared this to the non MC Template.

These were the same.

There is certainly a problem with the the Multicurrency Version of the Template. As this is a Product Issue i would need to delve further into the Template to figure out what is wrong and if we would be able to correct this. i would recommend you create a support case. This would be a non chargeable support case due to it being a product issue.

If you do choose to create a case, please email me the case number at brjarret@microsoft.com and i would be happy to take ownership of the case as i am already familiar with the issue.

One option that might be valid for you is to use the non MC version of the report. We don't get the Currency ID, Exchange Rate, etc on the report but it does show the originating value and other information. Otherwise, i think we would need to use the MC020103 table for these fields in the template. Doing this, we would likely need to change the same fields on the report so we can bring the new xml onto the report. Just a thought on how we might be able to get this to work.

I hope this helps!

Microsoft Support Engineer | Brandon Jarrett.
Althea ADS 445 on at

Like (0)

Report

RE: MC PM Transaction Posting Journal Word Template (non-modified) missing vendor/invoice info - only has distributions

Hi Brandon,

Thank you for that info. That is the Template format for the Multicurrency, but that is not the printout for MC. Your printout with data does have the section for payment information, where the template does not even have that. You need to print with a company using MC to have that template print. My MC template is the same, but here is my printout of data. This batch has 2 test invoices and you can see both distributions but no invoice info. Note the top says Multicurrency Management when you print it. Yours does not have this as it is not printing this version. You are printing the regular PM edit list.

The printout should have headings like Currency ID, Rate Type ID, etc. Can you test printing this using a MC company so this one prints? That would be very helpful to me to know if this works for you or not.

Thanks again!
Suggested answer

Hokuminaria 2,950 on at

Like (0)

Report

RE: MC PM Transaction Posting Journal Word Template (non-modified) missing vendor/invoice info - only has distributions

Hello Althea,

I was able to test this in GP 2016 and not get the same issue. When i print the Core GP Template it does show the Invoices. What i see not showing is any of the Payment Information.

Opening Template for review, it is designed to pull the Invoice information.

I would recommend that you create a support case to allow us to look at your Template, Report and process that you are taking to see if we can recreate this as i am not able to recreate in my GP2016 version.

Microsoft Support Engineer | Brandon Jarrett