Duplication in invoices

[uzmil1]

• Title: Sales Invoice Totals by Item shows duplicate/triplicate rows in desktop v25.11.3.3093

• 	Date	Transaction	Customer	Inventory Item	Qty	Amount	Balance
  

  Edit View 29/10/2025 Sales Invoice — 1621 — 29/10/2025 COUNTER SALE (RECEIABLE) X5 MULTI SOCKET 130 - 98,900.41 671,170.00
  Edit View 29/10/2025 Sales Invoice — 1621 — 29/10/2025 COUNTER SALE (RECEIABLE) X5 MULTI SOCKET 130 98,900.41 770,070.41
  Edit View 29/10/2025 Sales Invoice — 1621 — 29/10/2025 COUNTER SALE (RECEIABLE) X5 MULTI SOCKET 130 101,400.00 671,170.00
  Edit View 27/10/2025 Sales Invoice — 1618 — 27/10/2025 COUNTER SALE (RECEIABLE) X5 MULTI SOCKET 1 - 760.77 569,770.00
  Edit View 27/10/2025 Sales Invoice — 1618 — 27/10/2025 COUNTER SALE (RECEIABLE) X5 MULTI SOCKET 1 760.77 570,530.77
  Edit View 27/10/2025 Sales Invoice — 1618 — 27/10/2025 COUNTER SALE (RECEIABLE) X5 MULTI SOCKET 1 800.00 569,770.00
  Edit View 22/10/2025 Sales Invoice — 1609 — 22/10/2025 COUNTER SALE (RECEIABLE) X5 MULTI SOCKET 1 - 760.77 568,970.00
  Edit View 22/10/2025 Sales Invoice — 1609 — 22/10/2025 COUNTER SALE (RECEIABLE) X5 MULTI SOCKET 16 - 12,172.36 569,730.77
  Edit View 22/10/2025 Sales Invoice — 1610 — 22/10/2025 COUNTER SALE (RECEIABLE) X5 MULTI SOCKET 18 - 13,693.90 581,903.13
  Edit View 22/10/2025 Sales Invoice — 1609 — 22/10/2025 COUNTER SALE (RECEIABLE) X5 MULTI SOCKET 1 760.77 595,597.03
  Edit View 22/10/2025 Sales Invoice — 1609 — 22/10/2025 COUNTER SALE (RECEIABLE) X5 MULTI SOCKET 1 800.00 594,836.26
  Edit View 22/10/2025 Sales Invoice — 1609 — 22/10/2025 COUNTER SALE (RECEIABLE) X5 MULTI SOCKET 16 12,172.36 594,036.26
  Edit View 22/10/2025 Sales Invoice — 1609 — 22/10/2025 COUNTER SALE (RECEIABLE) X5 MULTI SOCKET 16 12,640.00 581,863.90
  Edit View 22/10/2025 Sales Invoice — 1610 — 22/10/2025 COUNTER SALE (RECEIABLE) X5 MULTI SOCKET 18 13,693.90 569,223.90
  Edit View 22/10/2025 Sales Invoice — 1610 — 22/10/2025 COUNTER SALE (RECEIABLE) X5 MULTI SOCKET 18 14,220.00 555,530.00
  Edit View 21/10/2025 Sales Invoice — 1608 — 21/10/2025 JAWAID GILGIT X5 MULTI SOCKET 67 - 49,729.16 541,310.00
  Edit View 21/10/2025 Sales Invoice — 1608 — 21/10/2025 JAWAID GILGIT X5 MULTI SOCKET 67 49,729.16 591,039.16
  Edit View 21/10/2025 Sales Invoice — 1608 — 21/10/2025 JAWAID GILGIT X5 MULTI SOCKET 67 52,930.00 541,310.00
  Edit View 20/10/2025 Sales Invoice — 1602 — 20/10/2025 COUNTER SALE (RECEIABLE) X5 MULTI SOCKET 6 - 4,453.36 488,380.00
  Edit View 20/10/2025 Sales Invoice — 1605 — 20/10/2025 COUNTER SALE (RECEIABLE) X5 MULTI SOCKET 214 - 158,836.40 492,833.36
  Edit View 20/10/2025 Sales Invoice — 1602 — 20/10/2025 COUNTER SALE (RECEIABLE) X5 MULTI SOCKET 6 4,453.36 651,669.76
  Edit View 20/10/2025 Sales Invoice — 1602 — 20/10/2025 COUNTER SALE (RECEIABLE) X5 MULTI SOCKET 6 4,770.00 647,216.40
  Edit View 20/10/2025 Sales Invoice — 1605 — 20/10/2025 COUNTER SALE (RECEIABLE) X5 MULTI SOCKET 214 158,836.40 642,446.40
  Edit View 20/10/2025 Sales Invoice — 1605 — 20/10/2025 COUNTER SALE (RECEIABLE) X5 MULTI SOCKET 214 166,920.00 483,610.00
  Edit View 18/10/2025 Sales Invoice — 1599 — 18/10/2025 COUNTER SALE (RECEIABLE) X5 MULTI SOCKET 7 - 5,163.94 316,690.00
  Edit View 18/10/2025 Sales Invoice — 1599 — 18/10/2025 COUNTER SALE (RECEIABLE) X5 MULTI SOCKET 16 - 11,803.30 321,853.94
  Edit View 18/10/2025 Sales Invoice — 1600 — 18/10/2025 COUNTER SALE (RECEIABLE) X5 MULTI SOCKET 22 - 16,229.53 333,657.24
  Edit View 18/10/2025 Sales Invoice — 1599 — 18/10/2025 COUNTER SALE (RECEIABLE) X5 MULTI SOCKET 7 5,163.94 349,886.77
  Edit View 18/10/2025 Sales Invoice — 1599 — 18/10/2025 COUNTER SALE (RECEIABLE) X5 MULTI SOCKET 7 5,530.00 344,722.83
  Edit View 18/10/2025 Sales Invoice — 1599 — 18/10/2025 COUNTER SALE (RECEIABLE) X5 MULTI SOCKET 16 11,803.30 339,192.83
  Edit View 18/10/2025 Sales Invoice — 1599 — 18/10/2025 COUNTER SALE (RECEIABLE) X5 MULTI SOCKET 16 12,480.00 327,389.53
  Edit View 18/10/2025 Sales Invoice — 1600 — 18/10/2025 COUNTER SALE (RECEIABLE) X5 MULTI SOCKET 22 16,229.53 314,909.53
  Edit View 18/10/2025 Sales Invoice — 1600 — 18/10/2025 COUNTER SALE (RECEIABLE) X5 MULTI SOCKET 22 17,490.00 298,680.00
  Edit View 16/10/2025 Sales Invoice — 1595 — 16/10/2025 COUNTER SALE (RECEIABLE) X5 MULTI SOCKET 64 - 47,213.18 281,190.00
  Edit View 16/10/2025 Sales Invoice — 1595 — 16/10/2025 COUNTER SALE (RECEIABLE) X5 MULTI SOCKET 64 47,213.18 328,403.18
  Edit View 16/10/2025 Sales Invoice — 1595 — 16/10/2025 COUNTER SALE (RECEIABLE) X5 MULTI SOCKET 64 49,920.00 281,190.00
  Edit View 15/10/2025 Sales Invoice — 1594 — 15/10/2025 COUNTER SALE (RECEIABLE) X5 MULTI SOCKET 3 - 2,213.12 231,270.00
  Edit View 15/10/2025 Sales Invoice — 1594 — 15/10/2025 COUNTER SALE (RECEIABLE) X5 MULTI SOCKET 3 2,213.12 233,483.12
  Edit View 15/10/2025 Sales Invoice — 1594 — 15/10/2025 COUNTER SALE (RECEIABLE) X5 MULTI SOCKET 3 2,400.00 231,270.00
  Edit View 14/10/2025 Sales Invoice — 1591 — 14/10/2025 COUNTER SALE (RECEIABLE) X5 MULTI SOCKET 5 - 3,688.53 228,870.00
  Edit View 14/10/2025 Sales Invoice — 1591 — 14/10/2025 COUNTER SALE (RECEIABLE) X5 MULTI SOCKET 1 - 737.71 232,558.53
  Edit View 14/10/2025 Sales Invoice — 1591 — 14/10/2025 COUNTER SALE (RECEIABLE) X5 MULTI SOCKET 3 - 2,213.12 233,296.24
  Edit View 14/10/2025 Sales Invoice — 1592 — 14/10/2025 COUNTER SALE (RECEIABLE) X5 MULTI SOCKET 6 - 4,426.24 235,509.36
  Edit View 14/10/2025 Sales Invoice — 1591 — 14/10/2025 COUNTER SALE (RECEIABLE) X5 MULTI SOCKET 5 3,688.53 239,935.60
  Edit View 14/10/2025 Sales Invoice — 1591 — 14/10/2025 COUNTER SALE (RECEIABLE) X5 MULTI SOCKET 5 3,950.00 236,247.07
  Edit View 14/10/2025 Sales Invoice — 1591 — 14/10/2025 COUNTER SALE (RECEIABLE) X5 MULTI SOCKET 1 737.71 232,297.07
  Edit View 14/10/2025 Sales Invoice — 1591 — 14/10/2025 COUNTER SALE (RECEIABLE) X5 MULTI SOCKET 1 800.00 231,559.36
  Edit View 14/10/2025 Sales Invoice — 1591 — 14/10/2025 COUNTER SALE (RECEIABLE) X5 MULTI SOCKET 3 2,213.12 230,759.36
  Edit View 14/10/2025 Sales Invoice — 1591 — 14/10/2025 COUNTER SALE (RECEIABLE) X5 MULTI SOCKET 3 2,400.00 228,546.24
  Edit View 14/10/2025 Sales Invoice — 1592 — 14/10/2025 COUNTER SALE (RECEIABLE) X5 MULTI SOCKET 6 4,426.24 226,146.24
  Edit View 14/10/2025 Sales Invoice — 1592 — 14/10/2025 COUNTER SALE (RECEIABLE) X5 MULTI SOCKET 6 4,710.00 221,720.00
  Edit View 13/10/2025 Sales Invoice — 1590 — 13/10/2025 COUNTER SALE (RECEIABLE) X5 MULTI SOCKET 16 - 11,803.30 217,010.00
  Edit View 13/10/2025 Credit Note — 1204 COUNTER SALE (RECEIABLE) X5 MULTI SOCKET 24 - 17,704.94 228,813.30
  Edit View 13/10/2025 Credit Note — 1204 COUNTER SALE (RECEIABLE) X5 MULTI SOCKET 24 - 19,200.00 246,518.24
  Edit View 13/10/2025 Sales Invoice — 1590 — 13/10/2025 COUNTER SALE (RECEIABLE) X5 MULTI SOCKET 16 11,803.30 265,718.24
  Edit View 13/10/2025 Sales Invoice — 1590 — 13/10/2025 COUNTER SALE (RECEIABLE) X5 MULTI SOCKET 16 12,640.00 253,914.94
  Edit View 13/10/2025 Credit Note — 1204 COUNTER SALE (RECEIABLE) X5 MULTI SOCKET 24 17,704.94 241,274.94
  Edit View 10/10/2025 Credit Note — 1205 COUNTER SALE (RECEIABLE) X5 MULTI SOCKET 2 - 1,475.41 223,570.00
  Edit View 10/10/2025 Credit Note — 1205 COUNTER SALE (RECEIABLE) X5 MULTI SOCKET 2 - 1,600.00 225,045.41
  Edit View 10/10/2025 Sales Invoice — P300 — 10/10/2025 ELECTROCITY (MR BADAR MUNIR) X5 MULTI SOCKET 10 - 7,377.06 226,645.41
  Edit View 10/10/2025 Credit Note — 1205 COUNTER SALE (RECEIABLE) X5 MULTI SOCKET 2 1,475.41 234,022.47
  Edit View 10/10/2025 Sales Invoice — P300 — 10/10/2025 ELECTROCITY (MR BADAR MUNIR) X5 MULTI SOCKET 10 7,377.06 232,547.06
  Edit View 10/10/2025 Sales Invoice — P300 — 10/10/2025 ELECTROCITY (MR BADAR MUNIR) X5 MULTI SOCKET 10 7,950.00 225,170.00
  Edit View 09/10/2025 Sales Invoice — 1580 — 09/10/2025 COUNTER SALE (RECEIABLE) X5 MULTI SOCKET 100 - 73,770.60 217,220.00
  Edit View 09/10/2025 Sales Invoice — 1580 — 09/10/2025 COUNTER SALE (RECEIABLE) X5 MULTI SOCKET 3 - 2,213.12 290,990.60
  Edit View 09/10/2025 Sales Invoice — 1582 — 09/10/2025 COUNTER SALE (RECEIABLE) X5 MULTI SOCKET 24 - 17,704.94 293,203.72
  Edit View 09/10/2025 Sales Invoice — 1580 — 09/10/2025 COUNTER SALE (RECEIABLE) X5 MULTI SOCKET 100 73,770.60 310,908.66
  Edit View 09/10/2025 Sales Invoice — 1580 — 09/10/2025 COUNTER SALE (RECEIABLE) X5 MULTI SOCKET 100 78,000.00 237,138.06
  Edit View 09/10/2025 Sales Invoice — 1580 — 09/10/2025 COUNTER SALE (RECEIABLE) X5 MULTI SOCKET 3 2,213.12 159,138.06
  Edit View 09/10/2025 Sales Invoice — 1580 — 09/10/2025 COUNTER SALE (RECEIABLE) X5 MULTI SOCKET 3 2,400.00 156,924.94
  Edit View 09/10/2025 Sales Invoice — 1582 — 09/10/2025 COUNTER SALE (RECEIABLE) X5 MULTI SOCKET 24 17,704.94 154,524.94
  Edit View 09/10/2025 Sales Invoice — 1582 — 09/10/2025 COUNTER SALE (RECEIABLE) X5 MULTI SOCKET 24 19,200.00 136,820.00
  Edit View 07/10/2025 Sales Invoice — 1575 — 07/10/2025 COUNTER SALE (RECEIABLE) X5 MULTI SOCKET 3 - 2,197.98 117,620.00
  Edit View 07/10/2025 Sales Invoice — 1575 — 07/10/2025 COUNTER SALE (RECEIABLE) X5 MULTI SOCKET 3 2,197.98 119,817.98
  Edit View 07/10/2025 Sales Invoice — 1575 — 07/10/2025 COUNTER SALE (RECEIABLE) X5 MULTI SOCKET 3 2,400.00 117,620.00
  Edit View 04/10/2025 Sales Invoice — 1573 — 04/10/2025 COUNTER SALE (RECEIABLE) X5 MULTI SOCKET 18 - 13,187.85 115,220.00
  Edit View 04/10/2025 Sales Invoice — 1573 — 04/10/2025 COUNTER SALE (RECEIABLE) X5 MULTI SOCKET 6 - 4,395.95 128,407.85
  Edit View 04/10/2025 Sales Invoice — 1573 — 04/10/2025 COUNTER SALE (RECEIABLE) X5 MULTI SOCKET 18 13,187.85 132,803.80
  Edit View 04/10/2025 Sales Invoice — 1573 — 04/10/2025 COUNTER SALE (RECEIABLE) X5 MULTI SOCKET 18 14,220.00 119,615.95
  Edit View 04/10/2025 Sales Invoice — 1573 — 04/10/2025 COUNTER SALE (RECEIABLE) X5 MULTI SOCKET 6 4,395.95 105,395.95
  Edit View 04/10/2025 Sales Invoice — 1573 — 04/10/2025 COUNTER SALE (RECEIABLE) X5 MULTI SOCKET 6 4,740.00 101,000.00
  Edit View 03/10/2025 Sales Invoice — 1572 — 03/10/2025 COUNTER SALE (RECEIABLE) X5 MULTI SOCKET 100 - 73,265.84 96,260.00
  Edit View 03/10/2025 Sales Invoice — 1571 — 03/10/2025 COUNTER SALE (RECEIABLE) X5 MULTI SOCKET 4 - 2,930.63 169,525.84
  Edit View 03/10/2025 Sales Invoice — P297 — 03/10/2025 ELECTROCITY (MR BADAR MUNIR) X5 MULTI SOCKET 10 - 7,326.58 172,456.47
  Edit View 03/10/2025 Sales Invoice — 1572 — 03/10/2025 COUNTER SALE (RECEIABLE) X5 MULTI SOCKET 100 73,265.84 179,783.05
  Edit View 03/10/2025 Sales Invoice — 1572 — 03/10/2025 COUNTER SALE (RECEIABLE) X5 MULTI SOCKET 100 78,000.00 106,517.21
  Edit View 03/10/2025 Sales Invoice — 1571 — 03/10/2025 COUNTER SALE (RECEIABLE) X5 MULTI SOCKET 4 2,930.63 28,517.21
  Edit View 03/10/2025 Sales Invoice — 1571 — 03/10/2025 COUNTER SALE (RECEIABLE) X5 MULTI SOCKET 4 3,200.00 25,586.58
  Edit View 03/10/2025 Sales Invoice — P297 — 03/10/2025 ELECTROCITY (MR BADAR MUNIR) X5 MULTI SOCKET 10 7,326.58 22,386.58
  Edit View 03/10/2025 Sales Invoice — P297 — 03/10/2025 ELECTROCITY (MR BADAR MUNIR) X5 MULTI SOCKET 10 7,950.00 15,060.00
  Edit View 01/10/2025 Sales Invoice — 1568 — 01/10/2025 COUNTER SALE (RECEIABLE) X5 MULTI SOCKET 9 - 6,593.93 7,110.00
  Edit View 01/10/2025 Sales Invoice — 1568 — 01/10/2025 COUNTER SALE (RECEIABLE) X5 MULTI SOCKET 9 6,593.93 13,703.93
  Edit View 01/10/2025 Sales Invoice — 1568 — 01/10/2025 COUNTER SALE (RECEIABLE) X5 MULTI SOCKET 9 7,110.00 7,110.00
  671,170.00

[shahabb]

Why dont you use Advance Query on Sales Invoices Tab?

[uzmil1]

How

[shahabb]

Go to Sales Invoices Tab. Then

[uzmil1]

thanks

just check there is no duplication or triplication

if u r in pakistan can u support me remotely

[OBAdmin]

Yeah this is helpful.. I use it too. Actually Manager IO is really user friendly software only the user need to explore the tabs