AR Customer refunds

Yahoo Archive
1
You can adjust the credit memo to zero and create an AP check for a one time vendor (you just dont enter supplier id but just the name in this case of your customer) and that will be it.
 
Dora Chavarria   Sr. Consultant Analysis Services, ERP   Mayan Technologies USA, Inc. dchavarria@... www.mayantechs.com 



On Wednesday, August 19, 2015 8:32 AM, "Deirdre Sykes dsykes@... [vantage]" <vantage@yahoogroups.com> wrote:


  
<div id="ygrps-yiv-1093470437yiv7569758764ygrp-text">
  
  
  <div>We set-up the customer as a supplier and then process a AP invoice for the refund amount, booking to general account and then immediately process a write off adjustment against the AR invoice to the same account. When the check is process that will remove the amount from AP aged report and write adjustment removes the amount from the AR aged report.<br clear="none">

Deirdre Sykes | Finance Supervisor
GSI Technologies, LLC | 311 Shore Drive | Burr Ridge, IL 60527
dsykes@...<mailto:dsykes@...> | Phone: 630.590.8112 | Fax: 630.325.8197

Celebrating 30 Years of Excellence!

Like us on Facebook: [facebook] <https://www.facebook.com/pages/GSI-Technologies/624368870969219> Click: [linkedin] <http://www.linkedin.com/company/2690732?trk=vsrp_companies_cluster_name&trkInfo=VSRPsearchId%3A176974291386194698817%2CVSRPtargetId%3A2690732%2CVSRPcmpt%3Acompanies_cluster> and [followlinkedin] <http://www.linkedin.com/company/gsi-technologies?trk=company_name> us on Linked-In


From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, August 19, 2015 4:33 AM
To: vantage@yahoogroups.com
Subject: [Vantage] AR Customer refunds



Does anyone have a smarter way of dealing with Customer Refunds in E9? This occurs because credit memos may have been issued to Customers which cannot me matched against invoices with Apply Credit Memo, because the customer has been overcharged but there is no further invoice activity. Because AR receipts do not accept negative values, we raise a "dummy" AR invoice (no tax) and code to GL (suspense). Then the refund is made via Bank Adjustment, again coding to suspense. The "Invoice" is then matched to the Credit Memo, thereby zeroising the Customer balance.


CONFIDENTIALITY: The information contained in this email message, including any attachment(s), may be privileged and confidential and protected from disclosure. The email is not intended for transmission to, or receipt by, any unauthorized persons. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication or use of the information contained herein is strictly prohibited. If you have received this electronic mail transmission in error, please delete it from your system without copying or disseminating, and notify the sender by Reply email, so that our address record can be corrected.

[Non-text portions of this message have been removed]

</div>
 


<div style="color:#fff;height:0;"></div></div>
#ygrps-yiv-1093470437 #ygrps-yiv-1093470437yiv7569758764 #ygrps-yiv-1093470437yiv7569758764 -- #ygrps-yiv-1093470437yiv7569758764ygrp-mkp { border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}

#ygrps-yiv-1093470437 #ygrps-yiv-1093470437yiv7569758764 #ygrps-yiv-1093470437yiv7569758764ygrp-mkp hr {
border:1px solid #d8d8d8;}

#ygrps-yiv-1093470437 #ygrps-yiv-1093470437yiv7569758764 #ygrps-yiv-1093470437yiv7569758764ygrp-mkp #ygrps-yiv-1093470437yiv7569758764hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}

#ygrps-yiv-1093470437 #ygrps-yiv-1093470437yiv7569758764 #ygrps-yiv-1093470437yiv7569758764ygrp-mkp #ygrps-yiv-1093470437yiv7569758764ads {
margin-bottom:10px;}

#ygrps-yiv-1093470437 #ygrps-yiv-1093470437yiv7569758764 #ygrps-yiv-1093470437yiv7569758764ygrp-mkp .ygrps-yiv-1093470437yiv7569758764ad {
padding:0 0;}

#ygrps-yiv-1093470437 #ygrps-yiv-1093470437yiv7569758764 #ygrps-yiv-1093470437yiv7569758764ygrp-mkp .ygrps-yiv-1093470437yiv7569758764ad p {
margin:0;}

#ygrps-yiv-1093470437 #ygrps-yiv-1093470437yiv7569758764 #ygrps-yiv-1093470437yiv7569758764ygrp-mkp .ygrps-yiv-1093470437yiv7569758764ad a {
color:#0000ff;text-decoration:none;}
#ygrps-yiv-1093470437 #ygrps-yiv-1093470437yiv7569758764 #ygrps-yiv-1093470437yiv7569758764ygrp-sponsor #ygrps-yiv-1093470437yiv7569758764ygrp-lc {
font-family:Arial;}

#ygrps-yiv-1093470437 #ygrps-yiv-1093470437yiv7569758764 #ygrps-yiv-1093470437yiv7569758764ygrp-sponsor #ygrps-yiv-1093470437yiv7569758764ygrp-lc #ygrps-yiv-1093470437yiv7569758764hd {
margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}

#ygrps-yiv-1093470437 #ygrps-yiv-1093470437yiv7569758764 #ygrps-yiv-1093470437yiv7569758764ygrp-sponsor #ygrps-yiv-1093470437yiv7569758764ygrp-lc .ygrps-yiv-1093470437yiv7569758764ad {
margin-bottom:10px;padding:0 0;}

#ygrps-yiv-1093470437 #ygrps-yiv-1093470437yiv7569758764 #ygrps-yiv-1093470437yiv7569758764actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

#ygrps-yiv-1093470437 #ygrps-yiv-1093470437yiv7569758764 #ygrps-yiv-1093470437yiv7569758764activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#ygrps-yiv-1093470437 #ygrps-yiv-1093470437yiv7569758764 #ygrps-yiv-1093470437yiv7569758764activity span {
font-weight:700;}

#ygrps-yiv-1093470437 #ygrps-yiv-1093470437yiv7569758764 #ygrps-yiv-1093470437yiv7569758764activity span:first-child {
text-transform:uppercase;}

#ygrps-yiv-1093470437 #ygrps-yiv-1093470437yiv7569758764 #ygrps-yiv-1093470437yiv7569758764activity span a {
color:#5085b6;text-decoration:none;}

#ygrps-yiv-1093470437 #ygrps-yiv-1093470437yiv7569758764 #ygrps-yiv-1093470437yiv7569758764activity span span {
color:#ff7900;}

#ygrps-yiv-1093470437 #ygrps-yiv-1093470437yiv7569758764 #ygrps-yiv-1093470437yiv7569758764activity span .ygrps-yiv-1093470437yiv7569758764underline {
text-decoration:underline;}

#ygrps-yiv-1093470437 #ygrps-yiv-1093470437yiv7569758764 .ygrps-yiv-1093470437yiv7569758764attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}

#ygrps-yiv-1093470437 #ygrps-yiv-1093470437yiv7569758764 .ygrps-yiv-1093470437yiv7569758764attach div a {
text-decoration:none;}

#ygrps-yiv-1093470437 #ygrps-yiv-1093470437yiv7569758764 .ygrps-yiv-1093470437yiv7569758764attach img {
border:none;padding-right:5px;}

#ygrps-yiv-1093470437 #ygrps-yiv-1093470437yiv7569758764 .ygrps-yiv-1093470437yiv7569758764attach label {
display:block;margin-bottom:5px;}

#ygrps-yiv-1093470437 #ygrps-yiv-1093470437yiv7569758764 .ygrps-yiv-1093470437yiv7569758764attach label a {
text-decoration:none;}

#ygrps-yiv-1093470437 #ygrps-yiv-1093470437yiv7569758764 blockquote {
margin:0 0 0 4px;}

#ygrps-yiv-1093470437 #ygrps-yiv-1093470437yiv7569758764 .ygrps-yiv-1093470437yiv7569758764bold {
font-family:Arial;font-size:13px;font-weight:700;}

#ygrps-yiv-1093470437 #ygrps-yiv-1093470437yiv7569758764 .ygrps-yiv-1093470437yiv7569758764bold a {
text-decoration:none;}

#ygrps-yiv-1093470437 #ygrps-yiv-1093470437yiv7569758764 dd.ygrps-yiv-1093470437yiv7569758764last p a {
font-family:Verdana;font-weight:700;}

#ygrps-yiv-1093470437 #ygrps-yiv-1093470437yiv7569758764 dd.ygrps-yiv-1093470437yiv7569758764last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}

#ygrps-yiv-1093470437 #ygrps-yiv-1093470437yiv7569758764 dd.ygrps-yiv-1093470437yiv7569758764last p span.ygrps-yiv-1093470437yiv7569758764yshortcuts {
margin-right:0;}

#ygrps-yiv-1093470437 #ygrps-yiv-1093470437yiv7569758764 div.ygrps-yiv-1093470437yiv7569758764attach-table div div a {
text-decoration:none;}

#ygrps-yiv-1093470437 #ygrps-yiv-1093470437yiv7569758764 div.ygrps-yiv-1093470437yiv7569758764attach-table {
width:400px;}

#ygrps-yiv-1093470437 #ygrps-yiv-1093470437yiv7569758764 div.ygrps-yiv-1093470437yiv7569758764file-title a, #ygrps-yiv-1093470437 #ygrps-yiv-1093470437yiv7569758764 div.ygrps-yiv-1093470437yiv7569758764file-title a:active, #ygrps-yiv-1093470437 #ygrps-yiv-1093470437yiv7569758764 div.ygrps-yiv-1093470437yiv7569758764file-title a:hover, #ygrps-yiv-1093470437 #ygrps-yiv-1093470437yiv7569758764 div.ygrps-yiv-1093470437yiv7569758764file-title a:visited {
text-decoration:none;}

#ygrps-yiv-1093470437 #ygrps-yiv-1093470437yiv7569758764 div.ygrps-yiv-1093470437yiv7569758764photo-title a, #ygrps-yiv-1093470437 #ygrps-yiv-1093470437yiv7569758764 div.ygrps-yiv-1093470437yiv7569758764photo-title a:active, #ygrps-yiv-1093470437 #ygrps-yiv-1093470437yiv7569758764 div.ygrps-yiv-1093470437yiv7569758764photo-title a:hover, #ygrps-yiv-1093470437 #ygrps-yiv-1093470437yiv7569758764 div.ygrps-yiv-1093470437yiv7569758764photo-title a:visited {
text-decoration:none;}

#ygrps-yiv-1093470437 #ygrps-yiv-1093470437yiv7569758764 div#ygrps-yiv-1093470437yiv7569758764ygrp-mlmsg #ygrps-yiv-1093470437yiv7569758764ygrp-msg p a span.ygrps-yiv-1093470437yiv7569758764yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#ygrps-yiv-1093470437 #ygrps-yiv-1093470437yiv7569758764 .ygrps-yiv-1093470437yiv7569758764green {
color:#628c2a;}

#ygrps-yiv-1093470437 #ygrps-yiv-1093470437yiv7569758764 .ygrps-yiv-1093470437yiv7569758764MsoNormal {
margin:0 0 0 0;}

#ygrps-yiv-1093470437 #ygrps-yiv-1093470437yiv7569758764 o {
font-size:0;}

#ygrps-yiv-1093470437 #ygrps-yiv-1093470437yiv7569758764 #ygrps-yiv-1093470437yiv7569758764photos div {
float:left;width:72px;}

#ygrps-yiv-1093470437 #ygrps-yiv-1093470437yiv7569758764 #ygrps-yiv-1093470437yiv7569758764photos div div {
border:1px solid #666666;height:62px;overflow:hidden;width:62px;}

#ygrps-yiv-1093470437 #ygrps-yiv-1093470437yiv7569758764 #ygrps-yiv-1093470437yiv7569758764photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}

#ygrps-yiv-1093470437 #ygrps-yiv-1093470437yiv7569758764 #ygrps-yiv-1093470437yiv7569758764reco-category {
font-size:77%;}

#ygrps-yiv-1093470437 #ygrps-yiv-1093470437yiv7569758764 #ygrps-yiv-1093470437yiv7569758764reco-desc {
font-size:77%;}

#ygrps-yiv-1093470437 #ygrps-yiv-1093470437yiv7569758764 .ygrps-yiv-1093470437yiv7569758764replbq {
margin:4px;}

#ygrps-yiv-1093470437 #ygrps-yiv-1093470437yiv7569758764 #ygrps-yiv-1093470437yiv7569758764ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}

#ygrps-yiv-1093470437 #ygrps-yiv-1093470437yiv7569758764 #ygrps-yiv-1093470437yiv7569758764ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}

#ygrps-yiv-1093470437 #ygrps-yiv-1093470437yiv7569758764 #ygrps-yiv-1093470437yiv7569758764ygrp-mlmsg table {
font-size:inherit;font:100%;}

#ygrps-yiv-1093470437 #ygrps-yiv-1093470437yiv7569758764 #ygrps-yiv-1093470437yiv7569758764ygrp-mlmsg select, #ygrps-yiv-1093470437 #ygrps-yiv-1093470437yiv7569758764 input, #ygrps-yiv-1093470437 #ygrps-yiv-1093470437yiv7569758764 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}

#ygrps-yiv-1093470437 #ygrps-yiv-1093470437yiv7569758764 #ygrps-yiv-1093470437yiv7569758764ygrp-mlmsg pre, #ygrps-yiv-1093470437 #ygrps-yiv-1093470437yiv7569758764 code {
font:115% monospace;}

#ygrps-yiv-1093470437 #ygrps-yiv-1093470437yiv7569758764 #ygrps-yiv-1093470437yiv7569758764ygrp-mlmsg * {
line-height:1.22em;}

#ygrps-yiv-1093470437 #ygrps-yiv-1093470437yiv7569758764 #ygrps-yiv-1093470437yiv7569758764ygrp-mlmsg #ygrps-yiv-1093470437yiv7569758764logo {
padding-bottom:10px;}

#ygrps-yiv-1093470437 #ygrps-yiv-1093470437yiv7569758764 #ygrps-yiv-1093470437yiv7569758764ygrp-msg p a {
font-family:Verdana;}

#ygrps-yiv-1093470437 #ygrps-yiv-1093470437yiv7569758764 #ygrps-yiv-1093470437yiv7569758764ygrp-msg p#ygrps-yiv-1093470437yiv7569758764attach-count span {
color:#1E66AE;font-weight:700;}

#ygrps-yiv-1093470437 #ygrps-yiv-1093470437yiv7569758764 #ygrps-yiv-1093470437yiv7569758764ygrp-reco #ygrps-yiv-1093470437yiv7569758764reco-head {
color:#ff7900;font-weight:700;}

#ygrps-yiv-1093470437 #ygrps-yiv-1093470437yiv7569758764 #ygrps-yiv-1093470437yiv7569758764ygrp-reco {
margin-bottom:20px;padding:0px;}

#ygrps-yiv-1093470437 #ygrps-yiv-1093470437yiv7569758764 #ygrps-yiv-1093470437yiv7569758764ygrp-sponsor #ygrps-yiv-1093470437yiv7569758764ov li a {
font-size:130%;text-decoration:none;}

#ygrps-yiv-1093470437 #ygrps-yiv-1093470437yiv7569758764 #ygrps-yiv-1093470437yiv7569758764ygrp-sponsor #ygrps-yiv-1093470437yiv7569758764ov li {
font-size:77%;list-style-type:square;padding:6px 0;}

#ygrps-yiv-1093470437 #ygrps-yiv-1093470437yiv7569758764 #ygrps-yiv-1093470437yiv7569758764ygrp-sponsor #ygrps-yiv-1093470437yiv7569758764ov ul {
margin:0;padding:0 0 0 8px;}

#ygrps-yiv-1093470437 #ygrps-yiv-1093470437yiv7569758764 #ygrps-yiv-1093470437yiv7569758764ygrp-text {
font-family:Georgia;}

#ygrps-yiv-1093470437 #ygrps-yiv-1093470437yiv7569758764 #ygrps-yiv-1093470437yiv7569758764ygrp-text p {
margin:0 0 1em 0;}

#ygrps-yiv-1093470437 #ygrps-yiv-1093470437yiv7569758764 #ygrps-yiv-1093470437yiv7569758764ygrp-text tt {
font-size:120%;}

#ygrps-yiv-1093470437 #ygrps-yiv-1093470437yiv7569758764 #ygrps-yiv-1093470437yiv7569758764ygrp-vital ul li:last-child {
border-right:none !important;}
#ygrps-yiv-1093470437



2

Does anyone have a smarter way of dealing with Customer Refunds in E9? This occurs because credit memos may have been issued to Customers which cannot me matched against invoices with Apply Credit Memo, because the customer has been overcharged but there is no further invoice activity. Because AR receipts do not accept negative values, we raise a "dummy" AR invoice (no tax) and code to GL (suspense). Then the refund is made via Bank Adjustment, again coding to suspense. The "Invoice" is then matched to the Credit Memo, thereby zeroising the Customer balance.  

3
We set-up the customer as a supplier and then process a AP invoice for the refund amount, booking to general account and then immediately process a write off adjustment against the AR invoice to the same account. When the check is process that will remove the amount from AP aged report and write adjustment removes the amount from the AR aged report.

Deirdre Sykes | Finance Supervisor
GSI Technologies, LLC | 311 Shore Drive | Burr Ridge, IL 60527
dsykes@...<mailto:dsykes@...> | Phone: 630.590.8112 | Fax: 630.325.8197

Celebrating 30 Years of Excellence!

Like us on Facebook: [facebook] <https://www.facebook.com/pages/GSI-Technologies/624368870969219> Click: [linkedin] <http://www.linkedin.com/company/2690732?trk=vsrp_companies_cluster_name&trkInfo=VSRPsearchId%3A176974291386194698817%2CVSRPtargetId%3A2690732%2CVSRPcmpt%3Acompanies_cluster> and [followlinkedin] <http://www.linkedin.com/company/gsi-technologies?trk=company_name> us on Linked-In


From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, August 19, 2015 4:33 AM
To: vantage@yahoogroups.com
Subject: [Vantage] AR Customer refunds



Does anyone have a smarter way of dealing with Customer Refunds in E9? This occurs because credit memos may have been issued to Customers which cannot me matched against invoices with Apply Credit Memo, because the customer has been overcharged but there is no further invoice activity. Because AR receipts do not accept negative values, we raise a "dummy" AR invoice (no tax) and code to GL (suspense). Then the refund is made via Bank Adjustment, again coding to suspense. The "Invoice" is then matched to the Credit Memo, thereby zeroising the Customer balance.


CONFIDENTIALITY: The information contained in this email message, including any attachment(s), may be privileged and confidential and protected from disclosure. The email is not intended for transmission to, or receipt by, any unauthorized persons. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication or use of the information contained herein is strictly prohibited. If you have received this electronic mail transmission in error, please delete it from your system without copying or disseminating, and notify the sender by Reply email, so that our address record can be corrected.


[Non-text portions of this message have been removed]