/
Sorting on the Invoice No field in debtors Customer Activities > Unprocessed Sales Order is disabled

Sorting on the Invoice No field in debtors Customer Activities > Unprocessed Sales Order is disabled

Owned by Beth Blok (Unlicensed)
Nov 08, 2019
1 min read

Problem

You can sort by all columns except the Invoice No. column the Unprocessed Sales grid in Debtor Maintenance

Solution

SQL skills required

A working knowledge of SQL Management Studio is required to complete this task.

Download and apply the attached stored procedure to enable sorting on the Invoice No field

Related articles







Related content

Customer Activities tab - Unprocessed Sales to include Job Costing invoices and other non inventory items
Customer Activities tab - Unprocessed Sales to include Job Costing invoices and other non inventory items
Jiwa 7
More like this
CRMGT040 - Creditors Listing - Transaction Due Date Report - V 7.00.175.00 SR13, V 7.02.01 SR4
CRMGT040 - Creditors Listing - Transaction Due Date Report - V 7.00.175.00 SR13, V 7.02.01 SR4
Jiwa 7
More like this
CRM Dashboard "My Customer Invoices Overdue" displays incorrect data
CRM Dashboard "My Customer Invoices Overdue" displays incorrect data
Jiwa 7
More like this
Debtor Child sales orders do not appear in the Parent / Head Office account - 7.00.175 SR10 and prior
Debtor Child sales orders do not appear in the Parent / Head Office account - 7.00.175 SR10 and prior
Jiwa 7
More like this
Debtors statements to print un-aged fully allocated transactions
Debtors statements to print un-aged fully allocated transactions
Jiwa 7
More like this
DBINF025 - Debtor Contact Details Report
DBINF025 - Debtor Contact Details Report
Jiwa 7
More like this