Welcome, Guest. Please Login.
05/03/24 at 08:03:06
News:
Home Help Search Login


Pages: 1
Send Topic Print
Duplicate record in Balance Sheet (Read 1003 times)
JamesO
Member
**




Posts: 66
Duplicate record in Balance Sheet
09/08/20 at 13:32:49
 
We have a duplicate record on our balance sheet. That is throwing the balance off by the Duplicate amount.
How can I remove the duplicate entry? Maintain DB? what database?
 
Thank you,
Jim O.
Back to top
 
 
  IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5681
Re: Duplicate record in Balance Sheet
Reply #1 - 09/08/20 at 15:51:10
 
Probably BKGLCOA is the file with the duplicate.
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
JamesO
Member
**




Posts: 66
Re: Duplicate record in Balance Sheet
Reply #2 - 09/09/20 at 10:52:54
 
Lynn, I just checked the BKGLCOA as you suggested, but the duplicate was not there. I did see a GL account that it is within in BKGLCOA 1290000  (Inventory-Raw Material) That is the GL description. What next??
 
Thank you,
Jimmy O.
Back to top
 
 
  IP Logged
gtladmin
Active Member
*****


Diving is fun,
diving is fun!

Posts: 1306
Gender: female
Re: Duplicate record in Balance Sheet
Reply #3 - 12/22/20 at 10:42:17
 
I am picking up this outstanding issue.  
 
Finance thinks it may be due to a double receipt, but in looking at the related part # the transactions all are ok, PO line receipts look fine (the PO is  
already closed).  IN-A appears to be correct too.  So not entirely sure where the duplicate amount of 820.00line in the Purchases receipt report (below) for this part is coming from. It is a Credit amount for the same part, showing up twice.  Sooooo....where to look to fix this?
 
9/8/2020 1 Page :   <company name>
                 Purchases
Trans Date Cust/Vend Cd Reference Description GL Account GL Description Debit Amount Credit Amount
 
08/24/20 <vend-code> 20339  HP, ILLUMALED CC 12900000 INVENTORY-RAW MATERIAL                         820.00
08/24/20 <vend-code> 20339  HP, ILLUMALED CC 12900000 INVENTORY-RAW MATERIAL                         820.00
08/24/20 <vend-code> 20339  HP H/S EXTRUS,BLACK 12900000 INVENTORY-RAW MATERIAL                   377.44
08/24/20 <vend-code> 20339  END CAPS .75" (BLK) 12900000 INVENTORY-RAW MATERIAL                           919.19
08/24/20 <vend-code> 20339  LEXAN LENS W/BLACK SP 23 12900000 INVENTORY-RAW MATERIAL           168.40
08/24/20 <vend-code> 20339  SCREW 4-40X1 FH PHILLIPS12900000 INVENTORY-RAW MATERIAL                     11.76
08/24/20 <vend-code> 20339  ILTLED01 BACK LABEL 12900000 INVENTORY-RAW MATERIAL                       2.78
08/24/20 <vend-code> 20339  20 AWG BLACK/WHITE ZIP 12900000 INVENTORY-RAW MATERIAL                     15.73
08/24/20 <vend-code> 20339  LED "Z" SPREADER SPACER12900000 INVENTORY-RAW MATERIAL                     86.14
08/24/20 <vend-code> 20339  30"A ILLUMALED BOX 12900000 INVENTORY-RAW MATERIAL                             64.99
08/24/20 <vend-code> 20339  30"B ILLUMALED BOX 12900000 INVENTORY-RAW MATERIAL                             65.02
08/24/20 <vend-code> 20339  HP OSRAM BLACK PWDCT 48" 12900000 INVENTORY-RAW MATERIAL 2,676.45  
08/24/20 <vend-code> 20339  ACCRUED FREIGHT IN 12400000 INVENTORY-FINISHED GOODS              4.35  
08/24/20 <vend-code> 20339  ACCRUED FREIGHT IN 43360000 ABSORBED FREIGHT-IN                             4.35
08/24/20 <vend-code> 20339  RECEIVED/NOT INVOICED 20230000 PO'S REC'D NOT INVOICED                    145.00
Net Transactions:                                                                                                         2,680.80 3,500.80
Back to top
 
 

Val Feehan
  IP Logged
gtladmin
Active Member
*****


Diving is fun,
diving is fun!

Posts: 1306
Gender: female
Re: Duplicate record in Balance Sheet
Reply #4 - 12/22/20 at 12:36:01
 
So I had Walter verify my findings, there is no duplicate receipt, inventory is correct, transactions are correct, etc.  It seems to be that this "duplicate" $820.00 only appears when Finance runs GL-D.  So is this likely something showing up twice in the GL trans table?  Holly says things like this would normally get flagged and she would not be allowed to post but she'd have to go in and fix with GL-P  and then could post.  But this is now in a past period.....  
 
Val
Back to top
 
 

Val Feehan
  IP Logged
gtladmin
Active Member
*****


Diving is fun,
diving is fun!

Posts: 1306
Gender: female
Re: Duplicate record in Balance Sheet
Reply #5 - 12/22/20 at 15:23:42
 
One more update:
 
I did take a look at the BKGLTRANS table and I do see two records for the $820.00 entry on the same date, same PO, at the same time by the same user and both are BKGL.TRN.DC "C" entries.  This matches with the report Holly runs.
 
So IF this is the only place this exists, do we just delete the record, or does Holly have to do something else to fix this over stated inventory issue?
 
Kind regards,
 
Val
Back to top
 
 

Val Feehan
  IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5681
Re: Duplicate record in Balance Sheet
Reply #6 - 12/24/20 at 12:13:22
 
You may also need to run UT-K-D on the account if GL-A also is overstated.
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
gtladmin
Active Member
*****


Diving is fun,
diving is fun!

Posts: 1306
Gender: female
Re: Duplicate record in Balance Sheet
Reply #7 - 12/25/20 at 10:19:59
 
Thanks, Lynn.  
 
I'll remove the dupe and ask Holly to check GL-A and run UT-K-D if necessary.
 
Merry Christmas!
 
Val
Back to top
 
 

Val Feehan
  IP Logged
Pages: 1
Send Topic Print