Question on dataport validation

Hi

If you bring the price into a variable and then assign the variable to the unit price after the validation of the item it should work, so as an example:


VALIDATE (Type, Type::Item);
VALIDATE ("No.",ItemVarable);
VALIDATE (Quantity, QtyVariable);
"Sales Line"."Unit Price":=PriceVariable;
VALIDATE ("Sales Line"."Unit Price");
"Sales Line"."Unit Cost (LCY)":=CostVariable;
VALIDATE ("Sales Line"."Unit Cost (LCY)");

I believe this worked for me.

Validate the "No." first then put in your price.

Note you can either use the CallFieldCalidate Boolean in the Field Designer of the Dataport insteasd of putting it on the trigger.

Or better yet - Import all your data into Variables then you can map them to it's proper matching NAV field in the order that you want.

This way you have total control of what gets imported & when and you have more control of the validation process.

ex./
Lets say I have 3 variables i created in View->Golbals
v_Imported_No
v_Imported_Qty
v_Imported_Price

I enter these fields in the View->Dataport Fields instead of using the lookup directly to the Navision Standard Fields. Once the import begind the info is now saved in these variables. now on the OnAfterImportRecord I can bring them in the order that I want.

"Sales Line"."No." := v_Imported_No;
"Sales Line".VALIDATE("No."); //Get this out of the way!!!!!!

"Sales Line".Quantity := v_Imported_Qty;
"Sales Line".VALIDATE(Quantity); //Have control of validation

"Sales Line"."Unit Price" := v_Imported_Price; //put in the price at end to avoid changing

this is the proper way
VALIDATE ("No.",ItemVarable);
but i wanted to lay it out in an easy to understand manner