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

Having issues moving data from Items

(4) Share

Report

Posted on by CU11120629-0

214

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 (3)

Answers (0)

Suggested answer

Pallavi Phade 4,124 on at

Like (1)

Report

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 95,729 Super User 2025 Season 2 on at

Like (0)

Report

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. 20,603 Super User 2025 Season 2 on at

Like (1)

Report

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