Hi All, does anyone know a quick way of removing t...
# accounting
j
Hi All, does anyone know a quick way of removing the no vendor balance that appears in the aged creditors report? From what I understand this appears because journals posted as part of TB migration doesn't have a vendor associated with it. There is one solution may possibly work, but looking to see if anyone else had tried and tested solutions. 1. Create a dummy Opening Balance Vendor 2. Create a saved search with the Internal ID and Line ID and Amount of the J/E lines where Account = A/P. 3. Then re-import that in Update mode and map the Name field. 4. That will update all the A/P J/E lines. 5. Pay Single Vendor" for the dummy A/P vendor.
a
pretty much what you said. In other words, you just reclass 'no vendor' ap balances to the dummy vendor. If you have different currencies involved and / or multi-book than please make sure you take that into consideration as neglecting exchange rates will create more issues
j
@AK Thanks, I am struggling to understand how creditors balance is not going be affected in the TB is we "pay the single vendor for the dummy AP vendor, surely the AP balance would be affected?
a
@jayg if you pay this balance off, for sure it will be affected. If you just reclass it from 'no vendor' to dummy vendor the total balance will remain the same You can do a simple single journal reclass. One line will offset the 'no vendor' balance, the other line will post this balance against dummy vendor.
j
Ok thanks that makes sense
a
This balance will not just magically disappear. If you need to get rid of it than it needs to be moved somewhere. Like you were saying you can pay it off (but then the balance will pretty much move to your cash) or you can journal it to another account of your choice
👍 1
m
You can add a filter in your report for remove the no entity