This example show how we can update a document’s UDF field based on a value entered in an SQL report. In this example, we have a SQL Production Progress Report and when a user updates a UDF called ‘Qty made’, it will update the UDF in the row level, so that next time when the SQL is run, it has the latest ‘Qty made’ value.
Articles in this section
- Sample - Check for duplicate item codes in document lines
- Sample: Validation - how to check if the OnHand quantity of an Alternative item is larger than the one being sold
- Sample: Line loop - How to check if line items in PO are in Blanket Agreement
- Sample: Automation - How to set the batch numbers based on UDF
- Sample: How to keep last parameter values in SQL Query Report
- Sample: Line Loop – Select multiple Invoices in Incoming Payment Window according to specific values.
- Sample: Line Loop – Automatically Check if Unit Price is Less than Item Cost
- Sample: How to copy a Sales Order to a Quotation
- Sample: Uppercase all Free Text
- Sample: Custom Validation - How to check for a minimum unit price