In my app, there is a master โsalesโ table in which credit sales are recorded against separate invoice numbers. In the โCollectionโ table and โSales Return Tableโ, most of the columns of โsalesโ table are present such as invoice number, customer name and sales person. These values are input in โCollectionโ table and โSales Returnโ table as a result of spreadsheet formula applied in both tables so as to avoid double entry. In the Input form auto created by appsheet for โCollectionโ and โSales Returnโ tables; inovice number, customer name and sales person cannot be seen so as to input payment collection details or goods returned details.
Moreover, I want that the invoice number can be selected as dropdown item and other details are suggested for customer name and sales person automatically for both forms. Is there also a way that only those invoices that are outstanding are shown and data cannot be input for which payment has already been received or goods returned or discount given.
LinkedIn
Twitter
