Finance | Project Operations, Human Resources, ...

How to create Voucher number while inserting into inventJournalTrans

(2) Share

Report

Posted on by charanch

Hi All,

I am inserting records into "inventJournalTrans" in batch job, but i am stuck at how to create voucher number while inserting records into inventJournalTrans table.

Any help or suggestion. The is my code.

InventJournalTrans inventJournalTrans;
EntAssetParameters parameters = EntAssetParameters::find();
JournalTableData journalTableData;
JournalTransData journalTransData;

inventJournalTrans.clear();
inventJournalTrans.initValue();
inventJournalTrans.initFromInventJournalTable(EntAssetWorkOrderTableJournals::findOrCreateInventJournalTable(_workOrderTable.RecId));
inventJournalTrans.TransDate = DateTimeUtil::getSystemDate(DateTimeUtil::getUserPreferredTimeZone());

inventJournalTrans.EntAssetWorkOrderLine = _workOrderLine.RecId;
inventJournalTrans.ProjCategoryId = parameters.ItemCategory;

// inventJournalTrans.Voucher =

inventJournalTrans.JournalId = _inventJournalTable.JournalId;

inventJournalTrans.ItemId = _stagingLine.ItemId;
inventJournalTrans.Qty = _stagingLine.Qty;
inventJournalTrans.insert();

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (3)

Answers (0)

Diego Mancassola 603 on at

Like (0)

Report
Copy link

Link copied!

Hello, what's your business requirement to do that?

Tipically you don't have to set the voucher, the system set it for you based on journal name settings.

Was this reply helpful? Yes No
Suggested answer

Manikanda_Gopal 81 on at

Like (1)

Report
Copy link

Link copied!

Hi Chranch,

As Diego mentioned, the voucher number will be generated based on your respective inventory journal name. Please initialize your inventory journal name table (InventJournalName), then apply similar logic to populate the voucher number in the InventJournalTrans table.

NumberSeq numberSeq = NumberSeq::newGetVoucherFromId(inventJournalName.VoucherNumberSequenceTable); // Pls note this method has optional parameters, verify carefully based on your scenario and number sequence setup

inventJournalTrans.voucher = numberSeq.voucher();

Please test this on your dev machine and mark it as the suggested answer if it works.

Was this reply helpful? Yes No
charanch 80 on at

Like (0)

Report
Copy link

Link copied!

Hi @Diego Mancassola and @Manikanda Gopal thanks for replying to my query.

we are doing some integration, external party will send work order and work order journal related data, we are creating this work order journal in batch, so the entire journal creation and posting done in batch, while posting for every record need to generate voucher right. I'm new to integration , in fact this is my first working for integration.

Was this reply helpful? Yes No

Join the conversation

Community site session details

How to create Voucher number while inserting into inventJournalTrans

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2025 Community Spotlights

Congratulations to the January Top 10 Community Leaders

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

How to create Voucher number while inserting into inventJournalTrans

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2025 Community Spotlights

Congratulations to the January Top 10 Community Leaders

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates