Skip to Content
0

Business One Sales Analysis and BP Properties

Jun 08, 2017 at 02:44 PM

31

avatar image
Former Member

My client has a large customer (customer A) who has sales contracts with several other customers (customer X) in Business One. If customer X is a contract customer of customer A a BP Property is checked denoting that they are a contract customer of customer A.

For sales to customer (X), my client ships directly to them, but the sales are related to customer A via the BP Property Code.

What they would like is a Sales Analysis type report that will display all sales based on a BP Code of customer A and also include the sales for BP's that have that particular BP Property checked in the BP Master Data.

Customer Inv# Total $

Customer A 1234 $100

Customer B 9876 $150 Customer B has BP Property 1 denoting that they are a contract customer of customer A.

Hope this makes sense. If you have questions please let me know.

untitled.png (131.2 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers