Item Charge Assignment Import

(4) Share

Report

Posted on by ME-31032107-0

765

I am importing about 600 Purchase Orders with about 1500 line items from GP. These are POs that have been received in GP with Landed Costs.

While I am able to import the Purchase Header and Purchase Line records, I am unable to successfully import the related Item Charge Assignments for the Landed Costs. The data looks correct before import, but the Config Package throws errors and appears to ignore the assignment and allocation of the Charge (Item) Purchase Lines.

When I review the records in the Config Package, they all look correct. There are no errors detected. But after I apply the package, I get this error:

Applies-to Doc. Line No. must have a value in Item Charge Assignment (Purch): Document Type=Order, Document No.=PO009978, Document Line No.=20000, Line No.=10000. It cannot be zero or empty.

The Applies-to Doc. Line No. field has the correct value in the Excel file (and also is there when I review the imported Config Package records, but somehow disappears when applying.

What am I missing with importing these Item Charge Assignments? Is it possible to import them, or do I have to manually assign 600 POs?

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (10)

Answers (1)

Suggested answer

RockwithNav 8,947 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Still somehow the relationship is not getting successfully created. Did you try with the Processing Order within Configuration package?

I wont be doing this way, If I have to take this up then I will be happy to write a process only report after importing the raw data in a buffer table.

Was this reply helpful? Yes No
Suggested answer

Valentin Castravet 32,157 Super User 2026 Season 1 on at

Like (3)

Report
Copy link

Link copied!

It’s definitely possible to import them. Try manually creating one PO with an item charge in BC, then export it in a configuration package. You'll need to include table 337 in the configuration package for the item charge assignment. That will show you exactly which fields BC needs populated for your import.

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

Was this reply helpful? Yes No
ME-31032107-0 765 on at

Like (2)

Report
Copy link

Link copied!

Valentin Castravet,

I have exported the Purchase Header (38), Purchase Line (39) and Item Charge Assignment Purch (5805) tables in a Config Package to Excel. I have reviewed two POs (PO009899 & PO009976) where I manually did the IC Assignment, and one where I attempted to import (PO009978). Not sure why you mention Sales Line (37) in this scenario.

The imported records are missing the Item Charge No, Item No. & Description columns, along with the Unit Cost & Amount to Assign values (even though they were present in the import).

Even when I repopulate the missing data and do another import, it still does not import the data correctly. I am attaching the Excel export in case you are able to see something I am not.

Thanks.

Purch_Rcpt_Header...

Was this reply helpful? Yes No
ME-31032107-0 765 on at

Like (2)

Report
Copy link

Link copied!

RockwithNav,

Not sure what you are suggesting, is there another way to handle the imports? Or do you have some other method to debug the process?

Was this reply helpful? Yes No
Suggested answer

Valentin Castravet 32,157 Super User 2026 Season 1 on at

Like (3)

Report
Copy link

Link copied!

Sorry, I meant 337, not 37, the 3 must not have registered when I typed it. Try table 337, not 5805, and it will work.

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

Was this reply helpful? Yes No
ME-31032107-0 765 on at

Like (2)

Report
Copy link

Link copied!

Valentin Castravet,

Table 337 is the Reservation Entry table, which is really not part of what I am trying to import (I am trying to import the Item Charge Assignments for Purchase Orders)....

Was this reply helpful? Yes No
Verified answer

Valentin Castravet 32,157 Super User 2026 Season 1 on at

Like (3)

Report
Copy link

Link copied!

Oh wow, Monday mornings, I was thinking of item tracking instead of item charges. For item charges, yes, you’re using the correct table: 5805.

Remove all validation in the configuration package for this table. In the package, select the table, go to Table -> Fields, and clear the validation checkmark on every field. That’s the only way I’ve been able to upload data into this table using a configuration package.

You’ll need to make sure the data is clean and validated manually in Excel before importing. You can also run Preview Posting afterward to confirm everything looks correct. This should fix the issue.

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

Was this reply helpful? Yes No
ME-31032107-0 765 on at

Like (3)

Report
Copy link

Link copied!

Valentin Castravet,

Removing the Validate Field checkboxes did the trick, HUGE thanks for this idea. Saved me a ton of time and frustration.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 99,055 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi, just add some information, hope this helps as well.

Dynamics 365 Business Central: Can we skip/ignore field validation errors?

https://yzhums.com/44435/

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

RockwithNav 8,947 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

ME-31032107-0

Keep in mind, removing the field validation may make the process easier because it skips the table triggers, but it’s not always a recommended approach unless you are absolutely sure of the impact. In your case, disabling the field validation for a column like Qty. to Assign will skip the table trigger that actually populates the Qty. to Handle column.

Was this reply helpful? Yes No