When a customer wants to return items from a previous invoice, Business Central lets you copy credit memo data directly from the original posted document. This guide covers the copy document function, how to use it to create a sales credit memo, and why it saves time over manual entry.
Why Manually Re-Entering Data Is a Problem
When a customer calls to request a credit for a previous invoice, the classic approach is to open a new sales credit memo and re-enter every item from the original invoice by hand. For small invoices with one or two lines, this is quick. For larger invoices with many lines, however, it becomes slow and prone to errors.
In fact, the risk grows with each line you add. You might miss a line, use the wrong price, or enter the wrong amount. Each mistake takes time to find and fix. For a five-line invoice, these errors are small. For a twenty-line invoice, they can slow down the whole process.
Moreover, this is a common issue for teams that handle a high volume of credits each month. Even one missed line can lead to a wrong credit memo. Otherwise, the customer may come back with a dispute, and you have to trace the error through both documents. Whereas a copied document is exact, a typed one carries all this risk.
The original invoice already has all the correct data. Business Central gives you a way to bring it across in one step. Overall, the result is faster, cleaner, and more accurate every time.
The Copy Document Function
Business Central includes a Copy Document action on most sales and purchase documents. Specifically, on the sales credit memo, you find it under the Prepare menu in the menu bar. When you run it, a pop-up window asks you to choose a document type and pick the document to copy from.
The document type list includes posted invoices, posted credit memos, sales orders, and more. For this task – copying a posted invoice to copy credit memo data – select Posted Invoice as the document type. Business Central then shows a list of posted sales invoices for the selected customer. Additionally, the list is pre-filtered to that customer, so you only see their documents.
Step by Step: How to Copy Credit Memo Data
Start by creating a new sales credit memo and selecting the customer. Then go to the Prepare menu and click Copy Document. In the pop-up, set the document type to Posted Invoice. The three-dot lookup lets you browse posted invoices for this customer – sort by date to find the right one fast.
Select the invoice you want to credit and click OK. Business Central then asks two questions: do you want to include the header details, and do you want to recalculate the lines?
Indeed, these two options are easy to miss. For instance, if you leave Recalculate Lines turned on, Business Central will apply the current price list to each item. That means the credit memo will not match the original invoice. For a credit that should reverse a specific charge, this is not what you want. Consequently, always check both options before you click OK.
Include Header and Recalculate Lines
The Include Header option copies customer details, payment terms, and other header fields from the source document. In most cases, leave this unchecked. You have already set the customer on the new credit memo, and you want to enter any date or payment changes by hand.
The Recalculate Lines option recalculates prices based on current price lists. For a credit memo that should match a specific past invoice, uncheck this. You want the exact prices from the original invoice, not the current ones. Unchecking both options ensures the copied data matches the source exactly.
What Gets Copied
Once you click OK, Business Central copies all lines from the posted invoice into the new sales credit memo. Each item, amount, and price copies across. If a line had a partial amount on the original invoice – for example, four chairs were invoiced out of an order of five – the copied line shows the invoiced amount, not the original order amount.
Business Central also adds a comment line showing which document the data came from. For example, it might say Copied from Posted Sales Invoice 10321-6. This is useful for tracing the credit back to its source when you review the posting later.
From here, you can edit if needed – adjust amounts, remove lines, or add a note. However, for a standard credit that matches the original invoice, you can post directly. Specifically, the copy step does all the setup work. There is no need to re-enter items, look up prices, or check line details again. For instance, you might want to split a credit across two memos, or apply a discount before posting. Either way, you start from a correct base, not from scratch.
Copy Credit Memo vs. Sales Return Order
The copy document function works for both the sales credit memo and the sales return order. The choice depends on your process, not on the copy function itself. If you need a two-step process – receive goods first, then issue the credit – use the sales return order. If you want a single posting step, use the sales credit memo.
In both cases, the copy credit memo approach saves you the same time. The copy function pulls all line data from the original invoice. Thus, you avoid re-entering items regardless of which document type you use.
In addition, both document types use the same Copy Document pop-up. The steps are the same. Only the document type on the screen changes. Likewise, the same approach works for purchase documents – if you need to credit a vendor, you can use the copy function on a purchase credit memo. The process is the same: copy from the posted purchase invoice and adjust if needed.
When the Invoice Is Not the Most Recent One
Notably, you are not limited to the most recent invoice. The lookup window shows all posted invoices for this customer. You can sort by date, filter by number, or scroll to find the one the customer is asking about.
This matters when a customer calls about an older invoice, not the last one you sent. For example, suppose the customer wants a credit for invoice number 103216, but you have sent three more invoices since then. Simply find 103216 in the list, select it, and copy. Business Central brings across exactly those lines – the right items, the right amounts, the right prices from that document.
Furthermore, if you are not sure which invoice is correct, you can open each one to check before you copy. This gives you full control over which document you use as the source. You do not have to guess or scroll through a long list of line items to verify the data.
Wrapping Up: How to Copy Credit Memo in Business Central
The copy credit memo approach in Business Central cuts out manual data entry when processing a customer return or credit. You create a new sales credit memo, use the Copy Document function under Prepare, select the posted invoice, uncheck Recalculate Lines, and click OK. Business Central does the rest – bringing across every line with the correct amounts and prices. The bigger the original invoice, the more time this saves.
For more Business Central guides and tutorials, visit NAV SEAL Blog and watch more videos on our YouTube Channel.
