Hello Team, I faced with the following problem in...
# suitetalkapi
a
Hello Team, I faced with the following problem in NetSuite. If the Customer balance is changed, NetSuite doesn't update the last modified date for this Customer. For example: I have two Customers. Each Customer has two open invoices. From Customer1, I moved the invoice to Customer2. The balance for Customer1 is changed, but the last modified date is not changed. This negatively affects the correct use of the data via API because we don't understand that the data for Customer1 is changed. As I understand this is a bug in NetSuite. Is it correct?
b
that is the behavior, but you are unlikely to get it classified as a bug. The balance is calculated from other records
a
yes, but in fact, once I moved the invoice to another Customer the balance is changed and the last modified date should be changed too.
b
a change to an invoice is not a change to a customer
and the balance is not data that is on the customer, its a number calculated from other records
a
thank you for your prompt reply!
Battk, in this case, how I can understand that the Customer Balance is changed?
b
id go for the lame answer of creating a search to get customer balance and compare it to the value you got the last time you performed the search
a
Currently, we are tracking the last modified date and once the date is changed, we receive information about the Customer. We do not iterate over every client during integration, only those whose last modification date has changed over a certain period. But, once the balance is changed, NetSuite doesn't modify the last modified date. Maybe you could provide some alternative way?
b
nope, approach flawed, new one needed
a
Does NetSuite have a method that allows receiving information that the Customer Balance is changed?
b
you can do a search on transactions and calculate the balance yourself
i would not expect that to be easier than storing the previous value of the balance and comparing it to the new one
c
you could possibly create a user event on the transaction records that performs some benign update on the customer to trigger the modification date change
a
thank you!