Table is not showing the values

Frappe Framework App Development
1

My table is receiving the values, but it’s not showing them…

Follow the Label and Name of table fields:
Type = reference_doctype
Name = reference_name
Total Amount = total_amount
Outstanding amount = outstanding_amount
Allocated amount = allocated_amount

Table picture:

tabela payment.jpg966×236 20.5 KB

Console picture:

JS function:
https://github.com/leonardoaugt/financeiro/blob/master/financeiro/financeiro/doctype/titulos/titulos.js#L33

PY function:
https://github.com/leonardoaugt/financeiro/blob/master/financeiro/financeiro/doctype/titulos/titulos.py#L27

2

Are you seeing the values in the database?

3

Where is the javascript code that actually tries to populate the child table?

4

I never set value to table, i don’t know what you talking about…
Can you help me do this please?

5

Oh sorry. I didn’t read your question properly. Start by explaining what excatly it is that you are trying to achieve so that the code you linked can have some context.

6

Im working with installments, each Título document is a installment.
When the workflow of Título are released, add a button Pagar(payment) in doctype form.
When click on this button, this take some values of Título form, and create a Payment Entry doctype based in these values.
The process its like payment of Purchase Invoice, when i do a make payment, this create a route to payment entry, getting some datas of purchase invoice, including in the references table.

7

Yes, is receiving in database

8

I think is missing some code in js, anyone can help me?

9

Hi, use this exemplo to charge values
Python
def load_receipe(group, creation_date):
receipe = frappe.db.sql (“”“SELECT production_order, warehouse, bom, quantity
FROM tabWarehouse Receipe
WHERE group = %s and creation_date = %s;
“””, [group, creation_date], as_dict=1)
return receipe

JS
frappe.call({
method:“erpfoa.manufacturing_foa.doctype.warehouse_receipe.warehouse_receipe.load_receipe”,
args: {
group: cur_frm.doc.group,
creation_date: cur_frm.doc.creation_date
},
callback: function (r) {
cur_frm.doc.item = []; → function to clear table
refresh_field(“item”); → function to clear table
|
--------> child table name
var receipe = r.message;
$.each(receipe, function(i) {
var row = cur_frm.add_child(“item”)
row.production_order = receipe[i].production_order;
row.warehouse = receipe[i].warehouse;
row.bom = receipe[i].bom;
row.quantity = receipe[i].quantity;
refresh_field(“item”); —> update values
});
}
});

https://pastebin.com/55thQwS1