ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Accounting >> AP-C has bug when it adds frt and tax
http://www.istechforum.com/YaBB.pl?num=1672457252

Message started by Laura Oliver on 12/30/22 at 20:27:32

Title: AP-C has bug when it adds frt and tax
Post by Laura Oliver on 12/30/22 at 20:27:32

Sometimes we end up missing a leg in GL-O after adding tax/frt to AP-C. We have had this happen several times. I now think it is a bug/

12/30/2022 BATCH TYPES: Cash Disbursements, Purchases Page : 1

From Date: 12/23/22 Thru Date: 12/25/22

Trans Dt Cus/Vnd Cd Reference Description G/L Account Dept G/L Description Debit Amount Credit Amount
12/23/22 AMAZON 212260 FUSES TR30R 30 AMP 70900 500 MAINTENANCE & REPAIR 53.00
12/23/22 AMAZON 212260 RECEIVED/NOT INVOICED 21900 999 PO'S REC. NOT INVOICED 53.00
Net Transaction     53.00 53.00

SP
12/24/22 AMAZON 112-2325041-7386619 AMAZON 22000 ACCTS PAYABLE TRADE    58.03
12/24/22 AMAZON 112-2325041-7386619 RNI/INVOICED   21900 999 PO'S REC. NOT INVOICED 53.00
   Net Transaction 53.00 58.03 ?????

12/25/22 AMAZON 18267 FUSES WALK IN OVEN 22000 ACCTS PAYABLE TRADE    58.03
12/25/22 AMAZON 18267 AMAZON 10400 0 VISA WCMA    58.03
   Net Transaction 58.03    58.03

Net Balance 3    164.03 169.06 ??????

12/30/2022 BATCH TYPES: Cash Disbursements, Purchases Page : 2

From Date: 12/23/22 Thru Date: 12/25/22
10400 0 VISA WCMA           0.00 58.03 <58.03>
21900 999 PO'S REC. NOT INVOICED 53.00 53.00    0.00
22000 ACCTS PAYABLE TRADE    58.03 58.03 0.00
70900 500 MAINTENANCE & REPAIR 53.00 0.00 53.00

Title: Re: AP-C has bug when it adds frt and tax
Post by Laura Oliver on 01/24/23 at 17:03:32

Tax dist distribution that occurs in AP-C does not always make it to GL-O and we are out of balance. Sometimes it works perfectly but other times it doesnt.
Any idea why this is happening.

for future reference: I “FIX” this by going into maintain database and scrolling down to the very bottom so I can add two new lines. I click edit at the top and then the black plus at the bottom and add the two new rows. I have to add a row for the GL account for the tax expense and a row for the Received not invoiced.

Title: Re: AP-C has bug when it adds frt and tax
Post by Laura Oliver on 10/06/23 at 09:12:25

I now believe this happens because the folks entering Purchase Orders (PO-A) will have the Purchase Order screen showing taxable YES but the Tax Group box iwas left empty. If the choice was made to make the PO taxable Y there has to do be a valid tax group in the next box on the header. If not the correspponding transaction created by AP-C is out of balance. So I have to go to BKGLTEMP and create a tax leg. (see red line below) so that GL-O balances

step 1 Received in
9/1/23 Lowes 309207 Recieved/Not Invoiced 21900-999 PO's rec not invoiced 00.00 70.70
9/1/23 Lowes 309207 1" pipe 70900-400 Maintenance & Repair 70.70 00.00

Step 2 AP-C
9/2/23 Lowes 96092697 Lowes Invoice #5 22000 Accounts Pay Trade 00.00 77.77
9/2/23 Lowes 96092697 Lowes 21900-999 PO's not received 70.77 00.00
9/2/23 Lowes 96092697 Lowes invoice tax 70900-400 Maintenance & Repair 7.07 00.00

Step3 write check
9/3/23 Lowes 42687 1" Pipe 22000 Accounts Pay Trade 77.77 0.00
9/3/23 Lowes 42687 Lowes 10100 Wells Fargo Bank acct 00.00 77.77