Закрыт

SAP Business 1 query with link to pricelist hirtory tables

We need a report which will indicate differences between the selling prices of products on sales orders at the time sales orders have been added to SAP (therefore approved and added by the creator of the sales orders) vs the selling prices of those products at that point in time on the price lists related to the customer being sold to.

This will therefore require referencing the history tables of the pricelists and comparing to the price list and prices related to the customer at the point in time of adding the sales orders.

The query should therefore compare the final selling prices of the products on the sales orders (closed sales orders) and compare it to the selling prices of those products which was applicable at the point in time the sales order was originally added to SAP.

Навыки: Oracle, SQL, Управление базами данных, Программирование баз данных, Бухгалтерия

О клиенте:
( 1 отзыв ) Cape Town, South Africa

ID проекта: #33727781

22 фрилансеров(-а) готовы выполнить эту работу в среднем за $171

(26 отзывов(-а))
5.4
(44 отзывов(-а))
5.3
(9 отзывов(-а))
4.7
(2 отзывов(-а))
3.8
techplusintl

Hi there, ★★★ Database Design & Development Expert ★★★ 7+ Years of Experience ★★★ I've read requirements and ready to build a report . I have completed multiple projects across various domains like Manufacturing, Inve Больше

$250 USD за 3 дней(-я)
(4 отзывов(-а))
4.2
arpitrai07

Hello, I went through the details of the project you posted. I can do the required work accurately. I presume Sales Order details & prevailing prices of products at point of time can be made available in Excel. Please Больше

$120 USD за 4 дней(-я)
(4 отзывов(-а))
2.0
devendrathakur12

Hello, Greetings! I read your job description completely and I found my skills relevant to your project. Specializing in SAP Business One, SAP ByDesign, S/4HANA, SAP SD/MM and SAP ECC Consulting and Development. SAP Больше

$140 USD за 7 дней(-я)
(3 отзывов(-а))
2.6
(1 отзыв)
1.2
abatsis

Hello, I read your requirements and I can create such a query. I suppose that you have MS SQL Server as the database for SAP. If so then I will be able to do tests and create the query because in the company I work fo Больше

$400 USD за 7 дней(-я)
(1 отзыв)
1.0
somnathbhosle787

Hello I Am Somnath Bhosle COMPUTER AND SYSTEM KNOWLEDGE: –  Sap Module : MM,SD,HANA S/4,C/4-: IRN Creation , GRN Creation, Inward, Outward, PO Creation, STO Creation, MRP and CP Changes, Set Margin Calculation, Sales Больше

$140 USD за 7 дней(-я)
(2 отзывов(-а))
0.6
(0 отзывов(-а))
0.0
wilfrednjorog

Hello! I am confident that I am the perfect candidate for this job, hence I would like to submit my proposal for your consideration. I have rich experience in Database Administration, SQL, Oracle, Database Programming Больше

$100 USD за 3 дней(-я)
(0 отзывов(-а))
0.0
Rajanjha13

I have a good experience in this , also have a good accounting knowledge and technical knowledge.....

$140 USD за 7 дней(-я)
(0 отзывов(-а))
0.0
cmagreddy

Hi, Please contact me i have 13 years experience in accounts and finance field 9449983720. I can handle accounts, finance, costing, Taxation etc.. Regards

$140 USD за 7 дней(-я)
(0 отзывов(-а))
0.0
GrasonM

[login to view URL] - [login to view URL] Ambitious Computer Scientist / IT Specialist that takes responsibility for technically rigorous assignments which require superior per Больше

$140 USD за 2 дней(-я)
(0 отзывов(-а))
0.0
(0 отзывов(-а))
0.0
adnanhaider6

I can assist you and I will do quality work for you in SAP B1 and ERP Projects. I can assist you as a Functional and Technical consultant for SAP B1 or ERP. I have vast experience in SAP Business One and I have imple Больше

$140 USD за 2 дней(-я)
(0 отзывов(-а))
0.0
vadimslavinsk

********I have a good logic and good knowledge about SQL**************** Dear client. As I'm a database expert, I can handle your project perfectly. I have a good logic and good knowlege about Oracle and SQL, so I can Больше

$140 USD за 7 дней(-я)
(0 отзывов(-а))
0.0
tahirsiddiqui190

Hello sir am expert in Crystal report i designing many reports like stock position sales,purchase and finical .

$220 USD за 7 дней(-я)
(0 отзывов(-а))
0.0
TarekMYoussef

Hello, I read the description of your project and I understood what you need to do, where you need report get the data for closed sales orders (which converted to AR invoice) and get the prices of the items each sales Больше

$170 USD за 2 дней(-я)
(1 отзыв)
0.0