Month: July 2022

Sharing of Parent Customer’s credit limit by the subcustomers

Scenario Credit Limit handling work with a condition that Children Companies will share in Parent Customer’s assigned Credit Limit. Solution Enable the following: 1. Consolidated Payments Feature 2. Apply Payments Through Top-Level Customers Only Preference 3. Customer Credit Limit Handling Preference  B. Credit Limit handling will be based on Parent Customer’s assigned Credit Limit 1. Open Customer Record2. Click Financial 3. Credit Limit: Enter Credit Limit4. Hold: Select Hold Note:Do not… Continue reading Sharing of Parent Customer’s credit limit by the subcustomers

What is Dynatrace

DynaTrace Software is an Application Performance Monitoring tool (APM) ,Which is widely used nowadays .It comes with advanced features for monitoring Java. Through which we can easily identify the performance of our application. We are using it to discover the existence of abnormalities in CPU Performance, response time, transaction rate, throughput and system usage.It has helped to diagnose… Continue reading What is Dynatrace

NetSuite Saved Search Date Formulas

Saved Search Dates for Financial reporting Year To Date CASE WHEN {trandate} BETWEEN to_date(TRUNC({today}, ‘YEAR’), ‘MM/DD/YYYY’) AND to_date({today}) THEN {amount} ELSE 0 END Last Year To Date CASE WHEN {trandate} BETWEEN to_date(TRUNC(TRUNC({today}, ‘YEAR’)-1,’YEAR’), ‘MM/DD/YYYY’) AND to_date(ADD_MONTHS({today},-12)) THEN {amount} ELSE 0 END Current Year CASE WHEN {trandate} BETWEEN to_date(TRUNC({today}, ‘YEAR’), ‘MM/DD/YYYY’) AND to_date(last_day(add_months(trunc(sysdate,’YYYY’), 11))) THEN {amount}… Continue reading NetSuite Saved Search Date Formulas

Work orders created from intercompany sales orders

While creating a work order from an Intercompany Sales Order it is just a regular non-intercompany transaction. There is a chance of getting error while saving that work order. For resolving the error and to build a Work order record from the Intercompany Sales Order created from Intercompany Purchase Orders:    1. Edit Intercompany Sales Order 2. Under Items tab >… Continue reading Work orders created from intercompany sales orders

Setting default invoice transaction form for invoices creating from Invoice Sales Orders page

We can set a specific Custom Form for Invoices that are created via the Invoice Sales Order page using Workflow.  Navigate to Customization > Workflow > Workflows > New  Basic Information:  Name: Enter Name  Record Type: Select Transaction  Sub-Type: Select Invoice  Execute As Admin: Enter Checkmark  Release Status: Select Released  Keep Instance and History: Select… Continue reading Setting default invoice transaction form for invoices creating from Invoice Sales Orders page

Resolve Error: “You only have xx available. Please enter a different quantity” in Inventory Count.

Scenario When the Inventory Count transaction status is set to Started, a snapshot of the inventory on hand quantity is taken from the system for comparison. The error happens if a user continues to process inventory changes while the counting activities are occurring so please note these changes. Please include these changes when a user… Continue reading Resolve Error: “You only have xx available. Please enter a different quantity” in Inventory Count.

Resolving error while approving inventory count, “Invalid bin number reference key XXX”

Scenario: When the user is trying to approve the inventory count, user is encountering the error “Invalid Bin number reference key XXX”, even though the bin is active and quantity is available in the bin. Error shown: Solution: Open the Item records in the inventory count one by one Click Inventory Detail Check if Quantity Available = Quantity On Hand  Check… Continue reading Resolving error while approving inventory count, “Invalid bin number reference key XXX”