Ref Freshdesk ticket
https://smartacc.freshdesk.com/a/tickets/137097
https://smartacc.freshdesk.com/a/tickets/136206


You may face situation at DynaMod whereby Error message prompt as follow while generate Customer Invoice from Site Giant order as in DynaMod 2022.1 Build 0000.


The error prompt due to duplicated record in SiteGiant order table. 

Temporary solution
Download script attached, configure it at DynaMod Process Manager as custom script. Those script will remove the duplicates record, customer invoice can be generate success without error. Step as follow.



Open DynaMod Process Manager, add ne task as Custom Script.



Double click on custom script drop down panel, fill in all 3 custom script content inside click ok to close,




The custom script icon will become different, default auto run setting as 10 minute, amend it when necessary. Click close to complete configuration.




FAQ
-will it be jumping Site Giant order ID exist in DynaMod while there was duplicate record ?


What actual happen on DynaMod there was duplicate Site Giant Order ID which auto generate by Site Giant side and download into DynaMod AcSiteGiantOrderM table, example issue as follow.


10001

10001

10002

10002

10003

10004

Since the Order ID is provided by SiteGiant , so it follows the sequence set. After the temporary rectify script was execute, result as follow.

AcSiteGiantOrderM


10001

10002

10003

10004