Sage 100

Error: Cannot select invoices or "Invoice Already Being Paid" or "The invoice balance was exceeded" in Cash Receipts Entry or the balance for an invoice is showing zero or incorrect
Has anyone ever figured out what exactly causes this issue?  have not been able to figure out a series of events that leaves the record as being paid.  Seems to happen with certain customers so it must be an operator-created issue.  would like to be able to tell them what to STOP DOING.  :)

------------------------------
alan niergarth
Velosio LLC
------------------------------

I was determined to figure it out one time and even rebooted my machine in the middle of a Cash Receipts Entry, but no go.  I think they choose to pay an invoice and then unselect it in some way that Sage misses clearing the flag.

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

I've seen it happen where the entire Cash Receipt Deposit entry gets deleted.  I always tell them to delete the individual invoices before deleting the deposit.  Either it stops happening or they just ignore the warning and keep entering, because I don't get many repeat calls from the same user.

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

Original Message:
Sent: 04-24-2020 16:30
From: Beth Bowers
Subject: Cause for this recurring issue with some clients - AR Cash Receipts

I was determined to figure it out one time and even rebooted my machine in the middle of a Cash Receipts Entry, but no go.  I think they choose to pay an invoice and then unselect it in some way that Sage misses clearing the flag.

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

I had 2 within an hour once...(same client)

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

Original Message:
Sent: 04-24-2020 16:43
From: Michelle Taylor
Subject: Cause for this recurring issue with some clients - AR Cash Receipts

I've seen it happen where the entire Cash Receipt Deposit entry gets deleted.  I always tell them to delete the individual invoices before deleting the deposit.  Either it stops happening or they just ignore the warning and keep entering, because I don't get many repeat calls from the same user.

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


Original Message:
Sent: 04-24-2020 16:30
From: Beth Bowers
Subject: Cause for this recurring issue with some clients - AR Cash Receipts

I was determined to figure it out one time and even rebooted my machine in the middle of a Cash Receipts Entry, but no go.  I think they choose to pay an invoice and then unselect it in some way that Sage misses clearing the flag.

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

I add the attached simple Crystal report to the menu and ask the customer to run it once a month.  It helps reduce the frustration level of the cash receipts data entry person.  One of my customers calls them "ghost posts", so I name the report, "The Ghost Post Report".

------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Assistant to the Traveling Secretary
------------------------------

Interesting.  What does the client do with the information?

------------------------------
Jeff Schwenk
FORMER 90M Board Member
Bottomline Software, Inc.
Waynesboro VA
540-221-4444
------------------------------

Original Message:
Sent: 04-25-2020 08:13
From: Doug Higgs
Subject: Cause for this recurring issue with some clients - AR Cash Receipts

I add the attached simple Crystal report to the menu and ask the customer to run it once a month.  It helps reduce the frustration level of the cash receipts data entry person.  One of my customers calls them "ghost posts", so I name the report, "The Ghost Post Report".

------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Assistant to the Traveling Secretary
------------------------------

They send me an email once a month with a pdf of the report and I dfdm to fix.

------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Assistant to the Traveling Secretary
------------------------------

Original Message:
Sent: 04-25-2020 10:33
From: Jeff Schwenk
Subject: Cause for this recurring issue with some clients - AR Cash Receipts

Interesting.  What does the client do with the information?

------------------------------
Jeff Schwenk
FORMER 90M Board Member
Bottomline Software, Inc.
Waynesboro VA
540-221-4444
------------------------------


Original Message:
Sent: 04-25-2020 08:13
From: Doug Higgs
Subject: Cause for this recurring issue with some clients - AR Cash Receipts

I add the attached simple Crystal report to the menu and ask the customer to run it once a month.  It helps reduce the frustration level of the cash receipts data entry person.  One of my customers calls them "ghost posts", so I name the report, "The Ghost Post Report".

------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Assistant to the Traveling Secretary

Try the tried and true - File | Run | ARWAR4 next time.  Little faster.  Since you value add, they won't know the difference,

------------------------------
Jeff Schwenk
FORMER 90M Board Member
Bottomline Software, Inc.
Waynesboro VA
540-221-4444
------------------------------

Original Message:
Sent: 04-25-2020 11:29
From: Doug Higgs
Subject: Cause for this recurring issue with some clients - AR Cash Receipts

They send me an email once a month with a pdf of the report and I dfdm to fix.

------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Assistant to the Traveling Secretary
------------------------------


Original Message:
Sent: 04-25-2020 10:33
From: Jeff Schwenk
Subject: Cause for this recurring issue with some clients - AR Cash Receipts

Interesting.  What does the client do with the information?

------------------------------
Jeff Schwenk
FORMER 90M Board Member
Bottomline Software, Inc.
Waynesboro VA
540-221-4444


Original Message:
Sent: 04-25-2020 08:13
From: Doug Higgs
Subject: Cause for this recurring issue with some clients - AR Cash Receipts

I add the attached simple Crystal report to the menu and ask the customer to run it once a month.  It helps reduce the frustration level of the cash receipts data entry person.  One of my customers calls them "ghost posts", so I name the report, "The Ghost Post Report".

------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Assistant to the Traveling Secretary

Thanks @Jeff Schwenk ​​​

------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Assistant to the Traveling Secretary
------------------------------

Original Message:
Sent: 04-25-2020 13:09
From: Jeff Schwenk
Subject: Cause for this recurring issue with some clients - AR Cash Receipts

Try the tried and true - File | Run | ARWAR4 next time.  Little faster.  Since you value add, they won't know the difference,

------------------------------
Jeff Schwenk
FORMER 90M Board Member
Bottomline Software, Inc.
Waynesboro VA
540-221-4444
------------------------------


Original Message:
Sent: 04-25-2020 11:29
From: Doug Higgs
Subject: Cause for this recurring issue with some clients - AR Cash Receipts

They send me an email once a month with a pdf of the report and I dfdm to fix.

------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Assistant to the Traveling Secretary


Original Message:
Sent: 04-25-2020 10:33
From: Jeff Schwenk
Subject: Cause for this recurring issue with some clients - AR Cash Receipts

Interesting.  What does the client do with the information?

------------------------------
Jeff Schwenk
FORMER 90M Board Member
Bottomline Software, Inc.
Waynesboro VA
540-221-4444


Original Message:
Sent: 04-25-2020 08:13
From: Doug Higgs
Subject: Cause for this recurring issue with some clients - AR Cash Receipts

I add the attached simple Crystal report to the menu and ask the customer to run it once a month.  It helps reduce the frustration level of the cash receipts data entry person.  One of my customers calls them "ghost posts", so I name the report, "The Ghost Post Report".

------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Assistant to the Traveling Secretary

@Jeff Schwenk  the one customer that emails the list of "ghost posts" each month has four different Sage 100 companies and users from all over the country logged in.  Each month there are between 5 and 10 invoices that need the payments today flag cleared.  Running ARWAR4 is a great idea, however, it requires all users to be out of cash receipts entry, which most of the time would require kicking out users.  It's easier to spend 5 minutes dfdm-ing it and being done with it.

------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Assistant to the Traveling Secretary
------------------------------

Original Message:
Sent: 04-25-2020 13:09
From: Jeff Schwenk
Subject: Cause for this recurring issue with some clients - AR Cash Receipts

Try the tried and true - File | Run | ARWAR4 next time.  Little faster.  Since you value add, they won't know the difference,

------------------------------
Jeff Schwenk
FORMER 90M Board Member
Bottomline Software, Inc.
Waynesboro VA
540-221-4444
------------------------------


Original Message:
Sent: 04-25-2020 11:29
From: Doug Higgs
Subject: Cause for this recurring issue with some clients - AR Cash Receipts

They send me an email once a month with a pdf of the report and I dfdm to fix.

------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Assistant to the Traveling Secretary


Original Message:
Sent: 04-25-2020 10:33
From: Jeff Schwenk
Subject: Cause for this recurring issue with some clients - AR Cash Receipts

Interesting.  What does the client do with the information?

------------------------------
Jeff Schwenk
FORMER 90M Board Member
Bottomline Software, Inc.
Waynesboro VA
540-221-4444


Original Message:
Sent: 04-25-2020 08:13
From: Doug Higgs
Subject: Cause for this recurring issue with some clients - AR Cash Receipts

I add the attached simple Crystal report to the menu and ask the customer to run it once a month.  It helps reduce the frustration level of the cash receipts data entry person.  One of my customers calls them "ghost posts", so I name the report, "The Ghost Post Report".

------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Assistant to the Traveling Secretary

@Doug Higgs Love it.  the "Ghost Post Report".  This seems like an issue Sage has just swept under the rug.  Ignore it and it will go away.

------------------------------
alan niergarth
Velosio LLC
------------------------------

Original Message:
Sent: 04-25-2020 08:13
From: Doug Higgs
Subject: Cause for this recurring issue with some clients - AR Cash Receipts

I add the attached simple Crystal report to the menu and ask the customer to run it once a month.  It helps reduce the frustration level of the cash receipts data entry person.  One of my customers calls them "ghost posts", so I name the report, "The Ghost Post Report".

------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Assistant to the Traveling Secretary
------------------------------

We see this issue all the time. Right now the leading theory on this is that the PaymentsToday value is updated in AR_OpenInvoice before the Cash Receipt entry is accepted. Then the user either exits the cash receipt entry without accepting it, or their network connection to the Sage server is interrupted and they receive an error that forces them to get out of Sage and log back in. When they go back in, the last Cash Receipts batch they entered is there, but the entry they were working on needs to be re-entered because it was not accepted/saved. When they go to apply the cash, the PaymentsToday value in AR_OpenInvoice reflects the amount entered just before they were forced out of C/R data entry, so they cannot enter a value.

The solution for this is to go into the AR_OpenInvoice table in Datafile Display and Maintenance and reset to the PaymentsToday value to zero.

------------------------------
Raymond Westcott
MBSG
------------------------------

I was thinking I may have missed the memo on this issue.  Apparently not.  Looks like we've all become well versed in the use of DFDM to easily fix the issue.  ARWAR4 is great if you can kick everyone out but quicker usually to fix the record. @Raymond Westcott your explanation seems likely, also @michelle taylor deleting the whole deposit may also be a trigger.  That should be able to be tested.  ​​

------------------------------
alan niergarth
Velosio LLC
------------------------------

Original Message:
Sent: 04-25-2020 13:58
From: Raymond Westcott
Subject: Cause for this recurring issue with some clients - AR Cash Receipts

We see this issue all the time. Right now the leading theory on this is that the PaymentsToday value is updated in AR_OpenInvoice before the Cash Receipt entry is accepted. Then the user either exits the cash receipt entry without accepting it, or their network connection to the Sage server is interrupted and they receive an error that forces them to get out of Sage and log back in. When they go back in, the last Cash Receipts batch they entered is there, but the entry they were working on needs to be re-entered because it was not accepted/saved. When they go to apply the cash, the PaymentsToday value in AR_OpenInvoice reflects the amount entered just before they were forced out of C/R data entry, so they cannot enter a value.

The solution for this is to go into the AR_OpenInvoice table in Datafile Display and Maintenance and reset to the PaymentsToday value to zero.

------------------------------
Raymond Westcott
MBSG
------------------------------

You also can just manually put in the invoice and the Amount Posted and the balance will post fine if you can't get to DFDM or the utility quickly.

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

Original Message:
Sent: 04-27-2020 08:30
From: alan niergarth
Subject: Cause for this recurring issue with some clients - AR Cash Receipts

I was thinking I may have missed the memo on this issue.  Apparently not.  Looks like we've all become well versed in the use of DFDM to easily fix the issue.  ARWAR4 is great if you can kick everyone out but quicker usually to fix the record. @Raymond Westcott your explanation seems likely, also @michelle taylor deleting the whole deposit may also be a trigger.  That should be able to be tested.  ​​

------------------------------
alan niergarth
Velosio LLC
------------------------------


Original Message:
Sent: 04-25-2020 13:58
From: Raymond Westcott
Subject: Cause for this recurring issue with some clients - AR Cash Receipts

We see this issue all the time. Right now the leading theory on this is that the PaymentsToday value is updated in AR_OpenInvoice before the Cash Receipt entry is accepted. Then the user either exits the cash receipt entry without accepting it, or their network connection to the Sage server is interrupted and they receive an error that forces them to get out of Sage and log back in. When they go back in, the last Cash Receipts batch they entered is there, but the entry they were working on needs to be re-entered because it was not accepted/saved. When they go to apply the cash, the PaymentsToday value in AR_OpenInvoice reflects the amount entered just before they were forced out of C/R data entry, so they cannot enter a value.

The solution for this is to go into the AR_OpenInvoice table in Datafile Display and Maintenance and reset to the PaymentsToday value to zero.

------------------------------
Raymond Westcott
MBSG

@Beth Bowers​ thanks for that tip.  I did not know you could override the issue with a manual entry of the invoice and amount!

------------------------------
alan niergarth
Velosio LLC
------------------------------

Original Message:
Sent: 04-27-2020 08:35
From: Beth Bowers
Subject: Cause for this recurring issue with some clients - AR Cash Receipts

You also can just manually put in the invoice and the Amount Posted and the balance will post fine if you can't get to DFDM or the utility quickly.

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


Original Message:
Sent: 04-27-2020 08:30
From: alan niergarth
Subject: Cause for this recurring issue with some clients - AR Cash Receipts

I was thinking I may have missed the memo on this issue.  Apparently not.  Looks like we've all become well versed in the use of DFDM to easily fix the issue.  ARWAR4 is great if you can kick everyone out but quicker usually to fix the record. @Raymond Westcott your explanation seems likely, also @michelle taylor deleting the whole deposit may also be a trigger.  That should be able to be tested.  ​​

------------------------------
alan niergarth
Velosio LLC


Original Message:
Sent: 04-25-2020 13:58
From: Raymond Westcott
Subject: Cause for this recurring issue with some clients - AR Cash Receipts

We see this issue all the time. Right now the leading theory on this is that the PaymentsToday value is updated in AR_OpenInvoice before the Cash Receipt entry is accepted. Then the user either exits the cash receipt entry without accepting it, or their network connection to the Sage server is interrupted and they receive an error that forces them to get out of Sage and log back in. When they go back in, the last Cash Receipts batch they entered is there, but the entry they were working on needs to be re-entered because it was not accepted/saved. When they go to apply the cash, the PaymentsToday value in AR_OpenInvoice reflects the amount entered just before they were forced out of C/R data entry, so they cannot enter a value.

The solution for this is to go into the AR_OpenInvoice table in Datafile Display and Maintenance and reset to the PaymentsToday value to zero.

------------------------------
Raymond Westcott
MBSG

@alan niergarth - I know all the "lazy" tips...  :-)​

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

Original Message:
Sent: 04-27-2020 09:09
From: alan niergarth
Subject: Cause for this recurring issue with some clients - AR Cash Receipts

@Beth Bowers​ thanks for that tip.  I did not know you could override the issue with a manual entry of the invoice and amount!

------------------------------
alan niergarth
Velosio LLC
------------------------------


Original Message:
Sent: 04-27-2020 08:35
From: Beth Bowers
Subject: Cause for this recurring issue with some clients - AR Cash Receipts

You also can just manually put in the invoice and the Amount Posted and the balance will post fine if you can't get to DFDM or the utility quickly.

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


Original Message:
Sent: 04-27-2020 08:30
From: alan niergarth
Subject: Cause for this recurring issue with some clients - AR Cash Receipts

I was thinking I may have missed the memo on this issue.  Apparently not.  Looks like we've all become well versed in the use of DFDM to easily fix the issue.  ARWAR4 is great if you can kick everyone out but quicker usually to fix the record. @Raymond Westcott your explanation seems likely, also @michelle taylor deleting the whole deposit may also be a trigger.  That should be able to be tested.  ​​

------------------------------
alan niergarth
Velosio LLC


Original Message:
Sent: 04-25-2020 13:58
From: Raymond Westcott
Subject: Cause for this recurring issue with some clients - AR Cash Receipts

We see this issue all the time. Right now the leading theory on this is that the PaymentsToday value is updated in AR_OpenInvoice before the Cash Receipt entry is accepted. Then the user either exits the cash receipt entry without accepting it, or their network connection to the Sage server is interrupted and they receive an error that forces them to get out of Sage and log back in. When they go back in, the last Cash Receipts batch they entered is there, but the entry they were working on needs to be re-entered because it was not accepted/saved. When they go to apply the cash, the PaymentsToday value in AR_OpenInvoice reflects the amount entered just before they were forced out of C/R data entry, so they cannot enter a value.

The solution for this is to go into the AR_OpenInvoice table in Datafile Display and Maintenance and reset to the PaymentsToday value to zero.

------------------------------
Raymond Westcott
MBSG

Lazy is just another way of "Working Smart, Not Hard".....

------------------------------
Jeff Schwenk
FORMER 90M Board Member
Bottomline Software, Inc.
Waynesboro VA
540-221-4444
------------------------------

Original Message:
Sent: 04-27-2020 09:15
From: Beth Bowers
Subject: Cause for this recurring issue with some clients - AR Cash Receipts

@alan niergarth - I know all the "lazy" tips...  :-)​

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


Original Message:
Sent: 04-27-2020 09:09
From: alan niergarth
Subject: Cause for this recurring issue with some clients - AR Cash Receipts

@Beth Bowers​ thanks for that tip.  I did not know you could override the issue with a manual entry of the invoice and amount!

------------------------------
alan niergarth
Velosio LLC


Original Message:
Sent: 04-27-2020 08:35
From: Beth Bowers
Subject: Cause for this recurring issue with some clients - AR Cash Receipts

You also can just manually put in the invoice and the Amount Posted and the balance will post fine if you can't get to DFDM or the utility quickly.

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


Original Message:
Sent: 04-27-2020 08:30
From: alan niergarth
Subject: Cause for this recurring issue with some clients - AR Cash Receipts

I was thinking I may have missed the memo on this issue.  Apparently not.  Looks like we've all become well versed in the use of DFDM to easily fix the issue.  ARWAR4 is great if you can kick everyone out but quicker usually to fix the record. @Raymond Westcott your explanation seems likely, also @michelle taylor deleting the whole deposit may also be a trigger.  That should be able to be tested.  ​​

------------------------------
alan niergarth
Velosio LLC


Original Message:
Sent: 04-25-2020 13:58
From: Raymond Westcott
Subject: Cause for this recurring issue with some clients - AR Cash Receipts

We see this issue all the time. Right now the leading theory on this is that the PaymentsToday value is updated in AR_OpenInvoice before the Cash Receipt entry is accepted. Then the user either exits the cash receipt entry without accepting it, or their network connection to the Sage server is interrupted and they receive an error that forces them to get out of Sage and log back in. When they go back in, the last Cash Receipts batch they entered is there, but the entry they were working on needs to be re-entered because it was not accepted/saved. When they go to apply the cash, the PaymentsToday value in AR_OpenInvoice reflects the amount entered just before they were forced out of C/R data entry, so they cannot enter a value.

The solution for this is to go into the AR_OpenInvoice table in Datafile Display and Maintenance and reset to the PaymentsToday value to zero.

------------------------------
Raymond Westcott
MBSG

That is good to know!  We train customers in ARWAR4 but they complain about the need to get everyone out before they can run it. 

(We're working on a button script to fix things one customer at a time, which puts control in the user's hands... similar to an AP paid today reset script we have on file).

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

Original Message:
Sent: 04-27-2020 08:35
From: Beth Bowers
Subject: Cause for this recurring issue with some clients - AR Cash Receipts

You also can just manually put in the invoice and the Amount Posted and the balance will post fine if you can't get to DFDM or the utility quickly.

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


Original Message:
Sent: 04-27-2020 08:30
From: alan niergarth
Subject: Cause for this recurring issue with some clients - AR Cash Receipts

I was thinking I may have missed the memo on this issue.  Apparently not.  Looks like we've all become well versed in the use of DFDM to easily fix the issue.  ARWAR4 is great if you can kick everyone out but quicker usually to fix the record. @Raymond Westcott your explanation seems likely, also @michelle taylor deleting the whole deposit may also be a trigger.  That should be able to be tested.  ​​

------------------------------
alan niergarth
Velosio LLC


Original Message:
Sent: 04-25-2020 13:58
From: Raymond Westcott
Subject: Cause for this recurring issue with some clients - AR Cash Receipts

We see this issue all the time. Right now the leading theory on this is that the PaymentsToday value is updated in AR_OpenInvoice before the Cash Receipt entry is accepted. Then the user either exits the cash receipt entry without accepting it, or their network connection to the Sage server is interrupted and they receive an error that forces them to get out of Sage and log back in. When they go back in, the last Cash Receipts batch they entered is there, but the entry they were working on needs to be re-entered because it was not accepted/saved. When they go to apply the cash, the PaymentsToday value in AR_OpenInvoice reflects the amount entered just before they were forced out of C/R data entry, so they cannot enter a value.

The solution for this is to go into the AR_OpenInvoice table in Datafile Display and Maintenance and reset to the PaymentsToday value to zero.

------------------------------
Raymond Westcott
MBSG

@Beth Bowers you are blowing my mind right now! I can't believe that we've never tried that.​

------------------------------
Raymond Westcott
MBSG
------------------------------

Original Message:
Sent: 04-27-2020 08:35
From: Beth Bowers
Subject: Cause for this recurring issue with some clients - AR Cash Receipts

You also can just manually put in the invoice and the Amount Posted and the balance will post fine if you can't get to DFDM or the utility quickly.

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


Original Message:
Sent: 04-27-2020 08:30
From: alan niergarth
Subject: Cause for this recurring issue with some clients - AR Cash Receipts

I was thinking I may have missed the memo on this issue.  Apparently not.  Looks like we've all become well versed in the use of DFDM to easily fix the issue.  ARWAR4 is great if you can kick everyone out but quicker usually to fix the record. @Raymond Westcott your explanation seems likely, also @michelle taylor deleting the whole deposit may also be a trigger.  That should be able to be tested.  ​​

------------------------------
alan niergarth
Velosio LLC


Original Message:
Sent: 04-25-2020 13:58
From: Raymond Westcott
Subject: Cause for this recurring issue with some clients - AR Cash Receipts

We see this issue all the time. Right now the leading theory on this is that the PaymentsToday value is updated in AR_OpenInvoice before the Cash Receipt entry is accepted. Then the user either exits the cash receipt entry without accepting it, or their network connection to the Sage server is interrupted and they receive an error that forces them to get out of Sage and log back in. When they go back in, the last Cash Receipts batch they entered is there, but the entry they were working on needs to be re-entered because it was not accepted/saved. When they go to apply the cash, the PaymentsToday value in AR_OpenInvoice reflects the amount entered just before they were forced out of C/R data entry, so they cannot enter a value.

The solution for this is to go into the AR_OpenInvoice table in Datafile Display and Maintenance and reset to the PaymentsToday value to zero.

------------------------------
Raymond Westcott
MBSG

You all are cracking me up.

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

Original Message:
Sent: 04-27-2020 11:26
From: Raymond Westcott
Subject: Cause for this recurring issue with some clients - AR Cash Receipts

@Beth Bowers you are blowing my mind right now! I can't believe that we've never tried that.​

------------------------------
Raymond Westcott
MBSG
------------------------------


Original Message:
Sent: 04-27-2020 08:35
From: Beth Bowers
Subject: Cause for this recurring issue with some clients - AR Cash Receipts

You also can just manually put in the invoice and the Amount Posted and the balance will post fine if you can't get to DFDM or the utility quickly.

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


Original Message:
Sent: 04-27-2020 08:30
From: alan niergarth
Subject: Cause for this recurring issue with some clients - AR Cash Receipts

I was thinking I may have missed the memo on this issue.  Apparently not.  Looks like we've all become well versed in the use of DFDM to easily fix the issue.  ARWAR4 is great if you can kick everyone out but quicker usually to fix the record. @Raymond Westcott your explanation seems likely, also @michelle taylor deleting the whole deposit may also be a trigger.  That should be able to be tested.  ​​

------------------------------
alan niergarth
Velosio LLC


Original Message:
Sent: 04-25-2020 13:58
From: Raymond Westcott
Subject: Cause for this recurring issue with some clients - AR Cash Receipts

We see this issue all the time. Right now the leading theory on this is that the PaymentsToday value is updated in AR_OpenInvoice before the Cash Receipt entry is accepted. Then the user either exits the cash receipt entry without accepting it, or their network connection to the Sage server is interrupted and they receive an error that forces them to get out of Sage and log back in. When they go back in, the last Cash Receipts batch they entered is there, but the entry they were working on needs to be re-entered because it was not accepted/saved. When they go to apply the cash, the PaymentsToday value in AR_OpenInvoice reflects the amount entered just before they were forced out of C/R data entry, so they cannot enter a value.

The solution for this is to go into the AR_OpenInvoice table in Datafile Display and Maintenance and reset to the PaymentsToday value to zero.

------------------------------
Raymond Westcott
MBSG