Small and medium business | Business Central, N...

Filling a field with RapidStart

(0) Share

Report

Posted on by Toni Sala

Hello,

I have a problem exporting table 27 from Dynamics Nav 2016 to BC. I'd like to change "VAT Bus. Posting Gr. (Price)" from blank to LOCAL to all records. Is there a way to do this without having to export to Excel and change the value inside the Excel worksheet? I've tryied using a configuration worksheet but I don't know how to place a blank field as the origin value. I've tryied BLANK, '', space, * but nothing happens and the field remains blank.

Thanks a lot,

TONI SALA.

All responses (4)

Answers (0)

Toni Sala 10 on at

Like (0)

Report

RE: Filling a field with RapidStart

Thank you Inge,

It's quite strange as you you can do it if the field is no blank.

Thanks a lot,

TONI SALA.
Suggested answer

Inge M. Bruvik 1,025 Moderator on at

Like (0)

Report

RE: Filling a field with RapidStart

No possible unless you use data exchange framework, xmlport or write something in AL or Cside.

If it is a one time export / import i would correct the data in Excel.

If you will do it many times i would involve a developer.
Toni Sala 10 on at

Like (0)

Report

RE: Filling a field with RapidStart

Thank you for your answer ZHU. I'm sorry if I haven't explained the problem very well. Filtering with blank is ok, the problem arises when you want to replace a field that is blank with a value before exporting.

Thanks a lot,

TONI SALA.
Suggested answer

YUN ZHU 83,303 Super User 2025 Season 1 on at

Like (0)

Report

RE: Filling a field with RapidStart

Hi, it's weird, I just tried '', it worked well.

Hope other experts can give you better advice.

Thanks.

ZHU