65
I created a dataport in Navision to import Engineering BOM lines from a text file. I wasn't able to successfully import the lines into Navision, and i wasn't getting any error messages at all. i pretty new to designing dataport. I would gladly appreciate your help.
Thanks
*This post is locked for comments
unfortunately you cannot sort based on the Variable value it should be a field, then you can create a key and sort the dataitem based on that field.
Are you using the classic version or RTC version ?
Great, it works as well. Thanks for the help Suresh, i am not a developer, but i have been thrown into this role. I do have another issue i need help with.
The report in 2009 is called Order Pick Ticket report, and and the dataitem used is the sales line, there is a code in the back end that pull the information from the item specifically the shelf no, but for the life of me not sure how to use this information to create a sorting in the report.
IF Item.GET("Sales Line"."No.") THEN BEGIN
ShelfNo := Item."Shelf No.";
You don't need to use Item.INIT statement and the IF condition to check for type::Item since you already have Item.GET statement. After Line No. Insert you just need this code
IF Item.GET("No.") THEN
"Description" := Item.Description;
IF NOT INSERT THEN
MODIFY;
In OnAfterImportRecord Trigger just add this code
IF Item.GET("No.") THEN
"Description" := Item.Description;
IF NOT INSERT THEN
MODIFY;
In your dataport fields you only have No. and Quantity, how are you getting the BOM Number, if you include all the fields in the file & in the dataport fields then you don't need to add any code, the dataport will import it. Include your BOM Number, Line Number and for Description you can add the code to retrieve it. Check the standard dataport like 5901.
#1
André Arnaud de Cal...
291,391
Super User 2024 Season 2
#2
Martin Dráb
230,445
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
