Debtors & Accounting Modules: "Post Record" Doesn't Function

[New2SQL]

Hello,

When attempting to "post record" in the invoicing section in either module, nothing happens. It behaves as though the post record button is never even clicked.


Also, when clicking "Accounts List" in the Maintenance section of the accounting module, I'm presented with an error:

Error
An error has occurred while running this query. Please contact technical support and quote error reference: 23dc0b1.
The following information is only provided for users logged on as globeadmin.

SQL

SELECT ledger.led_code, ledger.led_name, ledger.led_type, if( ledger.led_postable =1, 'Yes', ' No' ), parent.led_code, `ledger.ledger_id` FROM ledger INNER JOIN zzsys_list ON sli_option = ledger.led_type LEFT JOIN ledger AS parent ON ledger.led_parent_ledger_id = parent.ledger_id WHERE sli_name = 'FMaccounttype' GROUP BY ledger.led_code ORDER BY ledger.led_code LIMIT 0, 27

Transaction

No Transaction.
Error

1054: Unknown column 'ledger.ledger_id' in 'field list'

URL

http://

[admin]

New2SQL,

We have got rid of frames from nuBuilder and haven't been able to remove all references to it yet but the problem is probably in the spot below..

Untitled.png

for the Post button.

parent.frames[0].document.forms[0];

should be now ..

parent.document.forms[0];

And as a work around for the Accounts list until its fixed ..

Capture.PNG

change ledger.ledger_id
to
ledger`.`ledger_id

Steven