Main.Accert.insert_new_COA#

Accert.insert_new_COA(c, ind, supaccount, level, code_of_account, account_description=None, total_cost=0, review_status='Added', prn='0')[source]#

Insert a new COA in between an index in the account table.

Parameters:

  • c (MySQLCursor) – MySQLCursor class instantiates objects that can execute MySQL statements.

  • ind (int) – Index of the new inserted COA.

  • supaccount (str) – Super account of the new inserted COA.

  • level (int) – Level of the new inserted COA.

  • code_of_account (str, optional) – COA of the new inserted COA, by default “new”

  • account_description (str, optional) – Account description of the new inserted COA. (By default none)

  • total_cost (int, optional) – Total cost of the new inserted COA. (Set to 0 dollars by default)

  • review_status (str, optional) – Review status of the new inserted COA. (By default ‘Unchanged’)

  • prn (str(float), optional) – Percentage of the total cost of new inserted COA. (Set to 0% by default)