Hi,
We are using NetSuite's Dunning Letters module (Customer level).
We set up the module so statements with open transactions only will be added to the dunning email letters.
As you know, when a Customer has multiple currencies, he'll have a separate section for each currency in the same statement (when it is in the same subsidiary).
When a customer has multiple subsidiaries, a separate statement is added to the dunning email per each subsidiary.
As most of our customers have multiple subsidiaries AND currencies, but only one currency has a balance, we don't want our Customers to get statements with 0 balance nor statements with sections of currencies with 0 balance (sometimes the currency with the 0 balance is the first section in the statement and we’re afraid the customer won’t scroll down and miss the currency that has actual balance).
We use multi-currency statements.
Our in-house NetSuite developer adjusted the Multi-Currency Customer Statement Advanced PDF/HTML Template by adding a filter to the template NetSuite has built, which is printing a statement, only if the amount due is greater than zero (marked in green).
In this case, when creating a “generate statement”, NetSuite is skipping this.
When we generated a statement to a customer with a zero-balance subsidiary, we got the following error:
We are OK with the error, but when a dunning letter is sent to a customer with multiple subsidiaries, we found that the behavior is inconsistent, as we had a case that one customer got an accurate statement (only one statement with a relevant currency that has balance), but in a different customer with the same criteria (multiple subsidiaries and currencies), no statement was added to the Dunning Email at all.
After analyzing it with NetSuite support, we saw that the customer that got the statement as expected, his Subsidiaries and Balances looked like that:
So, when the first statement was generated, it was generated correctly, and when the 2nd one was generated, it probably got the error mentioned above because of the 0 balance and it stopped. Therefore only 1 statement was added to the dunning letter email.
The Customer that no statements were added to his dunning email, his Subsidiaries and Balances looked like that:
So, when the first statement was generated, it probably got the error mentioned above because of the 0 balance and it stopped the process of generating statements. That is why no statements were added to the dunning letter email.
Our developer tried to control the statements generating by sorting the subsidiaries per their balances with no success.
Please advise if you know how I can fulfill the request to send only statements that has actual balance.
Regards,
Itzik Turjeman