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
Need more, need help now?
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals
Bank_Flag and Bank_Reconciled_Date Fields
-
Neil Wylie
- User
- Posts: 2
- Joined: 09 Oct 2011, 17:28
- Sage Version: v2010 16 UK/Europe/Africa
-
leyburnsolutions
- User
- Posts: 132
- Joined: 14 Apr 2011, 18:02
- Sage Version: v2014 20 UK/Europe/Africa
Re: Bank_Flag and Bank_Reconciled_Date Fields
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
John
-
Neil Wylie
- User
- Posts: 2
- Joined: 09 Oct 2011, 17:28
- Sage Version: v2010 16 UK/Europe/Africa
Re: Bank_Flag and Bank_Reconciled_Date Fields
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
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
-
leyburnsolutions
- User
- Posts: 132
- Joined: 14 Apr 2011, 18:02
- Sage Version: v2014 20 UK/Europe/Africa
Re: Bank_Flag and Bank_Reconciled_Date Fields
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.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.
John
-
brucedenney
- Site Admin
- Posts: 4633
- Joined: 28 Feb 2006, 09:56
- Sage Version: v28 UK/Europe/Africa
Re: Bank_Flag and Bank_Reconciled_Date Fields
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.
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.
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.
Who is online
Users browsing this forum: No registered users and 2 guests