%doesn't calculate unless I refresh the line in the UI
I'm not sure I understand what that means. Is there a particular field on the line you are validating after the import?
I will confess - I have never tried to do such a large import using rapid. I've always used custom code, but that's probably because I'm a developer (when your only tool is a hammer, all problems become nails).
Jokes aside - I think the problem is going to be that you have no control over the order in which the table fields get validated. If you think about entering a sales line by hand, there is a certain order those fields are lined up in the subpage. Type, then No., than quantity, etc. The validation logic for those three fields prefers that order of entry. Said another way, if No. is entered first before Type, the logic doesn't know whether that is an item or a resource. With custom code, you can control the exact order of field validation. But in Rapid, that is done in the order the fields are defined in the table, not the order you might need.
However - I think you may be able to control this. If you drill into the fields to include for the import, there is a Processing Order column that you can adjust using the Move Up and Move Down Actions. This snap is from BC15, but those fields have existing for a long time.
------------------------------
Kyle Hardin
NAV Developer
ArcherPoint Inc.
Duluth GA
------------------------------
Original Message:
Sent: Dec 30, 2019 09:06 PM
From: Mark Anderson
Subject: RapidStart and tirggering validation
Hi All
We have a significant add-in, one of whose features is to calculate how many racks an order takes. Imported 20,000 sales lines. All worked great, except this doesn't calculate unless I refresh the line in the UI. I'm guessing there's no way to make this happen. Do I have to write an extension to go through all lines and trigger an event?
Thanks
Mark
------------------------------
Mark Anderson
Director of ERP Systems
Clesen Wholesale
Evanston, IL
------------------------------