Where is the manual assignment reason and comments stored in 15.1 database? It’s no longer in the demand table (previous versions) or in the order change log (15.x version).
.
Solved
15.1 Dispatch Console Manual Assignment Reason & Comments
+9Best answer by Phil Seifert
Hi Kyle,
It should be appearing in the demand table, however this appears to be an issue that was resolved in v15SP3. This means it needs to be fixed for 15SP1 (your version).
Once fixed, using the following SQL will return the manual assignments:
select * from demand where bpart_id = 'ManualAssignment'
Please log a ticket with your support group to get this sorted.
+24Hi Kyle,
It should be appearing in the demand table, however this appears to be an issue that was resolved in v15SP3. This means it needs to be fixed for 15SP1 (your version).
Once fixed, using the following SQL will return the manual assignments:
select * from demand where bpart_id = 'ManualAssignment'
Please log a ticket with your support group to get this sorted.
Please mark any comments which answered your question as Best Answer so the topic is easier recognised as answered and closed.
+24Hi Kyle,
I received word from the developers this will be available in V15SP1 HF11.
Phil
Please mark any comments which answered your question as Best Answer so the topic is easier recognised as answered and closed.
1 person likes this
+24You are welcome Kyle. I also just received this from the developers as well which will be a change with v15 from the previous versions:
Also please note the manual assignment reason be found here:
select * from order_changes_log where bpart_id = 'ManualAssignment'
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.