Topic Options
#1803 - 12/27/01 10:35 AM Inaccurate WIP reports
Anonymous
Unregistered


How do I find where the numbers on the WIP reports are coming from? Many of our clients are showing a WIP number - but the billing memos are 0.00.

Top
#1804 - 12/27/01 11:54 AM Re: Inaccurate WIP reports
Softrak Support Offline

Adagio Action Team

Registered: 03/09/99
Posts: 11549
Loc: Vancouver, BC Canada
Hi Dierdre,

The Billing Memo report is reading the WIP file, as do many other TBR reports. The Billing Memo report does rely on many of the options entered when printing this report, such as the date range, 1 or 2 part form, etc.

Which options are you selecting when printing the report, and where are you seeing zeroes? For example, if the WIP transactions have a date prior to the date range chosen in the Billing Memo report, then these transactions are included in a Balance Forward amount on the left-hand portion of the two-part report. The right-hand portion totals will not reflect these amounts.

If you want to see the transactions for a specific Client or Docket, you can look at either the T&D Ledger or Aged WIP report, or use the Detailed T&D Inquiry (all in the Time&Billing portion of the program).

Regards,
Softrak Support


Top
#1805 - 12/27/01 12:11 PM Re: Inaccurate WIP reports
Anonymous
Unregistered


For the billing memo I am choosing the date range 1/1/90 - 12/27/01. 1990 is the earliest date it lets me choose. The numbers I can't find anywhere but the WIP report is showing up in the Current and Balance columns.

The billing memos coming up as 0.00 is showing me that there is no detail to be billed.

The T&D ledger lists everthing that happened in the client and case - but nothing that matches the numbers hanging on the WIP report.


Top
#1806 - 12/27/01 12:42 PM Re: Inaccurate WIP reports
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada
Hello Diedre,

One possibility is that the date range you are selecting is now 2090, rather than 1990 (more than 10 years in the past = in the future), if the field is only 2 digits in width.

Andrew Bates


Top
#1807 - 12/27/01 01:16 PM Re: Inaccurate WIP reports
Anonymous
Unregistered


How do I check if there is a date issue? Do I have the option to change it to 4 places it is only showig 2 now.

I tried printing from 1/1/00 - 1/1/90 - meaning 2090 - but it said from can't be larger that to field.


Top
#1808 - 12/28/01 02:18 AM Re: Inaccurate WIP reports
Softrak Support Offline

Adagio Action Team

Registered: 03/09/99
Posts: 11549
Loc: Vancouver, BC Canada
Hello Dierdre

If you are using the most current release of TBR (Version 6.6A dated 981030), then there is a 'fix' for displaying 4-digit years. It is available to all registered Users of this version/release of TBR.

You should be able to get these files from your Dealer, as he is a Softrak Business Partner, however, we are emailing you the fix, which should work with your earlier release of 6.6A as well.

Please watch for the email and follow the suggestions in there closely. This should allow you to see the whole year of the dates you are entering.

Hope this helps!

Regards,
Softrak Tech Support


Top
#1809 - 12/27/01 04:55 PM Re: Inaccurate WIP reports
Softrak Support Offline

Adagio Action Team

Registered: 03/09/99
Posts: 11549
Loc: Vancouver, BC Canada
Hello Dierdre,

Just to confirm a couple of things:

If you have 2-digit years in any Accpac Plus program or add-on, such as TBR, the year interpretation depends on the version of the System Manager. If you have WSM 7.0, it will interpret the year '89' as 2089 but '90' as 1990 - regardless of it's use as a start or end of a date range. When you selected a range of 1/1/90 to 12/27/01, that was being interpreted correctly.

Could you confirm which field(s) are zero on the billing memo that you were expecting to have a value? Or perhaps it's the other way around, where you are expecting zero, but see a value on the Aged WIP report? I would be good to know whether Final/Progress billing was related, or perhaps including the AR amounts on the Aged WIP report.

If the date range you selected was 1/1/90 to today on the billing memo, then the unbilled total on the right-half should match the total amount on the Aged WIP report for each Client/Case.

Take care,
Softrak Support


Top
#1810 - 12/28/01 07:21 AM Re: Inaccurate WIP reports
Anonymous
Unregistered


There is no unbilled total on the right of the memo.

The left side of the memo says professional services recorded Jan 01 90 to Dec 27 01.

The right side of the memo says unbilled total 0.00, fees 0.00, and disbursements 0.00


Top
#1811 - 12/28/01 11:45 AM Re: Inaccurate WIP reports
Softrak Support Offline

Adagio Action Team

Registered: 03/09/99
Posts: 11549
Loc: Vancouver, BC Canada
Hello Dierdre,

The heading on the left side 'Professional Services Recorded (Date) to (Date)' is simply a heading and doesn't necessarily mean that there are any WIP transactions waiting to be billed. When you choose a date range, prior to printing the report, those dates are what print in the heading.

If any WIP transactions (time or disbursements) were posted in the specified date range, then they will appear underneath that heading with the date, description, and source or disbursement code. In this case will these amounts be included in the Unbilled Total to the right.

If any WIP transactions were posted prior to the date range specified, they will all be lumped together in a single line 'Balance Forward:'. These amounts are not included in the Unbilled Total to the right, by design.

TBR will print a page for each Client/Docket, even if there are no WIP transactions to bill, if you choose all the default settings for the report. If you want to prevent these Dockets from printing, then you have to enter 0.01 for the last field 'Files with unbilled amounts over'. This really should be labeled 'Files with unbilled amounts equal to or over'.

You posted earlier that amounts were appearing in the Current column of the WIP report. If this was for the AR row (rather than WIP), then this will not affect the Billing Memo report. Does the Time & Disb Ledger show any transactions that are not Final Billed for that Client/Docket? This would help determine whether transactions exist that should be printing on the Billing Memo.

I'm wondering if you've got a few Dockets with no transactions, and the Billing Memo report is simply printing a 'blank' page for them. These are spread amongst the other Dockets that do have billable amounts.

Regards,
Softrak Support


Top
#1812 - 12/28/01 12:05 PM Re: Inaccurate WIP reports
Anonymous
Unregistered


Thanks, I found the entries - they were items that were never final billed cause they were entered as the year 1911!!

Top


Moderator:  Christa_Meissner 
Who's Online
0 registered (), 69 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14467 Topics
70661 Posts

Max Online: 432 @ 01/20/25 10:17 PM
April
Su M Tu W Th F Sa
1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30