3 Replies Latest reply: Apr 30, 2012 5:42 AM by Chris Candido RSS

RDR1 / INV1 Transaction Line Update Date?

Chris Candido
Currently Being Moderated

I have a system that notes updated invoices and sales orders; I have noticed that the lines (RDR1/INV1) do not have update dates/timestamps.Is there another table in SAP B1 that holds this data? Using the transaction UpdateDate (OINV / RDR1 ) does not catch ALL updates so it is not reliable for reloading the lines.

 

I'm trying not to reload all transaction lines on my remote system, only updated ones.

 

Thanks!

  • Re: RDR1 / INV1 Transaction Line Update Date?
    Owen Slater
    Currently Being Moderated

    Hi Chris,

     

    I don't think there is an update date for each line held anywhere. When 'updating' marketing document lines, SBO actually deletes all the existing lines and inserts them again from the values on-screen (so it doesn't check to see if a line has changed).

     

    You could compare RDR1 to the history table (ADO1 where ObjType = 17 and where the LogInstanc field is incremented each time a document is saved) to see if any rows have been added or updated. However, the history tables don't capture every change (eg if you copy an order to a delivery then there is no new log entry for the order even though it's document and line status has changed). You could, of course, do separate checks for these exceptions if they are required by your integration. How reliable this is will depend on which fields in RDR1 you are interested in.

     

    Kind Regards,

     

    Owen

  • Re: RDR1 / INV1 Transaction Line Update Date?
    Johan Hakkesteegt
    Currently Being Moderated

    Hi Chris,

     

    If you have built this system yourself, an alternative to the method suggested by Owen, would be  sql's EXCEPT method.

     

    Regards,

    Johan

Actions