Đã Đóng

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.

Kĩ năng: Oracle, SQL, Quản trị cơ sở dữ liệu, Lập trình cơ sở dữ liệu, Kế toán

Về khách hàng:
( 1 Nhận xét ) Cape Town, South Africa

ID dự án: #33727781

22 freelancer chào giá trung bình$171 cho công việc này

(26 Nhận xét)
5.4
(44 Nhận xét)
5.3
(9 Nhận xét)
4.7
(2 Nhận xét)
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 Thêm

$250 USD trong 3 ngày
(4 Nhận xét)
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 Thêm

$120 USD trong 4 ngày
(4 Nhận xét)
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 Thêm

$140 USD trong 7 ngày
(3 Nhận xét)
2.6
(1 Nhận xét)
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 Thêm

$400 USD trong 7 ngày
(1 Nhận xét)
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 Thêm

$140 USD trong 7 ngày
(2 Nhận xét)
0.6
(0 Nhận xét)
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 Thêm

$100 USD trong 3 ngày
(0 Nhận xét)
0.0
Rajanjha13

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

$140 USD trong 7 ngày
(0 Nhận xét)
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 trong 7 ngày
(0 Nhận xét)
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 Thêm

$140 USD trong 2 ngày
(0 Nhận xét)
0.0
(0 Nhận xét)
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 Thêm

$140 USD trong 2 ngày
(0 Nhận xét)
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 Thêm

$140 USD trong 7 ngày
(0 Nhận xét)
0.0
tahirsiddiqui190

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

$220 USD trong 7 ngày
(0 Nhận xét)
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 Thêm

$170 USD trong 2 ngày
(1 Nhận xét)
0.0