Tag: amount

Apply Discount in Amount column in SO

/**  * @NApiVersion 2.1  * @NScriptType UserEventScript  */ /*******************************************************************  * MAGT-808 Apply Discount in Amount Calculations in SO  * ***************************************************************  *  * Date: 24-10-2024  *  * Author:Jobin & Jismi IT Services LLP.  *  * Description: Apply Discount in Amount Calculations in SO  *  * Created By: JJJ0135, Jobin & Jismi IT Services LLP  *  *… Continue reading Apply Discount in Amount column in SO

To convert amount in words and include the customer currency along with it.

To convert amount in words and include the customer currency along with it.. Created a custom field. And enter the below given formula in the default value field. {currencysymbol} is the internal id of currency. {currencysymbol} || ‘ ‘ || CASE WHEN {total}=0 THEN ‘ZERO’ ELSE TO_CHAR(TO_TIMESTAMP(LPAD(TRUNC({total}, 0), 9, ‘0’), ‘FF9’ ), ‘FFSP’) ||’ ‘… Continue reading To convert amount in words and include the customer currency along with it.

To convert amount in INR to words using formula

To convert amount in INR to words using formula. Created a custom field. And enter the below given formula in the default value field. ‘RUPEES’ || ‘ ‘ || CASE WHEN {custbody_amount_in_inr}=0 THEN ‘ZERO’ ELSE TO_CHAR(TO_TIMESTAMP(LPAD(TRUNC({custbody_amount_in_inr}, 0), 9, ‘0’), ‘FF9’ ), ‘FFSP’) ||’ ‘ || (CASE WHEN {custbody_amount_in_inr}-TRUNC({custbody_amount_in_inr}, 0) > 0 THEN ‘ AND ‘… Continue reading To convert amount in INR to words using formula

Rounding off JE’s at the time of knocking off

Requirement: If the amount difference between the Bill and Bill Payment is between 0 and 5, automatically generate the journal entry to pay the bill transaction. Solution: If the difference between the Bill and Bill payment amount is between 0 and 1, a new Bill Credit(Memo: Rounding Off) will be created automatically for the remaining… Continue reading Rounding off JE’s at the time of knocking off