How to Calculate Item Unit Price using Advance Pricing

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
 
F4211 Edit LIne MBF is always called for repricing.
However, inside this BSFN, it calls BSFN B4201500 to do the pricing. So, you can actually call B4201500 to calculate the advanced price directly, but it still has quite a lot of fields that need defining.
 
Hi All
Please Help, I need a step step solution to create a Price List. I'm new to JDE and this is very Urgent .
 
Have you looked at the BSFN B4500460. All you need to pass in is:
Address Number
Date
Qty
UOM
2nd item number
branch
(currency is optional as well)

it's pretty fast...

Aaron
 
Back
Top