SageForum for UK versions of Sage 50- Help and support.

Hi,
I am a Line 50 developer with some 20 years experience of writing Sage applications, but this is the first time I have come across this. I have successfully stripped and rebuilt a client's Sage data, but when I go to the bank rec screen, all transactions are shown as unreconciled. The Bank_Flag field appears in both the TransactionPost and SplitData tables, and I have tried updating it using both text and byte values without success. I have been unable to find the Bank_Reconciled_Date field in any table. Does anyone out there have any code I can copy. I am working in VB6, but will understand VB.Net.

Thanks

The SDO exposes a set of constants (all of which are documented in the SDO help file) for the Bank_Flag that you should use. As for the reconciled date, it is not exposed at all via the SDO (even on v2012) so there is now way fo you to write to it...

John

Thanks John. I have found a workaround: I know the items outstanding on the old system, so I go to the bank rec screen in Sage, click swap to flag all items, and unflag those still outstanding.
Does it not strike you that there is considerable redundancy in Sage data structures? I would have thought that the bank_flag field should appear once only.

Neil

Neil Wylie wrote:Does it not strike you that there is considerable redundancy in Sage data structures? I would have thought that the bank_flag field should appear once only.

The bank_flag really should not appear in the TransactionPost object at all as it is not possible, in Sage itself, to post a bank reconciled transaction. I believe it does appear as TransactionPost inherits the fields collection of the HeaderData object which does have that flag.

John

I think I have set the flags in the past...

They changed the values with different versions common values seem to be 0, 78, 82 as far as I can tell, you only need to set it in the headers.

The value in the splits is ignored, there is no way a split in a transaction could be reconciled and another part not so it makes no logical sense to have a flag in the split.