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

Custom Field to add in Line Items

(0) Share

Report

Posted on by Kae

150

how to to add custom field(column) to sales doc lines? We've been wanting to add another column for Shipping Cost, we tried the charge Item, but the shipping amount was equally distributed and we can't change it. So we think having a custom field would solve this.

Categories:

Other

Sales

Business Central

All responses (5)

Answers (0)

Suggested answer

YUN ZHU 62,477 Moderator on at

Like (0)

Report

RE: Custom Field to add in Line Items

Hi, As Kim said, this is not something that can be done simply by adding a column.

But if you want to add columns, you can refer to the following example.

TableExtension: https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-table-ext-object

PageExtension: https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-page-ext-object

Hope this also helps.

Thanks.

ZHU
Suggested answer

MahGah 15,407 on at

Like (0)

Report

RE: Custom Field to add in Line Items

Hi

As Kim mentioned the column will add a lot more complication to the whole process. Kim asked a great question. That can help us to understand your view better.
Dallefeld 11,417 on at

Like (0)

Report

RE: Custom Field to add in Line Items

It's really not going to work to have dollars in a column on the sales lines. You would have to program how these amounts would post, how they affect the total AR, etc.

Item charge distributes to the individual lines but even then it does the dollar distribution upon posting at the value entry level not to the sales lines.

Can I ask what you are trying to accomplish?
Kae 150 on at

Like (0)

Report

RE: Custom Field to add in Line Items

Hello MahGah,

So instead of creating another line, is there any other option to do this by means of the column?
Suggested answer

MahGah 15,407 on at

Like (0)

Report

RE: Custom Field to add in Line Items

Hi

Just as a suggestion. Can you use G/L in SO and add the shipping charge? Like create one line as G/L in SO, select needed G/L (such as outbound shipping) , QTY 1, then enter the shipping charge? When you ship that line it will add to invoice and selected G/L but will not distribute charge between items.

If you have a warehouse I suggest you see Alfonso suggestion here

community.dynamics.com/.../freight-charge-on-sales-order