The BAccount CreateDateTime field does not provide the date in which a business account is extended as a customer.
I am trying to create a Dashboard that displays number of new customers created by month. If they are being created from a prospect business account I don’t know how to pull a time stamp at which this happens. Can anyone help?
Best answer by Naveen Boga
View original
+17
Hi
Acumatica is just updating the LastModifiedDateTime field when Business Account is extended as Customer in the BAccount table. But, in the Customer table, we do not have the CreatedDateTime, LastModifiedDateTime fields and other audit fields to fetch the Date when Customer is extended from Business Account.
However,, we can achieve this with the simple customization. Please find the details below.
We can introduce a new Date and Time field in the Customers screen (read only field) in the header section and this Date field can be automatically populated whenever a Business Account is extended to become a Customer. Please let me know if you need further assistance on this.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.