Calculations in Dataports

Cannikin

Hey peoples,

I'm trying to export our Available Quantity via a Dataport into a comma-delimited text file. We define Available Quantity as:

availQuantity := Inventory - "Qty. on Sales Order" - "Qty. on Component Lines";

But the availQuantity variable always comes out as 0 (zero). I added a CALCFIELDS but that didn't fix anything. I tried just setting availQuantity := Inventory but that was 0 as well.

Then I tried just outputing Inventory and then it displays the correct value! Unfortunately that's not the one I want.

My variable is declared in C/AL Globals, I'm not getting any errors ... I must be missing one small thing. Anyone have any ideas?

OliverT

which trigger do you use to calculate the value of your available quantity?

sgg

Put the CALCFIELDS and calculations in the following trigger
OnBeforeExportRecord()

Cannikin

That was it! I had my CALCFIELDS in the OnPreDataItem()

Thanks guys!!

sgg

Also Make sure that you run the Dataport from The Object Designer.

Not when Designing the Dataport itself.

So, you must save the dataport and exit to the Object Designer.
Then you can run the Dataport

OliverT

ehm ... i never ever had any problems by starting the dataport in the dataport designer :?

SeanLin

You can test below codes written in OnBeforeExportRecord() Trigger:

IF Item.GET(Which Item No.) THEN
BEGIN
Item.CALCFIELDS(Inventory - "Qty. on Sales Order" - "Qty. on Component Lines");
CLEAR(AvailQuantity);
AvailQuantity := Inventory - "Qty. on Sales Order" - "Qty. on Component Lines";
END;

SeanLin

You can test below codes written in OnBeforeExportRecord() Trigger:

IF Item.GET(Which Item No.) THEN
BEGIN
Item.CALCFIELDS(Inventory - "Qty. on Sales Order" - "Qty. on Component Lines");
CLEAR(AvailQuantity);
AvailQuantity := Inventory - "Qty. on Sales Order" - "Qty. on Component Lines";
END;

SeanLin

You can test below codes written in OnBeforeExportRecord() Trigger:

IF Item.GET(Which Item No.) THEN
BEGIN
Item.CALCFIELDS(Inventory - "Qty. on Sales Order" - "Qty. on Component Lines");
CLEAR(AvailQuantity);
AvailQuantity := Item.Inventory - Item."Qty. on Sales Order" - Item."Qty. on Component Lines";
END;

SeanLin

You can test below codes written in OnBeforeExportRecord() Trigger:

Item.RESET;
IF Item.GET(Which Item No.) THEN
BEGIN
Item.CALCFIELDS(Inventory - "Qty. on Sales Order" - "Qty. on Component Lines");
CLEAR(AvailQuantity);
AvailQuantity := Item.Inventory - Item."Qty. on Sales Order" - Item."Qty. on Component Lines";
END;

SteveO

tafferKakao:

If you run an import dataport from the dataport designer then
the modifications to the database will not be committed.
Exporting is fine.