Small and medium business | Business Central, N...

Report : Linking Posted Credit Memo Lines to Posted Sales Invoice Numbers

(1) Share

Report

Posted on by LizHK

187

I have a need to do a mass lookup for Credit Memos to see what sales-order or posted sales invoice is it coming from.

For example below,

I would like to have a line by line item of first and second line to have PSI-04050 attached to it.

I have done this by a little complicated and not so perfect power query manipulation using the comment line above but I always wonder there should be a better way and the system would have a mapping to where this line belongs to.

I cannot find the link very well - I looked in Item Ledger Entries, Value Entries, etc to see if there is an easy link I could find but I somehow cannot find it but I'm thinking it maybe because there are too many columns and I am missing something.

How do they link together?

I need a ship to address populated for returns (one customer with multiple ship-to-location) and currently I use this but I have another need from Warehouse KPI and thought there should be a better way to do this.

Thank you!

I have the same question (0)

All responses (8)

Answers (0)

Suggested answer

YUN ZHU 93,024 Super User 2025 Season 2 on at

Like (2)

Report

Report : Linking Posted Credit Memo Lines to Posted Sales Invoice Numbers

The following table exists in the system. If you cancel using the standard method, it will be recorded in this table. You can check it first.

table 1900 "Cancelled Document"

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Yi Yong 2,462 Super User 2025 Season 2 on at

Like (2)

Report

Report : Linking Posted Credit Memo Lines to Posted Sales Invoice Numbers

Hello Liz,

I have written by pointers, I hope you can follow me through.

#1 From Sales Credit Memo Line -> Find Item Entry No.

Each line item on the credit memo will be linked to an item entry.

#2 From Item Entry No. -> Find Shipment No.

Each item ledger comes from a shipment line.

#3 From Value Entries -> Find Invoice No.

You must filter with 'Invoiced Quantity' <> 0.

You can get the Sales Order No. from either Sales Shipment Header or Sales Invoice Header.

This method is based on the scenario where you post from sales order -> sales shipment -> sales invoice.

I believe you can still use this method if you posted sales order -> sales invoice directly.

Was this reply helpful? Yes No
LizHK 187 on at

Like (1)

Report

Report : Linking Posted Credit Memo Lines to Posted Sales Invoice Numbers

Thank you Yi Yong - that's exactly what I was looking for but unfortunately for my purposes nothing is populated for me in that field.

There were a few places like that I was disappointed that they have nothing. I wonder what makes it populate and what doesn't. Even item ledger entry had some field like that which only populated when there was a cancelled return associated with it and was linked to that.

Example below:

Thanks,

Was this reply helpful? Yes No
Suggested answer

Yi Yong 2,462 Super User 2025 Season 2 on at

Like (1)

Report

Report : Linking Posted Credit Memo Lines to Posted Sales Invoice Numbers

Hello Liz,

There are a couple of reasons why there are sales credit memo lines without Appl.-From Item Entry; because changes are made to the line after using the 'Get Posted Document Lines to Reverse...' or the sales credit memos are not created using 'Get Posted Document Lines to Reverse...'.

To prevent this, you need to turn on 'Exact Cost Reversing Mandatory' on the Sales & Receivable Setup.

(It is recommended to turn on this setting on both Sales Setup and Purchase Setup)

In such cases, items are returned without relationship to sales shipment. I don't think there is a way to trace it back via Ledger Entry.

I will suggest you use the Sales Credit Memo's 'Applies-to Doc. No.' if your practice is 1 credit memo = 1 invoice

Or

Use Detailed Customer Ledger Entry to trace the invoices applied to the CN.

Was this reply helpful? Yes No
LizHK 187 on at

Like (1)

Report

Report : Linking Posted Credit Memo Lines to Posted Sales Invoice Numbers

Thanks again for the follow up Yi Yong:

We do have setting for that :

Also our practice for returns is that we go through : and thus the comments above (with posted sales invoices and shipment numbers are generated in comment - wish it was generated for the line itself!! - we don't know how else to do returns - thought the system didn't allow us to return anything without any source sales. (we had to use G/L when we first switched to BC)

I will look at the G/L and other info.

YUN ZHU - thanks for the table. that was very cool and never knew that table existed but it only had some of the mapping not all- maybe only fully reversed invoices get there? I got in using table=1900 but couldn't find a page with it.

Thank you both - for now I may just have to use the comments above to map them. :)

Was this reply helpful? Yes No
Suggested answer

Yi Yong 2,462 Super User 2025 Season 2 on at

Like (0)

Report

Report : Linking Posted Credit Memo Lines to Posted Sales Invoice Numbers

Hello Liz,

You might want to double-check if anyone turned off the field.

Below is an example of what will happen if the 'Exact Cost Mandatory Reversal' is turned on with a blank Appl.-From Item Entry line.

The credit memo cannot be posted.

Was this reply helpful? Yes No
LizHK 187 on at

Like (0)

Report

Report : Linking Posted Credit Memo Lines to Posted Sales Invoice Numbers

Thanks again : Yi Yong

I am so confused. That setting was always like that and still is.

( I haven't changed mine when I screenshot it - it was like that).

Last time the page was modified was this Jan 2024 so I am really not sure.

Only 58 rows have populated field there with 2.8K+ rows of items returned.

Thanks,

Was this reply helpful? Yes No
Yi Yong 2,462 Super User 2025 Season 2 on at

Like (0)

Report

Report : Linking Posted Credit Memo Lines to Posted Sales Invoice Numbers

Hello Liz,

I suggest you copy the production to a sandbox and do throughout testing. You may also want to test with third-party extensions uninstalled.

As shown, the standard behaviour will block you from posting the sales credit memo.

It will be helpful if you can verify the answers so that users with facing similar issue knows what to look for.

Was this reply helpful? Yes No