To start using the Effective Date Pricing SuiteApp, you must create a record for each of the update types to which the price change applies. You define the update types by creating price update records. You can create a price update record for the following update types: Item Update Type Item Category Update Type Customer… Continue reading Effective Date pricing SuiteApp -Update Types for Creating Price Update Records
Author: Jesna John
Effective Date Pricing SuiteApp
The Effective Date Pricing SuiteApp enables you to set a schedule for specific price changes in advance. You can select the start date and end date when you expect the price changes to take effect. A scheduled script runs in the background to automatically update the item prices on the scheduled period. On the specified… Continue reading Effective Date Pricing SuiteApp
Creating CSV files from a saved search
REQUIREMENT Needs to create CSV file of the saved search result and send the results to the client using a scheduled script. SOLUTION We will use the task module to convert the saved search results to the CSV file and send the CSV file as email attachment using map reduce script.
Sending saved search results as CSV attachment
Requirement Add a scheduled script to send the saved search results to the designated email address as CSV attachments. Solution
Converting date time to another time zone
let todayDate = new Date() let getTime = todayDate.getTime(); let timeOffset = 10 * 60 * 60 * 1000; //Converting to AEST let austTimestamp = getTime + timeOffset; let austDate = new Date(austTimestamp);
Restricting the sales order creation based on the checkbox field in the customer record
Description Upon saving the sales order record, the script will verify whether the customer’s checkbox named “Disallow Create Order” is checked. If the checkbox is found to be checked, it will restrict the update or creation of the sales order each time on its save.
Issue with the creation of multiple custom records when restlet script is triggered in quick succession
ISSUE When the restlet script is triggered in quick succession, multiple custom records are created. Only a single custom record is expected to be created per day. But when resltet script is triggered at the same time, custom records are created multiple times. SOLUTION This issue can be handled by adding an external Id to… Continue reading Issue with the creation of multiple custom records when restlet script is triggered in quick succession
Transaction Line Automation in Expense Report
REQUIREMENT Develop an automation to populate the project code values in the expense report based on the provided conditions. SOLUTION The automation can be done by adding a userevent script that can populate the project code based on the conditions provided.
Enabling Landed Cost Allocation per Line
To use Landed Cost Allocation on individual lines, you must first enable the preference. To set the Landed Cost Allocation per Line Preference: Go to Setup > Accounting > Preferences > Accounting Preferences. Click the Order Management subtab. Check the Landed Cost Allocation per Line box.Note When this preference is enabled, all new item receipts, credit card charges, vendor bills, and… Continue reading Enabling Landed Cost Allocation per Line
Landed cost Based on Volume
Requirement Calculate the landed cost for vendor bill based on the volume on vendor bill. Solution