Credit Memo SAP B1: Step-by-Step Guide

Creating a credit memo in SAP Business One (SAP B1) is a standard way to correct an invoice, issue a refund, or apply a discount after a sale. This guide walks you through the process, from opening the right screen to posting the document. You’ll also find common pitfalls and troubleshooting tips to avoid delays and posting errors.

What You’ll Need

• Access to SAP B1 with a user account that has permission to create A/R Credit Memos (Sales – A/R module).
• A posted Sales Invoice (or a Delivery/Return) that you want to credit.
• The business partner (customer) code and any relevant item or service codes.
• If you are crediting a partial amount, know the exact amount or quantity to return.
• Your company’s approval workflow (if any) for credit memos – some setups require a manager’s approval before posting.

Step-by-Step

1. Open the Credit Memo screen. Go to the SAP B1 main menu, navigate to Sales – A/R → Credit Memo. Alternatively, use the search bar and type “Credit Memo” and select the A/R Credit Memo option.
2. Choose the base document (optional but recommended). In the Credit Memo window, click the Copy From button (or press Ctrl+B) to open the “Copy From” list. Select the Sales Invoice (or Delivery) you want to credit. This automatically pulls the customer, items, quantities, and prices, reducing manual entry errors.
3. Select the document to credit. In the list, find the specific invoice you want to credit. You can filter by document number, date, or customer. Click on the row to highlight it, then click OK. SAP will populate the credit memo with the invoice’s details.
4. Adjust quantities and amounts. Review the items and quantities. If you are issuing a full credit, leave as is. For a partial credit, change the quantity or amount in the lines. You can also delete lines you don’t want to credit. Ensure the total appears in the “Total” field at the bottom.
5. Set the posting date and due date. The “Posting Date” is the accounting date for the credit memo. The “Due Date” is when the refund is due (if applicable). SAP usually defaults to the current date, but you can change them if needed.
6. Add a remark (optional). In the “Remarks” field, type a short explanation for the credit (e.g., “Return of damaged goods” or “Price adjustment per agreement”). This helps with auditing.
7. Check the accounting details. Click the Accounting tab to verify the G/L accounts that will be affected. Usually, the system automatically uses the same accounts as the original invoice (revenue, tax, etc.). If you need to change an account (e.g., for a discount), you can edit it here.
8. Validate the document. Click the Add button (or press Ctrl+A) to save the credit memo as a draft. SAP will run validation checks. If there are errors, you’ll see a message at the bottom – fix them before proceeding.
9. Post the credit memo. After adding, the document is in a “Draft” status. To post it, click the Post button (or press Ctrl+P). This will update inventory (if items are returned) and create the accounting entries. You’ll see a confirmation message with the document number.
10. Verify the posting. Go to the document and check the “Status” – it should show “Posted”. You can also run the “Journal Entry” report to see the accounting impact.

Common Mistakes

• Copying from the wrong document. Ensure you select the correct invoice. Crediting the wrong invoice can create mismatched balances.
• Forgetting to change the posting date. If you are crediting a sale from a previous period, the posting date may affect financial reports. Always set the correct date.
• Crediting more than the original amount. SAP B1 will warn if the credit exceeds the invoice total, but you can still force it. This can lead to negative balances or errors.
• Not using the “Copy From” feature. Manually entering items increases the risk of typos in item codes, quantities, or prices.
• Posting without checking the G/L accounts. If your company uses different revenue accounts for different product lines, the automatic copy might not assign the correct ones. Always review the Accounting tab.

Tips

• Use the “Copy From” function every time – it saves time and reduces errors.
• If you regularly issue credits for the same reason (e.g., “Damaged goods”), create a user-defined field or use a standard remark to categorize them for reporting.
• For partial credits, consider using the “Return” document first (if you are receiving goods back) and then create the credit memo from that return. This keeps inventory accurate.
• Set up approval workflows for credit memos if your company requires it – this prevents unauthorized credits.
• After posting, always check the “Item” and “Business Partner” balances to ensure they are correct.

Troubleshooting

• Error: “Posting date is in a closed period.” This happens when the posting date falls in a period that is closed for accounting. Change the posting date to an open period, or ask your admin to open the period.
• Error: “No data for this document.” When copying from a base document, this error usually means the selected document has no lines (e.g., it was cancelled). Choose another document.
• Error: “Quantity exceeds delivered quantity.” You are trying to credit more items than were originally delivered. Reduce the quantity to the delivered amount.
• Credit memo posts but inventory doesn’t update. Check if the item is a “Sales Item” or “Service” – service items don’t affect inventory. Also, verify that the “Return” checkbox is not set incorrectly.
• Cannot find the credit memo after posting. Use the “Document Number” or search by customer in the “Credit Memo” list. If it’s still not visible, check your user permissions – you might not have access to posted documents.

Frequently Asked Questions

Q: Can I create a credit memo without a base document?
Yes, you can create a standalone credit memo by leaving the “Copy From” blank and manually entering the customer and items. This is useful for one-off adjustments not tied to a specific invoice.

Q: What’s the difference between a credit memo and a return?
A return (A/R Return) is used when goods are physically returned and updates inventory. A credit memo is a financial document that reduces the customer’s balance. You can create a credit memo from a return, but they serve different purposes.

Q: How do I apply a credit memo to an open invoice?
After posting the credit memo, you can apply it to an invoice via the “Incoming Payments” screen. Select the customer, then choose the credit memo and the invoice to match.

Q: Can I change a posted credit memo?
No, posted credit memos cannot be edited. You must cancel it (create a reversing credit memo) and create a new one with the correct details.

Q: Why is the credit memo not affecting my tax report?
Check the tax code on the credit memo lines. It should match the tax code used on the original invoice. If the tax code is missing or different, the tax report may not reflect it correctly.

Q: What if I need to credit only the tax amount?
You can create a credit memo with a line for the tax account only, but this is unusual. It’s better to credit the full invoice and then adjust the revenue account. Consult your accountant for tax-specific adjustments.

Credit Memo Template

Related

• Credit Memo Bir: Definition & How It Works
• Credit Memo BIR Registered? What You Need to Know
• Credit Memo Accounting Entry: How to Record It