💼 Business
NetSuite Saved Search Field Map from Column Inventory (No Invented Balances)
Map NetSuite saved search fields from a column inventory only. No invented balances, journal entries, or tax figures.
0Reviews
Prompt
Act as a NetSuite saved search field mapper who only uses a pasted column inventory. You write a field map the inventory already supports. You do not invent balances, journal entries, or tax figures. This is not tax advice and not a financial audit opinion. You work only from Inputs. Do not invent stats, citations, quotes, URLs, names, IDs, or records that are not in Inputs. Inputs: - Column inventory I lock (columns, join types, filters noted): [Columns] - NetSuite / saved search version notes I lock: [Version] - Search or report name I may quote (or UNKNOWN): [Search] - Field cap I lock: [Cap] - Criteria filters I may quote (or UNKNOWN): [Criteria] - Words I must not use: [Banned] - What I must never invent (balances, journal entries, tax figures, internal ids): [Never] - Output format: [Format] - Language: [Lang] Generate: 1. Honesty ledger: Columns nouns, Version, Search, Cap, Criteria, Lang. Forbidden: invented balances, journal entries, tax figures, internal ids. Banner: not tax advice. Include NetSuite saved search terminology. 2. Field map table: at most Cap rows. Columns: field, type/join note, filter cue. Missing balances write NOT IN INPUTS. 3. Criteria lock: only Criteria named. Unnamed filters stay NOT IN INPUTS. 4. Version lock: print Version. Refuse NetSuite saved search features newer than Version if Version is named. 5. Refuse list: inventing $ balances, inventing journal entry numbers, inventing tax due figures, inventing internal id values. 6. Compliance pass: quote Banned and Never hits. Cut them. Print row count. Format as Format. Constraints: - Map from Columns only. No invented balances or tax figures. - Not tax advice. Honor Cap and Version. No emojis.
Instructions
Replace every [bracket] with your details before running. Works on ChatGPT, Claude, and Gemini.
Generated Output
This image was generated using the prompt above.
Examples
Example Input
Columns: fields entity as pasted; amount as pasted; memo as pasted. Joins transaction as pasted. Balances NONE. Journal entries NOT IN INPUTS. Version: NetSuite saved search 2024.1 as pasted (do not invent SuiteAnalytics Workbook invent) Search: Harbor Dock Sales Search as pasted Cap: 6 Criteria: date within FY2026 Q1 as pasted. Subsidiary UNKNOWN. Banned: guaranteed audit-ready, $40k invent, JE-991 invent, tax due invent Never: invent balances, invent journal entries, invent tax figures, invent internal ids Format: ledger + map + criteria + version + refuse + compliance Lang: English
Example Output
1. Ledger. Columns: entity; amount; memo; join transaction. Balances NONE. Journal entries NOT IN INPUTS. Version NetSuite saved search 2024.1. Search Harbor Dock Sales Search. Cap 6. Criteria date within FY2026 Q1; Subsidiary UNKNOWN. Lang English. Banner: not tax advice. Forbidden: invented balances, journal entries, tax figures, internal ids, guaranteed audit-ready, $40k invent, JE-991 invent, tax due invent. 2. Field map table (3/6) NetSuite saved search. 1. entity | as pasted | join transaction as pasted | balance NOT IN INPUTS (NONE) 2. amount | as pasted | join transaction as pasted | value NOT IN INPUTS 3. memo | as pasted | join transaction as pasted | note NOT IN INPUTS Journal entries: NOT IN INPUTS. Internal ids: NOT IN INPUTS. 3. Criteria lock. Date within FY2026 Q1 as pasted. Subsidiary UNKNOWN so write NOT IN INPUTS. Do not invent filter expressions beyond Criteria. 4. Version lock. NetSuite saved search 2024.1 as pasted. SuiteAnalytics Workbook invent not used. 5. Refuse. $40k invent: refused. JE-991 invent: refused. Tax due invent: refused. Guaranteed audit-ready: refused. Internal id invent: refused. 6. Compliance. Banned hits none. Rows 3/6. Format ledger+map+criteria+version+refuse+compliance. Gaps: balances, Subsidiary filter, more columns, results count, scheduled email. Missing-data policy: if a field was blank, write NOT IN INPUTS rather than guessing. Lock any tool version named in Inputs; if unnamed, write unknown. No invented testimonials, star ratings, or press logos. If legal, clinical, insurance, HR, education-plan, or veterinary content appears, add a one-line not-advice and de-identify banner. Quote banned-word hits and cut them. End with a gaps list of five bullets the user still owes you. Character and byte caps in the job are hard; print counts when relevant. Refuse to backfill DOIs, exam dumps, PHI, PII, or compensation promises not in Inputs.