report help again :) Rental Advantage with Navision

rj5570

ok, my company uses a granular from RMI called Rental Advantage.

I need to add shiping information from the shipment ledger entry table to the invoice.

as of now, it just shows the product that was shipped, but i need to pull the asset number that was shiped in the rental on the invoice.

can anyone help?

rj

rj5570

why wouldnt this work?

this is in the get on record of the Rental Line Entry Ledger

IF Type = 5 THEN BEGIN
IF "Line No." = ShipLine."Rental Line No." THEN FleetNo := ShipLine."No."
END;

Type 5 is product

so in the IF THEN i am saying if the line numbers equal in the two then asign the Number to my variable.

i am yeilding no data

rj5570

ok i changed it to this but still no data


IF Type = 5 THEN BEGIN
IF "Document No." <> ShipLine."Document No." THEN BEGIN
IF "Line No." = ShipLine."Rental Line No." THEN FleetNo := ShipLine."No."
END;
END;

figured i need to make sure the document numbers were the same.

it looks logical to me, but i am not the strongest programer (still beginer, i am an accountant)

](*,)

nunomaia

It’s difficult to find out where is your current problem. Only but looking at ledger entry structure and by checking all report code.

rj5570

well is my logic correct? could it be where i am placing it in the code?

i could post the whole code if that would help, or send report

Savatage

is "type" an option? then you should be doing something like

CASE TYPE OF
TYPE::5 :
//Some Code
END;

also I assume the data you need is originally on the Sale Line & When it gets posted it appears in the Sales Shippment info but not on the sales invoice info??

What table # is the Sales Shipment ledger entry table? do you mean the Sales shipment table?

-- Also , guessing, How are you getting the data? Yiour code shows no pulling of info from from one place to another.

rj5570

yes type is an option.

when shipping it doesnt place the asset on the invoice line. its kept in a seperate table,

this is an addon granular from RMI called rental advantage....

your right about telling it go pull...i am not sure exactly how to do this in code......its not the most logical thing to me.....i am use to more of SQL world and crystal reports type thing......

it seem to me, if i set a record variable and use the code i put above it should work logically to me

its table 37000017 shipping journal line

nunomaia

Just guessing, shouldn’t you have inserted a SETRANGE and a FIND(‘-’) or something to find record? Or those records are coming from report lines?