I have a few other posts around a multi screen App I am currently building, but a quick summary is I have pulled data from BC on the invoice amount, sales person, and zip code it shopped to. I had another table with comission rates for specific ship to zip codes. THen I have a text input to do a calculation of the invoice amount x the commission rate.
From here I have experimented with collections, patch, and a form. Next task, get this data into an excel file stored on OneDrive. I have looked through several posts, and I am not sure if this is possible or not. If not, my end goal is to use this data to point back to a General Journal entry in BC