Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Apply To Journals

(0) ShareShare
ReportReport
Posted on by 10

I have instances in my GL where there are PMAPY batches which are not posting through to the GL. What can cause this? I am looking at the transaction source from the subledger and it appears ok.

We do not use multicurrency.

*This post is locked for comments

  • Community Member Profile Picture
    on at
    RE: Apply To Journals

    This is a common behavior where in some times when you apply the multi-currency transactions in purchasing we notice that the transactions do not post through GL although your Posting Setup is marked "Post Through GL".

    Below are some of the reasons for this behavior 

    1) Foreign Exchange Gain Loss account is not assigned with the transaction currency.

    2) The user who have posted the APPLY transactions may not have the permission to post GL.

    3) Rounding issues in currency due to which Foreign Exchange Gain Loss account line is missing in GL. 

    Guys let me know if you figure out any other reasons.

  • Community Member Profile Picture
    on at
    RE: Apply To Journals

    Hi All,

    Even we have number of multicurrency PMAPY and RECVG JE's that are getting stuck in GL this is a random behavior. We are using Post To and Post Thru.

    Any pointers in this regard will be helpful.

    Regards

    Sandeep

  • Rosemary Profile Picture
    10 on at
    RE: Apply To Journals

    My apologies, but if you go into posting>posting setup>purchasing> origin you can also check what posting method is assigned to 'apply to' transactions.

  • Rosemary Profile Picture
    10 on at
    RE: Apply To Journals

    Hi,

    As Mahmoud has indicated the exchange rate would not cause this issue, but what I did observe and it was remiss of me not to respond, is that if a transaction is created and not assigned to a batch and subsequently posted it will 'post to' the GL. It will remain there until someone posts it through to the GL.

    This is basically what the user here was doing.

  • Community Member Profile Picture
    on at
    RE: Apply To Journals

    Hi Mahmoud, I am experiencing the same problem as the person asking this original question. Whenever we apply a foreign currency payment to a for curr invoice it creates a PMAPY batch. The posting setup does not have a setting for PMAPY batches. it does have one for Curr Revaluation but it is set up correctly ticked both Post To and Through.. Please advise. Thanks.

    Guido Kuwas

  • Suggested answer
    Mahmoud Saadi Profile Picture
    32,738 on at
    RE: Apply To Journals

    To be clear about your inquiry, Do you mean that these PMAPY batches are posting in the originating module without updating the posting accounts in GL?

    If this is the case, then it is related to the posting setup in which you choose whether to "Post To" or "Post Through" GL.

    I don't suspect that different exchange rate would stop the batches from posting, exchange rate variances are usually handled when Multicurrency revaluation is performed.

    Please provide us with any further details if any.

  • Rosemary Profile Picture
    10 on at
    RE: Apply To Journals

    Thanks for your response, but, I am not too clear on the connection. I saw the setup option in the GL.

    The transaction deals with payments made to our foreign suppliers where the exchange rate may differ at the time of payment.

    The write off will the difference between these values. I looked further into the transaction and there was no deletion, just a 'void transaction'. The AP personnel indicated the 'void' may occur if the wrong bank account is used.

    Any further clarification woudl be appreciated.

  • L Vail Profile Picture
    65,271 on at
    RE: Apply To Journals

    Hi Rosemary,

    I've had this happen because the entry was being deleted in the GL before it was posted. To keep that from happening, go into general ledger setup and uncheck the 'Allow Deletion of Saved Transactions' box. With this box unchecked, none of the GL trx coming up from a sub-ledger can be deleted.

    Kind regards,

    Leslie

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

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Almas Mahfooz Profile Picture

Almas Mahfooz 3 User Group Leader

Featured topics

Product updates

Dynamics 365 release plans