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.
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...
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