Ditutup

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.

Kemahiran: Oracle, SQL, Pentadbiran Pangkalan Data, Pengaturcaraan Pangkalan Data, Perakaunan

Tentang Klien:
( 1 ulasan ) Cape Town, South Africa

ID Projek: #33727781

22 pekerja bebas membida secara purata $171 untuk pekerjaan ini

(26 Ulasan)
5.4
(44 Ulasan)
5.3
(9 Ulasan)
4.7
(2 Ulasan)
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 Lagi

$250 USD dalam 3 hari
(4 Ulasan)
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 Lagi

$120 USD dalam 4 hari
(4 Ulasan)
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 Lagi

$140 USD dalam 7 hari
(3 Ulasan)
2.6
(1 Ulasan)
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 Lagi

$400 USD dalam 7 hari
(1 Ulasan)
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 Lagi

$140 USD dalam 7 hari
(2 Ulasan)
0.6
(0 Ulasan)
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 Lagi

$100 USD dalam 3 hari
(0 Ulasan)
0.0
Rajanjha13

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

$140 USD dalam 7 hari
(0 Ulasan)
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 dalam 7 hari
(0 Ulasan)
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 Lagi

$140 USD dalam 2 hari
(0 Ulasan)
0.0
(0 Ulasan)
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 Lagi

$140 USD dalam 2 hari
(0 Ulasan)
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 Lagi

$140 USD dalam 7 hari
(0 Ulasan)
0.0
tahirsiddiqui190

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

$220 USD dalam 7 hari
(0 Ulasan)
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 Lagi

$170 USD dalam 2 hari
(1 Ulasan)
0.0