Wednesday, 20 June 2018

Do we need to create multiple layout templates for printing report in multiple languages?


We can achieve multi language report by two ways:

     Different layout template for different languages This approach can be chosen if the layout is also different from language to language.

  Generate XLIFF template for each language XLIFF (XML Localization Interchange File Format): format for exchanging localization data. XML based format that enables translators to concentrate on the text to be translated. We use this option when we want to use the same layout and apply specific translation.

what is the file supporting the translation for a layout template?

XLIFF is the file that supports the translation, we have one XLIFF file for each language

Sunday, 10 December 2017

What is the importance of Auto Allocate flag



Enable: After picking automatically pick wave move order generated and material will be automatically moved from source sub inventory to the staging area.
Disable: After picking pick wave move order generated but manually move stock from source sub inventory to the staging area.

What is the importance of Auto create delivery flag



Enable: After picking automatically delivery numbers generated.
Disable: After picking manually delivery numbers has to be generated.

query to find between Internal Requisition and internal sales orders



  SELECT   OOH.ORDER_NUMBER SO,

           OOH.ORDERED_DATE,

           OOH.ORG_ID,

           PRH.SEGMENT1 REQ

    FROM   OE_ORDER_HEADERS_ALL OOH,

           PO_REQUISITION_HEADERS_ALL PRH,

           PO_REQUISITION_LINES_ALL PRL

   WHERE   1 = 1

           AND PRH.REQUISITION_HEADER_ID = PRL.REQUISITION_HEADER_ID

           --AND PRH.SEGMENT1 = OOH.ORIG_SYS_DOCUMENT_REF

           AND PRH.REQUISITION_HEADER_ID = OOH.SOURCE_DOCUMENT_ID

           --AND ORDER_NUMBER = '66534' --SALES ORDER NUMBER

           AND PRH.SEGMENT1 = '300059130'-- REQUISITION NUMBER

           AND PRH.TYPE_LOOKUP_CODE = 'INTERNAL'

   ORDER BY   OOH.ORDERED_DATE DESC

Mandatory setups for IR ISO Flow



1.      In item master form internal ordered and internal orders Enabled  flag should be enabled and  assigned to both the orgs

2.      List price required

3.      Shipping networks (specify source and destination organization).

4.      Customer ship to location should be destination org location

5.      In the purchasing options attach Internal Order Transaction type