Knowledgebase:
Invoice Line already exist - CO LINE
Posted by Steve Kulow, Last modified by Steve Kulow on 13 March 2024 08:09 AM

If you receive an error message when trying to print or email an invoice.

update the table with a new line number for the line that is in the error message.

splashtop into TDF server and start SQL server management studio and update the below commands for what you need to fix.

select No_, [Line No_], *

from [Campbell Supply$Sales Invoice Line]

where [Document No_] = 'INV-00479465'

update [Campbell Supply$Sales Invoice Line]

set [Line No_] = '89998'

where [Document No_] = 'INV-00514570' AND [Line No_] = '89995'

(0 vote(s))
Helpful
Not helpful

Comments (0)
GFI HelpDesk