#478 Different Date Formats Sequences Stock In Out – Documents

Different Date Formats and Date Sequences
Stock In Out – Documents
...\plug_ins\reports\systemreports\TRN_1999\TRN_906112\TRN_38
Added Stock Item Unit Size to main report
Fixed Date format
yyyy-mm-dd Deleting it from the Display format seems to work – causing some documents to display the date and time overlapping with the document number.
Changing the Expression “STOCKTRN.DDATE” Data type to Date fixes that.

Fixed Sequence order by date
Order the documents seemed to be randomly listed not in a specific date sequence.
Added order by ddate to the STOCKTRN Dataset
“Select * from docline
join dochead on docline.Wdocid = dochead.wdocid
where docline.WStockid = :Nr and dochead.ddate between :ddatefromfl and :ddatetofl
order by ddate”

Stock In / Out
...\plug_ins\reports\systemreports\TRN_1999\TRN_906112\TRN_906112
Added Stock Item Unit Size to main report
Fixed Date format
yyyy-mm-dd Deleting it from the Display format seems to work – causing some documents to display the date and time overlapping with the document number.
Changing the Expression “STOCKTRN.DDATE” Data type to Date fixes that.
Fixed Sequence order by date
“Select * from stocktrn
left join dochead on stocktrn.Wdocid = dochead.wdocid
where WStockid = :Nr and stocktrn.ddate between :ddatefromfl and :ddatetofl
order by stocktrn.ddate”

[Anonymous]

Stock In / Out Date Formats

[Anonymous]

Rechecked - correct Fixed in Buid 600 and Build 980