web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / PM HATB report is not ...
Microsoft Dynamics GP (Archived)

PM HATB report is not aligned with AP/GL Reconciliation

(0) ShareShare
ReportReport
Posted on by Alaa Ramadan 4,130

Hi,

I have a scenario where the AP/GL reconciliation matched perfectly when I run the routine as of Oct 31, 2013

However when I try to check the PM HATB report it shows a difference with $900

I found one payment transaction with matching amount that has been created in the following month (Nov 2013) and applied against one of the outstanding invoices listed in Oct 2013

Not sure if this relevant

***One important thing to say, the report correct itself when I query for Nov 2013, and it matches the balance in GL for the same period  

Any help please

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at

    I am not quite convinced, but it could be different GL posting versus Document date. You could make sure by checking the following script which shows detailed reconciliation per AP transaction,

    SQL Script for AP-GL Reconciliation

  • Alaa Ramadan Profile Picture
    Alaa Ramadan 4,130 on at

    Thanks Mahmoud!

    I managed to find out the transaction causing the issue. There is one invoice transaction posted in PM which has no distribution at all!!

    Is that event possible? my understanding that GP validates distributions before posting.

    How do I correct that?

  • Suggested answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at

    Let me clarify one issue about payable distribution. Let me take the Payment as an example to illustrate how the system works.

    On the module level, Transactions and distribution are recorded in two different tables. On other hand, the General Ledger apparently keeps records on the journal entries associated with the transaction.

    • PM20000  | PM Transaction Open Work 
    • PM10100  | PM Distribution Open Work
    • GL20000  | Journal Entries

    When you open the inquiry, it will retrieved the transaction details as recorded within the "Transaction Table", when you click on the distribution button, it will retrieve the data stored within the "Distribution Table". Journal Entries can be reached at the financial inquiry window.

    Now, the question is ... Does GP allow a transaction to be posted without associated distribution ? The answer is simply  "No". But, the below clarifications are the possible scenarios for your case;

    1- Vendor Card Maintenance > Options > Maintain History: The first scenario in which "Distribution" is not kept is the setup at the vendor card. as shown below;

    1538.Dis.png

    2- Tools > Routines > Purchasing > Remove Distribution History: Supposing the the distribution has been checked to be kept from the setup. This window is used to delete the distribution for certain document number or range of documents.

    3- Delete on the Database level: through which a "delete" statement has been executed on the distribution table directly to remove the distribution.

    4- Posting Corruption: It could still be possible that the distribution has been missed because of a posting corruption, cause of network error or other interrupting factors.

  • Alaa Ramadan Profile Picture
    Alaa Ramadan 4,130 on at

    Once again appreciated your detailed explanation.

    All what you stated above make sense, however I could not think about any possibility other than posting interruption by network issue.

    Is there any existing routine like check links that may take care of such correction.

    if Not, Is it safe to enter this missing record from the backend into the related tables in AP & GL?

    Thank you,

  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at

    Regardless of the different parameters of your case, the check links is always required to run in such cases, as it may create missing records in certain tables. But I'm not quite optimistic about it.

    Is the General Ledger Journal missing as well !

    Please let me know which of the tables I mentioned above having missing records, screen shots are highly appreciated.

  • Alaa Ramadan Profile Picture
    Alaa Ramadan 4,130 on at

    Yes, The distribution is missing in both PM10100 & GL20000.

    But should not the check to be on historical tables PM30600 & GL30000 since that invoice transaction has an applied payment against, both posted and moved from Open/Work to historical?

    However there is no reference for the GL distribution in GL30000 nor in PM30600

    Thank you,

  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at

    Let us know of the check links results when completed.

  • Alaa Ramadan Profile Picture
    Alaa Ramadan 4,130 on at

    Check links has no impact

  • Verified answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at

    Okay, we are clear now.

    To get your transaction corrected, I suggest doing the following steps;

    • Post a corrective Journal Entry in General Ledger
    • If the invoice is fully applied, then you could fill in the distribution details in PM30600. Otherwise, fill in the distribution in PM10100
    • If applied, check that all the details are not corrupted on the transaction file (History - PM30200). Otherwise, check the open transaction table (Open - PM20000)
    • Run reconciliation

    If you are not quite aware of how the distribution should be recorded, then you could quite this step as the PM report doesn't read the document amounts from the distribution tables, rather from the transaction table.

    Another easy suggestion, get your document unapplied then voided. And re-enter the transaction all over again to ensure that all transaction tables are to be filled correctly.

    Further issues to be understood regarding the PM tables as associated with GL:

    • When an invoice is entered and saved in PM Transaction window, the PM10000| PM Transaction WORK File  will be filled out.
      • Distribution will be created in PM10100 | Open and Work Distribution
    • When the invoice is posted, the data will be moved from the table above into PM20000 | PM Transaction OPEN File.
      • Distribution will be kept in the same distribution table PM10100
      • A journal entry will be created in GL20000.  (Supposing the GL Setup is Post Though GL)
    • When the invoice is "fully" applied, the data from the table above will be moved into PM30200 | PM Distribution History File
      • Distribution will be moved into PM30600 | PM History Distribution.
      • The journal entry created in GL20000 has nothing to do with the apply. Once the end year closing is performed, journal entries in GL20000 will be moved into GL30000


  • Alaa Ramadan Profile Picture
    Alaa Ramadan 4,130 on at

    This is perfect!

    The easiest solution for me is to populate PM30600 for the missing distribution and to post a corrective GL entry in GL

    BTW, the field TRXSORCE in PM30600  is a system generated, it always match ORTRXSRC in GL20000/GL30000

    does it matter whatever value to populate in?

    Thank you,

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

News and Announcements

Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Dan Liebl Profile Picture

Dan Liebl 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans