Sage 100

Client printed AP checks and updated the check registered.  They then realized that the check numbers did not match the register (off by one).  Used Manual Check Data Entry and voided all the checks.  Printed the register and updated.  Selected invoices to pay again but two of the invoices (previously paid on one check).  If they go into AP Payment Selection, they can highlight the invoices to be paid, but when printing the selection register, both invoices show as 0.00 balance.  A similar thing happens if attempting to post a manual check.  You can pick the invoices, and the balances show, but once selected, the invoice amount is zero.  I've checked that the Paid Today flag is not set on these invoices in AP_Open.  Any ideas are welcome.

------------------------------
Kathryn Scofield
STA Network Accounting Systems
------------------------------

You can verify the balance (and adjust) in the Open Invoice table.  I normally just tell folks to manually enter the amount, if they are certain that the amount correct, and continue to process the payment.

------------------------------
Michelle Taylor
ERP Consulting Manager, CS3 Technology
918-388-9772
------------------------------

I tried that.  It let me fill in the invoice amount in Manual Check Entry but the Payment amount was blank on the second tab.  I tried changing that but it keeps resetting to zero.

------------------------------
Kathryn Scofield
STA Network Accounting Systems
------------------------------

Original Message:
Sent: 10-01-2019 17:46
From: Michelle Taylor
Subject: AP Manual Check Entry for previously paid then check voided invoices

You can verify the balance (and adjust) in the Open Invoice table.  I normally just tell folks to manually enter the amount, if they are certain that the amount correct, and continue to process the payment.

------------------------------
Michelle Taylor
ERP Consulting Manager, CS3 Technology
918-388-9772
------------------------------

Are they using Job Cost?

------------------------------
Beth Bowers
Mom to Samson, Peanut, ChiChi, Canton, Cagney and Daisy (NO Oxford comma - shriek!)
Beth Bowers
269-445-1625
------------------------------

Original Message:
Sent: 10-01-2019 17:49
From: Kathryn Scofield
Subject: AP Manual Check Entry for previously paid then check voided invoices

I tried that.  It let me fill in the invoice amount in Manual Check Entry but the Payment amount was blank on the second tab.  I tried changing that but it keeps resetting to zero.

------------------------------
Kathryn Scofield
STA Network Accounting Systems
------------------------------


Original Message:
Sent: 10-01-2019 17:46
From: Michelle Taylor
Subject: AP Manual Check Entry for previously paid then check voided invoices

You can verify the balance (and adjust) in the Open Invoice table.  I normally just tell folks to manually enter the amount, if they are certain that the amount correct, and continue to process the payment.

------------------------------
Michelle Taylor
ERP Consulting Manager, CS3 Technology
918-388-9772

Yes, they use JC but these particular invoices are not charged to jobs, just GL accounts.

------------------------------
Kathryn Scofield
STA Network Accounting Systems
------------------------------

Original Message:
Sent: 10-01-2019 17:51
From: Beth Bowers
Subject: AP Manual Check Entry for previously paid then check voided invoices

Are they using Job Cost?

------------------------------
Beth Bowers
Mom to Samson, Peanut, ChiChi, Canton, Cagney and Daisy (NO Oxford comma - shriek!)
Beth Bowers
269-445-1625
------------------------------


Original Message:
Sent: 10-01-2019 17:49
From: Kathryn Scofield
Subject: AP Manual Check Entry for previously paid then check voided invoices

I tried that.  It let me fill in the invoice amount in Manual Check Entry but the Payment amount was blank on the second tab.  I tried changing that but it keeps resetting to zero.

------------------------------
Kathryn Scofield
STA Network Accounting Systems


Original Message:
Sent: 10-01-2019 17:46
From: Michelle Taylor
Subject: AP Manual Check Entry for previously paid then check voided invoices

You can verify the balance (and adjust) in the Open Invoice table.  I normally just tell folks to manually enter the amount, if they are certain that the amount correct, and continue to process the payment.

------------------------------
Michelle Taylor
ERP Consulting Manager, CS3 Technology
918-388-9772

I would still check the AP_JobDistributionDetail file - I've found line items in there before with no jobs (which may be how it's supposed to be)

------------------------------
Beth Bowers
Mom to Samson, Peanut, ChiChi, Canton, Cagney and Daisy (NO Oxford comma - shriek!)
Beth Bowers
269-445-1625
------------------------------

Original Message:
Sent: 10-01-2019 17:54
From: Kathryn Scofield
Subject: AP Manual Check Entry for previously paid then check voided invoices

Yes, they use JC but these particular invoices are not charged to jobs, just GL accounts.

------------------------------
Kathryn Scofield
STA Network Accounting Systems
------------------------------


Original Message:
Sent: 10-01-2019 17:51
From: Beth Bowers
Subject: AP Manual Check Entry for previously paid then check voided invoices

Are they using Job Cost?

------------------------------
Beth Bowers
Mom to Samson, Peanut, ChiChi, Canton, Cagney and Daisy (NO Oxford comma - shriek!)
Beth Bowers
269-445-1625


Original Message:
Sent: 10-01-2019 17:49
From: Kathryn Scofield
Subject: AP Manual Check Entry for previously paid then check voided invoices

I tried that.  It let me fill in the invoice amount in Manual Check Entry but the Payment amount was blank on the second tab.  I tried changing that but it keeps resetting to zero.

------------------------------
Kathryn Scofield
STA Network Accounting Systems


Original Message:
Sent: 10-01-2019 17:46
From: Michelle Taylor
Subject: AP Manual Check Entry for previously paid then check voided invoices

You can verify the balance (and adjust) in the Open Invoice table.  I normally just tell folks to manually enter the amount, if they are certain that the amount correct, and continue to process the payment.

------------------------------
Michelle Taylor
ERP Consulting Manager, CS3 Technology
918-388-9772

On Hold?

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
Toronto ON
------------------------------

Original Message:
Sent: 10-01-2019 17:49
From: Kathryn Scofield
Subject: AP Manual Check Entry for previously paid then check voided invoices

I tried that.  It let me fill in the invoice amount in Manual Check Entry but the Payment amount was blank on the second tab.  I tried changing that but it keeps resetting to zero.

------------------------------
Kathryn Scofield
STA Network Accounting Systems
------------------------------


Original Message:
Sent: 10-01-2019 17:46
From: Michelle Taylor
Subject: AP Manual Check Entry for previously paid then check voided invoices

You can verify the balance (and adjust) in the Open Invoice table.  I normally just tell folks to manually enter the amount, if they are certain that the amount correct, and continue to process the payment.

------------------------------
Michelle Taylor
ERP Consulting Manager, CS3 Technology
918-388-9772

Nope, not on hold.

------------------------------
Kathryn Scofield
STA Network Accounting Systems
------------------------------

Original Message:
Sent: 10-01-2019 17:51
From: Kevin Moyes
Subject: AP Manual Check Entry for previously paid then check voided invoices

On Hold?

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
Toronto ON
------------------------------


Original Message:
Sent: 10-01-2019 17:49
From: Kathryn Scofield
Subject: AP Manual Check Entry for previously paid then check voided invoices

I tried that.  It let me fill in the invoice amount in Manual Check Entry but the Payment amount was blank on the second tab.  I tried changing that but it keeps resetting to zero.

------------------------------
Kathryn Scofield
STA Network Accounting Systems


Original Message:
Sent: 10-01-2019 17:46
From: Michelle Taylor
Subject: AP Manual Check Entry for previously paid then check voided invoices

You can verify the balance (and adjust) in the Open Invoice table.  I normally just tell folks to manually enter the amount, if they are certain that the amount correct, and continue to process the payment.

------------------------------
Michelle Taylor
ERP Consulting Manager, CS3 Technology
918-388-9772

In the Open Invoice file, is the Paid Today flag set to Y ?

------------------------------
Lee Graham
Friendly Systems, Inc.
------------------------------

Original Message:
Sent: 10-01-2019 17:54
From: Kathryn Scofield
Subject: AP Manual Check Entry for previously paid then check voided invoices

Nope, not on hold.

------------------------------
Kathryn Scofield
STA Network Accounting Systems
------------------------------


Original Message:
Sent: 10-01-2019 17:51
From: Kevin Moyes
Subject: AP Manual Check Entry for previously paid then check voided invoices

On Hold?

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
Toronto ON


Original Message:
Sent: 10-01-2019 17:49
From: Kathryn Scofield
Subject: AP Manual Check Entry for previously paid then check voided invoices

I tried that.  It let me fill in the invoice amount in Manual Check Entry but the Payment amount was blank on the second tab.  I tried changing that but it keeps resetting to zero.

------------------------------
Kathryn Scofield
STA Network Accounting Systems


Original Message:
Sent: 10-01-2019 17:46
From: Michelle Taylor
Subject: AP Manual Check Entry for previously paid then check voided invoices

You can verify the balance (and adjust) in the Open Invoice table.  I normally just tell folks to manually enter the amount, if they are certain that the amount correct, and continue to process the payment.

------------------------------
Michelle Taylor
ERP Consulting Manager, CS3 Technology
918-388-9772

The Paid Today flag/amount should reset to zero at midnight, so if you try it this morning it might just work.

------Original Message------

In the Open Invoice file, is the Paid Today flag set to Y ?

------------------------------
Lee Graham
Friendly Systems, Inc.
------------------------------

Nope.  That was the first thing I checked.

------------------------------
Kathryn Scofield
STA Network Accounting Systems
------------------------------

Original Message:
Sent: 10-02-2019 10:41
From: Lee Graham
Subject: AP Manual Check Entry for previously paid then check voided invoices

In the Open Invoice file, is the Paid Today flag set to Y ?

------------------------------
Lee Graham
Friendly Systems, Inc.
------------------------------


Original Message:
Sent: 10-01-2019 17:54
From: Kathryn Scofield
Subject: AP Manual Check Entry for previously paid then check voided invoices

Nope, not on hold.

------------------------------
Kathryn Scofield
STA Network Accounting Systems


Original Message:
Sent: 10-01-2019 17:51
From: Kevin Moyes
Subject: AP Manual Check Entry for previously paid then check voided invoices

On Hold?

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
Toronto ON


Original Message:
Sent: 10-01-2019 17:49
From: Kathryn Scofield
Subject: AP Manual Check Entry for previously paid then check voided invoices

I tried that.  It let me fill in the invoice amount in Manual Check Entry but the Payment amount was blank on the second tab.  I tried changing that but it keeps resetting to zero.

------------------------------
Kathryn Scofield
STA Network Accounting Systems


Original Message:
Sent: 10-01-2019 17:46
From: Michelle Taylor
Subject: AP Manual Check Entry for previously paid then check voided invoices

You can verify the balance (and adjust) in the Open Invoice table.  I normally just tell folks to manually enter the amount, if they are certain that the amount correct, and continue to process the payment.

------------------------------
Michelle Taylor
ERP Consulting Manager, CS3 Technology
918-388-9772