Client » bioinnova

Problem¶

When attempting to create a Payment for either Sales or Purchase, after filling out the payment form and clicking Create, the system shows an error toast:

Error: column "transactionRefNo" does not exist

As a result, the payment is not recorded, and the process cannot be completed.

Expected Behavior¶

• Payment should be created successfully when the form is correctly filled.
• No server/database errors should be thrown.
• If transactionRefNo is required:
  • It should be included in the database schema.
  • Or it should be validated as optional and handled gracefully.

Requirements¶

• Investigate and fix the missing column issue.
• Ensure transactionRefNo field is:
  • Properly mapped in the backend (if required)
  • Present in the database table (migration may be needed)
  • Not referenced in backend code if not needed
• Ensure form submission proceeds without error.

Acceptance Criteria¶

• User can successfully create a payment for sales or purchase.
• No error message appears after clicking Create.
• If transactionRefNo is shown in UI, it is saved properly.
• Database structure matches expected fields.

Notes¶

• Check backend model/schema for the payments table.
• Review recent updates or migrations related to transactionRefNo.