Hi Everyone. I need help in filtering some entities. Note, we are using Bundle B2B.
1. Sales Order Export - Filter by Branch
I need to only export Sales Orders in the SLC-APPL branch to BigCommerce.
I have tried filtering by CurrentDocument.BranchID for Equals or Contains SLC-APPL, and even tried the underlying number associated with the branch in SQL (27 in Sandbox)
Any filtering on CurrentDocument.BranchID seems to filter all orders instead of letting only SLC-APPL orders through. Since we do so many Sales Orders in different branches this makes error monitoring very difficult.
- Inactive Acumatica customers are exporting to BigCommerce/BundleB2B. I have run some tests on Sandbox with the entity filters and it doesn't seem to be working as intended.
Thank you.