Sage 100

I have a customer that just recently went live on Avatax. They discovered an issue with credit memos (at least they way they do credit memos).

In the case of an incorrect price on an invoice, they do the following with a credit memo in SO; enter the item on line one for the ordered quantity and the incorrect price, then on line two, enter the same part number with the ordered quantity as negative and the correct price. The result is the customer receives a credit for the difference of the two.

Before Avatax this worked just fine, and changing the Tax Schedule to something other than Avatax allows it to work fine. With Avatax, the Taxable Amount is shown as the absolute value of the two amounts added together (in effect ignoring the negative amount).

Screen shots of the transaction below.
Anyone run into this? Open a support ticket with Avalara?

------------------------------
Greg Stiles
S & W Microsystems
Torrance CA
310.787.1010
------------------------------

This doesn't help you tonight, but my client experienced the same thing.  I'll ping them to see if they ever talked with Avalara and how they are handling since the discovery.  I think I recommended they have to go to a 2 step invoicing for this situation.
N

------------------------------
Nancy Hanson
Blytheco LLC
Eagan MN
------------------------------

You might ping Joe De Maria at DSD who has primary responsibility for the Avatax Connector.  He said DSD is cleaning up some stuff for 2019.  This may be on his list or perhaps added.
What does it look like in the Admin portal?

------------------------------
Bob Pfahnl
General Manager - Silicon Valley Office
DSD Business Systems
CA
408-641-0922
------------------------------

@Bob Pfahnl - Any inside skinny on when 2019 will be released???​

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

Original Message:
Sent: 08-21-2019 01:08
From: Bob Pfahnl
Subject: Credit Memo with Negative Lines Causes Problems for Avatax

You might ping Joe De Maria at DSD who has primary responsibility for the Avatax Connector.  He said DSD is cleaning up some stuff for 2019.  This may be on his list or perhaps added.
What does it look like in the Admin portal?

------------------------------
Bob Pfahnl
General Manager - Silicon Valley Office
DSD Business Systems
CA
408-641-0922
------------------------------

Aside from the fact that using a CM allows credit to be aligned with the original invoice, they could try issuing the credit as an invoice.  The results are the same and Avalara should work fine.  They just have to change the signs on both lines.

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

Original Message:
Sent: 08-21-2019 20:14
From: Jeff Schwenk
Subject: Credit Memo with Negative Lines Causes Problems for Avatax

@Bob Pfahnl - Any inside skinny on when 2019 will be released???​

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


Original Message:
Sent: 08-21-2019 01:08
From: Bob Pfahnl
Subject: Credit Memo with Negative Lines Causes Problems for Avatax

You might ping Joe De Maria at DSD who has primary responsibility for the Avatax Connector.  He said DSD is cleaning up some stuff for 2019.  This may be on his list or perhaps added.
What does it look like in the Admin portal?

------------------------------
Bob Pfahnl
General Manager - Silicon Valley Office
DSD Business Systems
CA
408-641-0922

@Jeff Schwenk. No insight.

---------------------------------
Bob Pfahnl
General Manager - Silicon Valley Office
DSD Business Systems
CA
408-641-0922
---------------------------------



Original Message:
Sent: 08-21-2019
From: Jeff Schwenk
Subject: RE: Credit Memo with Negative Lines Causes Problems for Avatax

@Bob Pfahnl - Any inside skinny on when 2019 will be released???​

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

Joe does not have this issue on his radar. Reported to Avalara, we'll see what happens next. In the meantime the client is issuing two transactions, a credit and a corrected invoice.​ I'll have to look and see how it appears in the console. Thanks all.

------------------------------
Greg Stiles
S & W Microsystems
Torrance CA
310.787.1010
------------------------------

Original Message:
Sent: 08-21-2019 20:29
From: Bob Pfahnl
Subject: Credit Memo with Negative Lines Causes Problems for Avatax

@Jeff Schwenk. No insight.

---------------------------------
Bob Pfahnl
General Manager - Silicon Valley Office
DSD Business Systems
CA
408-641-0922
---------------------------------




Original Message:
Sent: 08-21-2019
From: Jeff Schwenk
Subject: RE: Credit Memo with Negative Lines Causes Problems for Avatax

@Bob Pfahnl - Any inside skinny on when 2019 will be released???​

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


Original Message:
Sent: 08-21-2019 01:08
From: Bob Pfahnl
Subject: Credit Memo with Negative Lines Causes Problems for Avatax

You might ping Joe De Maria at DSD who has primary responsibility for the Avatax Connector.  He said DSD is cleaning up some stuff for 2019.  This may be on his list or perhaps added.
What does it look like in the Admin portal?

------------------------------
Bob Pfahnl
General Manager - Silicon Valley Office
DSD Business Systems
CA
408-641-0922

@Bob Pfahnl to answer your question: What does it look like in the Admin portal? - the credit memo appears with the correct total amount (difference between the 2 lines) and the correct sales tax. But it has summed the negative and positive amounts together on line 1 and shows zeros on line 2. This does not match what is in Sage with respect to Taxable Amount and Sales Tax (see prior screenshots).
Have not heard from Avalara yet...{not holding breath LOL}

------------------------------
Greg Stiles
S & W Microsystems
Torrance CA
310.787.1010
------------------------------

Original Message:
Sent: 08-21-2019 01:08
From: Bob Pfahnl
Subject: Credit Memo with Negative Lines Causes Problems for Avatax

You might ping Joe De Maria at DSD who has primary responsibility for the Avatax Connector.  He said DSD is cleaning up some stuff for 2019.  This may be on his list or perhaps added.
What does it look like in the Admin portal?

------------------------------
Bob Pfahnl
General Manager - Silicon Valley Office
DSD Business Systems
CA
408-641-0922
------------------------------

FWIW - Here is the answer from Avalara:

Thank you for contacting Avalara support.

You cannot use a combination of positive and negative lines on a credit memo.  You can do this on an invoice document but not a credit document.

No explanation as to why. She linked to this article which just restates her answer.

https://help.avalara.com/kb/001/Why_do_lines_not_add_up_when_entering_credit_memo's_with_Sage_100_and_Avatax%3F 

------------------------------
Greg Stiles
S & W Microsystems
Torrance CA
310.787.1010
------------------------------

Original Message:
Sent: 08-22-2019 19:34
From: Greg Stiles
Subject: Credit Memo with Negative Lines Causes Problems for Avatax

@Bob Pfahnl to answer your question: What does it look like in the Admin portal? - the credit memo appears with the correct total amount (difference between the 2 lines) and the correct sales tax. But it has summed the negative and positive amounts together on line 1 and shows zeros on line 2. This does not match what is in Sage with respect to Taxable Amount and Sales Tax (see prior screenshots).

Have not heard from Avalara yet...{not holding breath LOL}

------------------------------
Greg Stiles
S & W Microsystems
Torrance CA
310.787.1010
------------------------------


Original Message:
Sent: 08-21-2019 01:08
From: Bob Pfahnl
Subject: Credit Memo with Negative Lines Causes Problems for Avatax

You might ping Joe De Maria at DSD who has primary responsibility for the Avatax Connector.  He said DSD is cleaning up some stuff for 2019.  This may be on his list or perhaps added.
What does it look like in the Admin portal?

------------------------------
Bob Pfahnl
General Manager - Silicon Valley Office
DSD Business Systems
CA
408-641-0922

Bizarre.  You can do it on a regular invoice but not a credit memo.  Again.  Bizarre......

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

Original Message:
Sent: 08-29-2019 14:56
From: Greg Stiles
Subject: Credit Memo with Negative Lines Causes Problems for Avatax

FWIW - Here is the answer from Avalara:

Thank you for contacting Avalara support.

You cannot use a combination of positive and negative lines on a credit memo.  You can do this on an invoice document but not a credit document.

No explanation as to why. She linked to this article which just restates her answer.

https://help.avalara.com/kb/001/Why_do_lines_not_add_up_when_entering_credit_memo's_with_Sage_100_and_Avatax%3F 

------------------------------
Greg Stiles
S & W Microsystems
Torrance CA
310.787.1010
------------------------------


Original Message:
Sent: 08-22-2019 19:34
From: Greg Stiles
Subject: Credit Memo with Negative Lines Causes Problems for Avatax

@Bob Pfahnl to answer your question: What does it look like in the Admin portal? - the credit memo appears with the correct total amount (difference between the 2 lines) and the correct sales tax. But it has summed the negative and positive amounts together on line 1 and shows zeros on line 2. This does not match what is in Sage with respect to Taxable Amount and Sales Tax (see prior screenshots).

Have not heard from Avalara yet...{not holding breath LOL}

------------------------------
Greg Stiles
S & W Microsystems
Torrance CA
310.787.1010


Original Message:
Sent: 08-21-2019 01:08
From: Bob Pfahnl
Subject: Credit Memo with Negative Lines Causes Problems for Avatax

You might ping Joe De Maria at DSD who has primary responsibility for the Avatax Connector.  He said DSD is cleaning up some stuff for 2019.  This may be on his list or perhaps added.
What does it look like in the Admin portal?

------------------------------
Bob Pfahnl
General Manager - Silicon Valley Office
DSD Business Systems
CA
408-641-0922