Chris Kiehl
27th July 2006, 18:47
Hello,

When outbound data is released (sales order), a transaction time appears in the tdinv700 table.

Usually, it appears as a valid transaction time.

Other times, however, we see 86399 seconds which appears as 23:59 (11:59:59pm)

Does anyone know what causes this? Again, we're not seeing it consistently with every transaction.

Thanks in advance. -Chris-

jroberts
27th July 2006, 21:15
I have seen the 23:59 appear in tdinv700 due to transaction back dating.

In particular purchase receipts and inventory adjustments.

I have not seen it with respect to sales order deliveries.

What happens if you use 'release outbound,' and then go into 'Maintain Deliveries' and manually adjust the date ?

Do some testing around attempting to force a back dated transaction, and see if that is the cause of your problem.

John

savitr
8th August 2006, 08:15
whenever any transaction are done for any back date e.g receipt date before system date in 'Maintain Receipt' delivery date in 'Maintain delivery' the time stamp is 11:59:59 as it tries to put the transaction on the respective dates.
Hope this helps

Chris Kiehl
9th August 2006, 21:55
Our users aren't accessing the tdsls4120m000 Maintain Deliveries session. They use tdilc4202m000 Release Outbound Data exclusively.

So I'm not sure how "back dating" can be happening with our Sales Orders.