Offline Billable Items from Business Contact Manager/BCM not Appea

  • Thread starter Thread starter Eddie H.
  • Start date Start date
Status
Not open for further replies.
E

Eddie H.

When going from Offline database to Online database, the Offline Billable
Items from Business Contact Manager/BCM are not Appearing in Accounting Tools
-Submit Billable Time. This is a major problem. I have varified this on
several situations now. Happens when Integrated Outllook and Accounting
database.

Please, need to know what to do to fix this issue. I have posted many
questions in this community and I never get response. I really need one now.
 
All,

After much digging around, I found the answer on my own. As I suspected,
there is a flag in the database not getting set when Outlook items are synced
from offline to online. Apparently, the ActivitiesTable has an 'isBillable'
field which gets flagged correctly with True when you are Offline and when
your Online.

In addition, BCM uses ActivityCategoriesTable to mark and suppress the
Billable button on Activities like Task and Meeting in the BCM GUI (User
Interface). Further, to make things more frustrating, it does NOT use
ActivityCategoriesTable for Phone Logs (another inconsistency).

I checked the Offline database in the laptop and BOTH Tables are marked
correctly depending if is a Task or Phone Log. So the BUG lies within the
SYNC procedure or code that handles the sync between offline and online
database. When syncing, it is transferring over the ActivityCategoriesTable
which in turn sets the Billable GUI button for Task, but fails to set
isBillable=True (even though the Offline DB has it set). Finally, for Phone
Logs marked Billable, after syncing the isBillable=NULL. I am sure some
Programmer forgot to MAP the field correctly.

Of course, the Accounting Tools - Submit Billable Time function in BCM uses
a Stored Procedure (ir_RetrieveSBAActivities), which in turn is only looking
for isBillable=True, so the synced Outlook items are never pulled.

The Semi-good news is that Tasks and Meetings have Category set when you
click Billable in GUI, so ActivityCategoriesTable has a record in it that can
be detected after syncing.

The following query will reveal these items:

SELECT *
FROM ActivitiesTable INNER JOIN
ActivityCategoriesTable ON ActivitiesTable.ActivityID
= ActivityCategoriesTable.ActivityID
WHERE (ActivitiesTable.IsBillable IS NULL) AND
(ActivityCategoriesTable.CategoryName = N'Billable')

I have put an UPDATE query in ir_RetrieveSBAActivities so that these items
show when the Accounting Tools - Submit Billable Time command is clicked.
However, I still have issue with Phone Logs because someone decided NOT to
add the Category for Phone Logs, but it is ok for Meetings and Task when the
Billable button is clicked.

I hope this helps in the next service pack and more importantly helps some
companies recover lost revenue!

 
Hi Eddie

Can you give me the steps to repro and I can bring it to the attention of
the product team
Regards

Rahul Thomas [MSFT]

The posting is provided "AS IS" with no warranties and confers no rights.
https://blogs.msdn.com/rathomas

"Eddie H." <EddieH> wrote in message
news:717B3933-19EE-4324-A6B8-026420D033C2@microsoft.com...
> All,
>
> After much digging around, I found the answer on my own. As I suspected,
> there is a flag in the database not getting set when Outlook items are
> synced
> from offline to online. Apparently, the ActivitiesTable has an
> 'isBillable'
> field which gets flagged correctly with True when you are Offline and when
> your Online.
>
> In addition, BCM uses ActivityCategoriesTable to mark and suppress the
> Billable button on Activities like Task and Meeting in the BCM GUI (User
> Interface). Further, to make things more frustrating, it does NOT use
> ActivityCategoriesTable for Phone Logs (another inconsistency).
>
> I checked the Offline database in the laptop and BOTH Tables are marked
> correctly depending if is a Task or Phone Log. So the BUG lies within the
> SYNC procedure or code that handles the sync between offline and online
> database. When syncing, it is transferring over the
> ActivityCategoriesTable
> which in turn sets the Billable GUI button for Task, but fails to set
> isBillable=True (even though the Offline DB has it set). Finally, for
> Phone
> Logs marked Billable, after syncing the isBillable=NULL. I am sure some
> Programmer forgot to MAP the field correctly.
>
> Of course, the Accounting Tools - Submit Billable Time function in BCM
> uses
> a Stored Procedure (ir_RetrieveSBAActivities), which in turn is only
> looking
> for isBillable=True, so the synced Outlook items are never pulled.
>
> The Semi-good news is that Tasks and Meetings have Category set when you
> click Billable in GUI, so ActivityCategoriesTable has a record in it that
> can
> be detected after syncing.
>
> The following query will reveal these items:
>
> SELECT *
> FROM ActivitiesTable INNER JOIN
> ActivityCategoriesTable ON ActivitiesTable.ActivityID
> = ActivityCategoriesTable.ActivityID
> WHERE (ActivitiesTable.IsBillable IS NULL) AND
> (ActivityCategoriesTable.CategoryName = N'Billable')
>
> I have put an UPDATE query in ir_RetrieveSBAActivities so that these items
> show when the Accounting Tools - Submit Billable Time command is clicked.
> However, I still have issue with Phone Logs because someone decided NOT to
> add the Category for Phone Logs, but it is ok for Meetings and Task when
> the
> Billable button is clicked.
>
> I hope this helps in the next service pack and more importantly helps some
> companies recover lost revenue!
>

 
Raul,

I thought I gave a pretty comprehensive response and scenario to reproduce
it. There are several issues which I identified.

1. Phone Log is not adding a record in ActivityCategoriesTable for Billable.
2. In Offline add a Phone Log, Examine ActivitiesTable for the new record,
isBillable=1
3. Syncronize, Examine ActivitiesTable again for record, isBillable=0

For Task and Meetings.

1. In Offline add a Task, Examine ActivitiesTable for the new record,
isBillable=1
2. Syncronize, Examine ActivitiesTable again for record, isBillable=0

"Raul Thomas" wrote:

> Hi Eddie
>
> Can you give me the steps to repro and I can bring it to the attention of
> the product team
> > Regards
>
> Rahul Thomas [MSFT]
>
> The posting is provided "AS IS" with no warranties and confers no rights.
> https://blogs.msdn.com/rathomas
>
> "Eddie H." <EddieH> wrote in message
> news:717B3933-19EE-4324-A6B8-026420D033C2@microsoft.com...
> > All,
> >
> > After much digging around, I found the answer on my own. As I suspected,
> > there is a flag in the database not getting set when Outlook items are
> > synced
> > from offline to online. Apparently, the ActivitiesTable has an
> > 'isBillable'
> > field which gets flagged correctly with True when you are Offline and when
> > your Online.
> >
> > In addition, BCM uses ActivityCategoriesTable to mark and suppress the
> > Billable button on Activities like Task and Meeting in the BCM GUI (User
> > Interface). Further, to make things more frustrating, it does NOT use
> > ActivityCategoriesTable for Phone Logs (another inconsistency).
> >
> > I checked the Offline database in the laptop and BOTH Tables are marked
> > correctly depending if is a Task or Phone Log. So the BUG lies within the
> > SYNC procedure or code that handles the sync between offline and online
> > database. When syncing, it is transferring over the
> > ActivityCategoriesTable
> > which in turn sets the Billable GUI button for Task, but fails to set
> > isBillable=True (even though the Offline DB has it set). Finally, for
> > Phone
> > Logs marked Billable, after syncing the isBillable=NULL. I am sure some
> > Programmer forgot to MAP the field correctly.
> >
> > Of course, the Accounting Tools - Submit Billable Time function in BCM
> > uses
> > a Stored Procedure (ir_RetrieveSBAActivities), which in turn is only
> > looking
> > for isBillable=True, so the synced Outlook items are never pulled.
> >
> > The Semi-good news is that Tasks and Meetings have Category set when you
> > click Billable in GUI, so ActivityCategoriesTable has a record in it that
> > can
> > be detected after syncing.
> >
> > The following query will reveal these items:
> >
> > SELECT *
> > FROM ActivitiesTable INNER JOIN
> > ActivityCategoriesTable ON ActivitiesTable.ActivityID
> > = ActivityCategoriesTable.ActivityID
> > WHERE (ActivitiesTable.IsBillable IS NULL) AND
> > (ActivityCategoriesTable.CategoryName = N'Billable')
> >
> > I have put an UPDATE query in ir_RetrieveSBAActivities so that these items
> > show when the Accounting Tools - Submit Billable Time command is clicked.
> > However, I still have issue with Phone Logs because someone decided NOT to
> > add the Category for Phone Logs, but it is ok for Meetings and Task when
> > the
> > Billable button is clicked.
> >
> > I hope this helps in the next service pack and more importantly helps some
> > companies recover lost revenue!
> >

 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
A Outlook 365 Outlook (part of 365) now working offline - argh Using Outlook 5
R Outlook 2019 accesses POP3 but says its offline (because of IMAP servers?) Using Outlook 0
Commodore Automatic switch between working offline/online Using Outlook 4
B Clear Offline Items (Mail Folder) via VBA Outlook VBA and Custom Forms 1
R How can I access my emails from corrupt offline files of MS Outlook ? Using Outlook 1
hbmiller Outlook for Mac Keeps Dropping Offline Using Outlook 2
soadfan Outlook won't send e-mail when offline Outlook VBA and Custom Forms 19
W Receiving messages in offline mode Outlook VBA and Custom Forms 1
J VBA to switch Outlook online/offline Outlook VBA and Custom Forms 4
T BCM 2010 randmoly going offline BCM (Business Contact Manager) 0
L Clear Offline (Task) Items using VBA Outlook VBA and Custom Forms 0
Diane Poremsky Convert an Offline File (.ost) to a Personal File (.pst) Using Outlook 0
Diane Poremsky Moving an Outlook offline data file (*.ost) Using Outlook 3
Diane Poremsky Using Offline Sync Filters Using Outlook 0
A Offline folders password forgotten Using Outlook 2
DBoss Outlook 2013 as offline GMail IMAP Sync Using Outlook 1
2 How to use outlook 2003 calendar in always offline mode Using Outlook 0
Jennifer Murphy Why would I want to send/receive when offline? Using Outlook 0
M Outlook 2010 stuck in Work Offline mode; trouble sending email Using Outlook 1
D how to display email images when "working offline" Using Outlook 3
J Error: 0X8004010F - Microsoft Exchange offline address book Exchange Server Administration 9
J Export custom views from offline OST Exchange Server Administration 4
R Problems sending via POP profile when offline from Exchange Using Outlook 7
R Deleting the offline address book Using Outlook 1
D Unable to open hotmail, error hotmail.ost is not an offline folder file Using Outlook 3
M Change from working offline to online Using Outlook 2
R BCM 2010 error creating offline copy of shared database BCM (Business Contact Manager) 1
R Need code snippet to read offline PST file Outlook VBA and Custom Forms 1
J Offline database BCM (Business Contact Manager) 1
S Creating Offline Database BCM (Business Contact Manager) 6
S Cannot create offline database BCM (Business Contact Manager) 2
D BCM Offline BCM (Business Contact Manager) 1
I Displaying my Online/Offline Status BCM (Business Contact Manager) 2
J how do I accomplish offline archiving of email? Outlook VBA and Custom Forms 1
E Offline BCM Problem BCM (Business Contact Manager) 1
P How to know Outlook is being started in Offline mode? Outlook VBA and Custom Forms 2
S Is a form published in Org folder accessible offline to users ? Outlook VBA and Custom Forms 1
D offline fatabase on laptop not remembering TASKS dates BCM (Business Contact Manager) 1
M BCM 2007 Can not create Offline Database BCM (Business Contact Manager) 2
H Macro to Delete Duplicate items in Outlook calendar where title is the same and date is the same Outlook VBA and Custom Forms 0
P turn off the default "all day" check box in new calendar items. How? Using Outlook 1
A Outlook 365 (OutLook For Mac)Move "On My Computer" Folder Items From Old To New Mac Computer Using Outlook 4
Kika Melo Outlook Calendar deleted appointments not in Deleted Items folder Using Outlook 3
icacream Outlook 2021 Win 10 - Nothing goes in my Drafts or Sent items folders ! Using Outlook 1
M using excel to sort outlook appointment items Outlook VBA and Custom Forms 4
K Changing the Deleted Items location in Outlook 2019 Using Outlook 2
R Adding Userform Dropdown List items from names of subfolders on network drive Outlook VBA and Custom Forms 10
C How to search for items in Outbox with multiple accounts? Using Outlook 20
N How to add or delete items to Move dropdown Menu Using Outlook 0
sophievldn Looking for a macro that moves completed items from subfolders to other subfolder Outlook VBA and Custom Forms 7

Similar threads

Back
Top