#103 Can't look up Orders in CRMSFA from alternate store

[Eric Jacolin]

I have two companies COMPANY and DEMO and two corresponding stores. So that users can play with the DEMO store for training purposes.

In CRMSFA > Orders > Find Orders, a search will only return orders related to the COMPANY store, not the DEMO store.

I reckon it has to do with the CRMSFA setting in hot-deploy\crmsfa\config\crmsfa.properties
crmsfa.order.productStoreId = COMPANY
In the Ofbiz > Order application, orders from all stores appear as expected.
Is it a bug or feature?

[Si Chen]

Logged In: YES
user_id=908761
Originator: NO

It is a feature but maybe one that you don't want. CRMSFA will now only find orders for the organization which it is configured with, so if your stores reference different payToPartyId, then it will only show them for one store. This was a security and convenience feature we introduced recently to help people who wanted separate installations for different companies and stores.

You can modify this code in findOrders.bsh in crmsfa:
// restrict search results to the company set up for CRM
organizationPartyId = UtilProperties.getPropertyValue("crmsfa", "organizationPartyId");
searchConditions.add(new EntityExpr("billFromPartyId", EntityOperator.EQUALS, organizationPartyId));

At some point we might change all the opentaps apps to allow the user to set their preferred warehouse and organization party, so that a crmsfa user can choose this sort of stuff.

[Eric Jacolin]

Logged In: YES
user_id=1808441
Originator: YES

Thanks for the explanation.