Hi All! Really hoping someone has experienced this...
# general
r
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.
p
Is it maybe rounding down. is the actual amount due less then 0.01?
r
It could have to do with the invoice being paid via installments? It’s a 3-month term where each installment paid it set to $59.33. The customer could not pay for all their installments so only $118.67 could be paid and $59.32 was applied as a credit…leaving $0.01 remaining even though the order total is set to $178.00. Additionally, the invoice, payment and credit all reside in a closed period that cannot be opened…