jdeconsult
Member
Hi!,
Need a small help...
A Report to display Item Unit Price for a customer...
-----------------------------------------------------
Output:
=======
Effective Date 01/01/2002
Terminal (MCU) North Tees
Customer Effective Date Item Unit Price
------------------------------------------------------------------
F.Peart 01/01/2002 11 0.7199
07 0.1355
04 0.1244
W.H.Bowe 01/01/2002 11 0.7123
W.Eves 01/01/2002 04 .01223
Summary:
========
User will input Effective Date and MCU. Thus I have to list down Customers for that date and MCU with its Items and Unit Price(Calculated from Advance Price)
I tried checking P4074, its using Master BSFN B4500090 and B4200310
I tried checking R42950... It is also using MBSFN B4200310...
Can you help me how to get Unit Price... taking into consideration all overrides and Advance Pricing Setups.
When I debuged program P4074 the below MBSFN get me Unit Price for that Customers Item ... Check below Line with ££££££ gets me Unit Price
F4211 Edit Line
FC JOBS-Job Number (wf) [HIDDEN] <> mnCMJobNo
"A" -> cCMLineAction
"1" -> cCMProcessEdits
"2" -> cCMWriteToWFFlag
VA frm_Is_Error_EV04 <> cCMRecdWrittenToWF
FC CTID-Machine Key (wf) [HIDDEN] -> szCMComputerID
VA frm_General_EV03 <- cCMErrorConditions
FC KCOO - Order Company (wf) [HIDDEN] -> szOrderCo
FC DOCO - Order Number (wf) [HIDDEN] -> mnOrderNo
FC DCTO - Order Type (wf) [HIDDEN] <> szOrderType
FC Line Number <> mnLineNo
FC Business Unit <> szBusinessUnit
FC Ship To <> mnShipToNo
UNDEFINED X jdRequestedDate
UNDEFINED X jdPromisedDate
UNDEFINED X jdCancelDate
UNDEFINED X jdPromisedDlvryDate
FC Item Number <> szItemNo
UNDEFINED X szLocation
UNDEFINED X szLotNo
FC ITEM NUMBER <> szDescription1
UNDEFINED X szDescription2
UNDEFINED X szLineType
UNDEFINED X szLastStatus
UNDEFINED X szNextStatus
FC Quantity From <> mnQtyOrdered
UNDEFINED X mnQtyShipped
UNDEFINED X mnQtyBackordered
UNDEFINED X mnQtyCanceled
VA frm_EditLn_Unit_Price_MATH04 <-mnUnitPrice £££££
UNDEFINED X mnExtendedPrice
VA frm_EditLn_Unit_Cost_MATH05 <- mnUnitCost
UNDEFINED X mnExtendedCost
UNDEFINED X szPrintMesg
UNDEFINED X cPaymentInstrument
FC Adjustment Schedule_ASN <> szAdjustmentSchedule
UNDEFINED X cSalesTaxableYN
UNDEFINED X cAssociatedText
FC U/M <> szTransactionUOM
FC Pricing UOM <> szPricingUOM
UNDEFINED X mnItemWeight
UNDEFINED X szWeightUOM
VA frm_EditLn_For_Unit_Prc_MATH07 <- mnForeignUnitPrice
UNDEFINED X mnForeignExtPrice
VA frm_EditLn_For_Unt_Cost_MATH06 <- mnForeignUnitCost
UNDEFINED X mnForeignExtCost
VA frm_Current_Value_CLVL <> szPricingCategoryLevel
UNDEFINED X mnDiscountFactor
FC XLIN-Line Number (wf) [HIDDEN] <> mnCMLineNo
"EP40721" -> szCMProgramID
PO szVersion -> szCMVersion
UNDEFINED X mnSupplierNo
UNDEFINED X szRelatedKitItemNo
UNDEFINED X mnKitMasterLineNo
UNDEFINED X mnComponentLineNo
UNDEFINED X mnRelatedKitComponent
UNDEFINED X mnNoOfCpntPerParent
UNDEFINED X cOverridePrice
UNDEFINED X cOverrideCost
UNDEFINED X szUserID
UNDEFINED X jdDateUpdated
UNDEFINED X mnWKOrderTotal
UNDEFINED X mnWKForeignOrderTotal
UNDEFINED X mnWKTotalCost
UNDEFINED X mnWKForeignTotalCost
UNDEFINED X cWKProcessingType
"<Blank>" -> cWKSourceOfData
"<Blank>" -> cWKCheckAvailability
UNDEFINED X mnLastLineNoAssigned
UNDEFINED X cStockingType
UNDEFINED X szOriginalOrderKeyCo
UNDEFINED X szOriginalOrderNo
UNDEFINED X szOriginalOrderType
UNDEFINED X mnOriginalOrderLineNo
UNDEFINED X cParentItmMethdOfPriceCalcn
UNDEFINED X szLandedCost
"4" <> mnWKSuppressProcess
FC ITM-Short Item No. (wf) [HIDDEN] <- mnShortItemNo
UNDEFINED X mnWKRelatedOrderProcess
UNDEFINED X mnSODLineNo
UNDEFINED X mnPriceAdjRevLevel
UNDEFINED X szSalesOrderFlags
UNDEFINED X mnSODDocNo
UNDEFINED X szSODDocType
UNDEFINED X szSODOrderCo
UNDEFINED X szTransferOrderToBranch
VA frm_Domestic_Detached_Tot_DETD <- mnDomesticDetachedAdj
VA frm_Foreign_Detached_Tot_DETF <- mnForeignDetachedAdj
UNDEFINED X mnSODWFLineNo
UNDEFINED X szGeneric2CharString
UNDEFINED X mnTOEPOExchangeRate
UNDEFINED X szTOEPOCurrencyCode
UNDEFINED X mnDRPKeyId
UNDEFINED X mnSoldToCust
UNDEFINED X szF4201BranchPlant
UNDEFINED X szSoldToCurrencyCode
UNDEFINED X cConsolidationFlag
FC Price Effective <> jdPriceEffectiveDate
UNDEFINED X mnWOWFLineNo
UNDEFINED X mnLineNoIncrement
UNDEFINED X mnParentWFLineNo
UNDEFINED X cStatusInWarehouse
"1" -> cBypassCommitments
UNDEFINED X szProductSource
UNDEFINED X szProductSourceType
UNDEFINED X mnSequenceNumber
VA frm_szAgreementNumber_DMCT -> szAgreementNumber
UNDEFINED X mnAgreementSupplement
UNDEFINED X mnAgreementsFound
VA frm_szModeOfTransport_MOT -> szModeOfTransport
VA frm_szDutyStatus_DTYS -> szDutyStatus
VA frm_szLineofBusiness_LOB -> szLineofBusiness
UNDEFINED X jdPromisedShip
VA frm_szEndUse_EUSE -> szEndUse
VA frm_szPriceCode1_UPC1 -> szPriceCode1
VA frm_szPriceCode2_UPC2 -> szPriceCode2
VA frm_szPriceCode3_UPC3 -> szPriceCode3
UNDEFINED X szItemFlashMessage
UNDEFINED X szCompanyKeyRelated
UNDEFINED X szRelatedPoSoNumber
UNDEFINED X szRelatedOrderType
UNDEFINED X mnRelatedPoSoLineNo
UNDEFINED X cGenericChar3
UNDEFINED X mnProfitMargin
UNDEFINED X mnQuantityAvailable
UNDEFINED X cRequestScheduleFlag
UNDEFINED X cOrderProcessType
UNDEFINED X cGenericChar2
UNDEFINED X mnSODRelatedJobNumber
UNDEFINED X szGenericString
VA frm_mnCarrier_CARS -> mnCarrier
UNDEFINED X szGenericString2_DL02
UNDEFINED X mnGenericMathNumeric1_MATH01
UNDEFINED X mnGenericMathNumeric2_MATH02
UNDEFINED X mnItemVolume_ITVL
UNDEFINED X szVolumeUOM_VLUM
UNDEFINED X szRevenueBusinessUnit
UNDEFINED X szCustomerPO_VR01
UNDEFINED X szReference2Vendor_VR02
FC Process ID [HIDDEN] <> mnProcessID
FC Transaction ID [HIDDEN] <> mnTransactionID
Is using MBSFN the only way to calculated Unit Price... ? Is there any other way.
Can anybody help me how to use this MBSFN in reports
Awaiting for your reply.
Thanks & Regards,
JDE Consultant
OneWorld XE
Service Pack 19.1
Database SQL 2000
Need a small help...
A Report to display Item Unit Price for a customer...
-----------------------------------------------------
Output:
=======
Effective Date 01/01/2002
Terminal (MCU) North Tees
Customer Effective Date Item Unit Price
------------------------------------------------------------------
F.Peart 01/01/2002 11 0.7199
07 0.1355
04 0.1244
W.H.Bowe 01/01/2002 11 0.7123
W.Eves 01/01/2002 04 .01223
Summary:
========
User will input Effective Date and MCU. Thus I have to list down Customers for that date and MCU with its Items and Unit Price(Calculated from Advance Price)
I tried checking P4074, its using Master BSFN B4500090 and B4200310
I tried checking R42950... It is also using MBSFN B4200310...
Can you help me how to get Unit Price... taking into consideration all overrides and Advance Pricing Setups.
When I debuged program P4074 the below MBSFN get me Unit Price for that Customers Item ... Check below Line with ££££££ gets me Unit Price
F4211 Edit Line
FC JOBS-Job Number (wf) [HIDDEN] <> mnCMJobNo
"A" -> cCMLineAction
"1" -> cCMProcessEdits
"2" -> cCMWriteToWFFlag
VA frm_Is_Error_EV04 <> cCMRecdWrittenToWF
FC CTID-Machine Key (wf) [HIDDEN] -> szCMComputerID
VA frm_General_EV03 <- cCMErrorConditions
FC KCOO - Order Company (wf) [HIDDEN] -> szOrderCo
FC DOCO - Order Number (wf) [HIDDEN] -> mnOrderNo
FC DCTO - Order Type (wf) [HIDDEN] <> szOrderType
FC Line Number <> mnLineNo
FC Business Unit <> szBusinessUnit
FC Ship To <> mnShipToNo
UNDEFINED X jdRequestedDate
UNDEFINED X jdPromisedDate
UNDEFINED X jdCancelDate
UNDEFINED X jdPromisedDlvryDate
FC Item Number <> szItemNo
UNDEFINED X szLocation
UNDEFINED X szLotNo
FC ITEM NUMBER <> szDescription1
UNDEFINED X szDescription2
UNDEFINED X szLineType
UNDEFINED X szLastStatus
UNDEFINED X szNextStatus
FC Quantity From <> mnQtyOrdered
UNDEFINED X mnQtyShipped
UNDEFINED X mnQtyBackordered
UNDEFINED X mnQtyCanceled
VA frm_EditLn_Unit_Price_MATH04 <-mnUnitPrice £££££
UNDEFINED X mnExtendedPrice
VA frm_EditLn_Unit_Cost_MATH05 <- mnUnitCost
UNDEFINED X mnExtendedCost
UNDEFINED X szPrintMesg
UNDEFINED X cPaymentInstrument
FC Adjustment Schedule_ASN <> szAdjustmentSchedule
UNDEFINED X cSalesTaxableYN
UNDEFINED X cAssociatedText
FC U/M <> szTransactionUOM
FC Pricing UOM <> szPricingUOM
UNDEFINED X mnItemWeight
UNDEFINED X szWeightUOM
VA frm_EditLn_For_Unit_Prc_MATH07 <- mnForeignUnitPrice
UNDEFINED X mnForeignExtPrice
VA frm_EditLn_For_Unt_Cost_MATH06 <- mnForeignUnitCost
UNDEFINED X mnForeignExtCost
VA frm_Current_Value_CLVL <> szPricingCategoryLevel
UNDEFINED X mnDiscountFactor
FC XLIN-Line Number (wf) [HIDDEN] <> mnCMLineNo
"EP40721" -> szCMProgramID
PO szVersion -> szCMVersion
UNDEFINED X mnSupplierNo
UNDEFINED X szRelatedKitItemNo
UNDEFINED X mnKitMasterLineNo
UNDEFINED X mnComponentLineNo
UNDEFINED X mnRelatedKitComponent
UNDEFINED X mnNoOfCpntPerParent
UNDEFINED X cOverridePrice
UNDEFINED X cOverrideCost
UNDEFINED X szUserID
UNDEFINED X jdDateUpdated
UNDEFINED X mnWKOrderTotal
UNDEFINED X mnWKForeignOrderTotal
UNDEFINED X mnWKTotalCost
UNDEFINED X mnWKForeignTotalCost
UNDEFINED X cWKProcessingType
"<Blank>" -> cWKSourceOfData
"<Blank>" -> cWKCheckAvailability
UNDEFINED X mnLastLineNoAssigned
UNDEFINED X cStockingType
UNDEFINED X szOriginalOrderKeyCo
UNDEFINED X szOriginalOrderNo
UNDEFINED X szOriginalOrderType
UNDEFINED X mnOriginalOrderLineNo
UNDEFINED X cParentItmMethdOfPriceCalcn
UNDEFINED X szLandedCost
"4" <> mnWKSuppressProcess
FC ITM-Short Item No. (wf) [HIDDEN] <- mnShortItemNo
UNDEFINED X mnWKRelatedOrderProcess
UNDEFINED X mnSODLineNo
UNDEFINED X mnPriceAdjRevLevel
UNDEFINED X szSalesOrderFlags
UNDEFINED X mnSODDocNo
UNDEFINED X szSODDocType
UNDEFINED X szSODOrderCo
UNDEFINED X szTransferOrderToBranch
VA frm_Domestic_Detached_Tot_DETD <- mnDomesticDetachedAdj
VA frm_Foreign_Detached_Tot_DETF <- mnForeignDetachedAdj
UNDEFINED X mnSODWFLineNo
UNDEFINED X szGeneric2CharString
UNDEFINED X mnTOEPOExchangeRate
UNDEFINED X szTOEPOCurrencyCode
UNDEFINED X mnDRPKeyId
UNDEFINED X mnSoldToCust
UNDEFINED X szF4201BranchPlant
UNDEFINED X szSoldToCurrencyCode
UNDEFINED X cConsolidationFlag
FC Price Effective <> jdPriceEffectiveDate
UNDEFINED X mnWOWFLineNo
UNDEFINED X mnLineNoIncrement
UNDEFINED X mnParentWFLineNo
UNDEFINED X cStatusInWarehouse
"1" -> cBypassCommitments
UNDEFINED X szProductSource
UNDEFINED X szProductSourceType
UNDEFINED X mnSequenceNumber
VA frm_szAgreementNumber_DMCT -> szAgreementNumber
UNDEFINED X mnAgreementSupplement
UNDEFINED X mnAgreementsFound
VA frm_szModeOfTransport_MOT -> szModeOfTransport
VA frm_szDutyStatus_DTYS -> szDutyStatus
VA frm_szLineofBusiness_LOB -> szLineofBusiness
UNDEFINED X jdPromisedShip
VA frm_szEndUse_EUSE -> szEndUse
VA frm_szPriceCode1_UPC1 -> szPriceCode1
VA frm_szPriceCode2_UPC2 -> szPriceCode2
VA frm_szPriceCode3_UPC3 -> szPriceCode3
UNDEFINED X szItemFlashMessage
UNDEFINED X szCompanyKeyRelated
UNDEFINED X szRelatedPoSoNumber
UNDEFINED X szRelatedOrderType
UNDEFINED X mnRelatedPoSoLineNo
UNDEFINED X cGenericChar3
UNDEFINED X mnProfitMargin
UNDEFINED X mnQuantityAvailable
UNDEFINED X cRequestScheduleFlag
UNDEFINED X cOrderProcessType
UNDEFINED X cGenericChar2
UNDEFINED X mnSODRelatedJobNumber
UNDEFINED X szGenericString
VA frm_mnCarrier_CARS -> mnCarrier
UNDEFINED X szGenericString2_DL02
UNDEFINED X mnGenericMathNumeric1_MATH01
UNDEFINED X mnGenericMathNumeric2_MATH02
UNDEFINED X mnItemVolume_ITVL
UNDEFINED X szVolumeUOM_VLUM
UNDEFINED X szRevenueBusinessUnit
UNDEFINED X szCustomerPO_VR01
UNDEFINED X szReference2Vendor_VR02
FC Process ID [HIDDEN] <> mnProcessID
FC Transaction ID [HIDDEN] <> mnTransactionID
Is using MBSFN the only way to calculated Unit Price... ? Is there any other way.
Can anybody help me how to use this MBSFN in reports
Awaiting for your reply.
Thanks & Regards,
JDE Consultant
OneWorld XE
Service Pack 19.1
Database SQL 2000