Thursday, 4 April 2019

WO Issue Types

Manual issueThe system deducts materials from inventory when you enter the issue transactions on the Inventory Issue Revisions form.
PreflushingYou set a processing option for the Order Processing program (R31410) to deduct materials from inventory automatically when you process a work order.
BackflushingThe system deducts materials from inventory when items on the work order are reported as complete. This deduction method might occur when you report partial completions throughout the production process or when you report full completions at the last routing operation.
Super backflushingThe system deducts materials from inventory automatically at operations that are defined as pay points throughout the routing when the pay points are reported as complete or partially complete. The Super Backflush program (P31123) enables you to simultaneously backflush materials and labor hours, and report items that are complete at an operation

Friday, 1 February 2019

Purchase Order Approval Setup and Flow

Purchase Approval Setup and Flow

Step 1: Create Approval Route Code
P43008 - Approval Route Code Setup
Enter the Order Type, Amount From, Responsible Person

Setup B/P Constant, Enter the Newly created Approval Route Code  and Save

Setup Processing Option in P4310--> Approvals--> 1. By Branch Plant 2. Next Status

Step 2: Transaction
P4310 - Create the PO using the Application for above B/P, the order will go for PO Approval Request.

Step 3:
P43081 - inquire the PO and approve or reject the PO after review. 

Step 4:
P43070 - Held Order Application .
F4209 is the base table for Held Order Application.

Friday, 25 January 2019

Modal & Modless Form Connection

Modal:

Modal interconnections enable the user to view only one form at a time. After the child form begins, the user cannot access the parent form until the child form is closed.
Additionally, the data connection between the parent and child is usually static. Input data structure items are populated when the child form is launched, and output data structure items are populated when the child form closes. Parent form ER that follows a modal form interconnection call executes after the child form is closed.
In addition to static data connections, you can create dynamic form interconnections. A dynamic form interconnection enables you to call a form by passing the application and form ID. A dynamic form interconnection is always modal.
Modeless:

Modeless interconnections enable the user to view multiple forms at the same time. After the child form is started, users can switch back and forth between the parent form and the child form. Additionally, data changes on a parent or child form are immediately reflected in all other open forms in the connection.

Modal is the default interconnection type. Modal interconnections are appropriate when you want to lead the user through a particular process in which a number of values must be input in a specific order. In this case, you want the user to completely fill out each form before moving on to the next one. Add and copy functions also lend themselves to modal processing because you want the user to complete the function before going on to others.
Modeless interconnections are valuable when the user needs to view or update a series of data records. Avoid using modeless form interconnections if both the parent and child forms should be presented to the user at the same time. A power form is more appropriate in this case.
The parent form in a modeless interconnect must be a find/browse form. The child form type can be fix/inspect or transaction forms (header and headerless detail). When the user updates a record on the transaction form, the parent find/browse form automatically reflects the change.
When the user closes the parent form, the system closes all its modeless children forms.
Parent form ER that follow a modeless form interconnection call execute immediately instead of waiting for the child form to return.

Repost Programs - Sales, Purchase, Work Order

1). R42995 - Repost Active Sales Order
2). R43990 - Repost Open POs
3). R3190 - Repost Open Work Orders

Friday, 5 October 2018

How to Calculate the Tax for SO/PO in JDE?

F4102.Fetch Single
   BC Item Number - Short (F4211)(ITM) =  TK Item Number - Short
   BC Business Unit (F4211)(MCU) =  TK Business Unit
   VA rpt_PartialTax <- TK Category Code 7
   VA rpt_HazardousItem <- TK Category Code 8
   VA rpt_CommodityClassCode <- TK Commodity Class
//
F40205 Get Line Type Constants
   BC Line Type (F4211)(LNTY) -> BF szLineType
   VA evt_cIncludeCashDiscount_CDSC <- BF cIncludeCashDiscount
If VA evt_cIncludeCashDiscount_CDSC is equal to "Y" Or VA evt_cIncludeCashDiscount_CDSC is equal to "1"
   VA evt_cSuppressDiscount_EV01 = "0"
Else
   VA evt_cSuppressDiscount_EV01 = "1"
End If
//
If BC Sales Taxable (Y/N) (F4211)(TAX1) is equal to "Y"
   Tax, Calculate for Sales and Purchasing
      BC Tax Rate/Area (F4211)(TXA1) -> BF szTaxArea1
      BC Tax Expl Code 1 (F4211)(EXR1) -> BF szTaxExplanationCode1
      BC Date - Promised Delivery (F4211)(RSDJ) -> BF jdTransactionDate
      BC Payment Terms Code (F4211)(PTC) -> BF szPaymentTermsCode1
      BC Order Company (Order Number) (F4211)(KCOO) -> BF szCompany
      BC Item Number - Short (F4211)(ITM) -> BF mnShortItemNumber
      BC Quantity Shipped (F4211)(SOQS) -> BF mnUnitsPrimaryQtyOrder
      BC Amount - Extended Price (F4211)(AEXP) -> BF mnAmountTaxable
      VA evt_mnAmtTax2_STAM <- BF mnAmtTax2
      VA evt_mnAmtDiscontAvailable_ADSC <- BF mnAmtDiscountAvailable
      VA evt_mnTaxRate1_TXR1 <- BF mnTaxRate1
      VA evt_mnTaxRate2_TXR2 <- BF mnTaxRate2
      VA evt_mnTaxRate3_TXR3 <- BF mnTaxRate3
      VA evt_mnTaxRate4_TXR4 <- BF mnTaxRate4
      VA evt_mnTaxRate5_TXR5 <- BF mnTaxRate5
      VA evt_mnTaxAuthority1A_TA1 <- BF mnTaxAuthority1A
      VA evt_mnTaxAuthority2_TA2 <- BF mnTaxAuthority2
      VA evt_mnTaxAuthority3_TA3 <- BF mnTaxAuthority3
      VA evt_mnTaxAuthority4_TA4 <- BF mnTaxAuthority4
      VA evt_mnTaxAuthority4_TA4 <- BF mnTaxAuthority5
      VA evt_mnAmtSalesTaxTaxAuth1_STA1 <- BF mnAmtSalesTaxTaxAuth1
      VA evt_mnAmtSalesTaxTaxAuth2_STA2 <- BF mnAmtSalesTaxTaxAuth2
      VA evt_mnAmtSalesTaxTaxAuth3_STA3 <- BF mnAmtSalesTaxTaxAuth3
      VA evt_mnAmtSalesTaxTaxAuth4_STA4 <- BF mnAmtSaleStaxTaxAuth4
      VA evt_mnAmtSalesTaxTaxAuth5_STA5 <- BF mnAmtSalesTaxTaxAuth5
      VA evt_cTaxCalcMethod2_TC2 <- BF cTaxCalcMethod2
      VA evt_cTaxType3_TT3 <- BF cTaxType3
      VA evt_cTaxType4_TT4 <- BF cTaxType4
      VA evt_cTaxType5_TT5 <- BF cTaxType5
      VA evt_szDescriptionTaxArea_TAXA <- BF szDescriptionTaxArea
      VA evt_mnTotalAreaTaxRate_TRAT <- BF mnTotalAreaTaxRate
      VA evt_cFactorValueType_FVTY <- BF cFactorValueType
      "4" -> BF cSystemCode
      VA evt_mnGoodsValue_AG <> BF mnGoodsValue
      VA evt_mnAmountTaxExempt_ATXN <- BF mnAmountTaxExempt
      VA evt_mnUnroundedTaxAmt_UPRC <- BF mnUnroundedTaxAmt
      VA evt_cSummaryDetailFlag_EV02 <- BF cSummaryDetailFlag
      VA evt_cItemNumberUsed_EV03 <- BF cItemNumberUsedFlag
      VA evt_mnActiveVertexJob_JOBS -> BF mnJobnumberA
      VA evt_cActVertexTaxComplia_VVTX -> BF cIsVertexActive
      BC Document (Order No, Invoice, etc.) (F4211)(DOCO) -> BF mnDocumentOrderInvoiceE
      BC Order Type (F4211)(DCTO) -> BF szOrderType
      BC Order Company (Order Number) (F4211)(KCOO) -> BF szCompanyKeyOrderNo
      BC Order Suffix (F4211)(SFXO) -> BF szOrderSuffix
      BC Line Number (F4211)(LNID) -> BF mnLineNumber
      VA evt_cSuppressDiscount_EV01 -> BF cSuppressDiscountCalculation
      <Zero> -> BF cUseTaxedPrices
Else
   If BC Sales Taxable (Y/N) (F4211)(TAX1) is greater than or equal to "3" And BC Sales Taxable (Y/N) (F4211)(TAX1) is less than or equal to "8"
      Character to Math Numeric, Convert
         BC Sales Taxable (Y/N) (F4211)(TAX1) -> BF cCharacter
         VA evt_mnSalesTaxable_MATH01 <- BF mnMathNumeric
      F4008.Fetch Single
         BC Tax Rate/Area (F4211)(TXA1) =  TK Tax Rate/Area
         VA evt_mnTaxRate1_TXR1 <- TK Tax Rate 1
         VA evt_mnTaxRate2_TXR2 <- TK Tax Rate 2
         VA evt_mnTaxRate3_TXR3 <- TK Tax Rate 3
         VA evt_mnTaxRate4_TXR4 <- TK Tax Rate 4
         VA evt_mnTaxRate5_TXR5 <- TK Tax Rate 5
         BC Date - Invoice (F4211)(IVD) >= TK Date - Expiration (Julian)
         VA evt_mnSalesTaxable_MATH01 =  TK Item Number - Short
      Tax, Calculate for Sales and Purchasing
         BC Tax Rate/Area (F4211)(TXA1) -> BF szTaxArea1
         BC Tax Expl Code 1 (F4211)(EXR1) -> BF szTaxExplanationCode1
         BC Date - Promised Delivery (F4211)(RSDJ) -> BF jdTransactionDate
         BC Payment Terms Code (F4211)(PTC) -> BF szPaymentTermsCode1
         BC Order Company (Order Number) (F4211)(KCOO) -> BF szCompany
         VA evt_mnSalesTaxable_MATH01 -> BF mnShortItemNumber
         BC Quantity Shipped (F4211)(SOQS) -> BF mnUnitsPrimaryQtyOrder
         BC Amount - Extended Price (F4211)(AEXP) -> BF mnAmountTaxable
         VA evt_mnAmtTax2_STAM <- BF mnAmtTax2
         VA evt_mnAmtDiscontAvailable_ADSC <- BF mnAmtDiscountAvailable
         VA evt_mnTaxRate1_TXR1 <- BF mnTaxRate1
         VA evt_mnTaxRate2_TXR2 <- BF mnTaxRate2
         VA evt_mnTaxRate3_TXR3 <- BF mnTaxRate3
         VA evt_mnTaxRate4_TXR4 <- BF mnTaxRate4
         VA evt_mnTaxRate5_TXR5 <- BF mnTaxRate5
         VA evt_mnTaxAuthority1A_TA1 <- BF mnTaxAuthority1A
         VA evt_mnTaxAuthority2_TA2 <- BF mnTaxAuthority2
         VA evt_mnTaxAuthority3_TA3 <- BF mnTaxAuthority3
         VA evt_mnTaxAuthority4_TA4 <- BF mnTaxAuthority4
         VA evt_mnTaxAuthority4_TA4 <- BF mnTaxAuthority5
         VA evt_mnAmtSalesTaxTaxAuth1_STA1 <- BF mnAmtSalesTaxTaxAuth1
         VA evt_mnAmtSalesTaxTaxAuth2_STA2 <- BF mnAmtSalesTaxTaxAuth2
         VA evt_mnAmtSalesTaxTaxAuth3_STA3 <- BF mnAmtSalesTaxTaxAuth3
         VA evt_mnAmtSalesTaxTaxAuth4_STA4 <- BF mnAmtSaleStaxTaxAuth4
         VA evt_mnAmtSalesTaxTaxAuth5_STA5 <- BF mnAmtSalesTaxTaxAuth5
         VA evt_cTaxCalcMethod2_TC2 <- BF cTaxCalcMethod2
         VA evt_cTaxType3_TT3 <- BF cTaxType3
         VA evt_cTaxType4_TT4 <- BF cTaxType4
         VA evt_cTaxType5_TT5 <- BF cTaxType5
         VA evt_szDescriptionTaxArea_TAXA <- BF szDescriptionTaxArea
         VA evt_mnTotalAreaTaxRate_TRAT <- BF mnTotalAreaTaxRate
         VA evt_cFactorValueType_FVTY <- BF cFactorValueType
         "4" -> BF cSystemCode
         VA evt_mnGoodsValue_AG <> BF mnGoodsValue
         VA evt_mnAmountTaxExempt_ATXN <- BF mnAmountTaxExempt
         VA evt_mnUnroundedTaxAmt_UPRC <- BF mnUnroundedTaxAmt
         VA evt_cSummaryDetailFlag_EV02 <- BF cSummaryDetailFlag
         VA evt_cItemNumberUsed_EV03 <- BF cItemNumberUsedFlag
         VA evt_mnActiveVertexJob_JOBS -> BF mnJobnumberA
         VA evt_cActVertexTaxComplia_VVTX -> BF cIsVertexActive
         BC Document (Order No, Invoice, etc.) (F4211)(DOCO) -> BF mnDocumentOrderInvoiceE
         BC Order Type (F4211)(DCTO) -> BF szOrderType
         BC Order Company (Order Number) (F4211)(KCOO) -> BF szCompanyKeyOrderNo
         BC Order Suffix (F4211)(SFXO) -> BF szOrderSuffix
         BC Line Number (F4211)(LNID) -> BF mnLineNumber
         VA evt_cSuppressDiscount_EV01 -> BF cSuppressDiscountCalculation
         <Zero> -> BF cUseTaxedPrices
   End If
End If

VA evt_InvoiceAmount_AA = [BC Amount - Extended Price (F4211)(AEXP)]+[VA evt_mnAmtTax2_STAM]