Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Tools Development

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
35%
Installation Wizard into new VRC
42%
Manual into existing VRC
3%
Manual into new VRC
19%
Total votes: 31

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 18th November 2003, 11:00
en@frrom en@frrom is offline
Guru
 
Join Date: Aug 2003
Location: Belgium
Posts: 1,219
en@frrom will become famous soon enough
Baan: B50B - DB: Oracle 8.0 - OS: Win2k AS
Pricing methods

Hello,

I need to use the regular Baan-logic to retrieve the sales price of items (price-books etc) for a session in the service module. [Search method sales-price in Service parameters is set to 'prices service']

Can someone tell me please which dll('s)/function(s) have to be called with which arguments in order to retrieve the correct price based on price-books, matrices etc?

Many thanks in advance!!

En.
Reply With Quote
  #2  
Old 18th November 2003, 13:59
kbartelds kbartelds is offline
Senior Member
 
Join Date: Feb 2003
Location: Netherlands
Posts: 264
kbartelds is on a distinguished road
Baan: B40c4 - DB: Oracle 7 - OS: Sun Solaris
it is located in include itdsls4102, function tdsls4102.find.default.price.and.discount.

Regards,
Klaas
Reply With Quote
Sponsored Links
  #3  
Old 18th November 2003, 14:04
en@frrom en@frrom is offline
Guru
 
Join Date: Aug 2003
Location: Belgium
Posts: 1,219
en@frrom will become famous soon enough
Baan: B50B - DB: Oracle 8.0 - OS: Win2k AS
Thanks for your response Klaas.

However, I'm running Baan 5(.0b), and the include you mentioned does not exist anymore in Baan 5.
Any Baan 5 user that could help me??
Reply With Quote
  #4  
Old 18th November 2003, 19:39
en@frrom en@frrom is offline
Guru
 
Join Date: Aug 2003
Location: Belgium
Posts: 1,219
en@frrom will become famous soon enough
Baan: B50B - DB: Oracle 8.0 - OS: Win2k AS
Anyone????

Anyone?? Need this kinda urgently..!!
Reply With Quote
  #5  
Old 18th November 2003, 20:58
evesely's Avatar
evesely evesely is offline
Guru
 
Join Date: Dec 2001
Location: Lisle, Illinois USA
Posts: 411
evesely is on a distinguished road
How about tdpcgdll0001? Is that what you want?
Reply With Quote
  #6  
Old 19th November 2003, 08:35
en@frrom en@frrom is offline
Guru
 
Join Date: Aug 2003
Location: Belgium
Posts: 1,219
en@frrom will become famous soon enough
Baan: B50B - DB: Oracle 8.0 - OS: Win2k AS
I think that is what I need. The problem is that since I do not have the sources on my system, it is rather hard for me to check the whole pricing-flow. There are a bunch of pricing-dll's (tdpcgdll****), and I don't know exactly which one to implement, and which arguments to send along.

This is for within the service module, I will use it for printing price-quotations; so I should have it functioning similar to the price calculator, i.e. not coming from a specific order, yet just entering:
- type of order [-> sales or purchase],
- optionally a specific BP,
- item
- currency
- quantity + unit
- price date

So I need to know which dll(s)/function(s) to call and which arguments to pass them in order to get this done.

This is getting urgent...


Thanks again,

En.
Reply With Quote
  #7  
Old 19th November 2003, 14:36
evesely's Avatar
evesely evesely is offline
Guru
 
Join Date: Dec 2001
Location: Lisle, Illinois USA
Posts: 411
evesely is on a distinguished road
You can run bic_info6.2 on the object in question to get more information including the prototype and description. For example, here is a portion of the output from running bic_info6.2 -a otdpcgdll0001:

Code:
function extern long tdpcg.dll0001.retrieve.price.and.discounts(
         domain tdpcg.tyor typ.of.ord,
         domain tcccur trn.cur,
         ref domain tcratc exc.rat(),
         ref domain tcratf rat.fac(),
         domain tcitem item,
         domain tcqsl1 ord.qua,
         domain tcqsl1 org.ord.qua,
         domain tcqsl1 prc.grp.qua,
         domain tccuni qty.unt,
         domain tcconv cnv.qty.inv,
         domain tcdate del.dte,
         domain tcdate ord.dte,
         domain tcdate sys.dte,
         domain tcbool del.man.dsc,
         domain tcbool del.pb.dsc,
         domain tdpcg.prds prc.dsc.bth,
         ref domain tcamnt grs.amt,
         ref domain tcamnt dsc.amt,
         ref domain tcamnt net.amt,
         ref domain tcbool drv.itm.used,
         ref domain tcbool deal.ret,
         ref domain tdpcg.deal deal,
         ref domain tcitem deal.item,
         ref domain tcefex.date deal.eff,
         ref domain tdpcg.prse deal.seq,
         ref domain tcyesno deal.dtr,
         ref domain tcyesno deal.elg,
         ... )
 
        This method will attempt to apply a price and discounts to a
        given sales order line, sales quotation line, purchase order
        line or RFQ line. The order line buffer will be loaded with the
        pricing information.  The method can also be used to retrieve a
        price and discounts for general processing (e.g. project,
        service etc.) The price and discount information will be passed
        back via global variables.
 
        Return Values:  0               Method successful.
                        DALHOOKERROR    Method failure.
        Input        :  typ.of.ord      Type of order being processed
                                        sales orders (so), sales
                                        quotations (sq), purchase
                                        orders (po), RFQs (pq),
                                        service (sr), general sales(gs)
                                        or general purchase(gp).
                        trn.cur         Transaction currency from the
                                        order table.
                        exc.rat()       Exchange rate array from the
                                        order table.
                        rat.fac()       Rate factor array from the
                                        order table.
                        item            Item from the order line
                                        table.
                        ord.qua         Total order quantity from the
                                        order line table.
                        org.ord.qua     Original order quantity of
                                        the order line.  In add mode,
                                        set to zero. In edit mode set
                                        to the quantity before the
                                        line was edited.
                        prc.grp.qua     Quantity used to apply
                                        discounts for 'like' price
                                        groups.  (Should be set with
                                        the same value as ord.qua
                                        except when called from
                                        redisc.like.price.groups()).
                        qty.unt         Units the quantity is in
                                        (from the order line table).
                        cnv.qty.inv     Conversion factor from quantity
                                        units to inventory (base)
                                        units (from the order line
                                        table).
                        del.dte         Planned delivery date from
                                        the order line table.
                        ord.dte         Order date from the order line
                                        table.
                        sys.dte         System date.
                        del.man.dsc     Delete manual discounts (T/F).
                        del.pb.dsc      Delete discount applied from
                                        the price book (T/F).
                        prc.dsc.bth     Apply a price, apply the
                                        discounts or both.
        Optional Input: opt.arg28       If set, pass into initialize
                                                                |#SOL 102731.en
        Optional Input: opt.arg29       If set, pass into tdintcfall
                                                                |#SOL 102731.en
                                        method.
        Output        : grs.amt         Gross extended amount of the
                                        line.
                        dsc.amt         Total discount amount of the
                                        line.
                        net.amt         Net extended amount of the
                                        line.
                        drv.itm.used    The derived from item was used
                                        to retrieve the price (T/F).
                        deal.ret        Was a deal discount retrieved
                                        (T/F)
                        deal            Deal id.
                        deal.item       Item from the deal.
                        deal.eff        Effective date of the deal.
                        deal.seq        Sequence number of the deal.
                        deal.dtr        Determining flag from deal.
                        deal.elg        Eligible flag from the deal.
 
        When this method is called to apply the price and discounts for
        an order line, the del.man.dsc parameter should be set to false
        and the del.pb.dsc parameter should be set to true.  The prc.dsc.bth
        parameter should be set to both. For general pricing processing,
        set the del.man.dsc and del.pb.dsc parameters to true.
 
        Deal functionality has postponed until a later release.  All deal
        output parameters can be ignored at this time.
 
        Pre-conditions:
 
        One of the following header/detail table combinations must be in
        memory before calling this method:
                Sales Orders/Sales Order Lines (tdsls400,tdsls401)
                Sales Quotations/Sales Quotations Lines (tdsls100,tdsls101)
                Purchase Orders/Purchase Order Lines (tdpur400,tdpur401)
                BP RFQ Headers/BP RFQ Lines (tdpur105, tdpur106)
 
        If this method is called to retrieve a price for a general
        pricing process, no table combination will be in memory. The
        method tdpcg.dll0010.load.global.so.matrix.attributes() or
        tdpcg.dll0010.load.global.po.matrix.attributes() must be called
        before this method to load the matrix attributes needed to
        retrieve a price.
 
        If optional argument 28 is passed into this method, that
        argument will be passed into the initialization method.  If the
        argument is non-zero, initialization will always occur.
 
        If this method is called in a batch program where the header
        instances change, optional argument 28 should be passed with a
        value of one when the header instance changes so initialization
        will occur for all new header instances.
 
        Post-conditions:
 
        The function update.occ() must be called after the call to this
        method.  This will ensure that the price/discount information
        will be updated to the database.
 
        The method will call tdpcg.dll0010.initialize.price.discounts()
        which allocates memory at runtime. Be sure to call the method
        tdpcg.dll0010.free.array.memory() before leaving the session.

I hope that helps.
Reply With Quote
  #8  
Old 20th November 2003, 12:33
en@frrom en@frrom is offline
Guru
 
Join Date: Aug 2003
Location: Belgium
Posts: 1,219
en@frrom will become famous soon enough
Baan: B50B - DB: Oracle 8.0 - OS: Win2k AS
you're right, didn't think of that one. I've been looking at the dll's - a whole bunch!! - and I think the one I need is tsmdm.dll0045.read.pricing.and.discount.data().
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Cannot add posting data to Payment Methods Neal Matthews Finance, Invoicing and Integration 10 18th February 2004 16:05
Settings in payment methods Erik Konrath Finance, Invoicing and Integration 1 6th October 2003 23:01
Check status for diff.payment methods Kotharu Narayan Finance, Invoicing and Integration 1 14th March 2003 15:19
Lot pricing in BAAN mplaza@canamera Finance, Invoicing and Integration 10 18th July 2002 14:03


All times are GMT +2. The time now is 02:06.


©2001-2017 - Baanboard.com - Baanforums.com