I am currently working on a personal project that consists of a website which displays invoice information in a table, which is pulled from Firebase. I am using JavaScript to show the data in my table.
This is how I'm populating my table:
function getInvoices(){
var docRef = db.collection("invoices");
docRef.get().then(function(querySnapshot) {
querySnapshot.forEach(function(doc) {
html = createInvoiceRow(doc.data(),doc.id);
$('.invoiceTable').find('tbody').append(html);
});
jobsDataTable = $('.jobsTable').DataTable({language: { search: "", searchPlaceholder: "Search...", sLengthMenu: "MENU" }, "lengthMenu": [[300], ["300"]]});
});
}
.
function createInvoiceRow(invoice,id)
{
var invoicedate = invoice['value'].toDate();
var getvaluedate = invoicedate.getDate() + '/' + (invoicedate.getMonth()+1) + '/' + invoicedate.getFullYear();
html = '<tr id="invoice'+id+'">';
html += ' <td class="centercheck">'+invoice['jobnumber']+'</td>';
html += ' <td class="centercheck">'+invoice['price']+'</td>';
html += ' <td class="centercheck">'+getvaluedate+'</td>';
html += '</tr>';
return html;
}
Here is where I am struggling, I would like to be able to pass the information of a selected invoice into SAGE 50, like how you add invoices on via the 'Batch Ledger', by clicking a button on my website.
You need the Sage 50 SDK by joining the Sage Developer program or you could use a tool like Zynk to import the file into Sage.