Sage 100

Robert, can you review the RA_ReceiptHeader and RA_ReceiptDetail tables instead?

Bob  go to RMA Receipts Entry. It sounds like there is an open batch there.

Bob  go to RMA Receipts Entry. It sounds like there is an open batch there.

Bob  go to RMA Receipts Entry. It sounds like there is an open batch there.

Hi Tara,  This is Premium so the data is in SQL - less chance of "litter".  I went ahead an ran it anyway with no change.   I DID wind up finding a record in RA_ReciptsMemo but clearing that didn't help.   I tried rebuilding sorts to see if that would clear anything and still the same message

Hi Tara,  This is Premium so the data is in SQL - less chance of "litter".  I went ahead an ran it anyway with no change.   I DID wind up finding a record in RA_ReciptsMemo but clearing that didn't help.   I tried rebuilding sorts to see if that would clear anything and still the same message

I created a return in standard edition and ran the transaction generation.  The tables in the attached screen shot were modified.  You may check to see if there are any orphaned records in these tables that need to be cleared.

Hi Tara/Doug,

   I reinitialized all the ones that Tara listed.   The RA_DeleteRenumberMergeXref has 430 records in it.   As I don't know what function it is used for, I am leery of wiping it out.  The client does a lot of RMAs..

I created a return in standard edition and ran the transaction generation.  The tables in the attached screen shot were modified.  You may check to see if there are any orphaned records in these tables that need to be cleared.

Maybe back up to a test company code then reinitialize it to see if that table is the culprit.

Hi Tara/Doug,

   I reinitialized all the ones that Tara listed.   The RA_DeleteRenumberMergeXref has 430 records in it.   As I don't know what function it is used for, I am leery of wiping it out.  The client does a lot of RMAs..

Maybe back up to a test company code then reinitialize it to see if that table is the culprit.

Hi Tara/Doug,

   I reinitialized all the ones that Tara listed.   The RA_DeleteRenumberMergeXref has 430 records in it.   As I don't know what function it is used for, I am leery of wiping it out.  The client does a lot of RMAs..

I created a return in standard edition and ran the transaction generation.  The tables in the attached screen shot were modified.  You may check to see if there are any orphaned records in these tables that need to be cleared.

Hi All,   It is going to have to be a call to DSD.   I copied the company and when I accessed the copy, it said that MB was not enabled (so there is clearly something that does not get copied).  Went through the steps.  Did the DSD conversion and I was could enable MB in the warehouse.  I went back and looked and RA_DeleteRenumberMergeXref was empty in the copy company.    So I copied them over to the test company table and did a reinit on it.   Still no joy.   I am baffled.  

Maybe back up to a test company code then reinitialize it to see if that table is the culprit.

Hi Tara/Doug,

   I reinitialized all the ones that Tara listed.   The RA_DeleteRenumberMergeXref has 430 records in it.   As I don't know what function it is used for, I am leery of wiping it out.  The client does a lot of RMAs..

I created a return in standard edition and ran the transaction generation.  The tables in the attached screen shot were modified.  You may check to see if there are any orphaned records in these tables that need to be cleared.

This can be moved out of urgent as I have contacted DSD.    Thanks everyone!

Hi All,   It is going to have to be a call to DSD.   I copied the company and when I accessed the copy, it said that MB was not enabled (so there is clearly something that does not get copied).  Went through the steps.  Did the DSD conversion and I was could enable MB in the warehouse.  I went back and looked and RA_DeleteRenumberMergeXref was empty in the copy company.    So I copied them over to the test company table and did a reinit on it.   Still no joy.   I am baffled.  

Maybe back up to a test company code then reinitialize it to see if that table is the culprit.

Hi Tara/Doug,

   I reinitialized all the ones that Tara listed.   The RA_DeleteRenumberMergeXref has 430 records in it.   As I don't know what function it is used for, I am leery of wiping it out.  The client does a lot of RMAs..

I created a return in standard edition and ran the transaction generation.  The tables in the attached screen shot were modified.  You may check to see if there are any orphaned records in these tables that need to be cleared.

What was the resolution?

This can be moved out of urgent as I have contacted DSD.    Thanks everyone!

Hi All,   It is going to have to be a call to DSD.   I copied the company and when I accessed the copy, it said that MB was not enabled (so there is clearly something that does not get copied).  Went through the steps.  Did the DSD conversion and I was could enable MB in the warehouse.  I went back and looked and RA_DeleteRenumberMergeXref was empty in the copy company.    So I copied them over to the test company table and did a reinit on it.   Still no joy.   I am baffled.  

Maybe back up to a test company code then reinitialize it to see if that table is the culprit.

Hi Tara/Doug,

   I reinitialized all the ones that Tara listed.   The RA_DeleteRenumberMergeXref has 430 records in it.   As I don't know what function it is used for, I am leery of wiping it out.  The client does a lot of RMAs..

I created a return in standard edition and ran the transaction generation.  The tables in the attached screen shot were modified.  You may check to see if there are any orphaned records in these tables that need to be cleared.

Suggestion:

Postings to Urgent Support should require a written after action summary of how the issue was solved (or not). 

What was the resolution?

This can be moved out of urgent as I have contacted DSD.    Thanks everyone!

Hi All,   It is going to have to be a call to DSD.   I copied the company and when I accessed the copy, it said that MB was not enabled (so there is clearly something that does not get copied).  Went through the steps.  Did the DSD conversion and I was could enable MB in the warehouse.  I went back and looked and RA_DeleteRenumberMergeXref was empty in the copy company.    So I copied them over to the test company table and did a reinit on it.   Still no joy.   I am baffled.  

Maybe back up to a test company code then reinitialize it to see if that table is the culprit.

Hi Tara/Doug,

   I reinitialized all the ones that Tara listed.   The RA_DeleteRenumberMergeXref has 430 records in it.   As I don't know what function it is used for, I am leery of wiping it out.  The client does a lot of RMAs..

Suggestion:

Postings to Urgent Support should require a written after action summary of how the issue was solved (or not). 

What was the resolution?

This can be moved out of urgent as I have contacted DSD.    Thanks everyone!

Hi All,   It is going to have to be a call to DSD.   I copied the company and when I accessed the copy, it said that MB was not enabled (so there is clearly something that does not get copied).  Went through the steps.  Did the DSD conversion and I was could enable MB in the warehouse.  I went back and looked and RA_DeleteRenumberMergeXref was empty in the copy company.    So I copied them over to the test company table and did a reinit on it.   Still no joy.   I am baffled.  

Maybe back up to a test company code then reinitialize it to see if that table is the culprit.

Hi Tara/Doug,

   I reinitialized all the ones that Tara listed.   The RA_DeleteRenumberMergeXref has 430 records in it.   As I don't know what function it is used for, I am leery of wiping it out.  The client does a lot of RMAs..

I created a return in standard edition and ran the transaction generation.  The tables in the attached screen shot were modified.  You may check to see if there are any orphaned records in these tables that need to be cleared.

I'm not sure if the RMA module leaves flags in this file but it is worth a look and no one seems to have mentioned it.

PO_ReceiptReturnMatRqByPO.M4t

If a receipt or return is in progress it puts a record in this file.  Sometimes the record doesn't get removed after posting. Used DFDM to remove any orphaned records.

Suggestion:

Postings to Urgent Support should require a written after action summary of how the issue was solved (or not). 

What was the resolution?

This can be moved out of urgent as I have contacted DSD.    Thanks everyone!

Hi All,   It is going to have to be a call to DSD.   I copied the company and when I accessed the copy, it said that MB was not enabled (so there is clearly something that does not get copied).  Went through the steps.  Did the DSD conversion and I was could enable MB in the warehouse.  I went back and looked and RA_DeleteRenumberMergeXref was empty in the copy company.    So I copied them over to the test company table and did a reinit on it.   Still no joy.   I am baffled.  

Maybe back up to a test company code then reinitialize it to see if that table is the culprit.

Hi Tara/Doug,

   I reinitialized all the ones that Tara listed.   The RA_DeleteRenumberMergeXref has 430 records in it.   As I don't know what function it is used for, I am leery of wiping it out.  The client does a lot of RMAs..

I created a return in standard edition and ran the transaction generation.  The tables in the attached screen shot were modified.  You may check to see if there are any orphaned records in these tables that need to be cleared.

Suggestion:

Postings to Urgent Support should require a written after action summary of how the issue was solved (or not). 

What was the resolution?

This can be moved out of urgent as I have contacted DSD.    Thanks everyone!

Hi All,   It is going to have to be a call to DSD.   I copied the company and when I accessed the copy, it said that MB was not enabled (so there is clearly something that does not get copied).  Went through the steps.  Did the DSD conversion and I was could enable MB in the warehouse.  I went back and looked and RA_DeleteRenumberMergeXref was empty in the copy company.    So I copied them over to the test company table and did a reinit on it.   Still no joy.   I am baffled.  

Maybe back up to a test company code then reinitialize it to see if that table is the culprit.

Hi Tara/Doug,

   I reinitialized all the ones that Tara listed.   The RA_DeleteRenumberMergeXref has 430 records in it.   As I don't know what function it is used for, I am leery of wiping it out.  The client does a lot of RMAs..

I created a return in standard edition and ran the transaction generation.  The tables in the attached screen shot were modified.  You may check to see if there are any orphaned records in these tables that need to be cleared.

@Robert Osborn, did you get a resolution from DSD?

Suggestion:

Postings to Urgent Support should require a written after action summary of how the issue was solved (or not). 

What was the resolution?

This can be moved out of urgent as I have contacted DSD.    Thanks everyone!

Hi All,   It is going to have to be a call to DSD.   I copied the company and when I accessed the copy, it said that MB was not enabled (so there is clearly something that does not get copied).  Went through the steps.  Did the DSD conversion and I was could enable MB in the warehouse.  I went back and looked and RA_DeleteRenumberMergeXref was empty in the copy company.    So I copied them over to the test company table and did a reinit on it.   Still no joy.   I am baffled.  

Maybe back up to a test company code then reinitialize it to see if that table is the culprit.

Hi Tara/Doug,

   I reinitialized all the ones that Tara listed.   The RA_DeleteRenumberMergeXref has 430 records in it.   As I don't know what function it is used for, I am leery of wiping it out.  The client does a lot of RMAs..

I created a return in standard edition and ran the transaction generation.  The tables in the attached screen shot were modified.  You may check to see if there are any orphaned records in these tables that need to be cleared.

@Robert Wood  I got an email from Ken Phillips directly but DSD said that Sage handles support for MB basic.  They of course had no ideas.   

@Robert Osborn, did you get a resolution from DSD?

Suggestion:

Postings to Urgent Support should require a written after action summary of how the issue was solved (or not). 

What was the resolution?

This can be moved out of urgent as I have contacted DSD.    Thanks everyone!

Hi All,   It is going to have to be a call to DSD.   I copied the company and when I accessed the copy, it said that MB was not enabled (so there is clearly something that does not get copied).  Went through the steps.  Did the DSD conversion and I was could enable MB in the warehouse.  I went back and looked and RA_DeleteRenumberMergeXref was empty in the copy company.    So I copied them over to the test company table and did a reinit on it.   Still no joy.   I am baffled.  

Maybe back up to a test company code then reinitialize it to see if that table is the culprit.

Hi Tara/Doug,

   I reinitialized all the ones that Tara listed.   The RA_DeleteRenumberMergeXref has 430 records in it.   As I don't know what function it is used for, I am leery of wiping it out.  The client does a lot of RMAs..

I created a return in standard edition and ran the transaction generation.  The tables in the attached screen shot were modified.  You may check to see if there are any orphaned records in these tables that need to be cleared.

Hi All,   Ken at DSD looked at the code and the issue is that you cannot have any RMA's entered when enabling MB.   It can be moved out of urgent support.

@Robert Wood  I got an email from Ken Phillips directly but DSD said that Sage handles support for MB basic.  They of course had no ideas.   

@Robert Osborn, did you get a resolution from DSD?

Suggestion:

Postings to Urgent Support should require a written after action summary of how the issue was solved (or not). 

What was the resolution?

This can be moved out of urgent as I have contacted DSD.    Thanks everyone!

Hi All,   It is going to have to be a call to DSD.   I copied the company and when I accessed the copy, it said that MB was not enabled (so there is clearly something that does not get copied).  Went through the steps.  Did the DSD conversion and I was could enable MB in the warehouse.  I went back and looked and RA_DeleteRenumberMergeXref was empty in the copy company.    So I copied them over to the test company table and did a reinit on it.   Still no joy.   I am baffled.  

Maybe back up to a test company code then reinitialize it to see if that table is the culprit.

Hi Tara/Doug,

   I reinitialized all the ones that Tara listed.   The RA_DeleteRenumberMergeXref has 430 records in it.   As I don't know what function it is used for, I am leery of wiping it out.  The client does a lot of RMAs..

I created a return in standard edition and ran the transaction generation.  The tables in the attached screen shot were modified.  You may check to see if there are any orphaned records in these tables that need to be cleared.