News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Codeunit to copy data ...

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

Answered

Codeunit to copy data from Sales price to custom sales price table

(0) Share

Report

Report

Posted on by Dopnezz

55

Hi all,

Currently I am creating a custom table Temporary Sales Price, its purpose is to autosave and write the data from this custom table Temporary Sales Price into the Sales price table of Business Central.

I have planned to use a CodeUnit for copying of field data from the custom Table to the standard Sales price table.

I have problems finding a better code to the current codeunit, which will make it more efficient in copying the correct fields from table Temporary Sales Price to Sales price.

So far my CodeUnit Code is as below:

codeunit 51000 "Temp Sales Price"

{

TableNo = "Sales Price";

var

CpySalesPrice: Record "Sales Price";

trigger OnRun()

begin

CopyRows()

end;

// trigger OnRun()

// var

// Temp: Record "Temp Sales Price";

// begin

// Temp.Init();

// Temp.Validate("Item No.", 'Placed in Job Queue');

// Temp.Insert(true);

// end;

procedure CopyRows()

var

FromTable: Record "Temp Sales Price";

ToTable: Record "Sales Price";

begin

if FromTable.Find() then

repeat

ToTable."Item No." := FromTable."Item No.";

ToTable."Sales Code" := FromTable."Sales Code";

ToTable."Currency Code" := FromTable."Currency Code";

ToTable."Starting Date" := FromTable."Starting Date";

ToTable."Unit Price" := FromTable."Unit Price";

ToTable."Item No." := FromTable."Item No.";

ToTable."Price Includes VAT" := FromTable."Price Includes VAT";

ToTable."Item No." := FromTable."Item No.";

ToTable."Allow Invoice Disc." := FromTable."Allow Invoice Disc.";

ToTable."VAT Bus. Posting Gr. (Price)" := FromTable."VAT Bus. Posting Gr. (Price)";

ToTable."Sales Type" := FromTable."Sales Type";

ToTable."Minimum Quantity" := FromTable."Minimum Quantity";

ToTable."Ending Date" := FromTable."Ending Date";

ToTable."Coupled to CRM" := FromTable."Coupled to CRM";

ToTable."Unit of Measure Code" := FromTable."Unit of Measure Code";

ToTable."Variant Code" := FromTable."Variant Code";

ToTable."Allow Line Disc." := FromTable."Allow Line Disc.";

until FromTable.Next() = 0;

end;

}

I will provide more information if needed.

All responses Img

All responses (2)

Answers Img

Answers (2)

Verified answer

YUN ZHU 73,171 Super User 2024 Season 2 on at

Like (1)

Report

RE: Codeunit to copy data from Sales price to custom sales price table

Hi, I don't know if your table structure is the same as the original one, you can try the following two methods.

Record.Copy(Record [, Boolean]) Method

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/methods-auto/record/record-copy-method

Record.TransferFields(var Record [, Boolean]) Method:

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/methods-auto/record/record-transferfields-table-boolean-method

Hope this helps.

Thanks.

ZHU
Verified answer

Marco Mels on at

Like (1)

Report

RE: Codeunit to copy data from Sales price to custom sales price table

Hello,

We currently do not have dedicated Dev support via the Dynamics 365 Business Central forums, but I wanted to provide you some additional resources to assist. If you need assistance with debugging or coding I would recommend discussing this on one of our communities.

www.yammer.com/dynamicsnavdev

www.dynamicsuser.net/.../14

I will open this up to the community in case they have something to add.

Thanks.

Helpful resources

News and Announcements

Join us in the Community for an AMA: December 12th Register Today

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,151 Super User 2024 Season 2

#2

Martin Dráb 229,993 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans