Skip to main content

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.

  1. 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.
     

Hi @bernadeth58

Once give And Operator in the below screenshot

 Thanks


Reply