The account ledger report must be processed to any item ledger and account ledger discrepancies, based on the invoice number and the invoice document type.
You should install the fat client in order to use JD Edwards object library workbench.
The following steps are the detailed technical specifications that you need to follow in order to develop the item ledger and account ledger reconciliation report. Tables used are F4111 and F0901:
The development of this report is based on the preceding specification. In the Initialize Section
of the following code, you will initialize the variable, and in the Do Section
you will do the main report coding:
Listing of ER for Report: Report: Sales Update Discrepancy between Sales / Cardix / AR / GL (R574211I) ********************************************************************* GLOBALS: Variables (Global) ********************************************************************* rpt_CompanyKey_F0911_KCO rpt_DocumentType_F0911_DCT rpt_InvoiceNumber_F0911_DOC rpt_RevenueAmount_F0911_AA rpt_COGSAmount_F0911_AA rpt_InventoryAmount_F0911_AA rpt_SalesAmount_F4211_AEXP ===================================================================== SECTION: Sales Order Detail - Integrity [GROUP SECTION] () ===================================================================== OBJECT: SECTION EVENT: Initialize Section --------------------------------------------------------------------- OPT: Using Defaults 0001 VA rpt_ErrorMsg01_DL010 = "ERROR: Integrated Module!" --------------------------------------------------------------------- EVENT: Do Section --------------------------------------------------------------------- OPT: Using Defaults 0001 VA rpt_CompanyKey_F4111_KCO = BC Document Company (F4211)(KCO) 0002 VA rpt_InvoiceNumber_F4111_DOC = BC Document (Voucher, Invoice, etc.) (F4211)(DOC) 0003 VA rpt_DocumentType_F4111_DCT = BC Document Type (F4211)(DCT) 0004 VA rpt_CostCenter_F4111_MCU = BC Business Unit (F4211)(MCU) 0005 VA rpt_ItemNumber_F4111_LITM = BC 2nd Item Number (F4211)(LITM) 0006 VA rpt_LineNumber_F4111_LNID = BC Line Number (F4211)(LNID) 0007 // 0008 // CARDIX, F4111 0022 RV COGS_F0911_FLAG = VA rpt_COGS_F0911_FLAG 0023 RV Inventory_F0911_FLAG = VA rpt_Inventory_F0911_FLAG 0024 RV Receivable_F03B11_FLAG = VA rpt_Receivable_F03B11_FLAG 0025 // 0026 // SO, SG, CO Documents types 0027 If BC Order Type (F4211)(DCTO) is not equal to PO OrderType1_DCTO Or BC Order Type (F4211)(DCTO) is not equal to PO OrderType2_DCTO Or BC Order Type (F4211)(DCTO) is not equal to PO OrderType3_DCTO Or BC Order Type (F4211)(DCTO) is not equal to PO OrderType4_DCTO Or BC Order Type (F4211)(DCTO) is not equal to PO OrderType5_DCTO Or BC Order Type (F4211)(DCTO) is not equal to PO OrderType6_DCTO Or BC Order Type (F4211)(DCTO) is not equal to PO OrderType7_DCTO Or BC Order Type (F4211)(DCTO) is not equal to PO OrderType8_DCTO Or BC Order Type (F4211)(DCTO) is not equal to PO OrderType9_DCTO Or BC Order Type (F4211)(DCTO) is not equal to PO OrderType10_DCTO Or BC Order Type (F4211)(DCTO) is not equal to PO LeaseOrderType1_DCTO Or BC Order Type (F4211)(DCTO) is not equal to PO LeaseOrderType2_DCTO Or BC Order Type (F4211)(DCTO) is not equal to PO LeaseOrderType3_DCTO Or BC Order Type (F4211)(DCTO) is not equal to PO LeaseOrderType4_DCTO Or BC Order Type (F4211)(DCTO) is not eq ual to PO LeaseOrderType5_DCTO 0028 If BC Line Type (F4211)(LNTY) is equal to "N" 0029 If RV Cardix_F4111_FLAG is equal to "N" And RV Receivable_F03B11_FLAG is equal to "Y" And RV Revenue_F0911_FLAG is equal to "Y" And RV COGS_F0911_FLAG is equal to "N" And RV Inventory_F0911_FLAG is equal to "N" ===================================================================== SECTION: Sales Order Detail - Integrity [GROUP SECTION] () ===================================================================== OBJECT: SECTION EVENT: Do Section --------------------------------------------------------------------- OPT: Using Defaults 0001 RV ErrorMsg_Sales_620_DL010 = "Error: Open sales orders!" 0002 RV Cardix_F4111_FLAG = "N" 0003 RV COGS_F0911_FLAG = "N" 0004 RV Inventory_F0911_FLAG = "N" 0005 RV Receivable_F03B11_FLAG = "N" 0006 RV Revenue_F0911_FLAG = "N" ===================================================================== SECTION: Sales Order Detail - Integrity [GROUP SECTION] () ===================================================================== OBJECT: SECTION EVENT: Do Section --------------------------------------------------------------------- OPT: Using Defaults 0001 RV ErrorMsg_Sales_620_DL010 = "Error: Open sales orders!" 0002 RV Cardix_F4111_FLAG = "N" 0003 RV COGS_F0911_FLAG = "N" 0004 RV Inventory_F0911_FLAG = "N" 0005 RV Receivable_F03B11_FLAG = "N" 0006 RV Revenue_F0911_FLAG = "N"