Hi everyone, We are developing a Sales Order to Delivery process. We have created a master detail form to enter Orders received from customers. An order can have one or multiple items in it. The order number & order date along-with customer name is stored in the Master table and Item details (item, qty, Rate & amount) are stored in the Detail table. Let's assume we receive an order with 2 items / SKU's in a single order which is entered as 2 rows in the Sales Order form. At the time of Delivery the user may deliver either one of both items at the same time. Assuming that both items are to be delivered the user selects the Sales order Number from the drop down list. Based on the selected order number items from the selected sales order have to be filled into the Interactive grid (Detail table of Delivery Note). I remember using a fillgrid option to fill the Delivery Note detail table in another low code application / tool with Oracle as the DB. We had a pop-up showing list of items from the selected Sales order (in the delivery note form) wherein the user could select an item ...

Hi, I'm using Apex 20.0 I am developing a purchase module where i have a purchase order and Goods Receipt note.(Master Detail Pages) The process that is followed is, first i raise a purchase order against a vendor / supplier. After that when goods are received i select the supplier and purchase orders raised against that supplier is displayed (only pending purchase orders where order quantity has not been fulfilled through supplies) I can have multiple supplies against one purchase order for a single item. For example: I have placed an order for Item A for 10 nos. I receive 5 nos on day-1 and then receive 5 nos on day-2. Once i receive the first supply (entered in the goods receipt note) on day-1, I receive 5 nos (enter it using the Goods Receipt note) against the order of 10 nos. After saving the transaction the status of the line item in the order still remains pending. On Day-2 when i receive the balance 5 nos I enter using the Goods receipts note and save it. The status of the line item in the purchase order changes to closed from pending. The issue i have is when i open the first or second saved transaction in view ...

I'm using Apex 20.2 I am developing an application for Receipts (money received from clients) we collect money. Once a receipt is saved a Voucher Number gets generated and assigned to the saved Voucher. Since I have multiple branch offices I want to generate numbering Branch wise since money is collected at different locations. I thought of 2 ways to get this done. 1) Create Branch wise Receipt Forms with multiple tables and have Numbering sequence set. Challenge with this is that i will have to create a new form every time a new branch office is opened. 2) Create a Single Receipt Form and auto generate Numbering sequence Branch wise. Let's say I have 2 Locations ABC & XYZ which are 2 branch offices: When the user from location ABC logs in and generates Receipts, Numbering to start from 1. ABC-1, ABC-2, ABC-3 and it goes on. Whereas when the user from Location XYZ logs in and generates Receipts, Numbering to start from 1. XYZ1, XYZ2, XYZ3 and it goes on. Any help would be highly appreciated