Seek for a bright idea on filtering out wrong sell/Alternative sell lines on "sold since" feature.

@ray20 is customization an option? That’s pretty much the only thing I can see here

@Gabriel Michaud 
Sure thing, Customization is not an option, it is a must. The question here is how.
I mean, not in detail level. just the idea.

my obstacle here is how to mark the item is a “wrong sell” or “alternative sell”. You know, the “sold since” is customer specified. 
Item D for customer A might be an alternative sell, however it could be a normal sell for customer B. 

Somebody gives me an idea that I can show the “Period Sold Qty” in the pop up window.
For Normal Item should have a larger Period sold qty than Wrong Sell or Alternative item.

So the question turns to
How to add such a “Period sold Qty” column in the grid with the counted figure?


The background behind this requirement is:
We are selling food to restaurants. And take beef for example, we have more than 20 item ids. Each restaurant has its own favor item id.
The management would like order takers (if he is new) know which item of beef should be sold to 1 specific customer by leveraging the “sold since” feature.

@ray20 another idea: you could also add a tab in the Customer maintenance with “Customer Preferred Items” and list the items that this customer buys regularly. Then add a check box to the Add Items window to only include Preferred Items

@Gabriel Michaud 
Thank you. Great, this is indeed a talent idea. And you understand our need fully. Yes, it is “Customer Preferred Item” things.

But to implement your idea is a little difficult for me, causing I am not a qualified developer.
There are 2 main things to do with your idea:
1， Add a new tab and associate customer with multiple items. 
It might require a lot of efforts.
2, Add the check box to modify the search results on “add stock item” window.
Even for this point, I don’t know how to do.

What I am thinking of and could be practical is to use the “side panel” function.
I would write an inquiry to get the “sold since” on my own and display it through side panel on SO entry screen.
 

#1 is simple enough for anyone with minimal Acumatica development experience. #2, on the other hand, requires more experience and ability to reverse-engineer and understand the existing “Add Stock Item” panel logic. Doable, but I wouldn’t recommend venturing into this without the help of someone that is qualified.

The side panel idea will work to display the items, however as far as I know you won’t be able to add items to the Sales Order from the side panel; it would just serve for display purposes...

 @Gabriel Michaud 
You are absolutely right. I am with you 100%.

You can hardly believe, the users from our company are more willing to key in the ItemID line by line, instead of to select and add.  So it is OK for them, they only like to see some more information.

Now, please allow me to share my not perfect solution by side panel.

1，The user should take the responsibility to mark the wrong sell line by adding note on soline.

Even if the sales order is completed, the note can be added and modified at any time, so user should have no problem to do it.

2, And then I can filter the lines out by the conditions of the GI

3、Then I can have my own “sold since” without the wrong sell and alternative sell lines

@Gabriel Michaud 
Thank you, sir. 
You are 100% right.
But Acumatica has its own way to disable order, for example ,if I put a checkbox on the soline, however, the whole SO would be disabled if the SO came to Completed Status. Then user can not edit and save the checkbox.
The note is something different, it can be edited any time.

But your comments are right, we should take performance and ambiguity into consideration.
I will monitor the system performance and user behavior, if necessary, I would try to upgrade my method according to your suggestion.

Thank you for your ideas.

@ray20 you an create a simple customization to enable editing on these fields even when the order is completed; I’ve done something similar in the past for another client and it worked satisfactorily. You are absolutely right everything becomes read-only except the Note Text by default, I meant to mention it in my last reply.