How can I fetch Customers by changeDate?

Epicor ERP 10
, ,
1

I am using this particular service “Erp.BO.CustomerSvc/Customers”, to fetch the customers on epicor. But I don’t want to fetch all of them at once; I want to get only customers that were updated on a specific date.

For example, If I want to fetch all customers that were updated on “2023-08-31”, How do I go about it?

2

I highly recommend using a BAQ with the BAQSvc. Easy to write. Works reliably. Is faster and more efficient, i.e. returns fewer fields.

3 Likes
3

To @Mark_Wonsil’s point, this BAQ should return what you need:

select 
	[Customer].[CustID] as [Customer_CustID],
	[Customer].[CustNum] as [Customer_CustNum],
	[Customer].[ChangeDate] as [Customer_ChangeDate],
	[Customer].[ChangedBy] as [Customer_ChangedBy]
from Erp.Customer as Customer
where (Customer.ChangeDate = '08/31/2023')

Good luck!