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

Add a custom table in sales line sub form and post when post sales order in business central AL

(1) Share

Report

Posted on by Community member

Hi experts,
i want to add a custom table that link with sales line table and add a button in sales line sub form that will show my custom table in this page i added some field that store value against item no that present in sales line with current record and it is also post when we post sales order. and custom table data will in sales shipment. just like item tracking lines specification but it will only work on sales order page..
How i can do this?

Categories:

Dynamics 365 Business Central

All responses (2)

Answers (0)

Community member on at

Like (0)

Report

Add a custom table in sales line sub form and post when post sales order in business central AL

Thanks a Lot YUN ZHU i want to discuss my scenario with you what i want

simple i create a custom page and page button in sales line sub page when we click button then page will be open as i share screenshot with you.

but major problem is that when page is open how we can store value against each sales line record i.e. which sales line record selected and store value against them

and then post my custom page into sales shipment line. for example work as item tracking lines where we add serial number and lot no etc.

simply i just want to add serial number in the time of sale order manually.

can you provide any guidance for this
Suggested answer

YUN ZHU 75,848 Super User 2024 Season 2 on at

Like (0)

Report

Add a custom table in sales line sub form and post when post sales order in business central AL

Hi, is it not possible to use Dimensions directly to manage your data? This is a standard feature. And it can be automatically transferred to posted documents.

If you want to develop a new table, you can save Document Type, Document No., Line No. These data can also be found in Posted Sales Shipment. I think it would be easier to relate through them.

Sales Order:

Posted Sales Shipment:

Hope this helps.

Thanks.

ZHU