Prompt [I have a report with a Sage Tab and a CW tab showing customers with invoice numbers, amounts, and other information. The reports came from two different systems. Compare "Inv no." + "Invoice Balance" and list only rows where the Invoice Balance differs by more than $0.01 or where the invoice exists on only one tab. Return "Inv no.", "Invoice balance" from each tab, and a Reconciliation Notes column. Once discrepancies have been identified, exclude from reporting on any rows where Invoice Balance amount is 0. Export the report to an Excel file.] 的热门建议 |
反馈