Scheme Ask for not show table query at Shipment Order WMS

Question:

INCIDENT REPORT

< [PT. Gudang Packing Nusatara] Issue Description >

Affected Environment:

< PROD>

Affected warehouse:

< ID_IDCOMGW004 >

Screenshots of error messages:

Time when issue occurred:

5 Mei 2024 at 10.00 AM

Affected module:

For detail at Shipment Order for Query Condition So Reference 2 not show in

After we input some condition for SO Reference 2 & Delivery NO not showing after search query.

Detailed description of issue:

User find to check at module shipment order do not show detail So Reference 2 & at more query condition for checking SO Reference 2 & Delivery Number after query cannot search the detail.

First level investigation/troubleshooting taken:

We already check at Function Config – Shipment Order for UDF Grid & UDF Form, this Menu issue for So Refrence 2 & Delivery NO thare is any wrong ?

Case replication in original warehouse:

For Role all user WMS used scheme ID : ID

---

Answer:

You may make the changes in PROD’s scheme.
1) Open Shipment Order module, and click the picture at bottom right.


2) Click Data Source


3) Select scheme “ID”



4) Click Document Header -> h1(DOC_ORDER_HEADER) -> Additional Clauses


5) Add the following logic:
: And h1.deliveryNo Equal ‘${deliveryNo}’
: And h1.soReference2 Equal ‘${soReference2}’
then click Save Scheme.


*For multi-line search for SO ref 2, you may make the following changes to the following logic:

: And h1.soReference2 Contain (‘${soReference2}’)



6) After saving, relogin WMS and try again.

Customer confirmed it's working

Issue:
In Shipment Order module, query condition filter of "So Reference2" and "deliveryNote" does not apply when querying.


Checking with flux on this.

Found out TEST does not have this scheme issue.


Advised customer to:
1) Backup the current scheme in PROD.
2) Export the ID scheme in TEST.
3) Import the exported ID scheme into PROD.