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

Config Packages and Lookups

(0) Share

Report

Posted on by CindyFromIndy

I'm having a mental block when it comes to config packages and lookups.

I have a package with both table 18 (Customer) and 222 (Ship-to-Addresses). If I populate both with both the customer number and address code, both throw the error that the record can't find the matched record in the other table.

I received the recommendation to drop the address code out of the customer table, import the two tables, and then do another pass taking in just the customer number and address code in the customer table. I think I must have misunderstood, because I am back to having an error for every record in both tables. I'm wondering if I validated too much, or used the validate in the wrong place (header instead of line).

Can anyone offer a reference or help me understand the sequence?

Categories:

Business Central

All responses (2)

Answers (0)

CindyFromIndy 32 on at

Like (0)

Report
Config Packages and Lookups

Hi ZHU!

Thanks so much for taking the time to show me step-by-step! Please pardon me for responding with 3 questions.

It looks like you did not have a ship-to address code in the Customer table. Did you cycle back around and do a second import for just the customer number and address code?

Also curious if you ran any validations?

And lastly, could you explain the purpose of Parent Table ID?

Looking forward to your kind replies. Thanks so much!
Suggested answer

YUN ZHU 73,339 Super User 2024 Season 2 on at

Like (0)

Report

Config Packages and Lookups

Hi, suggest trying to fill in the Parent Table ID, I just tested it and there doesn't seem to be any problem.

For example,

Hope this helps.

Thanks.

ZHU