Skip to main content
Solved

Filtering Mapping

  • 22 November 2022
  • 1 reply
  • 169 views

Forum|alt.badge.img

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 Manikanta Dhulipudi

Hi @bernadeth58

Once give And Operator in the below screenshot

 Thanks

View original
Did this topic help you find an answer to your question?

1 reply

Manikanta Dhulipudi
Captain II
Forum|alt.badge.img+13

Hi @bernadeth58

Once give And Operator in the below screenshot

 Thanks


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings