Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / PM Transaction with BC...
Microsoft Dynamics GP (Archived)

PM Transaction with BCHSOURC = XXPM_Trxent not in GL

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

I am working with a client who has 11 transactions that were posted in the PM module but not in GL.  The only thing I can tell is that they were not posted in batches as the batch number is the users name.  They were done over a couple month period as well.  They do have MEM installed and I do see the intercompany Transactions in the PM Distribution screen of the voucher.  I can see them in the Binary Stream tables as well.  However they are not in the GL tables and the reconcile GL to PM report shows them missing. 

My question is why is this happening?  The only thing I can find that discusses that batch status is invoices with different currency types but the CURNCYID is blank in all transactions in this PM30200 table.  The payments for these vouchers did post when they were made just not the original voucher posting.

Thanks for any assistance!

Dawn

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: PM Transaction with BCHSOURC = XXPM_Trxent not in GL

    Thanks you for your repeated assistance in trying to help me figure this out I so appreciate it!  Here is the strange thing.....the checks that were written against these invoices all hit the GL and were done in a different batch than the actual invoices - that is per the client and will agree with them as they were posted in the PM tables on different dates in some cases.  The only thing I can correlate is the fact that they are all transactions that were not entered as payables in a batch, but rather posted as a transaction.   They all have entities assigned to them and do not appear in the MEM assign entity screen.  I still can't figure it out so I may need to open a case with Microsoft but for now I have them ALWAYS using a batch to post.

  • Verified answer
    Redbeard Profile Picture
    Redbeard 12,931 on at
    RE: PM Transaction with BCHSOURC = XXPM_Trxent not in GL

    Dawn -

    Then I will hazard a last educated guess. Steve's post refers to the concept of "Real Time" - on the PM Transaction Entry Window, a user can enter Cash, Check or CC Payments made, while entering an Invoice combining the Invoice and Payment process.  Perhaps this is the behavior that is causing this problem. 

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: PM Transaction with BCHSOURC = XXPM_Trxent not in GL

    Brand new install and nothing in the currency fields for any of the transactions.  I have no idea what happened. :)

  • Redbeard Profile Picture
    Redbeard 12,931 on at
    RE: PM Transaction with BCHSOURC = XXPM_Trxent not in GL

    Dawn -

    Steve Endow has a post about this transaction type.

    -- Excerpt from post

    It would seem that those two field values indicate a multi-currency transaction.  I don't know the details of why those values are set differently, but this is relevant to applying AP payments because Dynamics GP does not allow you to apply an unposted AP payment to an open invoice if multi-currency is involved.

    If you attempt to apply an AP payment to an invoice with a different currency, you get this message.

    You can't apply documents to a multicurrency transaction until the transaction has been posted.

    You have to first post the payment, and you can then apply the open payment to the open invoice, and the multi-currency calculations and related transactions can be processed by GP.

    dynamics1891.rssing.com/.../all_p5.html

    -- End Excerpt

    Hopefully this helps you narrow why these transactions are happening.

    Perhaps you recently transitioned from an older version of GP. Since the introduction of the Perpetual Licensing model, multicurrency, which used to be an optional (a la cart) purchase is owned by everyone. Now that multicurrency is included, in GP, it causes some unintended consequences. For instance if someone assigns a currency to one transaction (even USD), if the other transaction does not have a currency assigned, you might experience problems applying them.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: PM Transaction with BCHSOURC = XXPM_Trxent not in GL

    Thank you for the reply.  I am sure that the check links will likely fix them, and I have verified that there are entities associated with each transaction and I was able to see them in the MEM tables and no transactions in the assign entity screen of MEM when I ran it.  I just really wonder what is triggering the issue since it has happened nearly a dozen times in a little over a month.

  • Suggested answer
    Redbeard Profile Picture
    Redbeard 12,931 on at
    RE: PM Transaction with BCHSOURC = XXPM_Trxent not in GL

    Dawn -

    In cases like this, the best place to start is to run CheckLinks and Reconcile on the Payables Management tables. If Maintenance and Utilities do not clear up the issue, I would move on to MEM first, and make sure all transactions are assigned a company ID using the Assign Company window.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans