Dynamics 365 F&O/AX Dynamics 365 CE / CRM Dynamics GP Business Central / NAV UG Dynamics SL Power Platform Fabric UG MS Copilot UG

[Don McCready]

Gang,

We have an AP invoice that shows in History on the Inquiry window but also shows as open on the HATB.  We either need to get it out of History and back into Open so we can void it… or just delete it from all tables.

I ran CheckLinks and PM Reconcile to no avail.  It does not show up in the Void Historical Payables Transactions window.

Any suggestions would be appreciated.  I don’t mind working in the SQL db if I know which tables are involved and whether to change a flag or just delete records.

Thanks!

——————————
Don McCready
Controller and IT Director
The Schaefer Group, Inc.
Beavercreek OH
——————————

[Scott McIntosh]

Create an invoice to apply against it and then void both.

——————————
Scott McIntosh
VP of Accounting
William Warren Group DBA StorQuest Self Storage
Santa Monica CA
——————————
——————————————-

[Bruce Strom]

The HATB report is generated from the history and open files and the apply to files.
If a posting got interrupted sometimes the apply-to record has incorrect records or is missing.
I wrote a piece on this in the GPUG magazine for Q1 2017 and Q3 2016.
In SQL I simply look at the apply to records for the suspect transaction, compare them to a transaction that is correct, and make the corrections.
Just make a copy of the values apply to files before and you will be fine.  The only thing the historical apply to files affect is the HATB report, and the inquiry windows.
Quite often discounts will involved in differences.

——————————
Bruce Strom
Programmer Analyst
Associated Grocers of Florida
sunrise FL
——————————
——————————————-

[Bruce Strom]

Your screen shot definitely tells me you need to modify the apply-to files in SQL.  There is no other way I know of to fix this.
Search for HATB articles in discussions, I have more details some months back.

——————————
Bruce Strom
Programmer Analyst
Associated Grocers of Florida
sunrise FL
——————————
——————————————-

[Mark Wiley]

?Don,

I would look at your dates. It might be the payment has an apply date way in the future. Run the regular ATB report which does not exclude any transactions based on a date.

——————————
Mark Wiley
Senior Consultant
Tribridge
Akron, OH
——————————
——————————————-