Groovy Script Examples

These pages are ready-made Groovy scripts for entity flows and task schedules, each one checked on a demo database before it was published. Every page explains what the script does, when it helps, how to set it up and what its messages mean, and gives the full source to copy.

None of these scripts is built into the system. They are samples: you paste the source into the customer's flow or task, and you can adapt it.

Using a script from these pages

Each page has a Script link to a .groovy file and shows the same source at the bottom of the page. Copy the whole file, from the package line to the last brace.

• On an entity flow: open Administration → Display Customization → Entity Flow, add a line to the Details grid with the target action the page gives, and paste the script into the line's Groovy Script column. Leave Class Name empty: it is filled in when you save.
• On a task schedule: open Basic → Settings → Task Schedule, create a task of type Action, enter com.namasoft.infor.domainbase.util.actions.EAGroovyAction in Class Name, and paste the script into Parameter 1.

Every script takes its first input from Parameter 2. On an entity flow, Parameter 1 stays empty. On a task schedule, Parameter 1 holds the script. Either way the parameter table on each page starts at Parameter 2. When you save, the line's description and the titles above the parameters fill in from the script itself.

EAGroovyAction explains how the system compiles and runs these scripts.

Each page is marked one of two ways:

• Recommended pattern: generic. It works as it is, controlled through its parameters.
• Customer-specific example: written for one installation, with fields or codes fixed in the source. The page lists what to change before using it elsewhere.

Repair and maintenance

🔁Rebuild Quantity Tracking for Documents From a QueryRebuilds the satisfied and open quantities that the documents a query returns leave on their source documents.🔒Reserve a Draft's Code When It Is SavedRegisters a draft's codes at once, so no other record can take its code before it is committed.🧮Recalculate an Invoice's Totals After a Field MapRecalculates line values, taxes and totals after a field map that changes prices on Validate On Save.📱Keep Only a User's Last Mobile Device TokenStops push notifications reaching old phones by keeping only a user's newest device token.

Accounting and other modules

💱Send One Account's Ledger Lines in Local Currency at Rate 1Rewrites one account's ledger lines as their local amount at rate 1, just before the accounting request is sent.🔐Hide Entries and Vouchers Behind Their Account's View CapabilityJournal entries and vouchers take the View Capability of the first account on their lines.🔢Number Voucher Lines per Subsidiary and Fiscal YearA running number per customer or supplier per fiscal year on receipt and payment voucher lines.☑️Tick a Line Flag on Every Line That Shares a ReferenceOn a misc invoice, one ticked line ticks its whole group. The field ids come from the parameters.🩺Cap a Yearly Allowance per Employee on Payment RequestsYearly limits per employee, per item and in total, with running totals on each request line.🏗️Copy Project Contract Term Codes Into Its BudgetsSaving a project contract writes its term codes into the estimated and executive budget lines.🏠Rebuild a Cancel Contract's Expense Lines From the LeaseRefills a lease termination's Expense grid from the lease's non-installment lines on every save.📮Fill Postal Parcels Sort Lines From IPSLooks up every line's mail item in IPS in one go, for lines that were scanned or imported without the look-up.🧾Add a Service Fees Line to the Electronic InvoiceAdds Service Fees 1 to the e-invoice as an item line with 15% tax. The document itself is unchanged.

HR and the item master file

🕛Clear Attendance Punches Recorded at MidnightClears a Time Attendance check-in or check-out that the machine wrote as 00:00.🚪Treat a Late Check-In as a Check-OutTurns a lone check-in after a cut-off time into a check-out.⏰Fill a Forgotten Punch's Hour From the Employee's ShiftSets a Forgot Check In / Out leave permission's hour from the employee's shift.📅Show What the System Thinks Each Day Is for an EmployeeA diagnostic that lists each day's shift, holiday, weekend and weekly-rest status for one employee.💰Drop Salary Documents of Another Period From a Salary SheetRemoves salary sheet lines whose salary document is of another fiscal period.🎨Validate an Item's Sizes and Colors GridRefuses one size or color code with two names, and two default lines for one size and color.⚖️Rewrite an Item's Unit Conversions to the Base UnitTurns chained conversions (1 Pallet = 50 Carton) into direct ones to the base unit.📍Learn an Item's Default Locator From Stock MovementsRecords the locator a stock transfer or opening stock used as the item's default locator.

Supply chain: lots, locators and other item dimensions

🏷️Number Lot-Tracked Lines by Item Section and YearWrites QC-26-RAW00001-style numbers into Text 1, counted per section and year.🧹Clear Lots That Were Never Received, and Unused DimensionsClears lots the item never had stock of, and dimensions the item does not use.🚫Clear the Locator When the Warehouse Does Not Use LocatorsDrops leftover locators on lines whose warehouse prevents locators.📦Set a Default Locator on Lines Without OneFills empty locators with a fixed default, for all items or for chosen item sections.🔖Fill the Item's Default Revision on Document LinesEmpty revisions get the item's default revision.🔀Move a Serial Number Typed by Mistake Into the LotFor lot-only items, a typed serial becomes the lot.👕Fill the Default Size and Color When a Committed Document Is EditedCustomer-specific: repairs size and color on re-saved committed documents.📏Refuse Serial Numbers That Are Not 15 Characters LongCustomer-specific: a fixed-length serial validation.🏬Update Items' Warehouse Settings From a Purchase Return RequestCustomer-specific: request lines write into the items' warehouse rows.🧩Spread an Assembly BOM Line Into One Line per Item of a ClassCustomer-specific: one BOM line per item of an Item Class 4.

Supply chain documents: source documents and generated documents

↩️Link Sales Return Lines to the Invoices They Came FromFinds each return line's invoice by query and splits a line across invoices.🎁Link Free Item Lines of a Sales Return to the InvoiceFills the Source Line Id of free lines from the invoice.🚗Collect a Purchase Invoice's Stock Receipts From Its Car ReceiptsFills Stock Documents with the receipts made from the car receipts.💲Keep the Prices of the Document a Sales Document Was Made FromLines take the source line's price, also through a stock issue.🛒Create One Purchase Order per Supplier From a Purchase QuotationSplits a quotation into orders or invoices per supplier and keeps them in step.🟰Refuse a Document Whose Quantities Differ From Its From DocumentAn item-by-item quantity check against the From Document.

Supply chain documents: statuses and lines

🚚Set the Delivery Status of the Lines a Document Was Made FromStamps a fixed delivery status on source lines, climbing the from-document chain to the type you name.✅Mark the From Document as FulfilledWrites Fullfilled into the from-document's Description 1 once the documents made from it cover every line.🗂️Record Inventory Effects Under the Warehouse's Analysis SetInventory request lines take their warehouse's analysis set.🔏Lock Saved Price Lines on Items and Sales Price ListsRefuses deleting or editing existing price lines. New lines are still allowed.🆓Add Free Lines From the References on Each Sales LineReference 1-3 plus Number 1-3 on a sales line become free lines under it.🛑Force Do Not Update Prices At All on Sales Return Request TermsA Document Term flow that forces one term setting on save.📊Maintain Limit Sales Qty Lines From Items and CustomersFind-or-create a Limit Sales Qty record by query and keep this item's or customer's line in it.