Post Item journal lines automatically with codeunit?

(0) Share

Report

Posted on by srueda

Hi,

I am using power automate to create item journal lines from other data source, I can to create an API and use it in the flow to create the lines in the journal, and it works:

8741.p1.png

the next step is to post the line in the item ledger entries, is known for me that I need to use a codeunit and deploy as web service for this (documentation HERE).

But I'm not get very well the steps to create the codeunit, I don't know how to start, maybe someone have a usefull example or a better documentation?

Any help is appreciated, I've been stuck with this for several days.

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

JAngle 133 on at

Like (1)

Report

For a different scenario I created a codeunit to post a recurring journal. This blog explains how: joshanglesea.wordpress.com/.../

Adapt it to your scenario.

Was this reply helpful? Yes No
srueda 51 on at

Like (0)

Report
Thank you, I have created the codeunit and now I can post the Item Journal Line.

But, the item journal line is still in the journal, how can I delete it? That's a problem for me because I need to run the flow a lot of times.

The code of my codeunit is the following:

codeunit 50100 "PostAction" { procedure postJrnl() var ItemJrnl: Record "Item Journal Line"; begin ItemJrnl.SetFilter("Journal Template Name", 'ITEM'); ItemJrnl.SetRange("Journal Batch Name", 'DEFAULT'); if ItemJrnl.FindSet() then begin Codeunit.Run(Codeunit::"Item Jnl.-Post Line", ItemJrnl) end; end; }

Have I to modified something in the code?

Sorry if there are some problem with the code, Im not developer.

Thank you!

Was this reply helpful? Yes No
Suggested answer

Bilal Haider 414 on at

Like (1)

Report

Hi,

Using this code you will not be able to post multiple lines. It will work only for 1 line.

Replace the line codeunit.Run(Codeunit::"Item Jnl.-Post Line", ItemJrnl) with codeunit.Run(Codeunit::"Item Jnl.-Post Batch",ItemJrnl)

Using this codeunit multiple lines can be posted and lines will be deleted automatically as they are posted.

Was this reply helpful? Yes No
srueda 51 on at

Like (0)

Report

Yes!! Thank you a lot of!! :DD

Was this reply helpful? Yes No