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

Having issues moving data from Items

(7) Share

Report

Posted on by CU11120629-0

332

I added a field of Inventory Posting Group in these 6 pages

Sales Lines
Posted Sales Invoice Lines
Posted Sales Credit Memo Lines
Purchase Lines
Posted Purchase Invoice Lines
Posted Purchase Cr. Memo Lines

now the data is moving fine from Items table to these tables but as I have called the procedure in the trigger OnAfterGetRecord of the page extension of these pages so when i check for Inventory Posting Group = '' in these pages its showing not all but many records then out of those records when i filter a document no its showing blank and when I clear the filter for Inventory Posting Group = '' its showing the same records with filled Inventory Posting Group that were showing empty before, so how to resolve this issue

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Pallavi Phade 5,420 Super User 2026 Season 1 on at

Like (3)

Report
Copy link

Link copied!

Namaste @CU11120629-0

Can you confirm you did the below way. It should work fine

1) Created field "Inventory Posting group". Added Table Relation to field on tables

2) Created script to flow Inventory Posting Group code from Item Master on Trigger - "No." - Onafteralidate() - Table 37, 39

3) Filters on page should work

OR

There is standard field which is present in Table. Can you please verify

Sales Lines

Warm Regards

Pallavi Phade

Pallavi Phade | LinkedIn

Was this reply helpful? Yes No
Suggested answer

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

Like (2)

Report
Copy link

Link copied!

Hi, This is a standard field. Did you add a new one? First, I'd like to know what your purpose is.

Thanks

ZHU

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 22,128 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

This happens because the value is set in OnAfterGetRecord, which is UI-only and not stored in the table. Filtering then shows inconsistent results. Store the value during posting instead of calculating it in the page trigger.

Was this reply helpful? Yes No
Gerardo Rentería Ga... 25,555 Most Valuable Professional on at

Like (3)

Report
Copy link

Link copied!

Hi, good day
I hope this can help you, and give you some hints.

Dynamics 365 Business Central: How to flow/pass custom field values | Dynamics 365 Lab

Best Regards
Gerardo

Was this reply helpful? Yes No
Suggested answer

Kamal Khakhkhar 2,915 on at

Like (3)

Report
Copy link

Link copied!

Hii There as per @YUN ZHU Blog shared By @Gerardo Rentería García you can go through your requirement .
If Possible Go With base fields if you don't want more complex solution .only use if Base feature is not as much optimize as per your requirement.

If You got your answer mark it answered.

Thank You,

Kamal Khakhkhar

Was this reply helpful? Yes No
CU11120629-0 332 on at

Like (1)

Report
Copy link

Link copied!

I found the field for Inventory posting group but the same is happening for Salesperson code when I did this below code

The same issue is happening as below

First see the salesperson code is empty for some lines then i opened these lines then when i click back and opened the same page again

The record is now updated itself so please guide how to solve this issue as its reflecting issue in a report where the report is group by Salesperson code

Was this reply helpful? Yes No