Hi
We want to send Statement of Account to customers automatically using workflow.
I used answer ID 104373 and I am able to send the SOA automatically for a customer.
However I am encountering issue for customers orginally defined for e.g. subsidiary @A and also assigned to subsidiary B.
I need to send Statement to customers of B via workflow; however workflow is sending statement to customers for subsidary A even though customer has balance in subsidiary B also.
My saved search used in sending the statement selects the customers in Subsidiary B, but only few customers selected in the search has the subsidairy B as primary subsidiary, most are assigned to subsidiary B afterwards.
When I added subsidiary B in the workflow condition, this time i observed that statement is sent only to customers with subsidiary B as the primary subsidiary, this is not OK as all other customers of subsidiary B is omiited out as they have subsidiary A defined as primary subsidiary.
Any suggestion wil lbe greatly appreciated as I have tried every i could think of, I am out of ideas and it is not working
Thanking you all for your suggestions/help in advance