Hello everyone,
I created a custom child table on the sales invoice, I want to use the custom child table to track the item given out to a customer. Let us assume that you sold out 10 crates of Heineken with content to a customer and the customer brings 7 empty crates of Heineken instead of 10 empty crates of Heineken. I want to track the balance of empty crates owe by every customer. So, i decided to create a child table on the Sales invoice for tracking of empty crates owe by every customer. Below is the screenshot of the child table that was created on the Sales invoice for Tracking of the empty Crates :
Please, I need a Client Script that will automatically generate the number of (Empty crates owed by Customer) by Subtracting the number of (Empty crates brought in by customer) From the number of (Sales in Crates).
Thank you all.