ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Accounting >> Duplicate record in Balance Sheet
http://www.istechforum.com/YaBB.pl?num=1599597169

Message started by JamesO on 09/08/20 at 13:32:49

Title: Duplicate record in Balance Sheet
Post by JamesO on 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.

Title: Re: Duplicate record in Balance Sheet
Post by Lynn_Pantic on 09/08/20 at 15:51:10

Probably BKGLCOA is the file with the duplicate.

Title: Re: Duplicate record in Balance Sheet
Post by JamesO on 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.

Title: Re: Duplicate record in Balance Sheet
Post by gtladmin on 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

Title: Re: Duplicate record in Balance Sheet
Post by gtladmin on 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

Title: Re: Duplicate record in Balance Sheet
Post by gtladmin on 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

Title: Re: Duplicate record in Balance Sheet
Post by Lynn_Pantic on 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.

Title: Re: Duplicate record in Balance Sheet
Post by gtladmin on 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