Filtering Mapping

  • 22 November 2022
  • 1 reply

Userlevel 4

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.

Best answer by manikantad18 22 November 2022, 18:06

View original

1 reply

Userlevel 7
Badge +12

Hi @bernadeth58

Once give And Operator in the below screenshot



About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2023  Acumatica, Inc. All rights reserved