Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Enter Payment to Vendor
01-06-2018, 10:15 AM,
#1
Enter Payment to Vendor
I tried to enter a payment to a vendor and ran into a couple of problems:

1) It shows the invoices that need to be paid and I can click in a box to include those invoices in the payment. however, when I press "Update", nothing happens.

2) I tried to just enter the information into "Supplier Transactions Payment Entry" section.

However, I get this error:
Database Error 1054 : Cannot insert a payment transaction against the supplier because
Unknown column 'chequeno' in 'field list'

Database SQL Failure : Cannot insert a payment transaction against the supplier using the SQL
INSERT INTO supptrans ( transno, type, supplierno, trandate, inputdate, suppreference, rate, ovamount, transtext, chequeno ) VALUES ('147', 22,'4114','2018-01-05','2018-01-05 17-45-51','Cash','566','-405761','', '')

In looking at the database, I do not have the column chequeno in the supptrans table.

Should I put this column in or is it an error in the script?
Reply


Messages In This Thread
Enter Payment to Vendor - by briantmg - 01-06-2018, 10:15 AM
RE: Enter Payment to Vendor - by briantmg - 01-07-2018, 02:06 AM
RE: Enter Payment to Vendor - by TurboPT - 01-07-2018, 02:55 AM
RE: Enter Payment to Vendor - by briantmg - 01-07-2018, 03:55 AM
RE: Enter Payment to Vendor - by TurboPT - 01-07-2018, 05:26 AM
RE: Enter Payment to Vendor - by TimSchofield - 01-08-2018, 08:10 AM
RE: Enter Payment to Vendor - by VortecCPI - 01-09-2018, 01:25 AM
RE: Enter Payment to Vendor - by TimSchofield - 01-09-2018, 02:10 AM

Forum Jump:


Users browsing this thread: 1 Guest(s)