RMA-generated credit memo does not grab product group from invoice (right?)

I think I have this right, but I’d like some feedback.

I make an RMA for an existing invoice (and line) and it grabs the COS account from the product group on the related sales order. (I verified this in the PE Log Viewer.) This makes sense to me.

In that same screen (RMA Processing), I make a credit memo from the RMA. By default, it seems to grab the product group from the part setup, not from the sales order. (FYI, they are always different where I work.)

That one is the mystery. It just does the CM, so it’s not like I can use PE Log Viewer to determine its logic (right?).

I know I could override it, but come on! It got it right on the RMA, so why not on the CM?

If you disagree, I’d be happy to know what I am doing wrong.

2 Likes

That does the inventory trans tech say?.. Oh that’s right technical documents don’t talk…That’s a whole other conversation these days :sob:

Is this a config setting?

Well I don’t know - hopefully someone else does.

I don’t see a lot on Company Configuration:

image

I’m not familiar with RMA, and I could be reading the wrong section of the code, but as far as I can see it should work as you said.

InvcDtl.OrderNum and OrderLine come from RMADtl.

And InvcDtl.ProdCode comes from OrderDtl.ProdCode, IF OrderDtl doesn’t exist or its ProdCode is empty, then it takes it from the Part.

To clarify, I think you are saying it should use the invoice’s product group - or at least the sales order’s group - in both the RMA and the CM?

I’ll run another test to verify. Hopefully it’s my error.

Ok RMA aside how does a credit memo work against and invoice? A bit of testing on the RMA, you can raise a credit memo for an invoice, add an line then put in an a bogus part number description and reason, then go and click on the Credit button and it will create a credit memo the product group is empty. You don’t even have to receive of disposition the RMA, just close it, then you can pick up the credit in AR invoice entry.

I did a few scenarios in the education system. In the first instance 00M1a has no product group and the credit screen on in RMA entry reflects that

Second I picked up another invoice and selected the line and the part had a product group.

and finally I just added an RMA line gave it a qty and a UOM, used a bogus part and description and got no product code.

.

I have not posted this yet, but based on the AR Hierarchy tech doc it clearly states

I thought for a moment it might be getting the product group from the sales order, but I tested that too and it is definitely getting it from the part.

So I am just as confused as you are… All I can think of is that if the business rule is use the product group on the SO then you will have to override it either in posting rule or on the BPMs for the invoice maintenance screen. Would be nice to have an option to just use the PG from the sales order if empty use part PG, at least for your use case…

Still the same.

Here is the original invoice:

Here is the RMA CM (I only did line 2):

Groups are different.

And now I’ll read the response from @Hally

1 Like

So invoice is getting the group from the SO, and the credit from the part… I think we know the answer.

But the point is, this is FROM the RMA.

Maybe this is not common knowledge, but there is a button in the RMA screen that creates the CM for you.

1 Like

No, I only meant that the credit memo line product group should come first from the sales order line referenced in the rma detail. If there is none then it goes to the part.

1 Like

Yes I was using classic and its down the bottom of the credtis tab, that’s what brings up the MDI RMA credit window, it is specific to RMAs

I was really trying to say, what happens if you raise a standard CM against an invoice rather than using RMA, does the product group come from the invoice line or the part?

Oh, OK. Gotcha.

OK I see what you are saying now. Well that’s crazy if an ordinary CM does this, too.

image

Yeah this is part of what is mind-boggling - “Use the product group.” OK, but which product group?

It’s just so vague/wrong/etc.

Sorry, @Jonathan not trying to beat you up. I feel like we scared you off for a while. I do appreciate your feedback here.

Don’t worry, I think I was able to replicate it, now I’m invested, give me some time to get back to this and see what is happening.

4 Likes

So the reason why the product group is taken from the part and not the sales order is because you specified an Invoice Number/Line.

If you enter the sales order/line/release only, then it works as expected, but as far as I can see that also changes how some information on the credit memo is calculated/defaulted.

It sounds like a bug, you would need to report it.

4 Likes

I don’t exactly want to say “it makes sense,” but I understand the explanation anyway. Thank you for investigating.

To state the obvious, I personally would want the user to use the invoice, not just the order.

Yeah, wish me luck on reporting it….

2 Likes

Thanks for coming along with the user here and digging into it. Very kind and genuine of you!

2 Likes

To wrap this up, I should clarify this.

It’s the INS-DMR transaction that I am referring to. (Aka the RMA disposition.)

Even when I reference the invoice (not only the order), it grabs the product group from the order. (That’s good.)

Here is PE Log Viewer to prove that I didn’t just guess at that:

2 Likes

The answer I received from support is that KB0063732 provides the authorized way to create an RMA CM, and there is no mention of the original invoice number, therefore it is not supported.

So I’ll make an Idea for it.

Side note - I looked to see if such an Idea existed already.

There is not, but I was intrigued by this one that was Delivered. Apparently in 2024.1 you can create an RMA from a whole invoice. I have not researched this yet, so I don’t know how it works. Sounds like you need the customer number first. That’s a little annoying, but we’ll see.

Jason,
I remember putting an enhancement request for this way back in the day. We ended up doing a BPM or data directive (can’t remember which) to set the product group and sales category.
The other interesting thing we ran into was a change in the way RMA disposition back to stock worked with using AR clearing. It offset the clearing account expecting a credit memo issued for the amount, rather than inventory. That was an enhancement request that was made which we would have preferred it not to do. The solution was to customize the posting rule or fail these to DMR and then accept to stock from the DMR.
I am still waiting for an enhancement/Kinetic Idea to come out to stop deleting the RMA credit from the RMA if accounting deletes one of the credit memos from their invoice batch…
Jenn

1 Like