Greetings: We have many vendors with one cent balances due to rounding errors in the system. How can we remove these from the Open Invoice Register? I have dozens of these $.01 balances.
Greetings: We have many vendors with one cent balances due to rounding errors in the system. How can we remove these from the Open Invoice Register? I have dozens of these $.01 balances.
Go to AR Periodic Processing > Create Write-off Batch. In the amounts, enter -.01 to .01 (or a larger range if you prefer). Fill in the other selections on the screen if you want to have other criteria, and then click Process. It will create an Adjustment Batch in AR that you can post to clear these transactions.
One thing to note though: unless something has changed in recent versions, adjustments with a zero balance still show on some reports. You have to edit those in Crystal to tell it not to show transactions where balance = 0.
These penny balances are in A/P (vendor balances).
How many suppliers are we talking about with Penny Balances? How does this even happen, don't you get sent statements and fix it up on your next purchase payment to them? Are they all debit penny balance or credit penny balances too? I'm thinking a bulk credit note import if its a lot - just need to decide what account you want to park these into - something like "written off supplier balances" etc. ?
Many, many vendors with multiple (erroneous) .01 and (.01) balances.
No, vendor statements do not reflect penny balances.
sorry about my previous AR answer. AP doesn't have a corresponding feature. I agree you'll have to pick a write-off account and do a bulk import. Importing as Adjustments might be better so you can do the positives and negatives at once. If you have good Crystal or query skills, you can create an Excel list of just vendor#, document#, currency (if using) and balance for these transactions, and copy those into an Adjustment import template.
No worries
That's what I thought, but was hoping someone had an extraordinary idea. Import it is...
*Community Hub is the new name for Sage City