Topic Options
#1220 - 07/11/01 12:49 PM Re: Problems in posting to GL from TBR
Softrak Support Offline

Adagio Action Team

Registered: 03/09/99
Posts: 11616
Loc: Vancouver, BC Canada
Hello Mary

Basically, these errors are being returned by G/L, not TBR. However...

Did you change anything in the way you process your TBR transactions (or in the GL) that could have affected this batch? Did you have a system failure or power outage during the posting of the TBR batches? (Normally this would show up in the Data Integrity Check, but not always) If not -

1) After retrieving the TBR subledger batch into your GL, did you post it right away (when prompted during the retrieval process) or did you print the batch listing first, then post using the Batch processing area in GL? Did you notice if the batch balanced on the print out?

In TBR, did you get any error messages during the posting of those batches? Did all entries balance at that time?

2) "Source code does not exist" error is returned in GL when either there is no source code entered in the batch, or the source code entered does not match any in the GL Housekeeping - Source code maintenance area. Was a source code removed from this area, yet the batch contained the old source code?

3) Ok, this a G/L support question - not TBR. Since the entries are now in GL, you must use GL's methods to "fix" it.

Otherwise, the only other option would be to restore your TBR and GL data from a recently made backup (if you have one). If you decide to do this, then afterwareds you should check the entries in the TBR batches before posting them to ensure all entries balance and are valid for the fiscal period, then in GL you should ensure that all source codes required in fact exist in GL before you finally post the batches in TBR.

What version & release date of TBR are you using? What version of G/L and Windowing System Manager? The version of G/L you are using would determine what you should have toggled in the G/L Feed & G/L 6.1 Interface option. If you are using V6.1 or higher, then you should have this set to "Y" - if using 6.0 or earlier, this should be set to "N". Checking this option AFTER posting your TBR batches will not help - it MUST be toggled before posting any batches in TBR (could it have been inadvertently changed in error?) If not then this is not a concern and is unrelated to this issue.

As a footnote, I cannot look at your data unless you are on a current technical support plan. You can contact our Customer Service Department if you are interested (604) 736-3741 or customerservice@softrak.com - but having your data at this point would not be helpful unless you have checked all the areas suggested above.

Hope this helps
Regards,

Softrak Support


Top
#1222 - 07/18/01 12:30 PM Re: Problems in posting to GL from TBR
Softrak Support Offline

Adagio Action Team

Registered: 03/09/99
Posts: 11616
Loc: Vancouver, BC Canada
Dear Mary

In response:

1) Thanks for the additional information.

2) The source codes used in TBR should not be confused with the GL source codes. They are used for different purposes within each program. During the retrival process in step 1, (just after having selected to retrieve - but before saying yes to Post), GL should display a window on the right side of your screen giving you information on the batch(es) being retrieved. It will tell you a) How many batches were created, b) How many entries in the batch, and c) The Debits and Credits totals. At this time, if you see that the batch(es) does not balance, you should say NO to posting, then you will be able to edit the created batch (if you have the option to edit retrieved batches enabled in your GL Housekeeping area) to correct any errors or enter missing information. (The first time a particular type of TBR batch is retrieved into GL, GL will prompt you for a GL source code. You must select one that already exists or you will have to exit out of this area and create a new one. Once you have selected a GL source code for that type of batch, GL will (should) remember it and you will not be prompted for it again.).

3) AP is a separate program (ie it does not come with TBR - it is an ACCPAC Plus core module). Again, before posting the AP batch, you should ensure that: a) "TBR" was selected as the transaction type for those invoices b) proper source code was entered. (As per page C-2 in your TBR Time & Billing Module manual). c) Print the AP batch and check it for errors before posting, then post it and go into TBR and retrieve it. You will still have a chance to go into this batch in TBR Time/Disbursement entry/edit and post area to check and/or modify your entries before posting the batch in TBR.

I do not know why the entries coming from AP have a missing "C" in the Source Code. If you are sure you entered it correctly in the AP Batch, then there could be something going on during the AP posting process to affect this. Have you done the data integrity on AP specifically (it was not clear what module you were speaking of in this regard)? Perhaps something occurred to damage a program file in either AP or TBR that could affect this process. Did anything occur 2 months ago (system crash - power outage etc) that could have done this?

If you have reinstalled AP or installed a ptf for AP, then you should re-install TBR. You may need assistance from your Dealer or someone who is responsible for this in your office. You must say "Y" when prompted if you want to install the AP interface during the reinstall of TBR. (All posting sequences in AP should be printed and cleared/purged before doing this! - and you should make a backup as well before proceeding!)

I do not know what else to suggest. You may need to call your ACCPAC Dealer for assistance to do more thorough troubleshooting.

Regards
Softrak Support


Top


Moderator:  Christa_Meissner 
Who's Online
0 registered (), 80 Guests and 1 Spider online.
Key: Admin, Global Mod, Mod
Forum Stats
1872 Members
5 Forums
14527 Topics
70937 Posts

Max Online: 432 @ 01/20/25 10:17 PM
August
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
31