Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

13. SCM Customizations > Creating the sales invoice report

Creating the sales invoice report

Creating the sales invoice report The company requires the sales invoice report to be customized in order to control the printing of sales invoices. This section contains two parts; one is the technical specification, and the other one is the report development coding. Getting ready You should install a fat client in order to use JD Edwards OMW object library workbench. How to do it... The following are the specification details. The specification details are linked with the screenshot of the customized report, which has been marked with the field number, and each of the steps in the text is identified in the screenshot. The sales analysis report's detailed technical information is as shown next: Tables used are: F4201, F4211, F0101, and F0111. You can also create your custom business view from these tables as per the report requirement: Insert the Company logo and name in the page header. Sales Invoice should appear on the report header after the company name and logo.For the selected Order Number and Order Type, put the data selection F4201.DOCO and F4201.DCTO, and print F4201.DOCO and F4201.DCTO.For the selected Order Number and Order Type, put the data selection F4201.DOCO and F4201.DCTO, print F4201.DOCO and F4201.DCTO.For the selected Order Number and Order Type, put the data selection F4201.DOCO and F4201.DCTO, pass F4201.DOCO and F4201.DCTO to F4211.DOCO and F0201.DCTO, and print F4211.IVD where F4211.SOQS > 0 for the selected F4211.DOCO lines (F4211.LNID).For the selected Order Number and Order Type, put the data selection F4201.DOCO and F4201.DCTO, pass F4201.AN8 to F0101.AN8 and print F0101.ALPH.For the selected Order Number and Order Type, put the data selection F4201.DOCO and F4201.DCTO, print F4201.AN8.For the selected Order Number and Order Type, put the data selection F4201.DOCO and F4201.DCTO, pass F4201.DOCO and F4201.DCTO to F4211.DOCO and Fr201.DCTO, and print F4211.IVD where F4211.SOQS > 0 for the selected F4211.DOCO lines (F4211.LNID). For the selected Order Number and type in the data selection F4201.DOCO and F4201.DCTO, pass F4201.AN8 to F0111.AN8, and print F0111.NICK .***.For the selected Order Number and Order Type, put the data selection F4201.DOCO and F4201.DCTO, and print F4201.AN8.For the selected Order Number and Order Type, put the data selection F4201.DOCO and F4201.DCTO, and pass F4201.DOCO and F4201.DCTO to F4211.DOCO and F4211.DCTO, and print F4211.AITM where F4211.SOQS > 0.For the selected Order Number and Order Type, put the data selection F4201.DOCO and F4201.DCTO, and for the printed item in field 14 (Item Number) pass F4211.LITM to F4107.LITM, and print F4107.SDSC1.For the selected Order Number and Order Type, put the data selection F4201.DOCO and F4201.DCTO, and for the printed item in field 14 (Item Number) print F4211.SOQS.For the selected Order Number and Order Type, put the data selection F4201.DOCO and F4201.DCTO, and for the printed item in field 14 (Item Number) print F4211.UPRC.For the selected Order Number and Order Type, put the data selection F4201.DOCO and F4201.DCTO, and for the printed item in field 14 (Item Number) print F4211.AEXP.For the selected Order Number and Order Type, print F4211.DSC2.For the selected Order Number and Order Type, put the data selection F4201.DOCO and F4201.DCTO, print F4211.DSC1& AEXP where F4211.LNTY = S1.For the selected Order Number and Order Type, print F4211.AEXP.For the selected Order Number and Order Type, print F4211.UPRC. How it works... The coding of this report is based on the given specifications; the system generates the following code on OMW. In the Initialize Section, you will initialize the variable, and in the Do Section, you will do the main coding: ===================================================================== SECTION: Join Between F4201 & F4211 [GROUP SECTION] (S1) ===================================================================== OBJECT: SECTION EVENT: Do Section --------------------------------------------------------------------- evt_PriceAdjustmentType_AST evt_UserDefinedCodes_RT evt_ProductCode_SY evt_AmtPricePerUnit2_UPRC evt_FactorValue_FVTR evt_AdjustmentReasonCode_ARSN 0001 If PO PrintAttachment_FLAG is equal to "Y" 0002 Media Objects(GT4211A, <Get Text>, RV LineAttachment_DL01, BC Document (Order No, Invoice, etc.) (F4201) (DOCO), BC Order Type (F4201) (DCTO), BC Order Company (Order Number) (F4201) (KCOO), ...) 0003 Else 0004 End If 0005 // 0006 VA evt_PriceAdjustmentType_AST = "GEN" 0007 VA evt_ProductCode_SY = "40" 0008 VA evt_UserDefinedCodes_RT = "AR" 0009 ! F4074.Fetch Single ! BC Document (Order No, Invoice, etc.) (F4201) = TK Document (Order No, Invoice, etc.) ! BC Order Type (F4201) = TK Order Type ! BC Order Company (Order Number) (F4201) = TK Order Company (Order Number) ! BC Line Number (F4211) = TK Line Number ! VA evt_FactorValue_FVTR <- TK Factor Value ! VA evt_AmtPricePerUnit2_UPRC <- TK Amount - Price per Unit ! VA evt_AdjustmentReasonCode_ARSN <- TK Adjustment Reason Code 0010 RV FactorValue_FVTR = VA evt_FactorValue_FVTR*-1 0011 RV UnitPrice_UPRC = VA evt_AmtPricePerUnit2_UPRC 0012 Get UDC Description (Obsolete) VA evt_ProductCode_SY -> BF szSystemCode VA evt_UserDefinedCodes_RT -> BF szUserDefinedCodes VA evt_AdjustmentReasonCode_ARSN -> BF szUserDefinedCode RV F0005Description_DL01 <- BF szDescription01 0013 RV SubTotalAmount_AA = BC Amount - Extended Price (F4211)+RV UnitPrice_UPRC 0014 // 0015 If PO Language_FLAG is equal to "A" 0016 F4107.Fetch Single BC Item Number - Short (F4211) = TK Item Number - Short RV ItemDesc_DL01 <- TK Short Description 0017 Else 0018 RV ItemDesc_DL01 = concat(BC Description (F4211),BC Description - Line 2 (F4211)) 0019 End If There's more... The following are the required processing options, which need to be incorporated: Sales or Receivables Language Print Attachment See also Creating the purchase order report

  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint