Price Lists

[Stavors]

Hi List,

We have a requirement to produce a price list for either an individual item or an item/customer combination. The list needs to show the base price of the item and the selling price of the item when 1 of it is purchased by the customer.

We are looking for a business function so that if we give it an item number and/or customer number then it will return the base price / selling price etc. We have advanced pricing switched on - hence the enquiry as it is not as simple as a file get - or is it??????

Any help would be welcome.

Andrew Stavordale
Xe sp15.1, Oracle Win2000, Citrix

 

[bioriz]

Hello...

Have you had any luck with this. We are looking to do the same thing here. I tried using the BSFN B4200950, but it doesn't seem to work right. I then looked into R42950 (which calls B4200950), and it no longer uses that BSFN, it now uses F4211 Edit line and End doc, which are very complicated to use (at least for me). I may resort to using the EDI UBE R47011, and output to a bogus order number like 1-SQ (price book or quote order). Then maybe run a UBE from that order to either create a CSV and/or perhaps an EDI 832. Problem is, is that we have close to 20K items. Hate to fill up F4211 with so many line items. There should be an easier way.

Curious how you made out with this. We need to send price files for a couple of EDI/XML type projects we are doing here.


B7332, SP11.2, AS/400, DB2

 

[Stavors]

In the end I created a business function which seemed to do the trick. If you email me I can send a copy of the code I developed.

Xe (no updates), NT Oracle, SP15, Citrix

 

[Spenno]

Hi Stavors,
I'm looking at doing something similar to yourself as in, I'm looking at retreiving Customer Product Price inofrmation. This will be called from an external VB app. Your business function looks as if it would be ideal.
Would it be possible for a copy???

Regards

Chris

 

[iwanb]

Re: Price Lists --> using business Function

Hi,
I'm having a some problem. Do you got any solution for getting Base Price ? using Business Function ?

thanks
Iwanb

 

[Gergely_Pongracz]

Re: Price Lists --> using business Function

Hi All,
whenever I had to do something with advanced pricing (well, these were cases when order had already been entered) I used tables F4074 and F40UI74 to retrive all price related information...
Regards:
Gergely Pongrácz
e-Best, Hungary

 

[pfd]

Re: Price Lists --> using business Function

Try this link.
http://www.jdelist.com/ubb/showthreaded.php?Cat=0&Number=63188&page=&view=&sb=5&o=&vc=1

 

[BBritain]

Re: Price Lists --> using business Function

PFD may be a developer of few words, but the attachment PFD provided (in the link) was of great help.

Ben again,

 

[Frosty the Coder]

Re: Price Lists --> using business Function

What are some search words that I'd find on the link?

I can't get it to work from either the email or forum.

If you (Ben (again)) found it interesting, I definitely want to read it.

TIA

Gene

 

[BBritain]

Re: Price Lists --> using business Function

Go to the link

http://www.jdelist.com/ubb/showthreaded.php?Cat=0&Number=63188&page=&view=&sb=5&o=&vc=1

and find the entry where he added an attachement. THis way you don't even have to search.

Ben again,

 

[iwanb]

Re: Price Lists --> using business Function

PDF, thanks.
It's work.