Articles tagged #TRANSACTION
Articles tagged
#TRANSACTION
Show Purchase Orders and Vendor Bills Under Related Records of Project/Job Record When Projects on Sales Transactions Are Not Consolidated
Purchase transactions (Purchase Orders and Vendor Bills) are not directly associated with Project entities because they are part of the Accounts Payable module and not the Advanced Project Management module of NetSuite. This is reproducible when the Accounting Preference "Consolidate Projects on Sales Transactions" is disabled.
Discount Item With Negative Rate Displays Positive When Used as Promotion in Transaction Records
Discount Itemrecordsthat indicatesNegative Rate(E.g.-20.0%) in Promotion records will indeed displayPositive(E.g.20.0%)in transaction records (E.g. Sales Order) by design.
Saved Search > Transaction > Sales Orders > Actual Ship Date or Fulfillment Date per Line Item
To create a transaction saved search that shows the actual ship date on the item fulfillment.
Create a Saved Transfer Order Search > Duplicate Transfer Order Lines
Transfer Order Saved Search has duplicate Transfer Order Lines
Show Results of Saved Search for Custom Roles When Using The Filter Amount Is Less Than 0
When user creates a Transaction Saved Search with Amount is less than 0 in Criteria tab, it might not be visible for custom roles, even if permissions were set up correctly by Administrator.
Return all Invoices of Sub-Customers based on its Parent Customer in Print Checks and Forms > Invoices
User needs to pull all invoices for a customer and its sub customer, however theCustomerfilter is not available in aOne World Account.
Display Customer Status on Opportunity Saved Search
A user wants to display Customer Stages and Opportunity Status using an Opportunity Saved Search.
Create a Saved Search to Find Transactions Created by Administrator Roles
Create a Saved Search to find transactions created by an Administrator role.
Link Custom Transaction field to Custom Fixed Asset Management field
The customer would like to know how to link a custom transaction field to a custom Fixed Asset Management field.
Display Missing Transactions on Payment Subtab of a Deposit Record
There are missing transactions on the Payments subtab of the Make Deposits page.
Electronic Bank Payments > Reversing Payments
You can reverse payments if the bank has not yet processed the associated payment file. When you reverse a payment, a new payment file is created and the payments are reprocessed. However, any credit transactions are still applied to the bill or invoice. Full payment reversal voids all payments and the payment file is deleted. On the other hand, partial reversal voids only selected payments and a new payment file is created with the remaining payments.
Source Transaction Line Fields from Line on Sales Order onto Body Fields for Linked Work Order using SuiteScript
The User would like to source values of custom Transaction Line Fields from respective lines on a Sales Order onto Body Fields for the Linked Work Order possibly created in the following manner:
Manual Credit Hold Not Working
Navigate to Setup > Accounting > Accounting Preferences > General tab > Accounts Receivable portlet
Saved Search to Filter Transactions Created by Specific Role/s
User wants to create a Saved Search to filter transactions using specific role/s.
Transaction Saved Search to Show Related Sales Order Status of Item Fulfillment
Create aTransaction Saved Searchthat would show the status ofItem Fulfillment's related order.
Return User Error on Transaction Deletion not Working
A user wants to return a user error via workflow whenever a user tries to delete purchase orders that are not created by them.
Create Search for all Customers with no Transactions
Scenario
Solution
2. ClickCustomer
3.Search Title:EnterTitle
Example:Customers With No Related Transactions
4. ClickCriteria
5. ClickStandard
6.Filter:
- SelectStage
- Stage:SelectCustomer
- ClickSet
- Summary Type:SelectSum
- Field:SelectFormula (Numeric)
- Formula (Numeric):Select isequal
- ClickSet
- Formula:EnterDecode ({transaction.number},NULL, 0,1
9.Field:
- SelectName
- Summary Type:SelectGroup
- SelectFormula (Numeric)
- Summary Type:SelectSum
- Formula:EnterDecode ({transaction.number},NULL, 0,1)
Saved Search on Inventory Count of Lot Numbered Items to Show the Inventory Numbers and Quantities on Snapshot Detail and Count Detail
Scenario
Solution
- Navigate toLists>Search>Saved Searches>New
- SelectTransaction
- Search Title:EnterTitle
- ClickResults
- ClickStandard
- Filter:
- SelectType
- SelectInventory Count
- SelectItem
- Selectnot none
- SelectStatus
- SelectInventory Count:Approved,Inventory Count:Completed/Pending Approval
- SelectItem fields...
- SelectIs Lot Number
- SelectYes
- SelectIs Lot Number
- SelectFormula(Numeric)
- Formula:EnterCASE WHEN {transactionlinetype} = 'Snapshot Quantity' or {transactionlinetype} = 'Count Quantity' THEN 1 ELSE 0 END
- Formula (Numeric):Selectequal to
- Value:Enter1
- Formula:EnterCASE WHEN {transactionlinetype} = 'Snapshot Quantity' or {transactionlinetype} = 'Count Quantity' THEN 1 ELSE 0 END
- SelectType
- ClickResults
- ClickColumns
- Field:
- SelectDate
- SelectDocument Number
- SelectItem
- SelectFormula(Text)
- Formula:EnterCASE WHEN {transactionlinetype} = 'Snapshot Quantity' THEN {inventorydetail.inventorynumber} ELSE null END
- Custom Label:EnterSnapshot Lot Number
- SelectFormula(Text)
- Formula:EnterCASE WHEN{transactionlinetype} = 'Snapshot Quantity' THEN {inventorydetail.quantity} ELSE null END
- Custom Label:EnterSnapshot Quantity
- SelectFormula(Text)
- Formula:EnterCASE WHEN {transactionlinetype}='Count Quantity' THEN {inventorydetail.inventorynumber} ELSE null END
- Custom Label:EnterCount Lot Number
- SelectFormula(Text)
- Formula:EnterCASE WHEN {transactionlinetype}='Count Quantity' THEN {inventorydetail.quantity} ELSE null END
- Custom Label:EnterCount Quantity
- ClickAdd
- ClickSave & Run
Display SKU for Inventory Items on Sales Order Printout
User needs to display SKU (Display Name/Code) on their Sales Order Advanced PDF/HTML Template but would only need to display the code for Inventory Items only.