Sales price updation

mkpjsr

hi experts

I want to update the sales price as per the customer price group wise and item category code wise.remember the each item having a item group and its corresponding customer price group. plz guide me how i can maintain new sales price .tel me the method and what are the various tables where i have to maintain this price. also i have to keep track of the older price. plz guide me how can i do this?

golfer

Use the Sales Price Worksheet.

mkpjsr

plz give me the guide line how this sales price worksheet works..plz provide the steps

mohana_cse06

It will give you some idea..
http://msdn.microsoft.com/en-us/library/hh176862(v=nav.70).aspx

mkpjsr

hi experts

i want to fetch the pit structure field of sales table into the sales price worksheet . how i will do this ?

mohana_cse06

You need to write code in report 7052 - Suggest Sales Price on Wksh. just like the other fields

mkpjsr

hi experts

I have written code for the pit structure . It is returning 2 lines into the sales price worksheet after pressing ok button.

mkpjsr

hi experts

I have written code for the pit structure . It is returning 2 lines into the sales price worksheet after pressing ok button.

mohana_cse06

You must have 2 lines in Sales price table for the filters you have given while running the report.

mkpjsr

hi experts

in suggest sales price i want copy items on item product group code wise for updating the sales price. is it possible to do this. and how can i filter item product group code wise.

mohana_cse06

try running report - 7051 - Suggest Item Price on Wksh.

in Item tab select - Product Group Code field and add your filter

mkpjsr

hi experts

suggest item worksheet is filtering item product group code wise but . i have to take unit price from sales price table . then how to do this

mohana_cse06

You cant mix up the two,..
if you want, you need to add product group in sales price table and use for filtering..

mkpjsr

hi experts

if i want to change unit price from 72 to 74 in suggest sales price in worksheet then what to do..

mohana_cse06

First use the function "Suggest &Sales Price on Wksh." to get the existing sales price for the Item

then change the value in New Unit Price to 74

then press I&mplement Price Change

mkpjsr

hi experts

In sales price worksheet's suggest sales price on worksheet while creating new prices i want to also update the previous ending date of a particular item belonging to customer price group wise .how can i do this insert and update of this previous unreal ending date at a time.
Plz guide me and mention the coding

mkpjsr

hi experts

During the new price creation through suggest sales price on worksheet batch program, i want to also update the last ending date before inserting the new prices. plz suggest how can i do this. plz mention the code

mkpjsr

hi experts

Before changing prices I need to first change this unreal ending date with the real ending date (with the help of "Suggest Sales Price on Wksh." but if i don't know the staring date and i want to update ending date . how can i do this without providing the startdate.plz guide me.

mkpjsr

hi experts

Before changing prices I need to first change this unreal ending date with the real ending date (with the help of "Suggest Sales Price on Wksh." but if i don't know the staring date and i want to update ending date . how can i do this without providing the startdate.plz guide me.