Hi All! Really hoping someone has experienced this issue before so looking for some insight here.
Background: If you’re seeing a small remaining A/R balance (like $0.01 to $0.03) in the client account on the consolidated balance, but not in the A/R Aging Report, and you’re unable to apply a credit memo to it, this typically indicates a rounding or exchange rate discrepancy — often from foreign currency transactions.
If we make a journal entry to write off $0.01 of this consolidated balance, it will appear as a negative balance in AR Aging. However, if applied to the invoice, it would be successfully written off and clears the balance.
Problem: (See attached screenshot) We have an open invoice showing $0.01 due. When you click ‘Accept Payment’ on this invoice, you can see the default payment amount shows as $0.00. The $0.01 does not show as an amount that can be applied against…as if it doesn’t exist. Journals or credits can be selected here to write off those amounts but it doesn’t matter if NetSuite isn’t recognizing the balance as something that can be applied.
Any advice on how to proceed in a situation like this? Any help would be very much appreciated.