My Portfolio

What are the  order to cash accounting entries   and where are they defined  in fusion for the following scenarios: 1. Processing a Sales Order: When item is available in inventory and shipped to customer 2. Processing a Back to Back Sales Order: When item is not available in inventory and we request our supplier to ship item in our inventory and once they are received and available in inventory they are shipped to customer 3. Processing a Drop Ship Sales Order: When item is not available in inventory and we request our supplier to ship item directly to customer on our behalf. 3) Drop ship  Order Shipment : 1) Deferred COGS Account Dr.              To Inventory Account On Creation of the Revenue Invoice :    ( Entry 1 recognizes the revenue and Entry 2 below reverses the deferred COGS and books the amount to COGS) 1) AR Clearing Account  Dr.        ...

<?xdofx: expression ?> for extended SQL functions <?xdoxslt: expression ?> for extended XSL functions. You cannot mix xdofx statements with XSL expressions in the same context This function enables the conversion of numbers to words for RTF template output. This is a common requirement for check printing. The new function is “to_check_number”. The syntax of this function is <?xdofx:to_check_number(amount, precisionOrCurrency, caseType, decimalStyle)?> The following table describes the function attributes:   Attribute Description Valid Value amount The number to be transformed. Any number precisionOrCurrency For this attribute you can specify either the precision, which is the number of digits after the decimal point; or the currency code, which will govern the number of digits after the decimal point. The currency code does not generate a currency symbol in the output. An integer, such as 2; or a currency code, such as ‘USD’. caseType The case type of th...

Function for displaying Rupees in Words by   santosh kumar adda oracleapps Function for displaying Rupees in Words –XXIII. Function for displaying Rupees in Words : CREATE OR REPLACE FUNCTION to_word_i (amount IN NUMBER) RETURN VARCHAR2 AS v_length INTEGER := 0; v_num2 VARCHAR2 (50) := NULL; v_amount VARCHAR2 (50) := TO_CHAR (TRUNC (amount)); v_word VARCHAR2 (4000) := NULL; v_word1 VARCHAR2 (4000) := NULL; TYPE myarray IS TABLE OF VARCHAR2 (255); v_str myarray := myarray (‘ Thousand ‘, ‘ Lakh ‘, ‘ Crore ‘); BEGIN IF ((amount = 0) OR (amount IS NULL)) THEN v_word := ‘zero’; ELSIF (TO_CHAR (amount) LIKE ‘%.%’) THEN IF (SUBSTR (amount, INSTR (amount, ‘.’) + 1) > 0) THEN v_num2 := SUBSTR (amount, INSTR (amount, ‘.’) + 1); IF (LENGTH (v_num2) < 2) THEN v_num2 := v_num2 * 10; END IF; v_word1 := ‘ AND ‘ || (TO_CHAR (TO_DATE (SUBSTR (v_num2, LENGTH (v_num2) – 1,2), ‘J’), ‘JSP’ ))|| ‘ paise ‘; v_amount := SUBSTR(amount,1,INSTR (amount, ‘.’)-1); v_word := TO_CHAR (TO_DATE (SUBSTR ...

XML Tags (very important xml tags) by   santosh kumar adda oracleapps 1.) Define Header some where in the page as per requirement. (call header ) <?Call:header?> <?template: header?> <?end template?> —————————— 2) For body Contents <?start:body?> <?end body?> —————————— 3)Last Page Only Content: Insert the following syntax on the final page: <?start@last-page:body?> <?end body?> —————————— 4) Sort  (Data sorting) <?sort:trx_number?> Sort descending <?sort:trx_number;data-type=‘number’;order=‘descending’?> multiple sort tags <?sort:trx_number?><?sort:trx_date?&g ———————— Oracle Number Format Mask <?format-number:fieldname;’999G999D99’?> —————————— Mask Output for US Locale – SHORT =2/31/99 – MEDIUM =Dec 31, 1999 – LONG =Friday, December 31, 1999 – SHORT_TIME =12/31/99 6:15 PM – MEDIUM_TIME =Dec 31, 1999 6:15 PM – LONG_TIME =Friday, December 31, 1999 6:15 PM – SHORT_TIME_TZ =12/31/99 6:15 PM GMT – MEDI...