Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

POP Batches Stuck in GL

Posted on by Microsoft Employee

Dear All,

Following entry is from POP after GRN posting (By Batch and not by transaction). In posting steup, I've selected post through GL. I've setup functional currency, rate type ID, values ID in exchange table but following error occurs. Moreover, In this case functional and originating currency is same.

I can not edit this transaction in GL as well. Can you please suggest some solution? I've got so many batches like this stuck in GL. I've run the reconcile routines too but of no use. Remember that we are not using Multi-Currency and just working through Exchange Table.

-----------------------------------------------------------------------------------

"System:    6/22/2009   12:02:05 PM                      Colony Mills Limited                              Page:     1
 User Date: 6/22/2009                                GENERAL TRANSACTION EDIT LIST                User ID:  sa
                                                            General Ledger


 Batch ID:      RECVG00000160
 Batch Comment: Auto Generated Batch
 Approved:      No               Batch Total Actual:     Rs. 4,365,979.2000         Batch Total Control:             Rs. 0.0000
 Approved By:                    Trx Total Actual:                        1         Trx Total Control:                        0
 Approval Date:


     Journal      Transaction    Transaction    Reversing       Source     Transaction
     Entry           Type           Date          Date         Document    Reference
-----------------------------------------------------------------------------------------------------------------------------------------
         14,030    Standard      2/4/2009                       RECVG      Receivings Transaction Entry

   The currency ID is missing.
   The rate type ID is missing.
   The exchange table ID is missing.
                  Account                   Description                                                   Debit              Credit
                  ------------------------- ----------------------------------------------- ---------------------- ----------------------
                  5-02-01-003               LOCAL POLYESTER                                     Rs. 2,182,989.6000

          The currency ID is not selected for this posting account.
                  7-01-01-020               Accrued Purchases-Raw Material                                             Rs. 2,182,989.6000
                                                                                            ---------------------- ----------------------
        Total Distributions:          2                                             Totals:     Rs. 2,182,989.6000     Rs. 2,182,989.6000
   Total Journal Entries:          1"
------------------------------------------------------------------------------------------------------

Looking for your reply!

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: POP Batches Stuck in GL

    Dear Mariano Gomez,

    Thank you so much. It realy helped to fix the outstanding issue.

  • K Day Profile Picture
    K Day 7,365 on at
    Re: Re: Re: POP Batches Stuck in GL

    I would suggest setting up the Multicurrency Module.  Probably the easiest way of doing this would be to read the Printable Manual on multicurency setup (from Help ->> Printable Manuals) and then going through the "Setup Checklist" which can be found under Dynamics GP Button ->> Tools ->> Setup ->> Setup Checklist.  Then set up the multicurrency module.

    What is your functional currency then?  Are you receiving dollars and manually calculating the exchange rate and then entering it in Rupees?  That's fine but you might be better served using the functionality of the entire module.

    Let us know if you have any questions after following the above steps.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: POP Batches Stuck in GL

    This is MSGP 10.0. I have not set multicurrency module in system. Obviously there is functional currency that is being picked. For insatnce, I just put the exchange rate of "Dollar" in terms of "Pak Rupees". All such entries are posted but there is some problem in this.

    Hope now you are in better position to suggest.

  • K Day Profile Picture
    K Day 7,365 on at
    Re: POP Batches Stuck in GL

    What version are you on?  Did you setup the multicurrency in your system?  You need to pick a functional currency even if you are not using the multicurrency functionality.  If you setup multicurrency you will be prompted to run checklinks on the financial series.  I'm not sure what you mean by "not using multicurrency but working through exchange table."  Can you give us some more information?

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,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans