SG-2117 CLONE - Databridge - outbound ReceiveDelivery receive date in BOD has not the correct value |
Description |
|
DATABRIDGE IMPACT NOTE: Outbound ReceiveDelivery BOD for PO receipt has been adjusted with ReceivedDateTime mapped from R5DOCKRECEIPTS.DCK_RECVDATE instead of R5TRANSACTIONS.TRA_CREATED. END OF DATABRIDGE IMPACT NOTE The outbound BOD that is created after having received parts in EAM, does not contain the receipt date of the transaction, but it looks like that it contains the system date on which the BOD has been created. The server setoff was set to 5 : time field in BOD does not show 5 hours difference. Receipt time of part in local time: 14:37 r5dockreceipts.dck_recvdate and 16:37 in database Receipt time of part in local time: 14:37 r5transactions.tra_date 16:40 in database Receipt time of part with server set to GMT time: 09:40 The BOD shows time : 09:40: <DocumentDateTime>2022-07-01T09:40:20Z</DocumentDateTime> According to outbound documentation it should show r5dockreceipts.dck_recvdate or r5transactions.tra_date, no ? *Actual results* BOD receipt time shows system time *Expected results* BOD receipt time should show time of transaction in database *Steps to reproduce* 1. Create a purchase order 2. Add a part in part tab of purchase 3. Go to the materials - transactions - po receipt screen and create a po receipt 4. The receipt date can be change in the header 5. In Active line tab, retrieve the parts with help of Actions 6. Wait a some minutes (1 or 2) 7. Approve the parts 8. To trigger a BOD, the databridge setup Purchasing - Enable PO receipt outbound should be set to YES. |