Dynamics Community Forum Thread Details

HATB showing Payables Invoice that has been fully applied

User is running her HATB. However, and Invoice that is showing as HIST and has payment fully applied is showing on HATB, despite date.

She is running HATB based on GL Posting Date
She is excluding Fully Paid Documents

Here is the scenario - they cut a check (63615) to the Vendor with the PO in the amount of $23,700. They have now received items against PO and created Invoice for $7,900 and applied $7,900 of check 63615 to the Invoice. The HATB shows payment on 6/19 of -$23,700, but with balance remaining of -$15,800, so it recognizes that a portion of this payment has been applied. However, the Invoice is showing at full amount of $7,900.

I found a wonderful post with suggestions from Victoria Yudin, so I logged in to SQL to check dates on the PM30200 and PM30300. However, the Invoice does not show in the PM30300. Maybe because the payment is not fully applied yet? But, the Invoice IS fully applied. And why would Check amount show correctly, but not Invoice?

Any thoughts on where I should check next or something I am missing? Thanks.

GP Version 2015 R2

Quick Links

Leaderboard