• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Advanced Pricing - Adjustment based on formula

topher79

Member
Hi All! Advanced pricing is on and we've used for years. I'm trying to create an item level pricing adjustment which is based on the XM cost bucket in the F30026. The SDURAT field in F4211 has been correctly mapped to the value I'm wanting out of F30026 as I'm seeing it in the data browser. The formula is simple (-1)*SDURAT to discount XM cost in the 30026. I've been successful at setting up other cost basis codes for the adjustments but 7 (based on formula) is the only one that behaves in the following manner.

When I go to enter the ST the UNIT PRICE highlights red with the following errors below. Any help on the matter would be greatly appreciated! Thank you!


Syntax Error - Invalid Function Name Warning Go to error..


ER Details:
Form P4210_W4210A
Control Id 1
Control Title Grid
Event Row is Exit & Changed - Asynch
Line No 911
BSFN Details:
Source File /OneWorld/Packages/PY0402F1/source/CDIST/b4500050.c
Source Line 7086
Error ID 45FN3
BSFN DSTR Item 56

Error DetermineSOMBFPricing process failed Warning Go to error..

CAUSE: The operation did not succeed. .

RESOLUTION: See jde.log or jdedebug.log for more details on causes
ER Details:
Form P4210_W4210A
Control Id 1
Control Title Grid
Event Row is Exit & Changed - Asynch
Line No 911
BSFN Details:
Source File /OneWorld/Packages/PY0402F1/source/CSALES/b4200311.c
Source Line 21405
Error ID 097O
BSFN DSTR Item 56
 

Craig_Potter

Reputable Poster
Tough mod to get right when trying to add additional fields to Order Entry like this. Main issue is around the timing - plenty of advice and warnings on this in other postings including... http://www.jdelist.com/vb4/archive/index.php/t-49.html

However, perhaps consider a less intrusive development by simply writing this XM Cost Component from the F30026 to the Item Cost file (F4105) as a new Cost Method and use a simple Cost based Advanced Pricing rule to pick up this new Cost Method value?
 

topher79

Member
Thanks Craig. Writing from 30026 to 4105 occurred to me but that would prove to be more maintenance for instance having to run every time a new item is set up or revalued. Thanks for the link and I'll keep at it!
 
Top