[Barbara Gavron]

Client disposed of an asset then un-retired it. Then did so again. They made a mess of it and they would like to just flat out delete the asset and re-enter it cleanly. But when I try to delete the asset we get an error message that “Account distributions exist for this asset in an unposted batch. Delete or post the batch before deleting the asset”. However, there are no FATRX batches unposted. Is there a table that this may be hiding in that I do not know about? I ran Checklinks on GL Transaction Work and then Reconcile on the Financial Batches. Nothing.

 

I also tried the FA GL Posting specifying only this asset but I get no results. I even tried to process it for a wide range of dates, thinking it might be hiding in a strange date. Still nothing.

I ran the Create Batch Headers FA Reconcile tool and got no results.

 

I am at a loss. Anyone have any ideas?

 

——————————
Barbara Gavron
Atlantic Beach / Jacksonville FL
904-536-0129
——————————

[Danielle MacNaughton]

Hi Barbara,
Has the client done the step of GL posting shown below for each time they retired or un-retired?
If they haven’t, the act of retiring, un-retiring, then retiring again will have created distributions. However, if you haven’t done this step yet, there won’t be a FATRX batch created. I’m not sure what version they are running, but this would be in 2013 and higher. Once you process, the distributions will appear and you must hit post to create the batch. It’s confusing if you are used to 2010 because “post” on this step only creates the FATRX batch. You would then have to go into batches and post the FATRX batch like you normally would. If they have done the GL Posting and only hit “save” or “delete” the distributions will still be hanging, but no batch posted. 
I hope this helps you, if not, then i hope someone else with more back-end expertise will chime in!

——————————
Danielle MacNaughton
Leonards Express
Farmington NY
——————————
——————————————-

[Barbara Gavron]

I was not at the scene of the crime, so I cannot say for sure that they created the batches for posting, but if they did not, then when I ran the Post to GL routine it should have picked up anything unposted. I ran it with a range from 1/1/2000 through 12/31/2099 and got zero results. So I do not know where these unposted records are hiding. I would clean them up in SQL if I know what table to look at.

——————————
Barbara Gavron
Atlantic Beach / Jacksonville FL
904-536-0129
——————————
——————————————-

[Judy DeLello]

?Was anyone able to resolve this?  It has recently popped up for a customer of mine and I cannot find any unposted activity.  I checked the financial detail inquiry for the asset and also processed GL Posting for all assets from 0000-000 t0 2099-012 and there is no activity.  The only suspicious item appears to be a batch that someone processed in fixed assets and then deleted in the GL.

——————————
Judy DeLello
Informed Systems, Inc.
Blue Bell PA
——————————
——————————————-

[Leslie Vail]

?Hi,
Whenever I run into something like this, I search the entire database for the Asset ID. I use the FREE tool from Apex named Apex SQL Search. That helps me find any instance of that asset ID in any table. Perhaps that would be a way to find an answer. Once you download the Apex search tool, you will find LOTS of things to use it for. It’s a real gem for a great price of $0.
Kind regards,
Leslie

——————————
Leslie Vail
Accounting Systems Consulting, Inc.
Dallas TX
leslievail@earthlink.net 972-814-8550
——————————
——————————————-