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.

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

YUN ZHU 95,597 Super User 2025 Season 2 on at

Like (0)

Report

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

Hope other experts can give you better advice.

Thanks.

ZHU

Was this reply helpful? Yes No
Toni Sala 10 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,111 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Toni Sala 10 on at

Like (0)

Report

Thank you Inge,

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

Thanks a lot,

TONI SALA.

Was this reply helpful? Yes No