Hi all,
Inventories collection: stores the product and its available quantity.
Adjustments collection: stores the completed adjustments for the product.
I would like to create a Table listing page to display the current available stock. Then an action button for the users to click, to go to an adjustment form page to allow users to reduce/increase the quantity of the product according to the current available quantity, i.e. product code and quantity are auto populated according to the selected product. The adjustment form shall also allow users to select a reason code and entering of a reference data. When users confirm the adjustment, besides updating the Inventories record, system shall capture the transaction in Adjustments collection as well.
I tried with Popup Action button and Form (Edit)/Form (Add new), but there isn’t any option for me to add non-collection field into the form.
May I know what are the nocobase functionalities or module can achieve this requirement?
Thanks.
Regards,
Simon.
Please provide screenshots to illustrate your issue, as this will help us understand it better.
Hi Support,
You may login to demo site, https://a_m0pwgklzivn.v7.demo.nocobase.com/, under Stock Adjustment → Stock Balance screen, click on Popup action link.
In the Popup window, I would like to allow users to adjust the selected stock balance record’s quantity, i.e. create Adjustments collection record: Product ID shall be auto populated with the Product ID of the selected stock and not editable.
And right now, I can only click on Configure fields button to add the fields in the selected collection, is there any form block allows me to add in a temporary input box not related to any collection field?
Thanks.
Regards,
Simon.
You need to establish the correct relationships for the collections: Product, Stock Balance, and Adjustments. Once these relationships are established, you can add blocks via the associated tables.
Hi Support,
Actually what we want to achieve is the Adjustments works like a history table, it keeps track of all quantity activities, e.g. stock received via inbound order, stock shipped out via outbound order, positive/negative adjustment, that means Adjustments will need to be associated to multiple collections for certain field, e.g. SKU. Is this possible in current available blocks?
Are these standard blocks only work with the established relationship via selected collection for the block?
Is there any form block allow us to create form input, e.g. dropdown list, and associate it with some web request calls? Or this can only achieved in plugin customization?
Thanks.
Regards,
Simon.
Relationships should be established for these tables.
To implement external requests in a dropdown list, you currently have to write code to achieve this.