Sales Price Table - Additional Unit Price Field

Jonathan2708
Jonathan2708 Member Posts: 552
Hi,

I need to store an additional unit price for each record in the Sales Price table. There are 2 prices for each combination of customer/item/variant. Just wondered if anybody has done this development before and can point me in the direction of functions etc. that will need amending. The unit price selected will depend on a field on the Sales Header table when entering the order/invoice.

Any help appreciated,

Jonathan

Comments

  • SD-JR
    SD-JR Member Posts: 94
    Hi,

    We have done the same added a delivered and collected price to the sales header. You can manage the selection based on sales header option through code unit 7000 in version post 3.7 and I think it was codeunit 55 in older versions.
    Regards,

    Ger
    Simply Dynamics Ltd
    skype: gf.simplydynamics
    Web: www.simplydynamics.ie
  • Jonathan2708
    Jonathan2708 Member Posts: 552
    Many thanks Ger.

    Jonathan
  • jannestig
    jannestig Member Posts: 1,000
    Why do you need to bother with Code modification at all.

    there is already two very good ways of acheiving what you want already

    You can either base your prices discounts around the customers or around the Items Using customer price groups or items discount groups,

    both provide you the Item/Customer/Variant code selection criteria already.

    The customer discount group would probably be your preference if you want the header qualifications to determine the price.