Customer Management Detail

Customer Management Detail is a Sage 50 US Ready-to-Use Report for Accounts Receivable review. It shows customer invoice details, due dates, credit status, current balances, and amount remaining for the date range selected on the Instructions worksheet.

Prerequisites

1. Microsoft Windows 10 Pro, Windows 11 Pro, or Windows terminal server (2012 and above)
2. Microsoft Office 365
3. Sage 50 US edition (2021 and above)
4. Internet connection

What the Report Does

Customer Management Detail uses Instructions date inputs C8 and C9 to build the period heading on Report. The Report worksheet lists customer invoice rows with Customer ID, Customer Name, Invoice Number, Due Date, Credit Limit, Current, Amount Remaining, and Days to Pay. The workbook's hidden Data worksheet supports the visible output and includes a Days to Pay calculation that returns 0 when the amount remaining is 0 and otherwise compares the due date with today's date. The visible Report worksheet also includes a Grand Total row for the amount remaining shown in the output.

How to Use the Report

Step 1) Enter the date range on Instructions by updating C8 for the start date and C9 for the end date.

Step 2) Click Refresh on the Logicim XLGL ribbon to update Customer Management Detail.

Step 3) Click Go to Report on Instructions to move to the Report worksheet.

Step 4) Review Report to confirm the company name, selected period, customer rows, invoice numbers, due dates, credit limits, current balances, amount remaining, and days-to-pay values.

Customization Options

You can change the selected period by editing C8 and C9 on Instructions, then refreshing the Report. You can also use normal Excel formatting, filtering, or sorting on a copy of the workbook when you need a different view. For structural changes, additional fields, different calculations, or a redesigned Accounts Receivable layout, use the customization link on Instructions or request a Custom Report from Logicim.

Common Use Cases

1. Review Accounts Receivable customer invoice detail for a selected period.
2. Check due dates, amount remaining, and days-to-pay values for collection follow-up.
3. Compare credit limits, current balances, and amount remaining across customers.
4. Use the Grand Total row to reconcile the total amount remaining shown by Customer Management Detail.

Troubleshooting

1. Issue: The period shown on Report does not match the review period. Solution: Confirm the Start date in C8 and End date in C9 on Instructions, then click Refresh on the Logicim XLGL ribbon.
2. Issue: The Report shows information for the wrong company. Solution: Confirm that Logicim XLGL is connected to the correct Sage 50 US company. The company name appears near the top of Report.
3. Issue: An expected customer or invoice is missing. Solution: Confirm that the invoice belongs in the selected date range and that the customer invoice data exists in Sage 50 US, then refresh the Report.
4. Issue: A Days to Pay value looks unexpected. Solution: Check the related invoice due date and amount remaining in Sage 50 US. The workbook calculation returns 0 when the amount remaining is 0 and otherwise compares the due date with today's date.

FAQs

1. Q: Which dates control Customer Management Detail? A: The Start date in C8 and End date in C9 on Instructions control the period heading and refreshed output.
2. Q: What detail does the Report worksheet show? A: It shows customer ID, customer name, invoice number, due date, credit limit, current balance, amount remaining, and days-to-pay values.
3. Q: Does the workbook include a visible chart worksheet? A: No visible Chart worksheet was found in the inspected workbook. The customer-facing output is on Report.
4. Q: Can this Report be changed to include more Accounts Receivable fields? A: Yes. Use the customization link on Instructions or request a Custom Report from Logicim.

Best Practices

1. Confirm the Sage 50 US company name at the top of Report before relying on the output.
2. Refresh the Report after changing C8 or C9 on Instructions.
3. Review the Amount Remaining values and Grand Total row after each refresh.
4. Keep an unchanged copy of the workbook before making layout, sorting, filtering, or formatting changes.