Closed DMR - GL Transaction INS-DMR

OK. Both DMRs would have a INS-DMR trans & resulting GL debit (one offset appropriately by the dispositioned DMR action - that has a matching parttran record - & now the other Closed undispositioned DMR by a one sided journal entry - with no matching parttran record).

I guess where you are losing me (as I'm interested: We ran 5 yrs on Vantage 8 with inventory journal posting disabled & now live on E9 a little shy of a year, our comptroller is gaining enough confidence in people's execution of trans generating processes, he'd like to turn on inv journal posting May 1 when we start our new fuscal year).

Both INS-DMR transactions (& GL entries) had to be proceeded by an STK-INS transaction (& related GL entries - although perhaps as a portion of a summary posting) did they not?? (reducing your inventory on-hand twice as well - or was an ADJ-STK adjustment done to 'fix' one & correct o/h balances?)

If all records were written, accepting the (forced closed undispositioned) DMR back to stock (DMR-STK) would correct the inventory balance & the GL with an offsetting DMR resolution entry.

Or are you saying the network connectivity problem actually prevented the initial STK-INS parttran record to be written?

That would concern me. Client connectivity shouldn't impact full completion (or full rollback if failed) of all associated parttran, GL records & update of partbin.onhand values.

This is all occuring on the server (unless it too failed) & I'd be insisting Epicor support provide a fix.

????

Rob Brown
Versa Products
Sent from Yahoo Mail on Android


From:"'Chang, Chia' cchang@... [vantage]" <vantage@yahoogroups.com>
Date:Thu, Feb 12, 2015 at 5:03 PM
Subject:RE: [Vantage] Closed DMR - GL Transaction INS-DMR

 
<div id="ygrps-yiv-771713940ygrp-text">
  
  
  <p></p><div class="ygrps-yiv-771713940WordSection1"><p class="ygrps-yiv-771713940MsoNormal"><span style="font-size:11.0pt;color:#1F497D;">The DMR is for Inventory.&nbsp; There is no adjustments needed since this is not a valid DMR.&nbsp; We closed this DMR out with full remaining quantities.</span></p><p class="ygrps-yiv-771713940MsoNormal"><span style="font-size:11.0pt;color:#1F497D;"> &nbsp;</span></p><p class="ygrps-yiv-771713940MsoNormal"><span style="font-size:11.0pt;color:#1F497D;">What happened was the user lost network connectivity and the system would no longer allow the user to complete the DMR.&nbsp; So the user created a new DMR completely.&nbsp; We are looking to remove any GL adjustments off the GL account for the invalid DMR.&nbsp; Anytime a DMR is created, it will create an INS-DMR debit transaction to the account regardless if you disposition it or not.&nbsp; The workaround was to do a manual one sided journal entry to bring the account back in balance.</span></p><p class="ygrps-yiv-771713940MsoNormal"><span

style=“font-size:11.0pt;color:#1F497D;”>  

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Tuesday, February 10, 2015 4:38 PM
To: vantage@yahoogroups com; vantage@yahoogroups com
Subject: Re: [Vantage] Closed DMR - GL Transaction INS-DMR

 

 

Reopen it and disposition it. Then do whatever adjustments are needed to
offset.

 

You didn't say what the source of the Nonconformance/DMR was (jobmtl, labor, inventory, PO receipt inspection) & the source determines your adjustment options. 

Rob Brown
Versa Products
Sent from Yahoo Mail on Android


From:"'Chang, Chia' <a rel=“nofollow” shape=“rect”

cchang@… [vantage]" <vantage@yahoogroups.com>
Date:Tue, Feb 10, 2015 at 1:56 PM
Subject:[Vantage] Closed DMR - GL Transaction INS-DMR

 

We created a DMR but decided to cancel it by closing it with open remaining quantities.  This created an INS-DMR transaction in the GL account when viewing it in the WIP/Recon report causing the GL account to be out of balance.  How do we cancel the DMR to balance the GL account?

</div>
 


<div class="ygrps-yiv-771713940yQTDBase ygrps-yiv-771713940yqt8047078582" id="ygrps-yiv-771713940yqt51469"><div style="color:#fff;height:0;"></div></div>
<!-- #ygrps-yiv-836110379 _filtered #ygrps-yiv-836110379 {font-family:Wingdings; panose-1:5 0 0 0 0 0 0 0 0 0;} _filtered #ygrps-yiv-836110379 {font-family:Wingdings; panose-1:5 0 0 0 0 0 0 0 0 0;} _filtered #ygrps-yiv-836110379 {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4;} _filtered #ygrps-yiv-836110379 {font-family:Consolas; panose-1:2 11 6 9 2 2 4 3 2 4;} _filtered #ygrps-yiv-836110379 {font-family:Verdana; panose-1:2 11 6 4 3 5 4 4 2 4;} #ygrps-yiv-836110379 #ygrps-yiv-836110379 p.ygrps-yiv-836110379MsoNormal, #ygrps-yiv-836110379 li.ygrps-yiv-836110379MsoNormal, #ygrps-yiv-836110379 div.ygrps-yiv-836110379MsoNormal {margin:0in; margin-bottom:.0001pt; font-size:12.0pt; font-family:"Times New Roman", "serif";} #ygrps-yiv-836110379 a:link, #ygrps-yiv-836110379 span.ygrps-yiv-836110379MsoHyperlink { color:blue; text-decoration:underline;} #ygrps-yiv-836110379 a:visited, #ygrps-yiv-836110379 span.ygrps-yiv-836110379MsoHyperlinkFollowed { color:purple; text-decoration:underline;} #ygrps-yiv-836110379 p {

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-836110379 code
{
font-family:“Courier New”;}
#ygrps-yiv-836110379 pre
{

margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:“Courier New”;}
#ygrps-yiv-836110379 tt
{
font-family:“Courier New”;}
#ygrps-yiv-836110379 span.ygrps-yiv-836110379HTMLPreformattedChar
{

font-family:Consolas;}
#ygrps-yiv-836110379 p.ygrps-yiv-836110379attach, #ygrps-yiv-836110379 li.ygrps-yiv-836110379attach, #ygrps-yiv-836110379 div.ygrps-yiv-836110379attach
{

margin-right:0in;

margin-left:0in;
font-size:9.0pt;
font-family:“Arial”, “sans-serif”;}
#ygrps-yiv-836110379 p.ygrps-yiv-836110379bold, #ygrps-yiv-836110379 li.ygrps-yiv-836110379bold, #ygrps-yiv-836110379 div.ygrps-yiv-836110379bold
{

margin-right:0in;

margin-left:0in;
font-size:10.0pt;
font-family:“Arial”, “sans-serif”;
font-weight:bold;}
#ygrps-yiv-836110379 p.ygrps-yiv-836110379green, #ygrps-yiv-836110379 li.ygrps-yiv-836110379green, #ygrps-yiv-836110379 div.ygrps-yiv-836110379green
{

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;
color:#628C2A;}
#ygrps-yiv-836110379 p.ygrps-yiv-836110379replbq, #ygrps-yiv-836110379 li.ygrps-yiv-836110379replbq, #ygrps-yiv-836110379 div.ygrps-yiv-836110379replbq
{
margin:3.0pt;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-836110379 p.ygrps-yiv-836110379ad, #ygrps-yiv-836110379 li.ygrps-yiv-836110379ad, #ygrps-yiv-836110379 div.ygrps-yiv-836110379ad
{

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-836110379 p.ygrps-yiv-836110379underline, #ygrps-yiv-836110379 li.ygrps-yiv-836110379underline, #ygrps-yiv-836110379 div.ygrps-yiv-836110379underline
{

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-836110379 span.ygrps-yiv-836110379yshortcuts
{}
#ygrps-yiv-836110379 p.ygrps-yiv-836110379ad1, #ygrps-yiv-836110379 li.ygrps-yiv-836110379ad1, #ygrps-yiv-836110379 div.ygrps-yiv-836110379ad1
{

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-836110379 p.ygrps-yiv-836110379ad2, #ygrps-yiv-836110379 li.ygrps-yiv-836110379ad2, #ygrps-yiv-836110379 div.ygrps-yiv-836110379ad2
{

margin-right:0in;
margin-bottom:7.5pt;
margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-836110379 p.ygrps-yiv-836110379underline1, #ygrps-yiv-836110379 li.ygrps-yiv-836110379underline1, #ygrps-yiv-836110379 div.ygrps-yiv-836110379underline1
{

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;
text-decoration:underline;}
#ygrps-yiv-836110379 span.ygrps-yiv-836110379yshortcuts1
{
font-family:“Verdana”, “sans-serif”;
font-weight:bold;}
#ygrps-yiv-836110379 span.ygrps-yiv-836110379yshortcuts2
{
font-family:“Verdana”, “sans-serif”;
font-weight:normal;}
#ygrps-yiv-836110379 span.ygrps-yiv-836110379EmailStyle34
{
font-family:“Calibri”, “sans-serif”;
color:#1F497D;}
#ygrps-yiv-836110379 .ygrps-yiv-836110379MsoChpDefault
{
font-size:10.0pt;}
_filtered #ygrps-yiv-836110379 {
margin:1.0in 1.0in 1.0in 1.0in;}
#ygrps-yiv-836110379 div.ygrps-yiv-836110379WordSection1
{}
#ygrps-yiv-836110379
_filtered #ygrps-yiv-836110379 {
}
_filtered #ygrps-yiv-836110379 {

font-family:Symbol;}
_filtered #ygrps-yiv-836110379 {

font-family:“Courier New”;
}
_filtered #ygrps-yiv-836110379 {

font-family:Wingdings;}
_filtered #ygrps-yiv-836110379 {

font-family:Wingdings;}
_filtered #ygrps-yiv-836110379 {

font-family:Wingdings;}
_filtered #ygrps-yiv-836110379 {

font-family:Wingdings;}
_filtered #ygrps-yiv-836110379 {

font-family:Wingdings;}
_filtered #ygrps-yiv-836110379 {

font-family:Wingdings;}
_filtered #ygrps-yiv-836110379 {

font-family:Wingdings;}
#ygrps-yiv-836110379 ol
{margin-bottom:0in;}
#ygrps-yiv-836110379 ul
{margin-bottom:0in;}
–>

We created a DMR but decided to cancel it by closing it with open remaining quantities. This created an INS-DMR transaction in the GL account when viewing it in the WIP/Recon report causing the GL account to be out of balance. How do we cancel the DMR to balance the GL account?

Reopen it and disposition it. Then do whatever adjustments are needed to offset.

You didn't say what the source of the Nonconformance/DMR was (jobmtl, labor, inventory, PO receipt inspection) & the source determines your adjustment options. 

Rob Brown
Versa Products
Sent from Yahoo Mail on Android


From:"'Chang, Chia' cchang@... [vantage]" <vantage@yahoogroups.com>
Date:Tue, Feb 10, 2015 at 1:56 PM
Subject:[Vantage] Closed DMR - GL Transaction INS-DMR

 
<div id="ygrps-yiv-263853795ygrp-text">
  
  
  <p></p><div class="ygrps-yiv-263853795WordSection1"><p class="ygrps-yiv-263853795MsoNormal"><span style="font-size:11.0pt;color:#1F497D;">We created a DMR but decided to cancel it by closing it with open remaining quantities.&nbsp; This created an INS-DMR transaction in the GL account when viewing it in the WIP/Recon report causing the GL account to be out of balance.&nbsp; How do we cancel the DMR to balance the GL account?</span></p></div> 

</div>
 


<div style="color:#fff;height:0;"></div></div>