How to link Sales Invoice Header and Sales Shipment Header

nav_student

Hi guys i create a Report with this format

Data Items

---

Customer
Sales Invoice Header

On the section of Sales Invoice Header i want to connect informattion of the Sales Shipment Header.

Can you help me?

Thanks in advance.

Alex_Chow

If you do a search on this forum, there has been some good discussion on how to do this.

Savatage

for a student there doesn't seem to be alot of studying? 8)

Go to help - C/Side Ref Guide - Search "GET"

nav_student

I use the Sales Invoice Line to see the relations

Sales Invoice Header                Value Entry                               Item Ledger Entry                    SalesShipment Header 
No.<------------------->Doc No.  ItemLedger Entry No.<------> Entry No.          Document No.<------------>No.

So i Ident the tables according to this relationship

Sales Invoice Header
   Value Entry
       Item Ledger Entry
           Sales Shipment Header

Do you think that is the best way?

ara3n

I wouldn't do as dataItem in report but in Code.

David_Singleton

nav_student wrote:

Do you think that is the best way?

Shouldn't you ask the client exactly what they want? if they show you exactly how they want to see the data, it will be simple to then program.

nav_student

Ara3n how do you do on code?

By doing several GET´s?

ara3n

well get is used if you know the PK.

In your case to get the value entry

valueentry.setrange("Document No.","Sales Invoice Header"."No.");
valueentry.setrange("Posting Date","Sales Invoice Header"."Posting date");
if valueentry.findfirst then begin
  ItemLedgerEntry.get(valueentry."Item Ledger Entry No.");
  SalesShipmentHeader.get(ItemLedgerEntry."Document No.");
end;

nav_student

ara3n, thank you for this example!



Best Regards!