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

Invoice no field should updated when sales invoice posted

(0) Share

Report

Posted on by Eva2020

Hello Experts,

I am developing a program, when a sales invoice is posted then the sales shipment line posted in ILE should get updated with invoice no.

Invoice no. will be a new field in the item ledger entry. I have written program on SalesPost codeunit onafterpost trigger but its not working.

Any suggestions/help would be appriciated.

Thanks,

Eva

I have the same question (0)

All responses (9)

Answers (0)

Suggested answer

Inge M. Bruvik 1,111 Moderator on at

Like (1)

Report

I think there is a breach in your logic here. Because one invoice is not necessarily the same as one ILE.

The invoice basically results in a Item Value entry. So to see what invoice are behind a ILE you should look at the value entries, And you can already navigate to them though the ILE page.

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,708 Moderator on at

Like (0)

Report

Hi,

you can use the below Event from the CU - 80, check with the Item no. you are actually posting through Posted Sales shipment.

[IntegrationEvent(TRUE, false)]

local procedure OnAfterPostItemJnlLine(var ItemJournalLine: Record "Item Journal Line"; SalesLine: Record "Sales Line"; SalesHeader: Record "Sales Header"; var ItemJnlPostLine: Codeunit "Item Jnl.-Post Line"; var WhseJnlPostLine: Codeunit "Whse. Jnl.-Register Line"; OriginalItemJnlLine: Record "Item Journal Line")

begin

end;

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,720 Super User 2025 Season 2 on at

Like (0)

Report

Hi, Inge is right.

There is a situation in the system that one line of Item ledger entries corresponds to multiple invoices.

For example,

If you only want to display one invoice No., you can just create a FlowField by associating it with the Item Ledger entry No field.

Hope this helps as well.

Thanks.

ZHU

Was this reply helpful? Yes No
Eva2020 10 on at

Like (0)

Report

Hello Zhu,

In our case, one shipment will have only one invoice.

Regards,

Eva

Was this reply helpful? Yes No
Eva2020 10 on at

Like (0)

Report

Hi Zhu,

as we have one shipment for one invoice, can you please let me know how we can associate this with ILE entry no. Entry no is an Integer field and invoice no( new field) will be a code field

Was this reply helpful? Yes No
Eva2020 10 on at

Like (0)

Report

Hello Inge,

We only use one shipment for one invoice.

Was this reply helpful? Yes No
Suggested answer

Amit Baru 3,037 on at

Like (0)

Report

Hi,

Pls refer the below code for Reference. In my case i have flow fields in case of purchase.

[EventSubscriber(ObjectType::Table, Database::"Item Journal Line", 'OnAfterCopyItemJnlLineFromPurchLine', '', False, False)]

local procedure OnAfterCopyItemJnlLineFromPurchLine(var ItemJnlLine: Record "Item Journal Line";

PurchLine: Record "Purchase Line")

var

begin

ItemJnlLine."M.R.P." := PurchLine."M.R.P.";

ItemJnlLine."Pack Size" := PurchLine."Pack Size";

end;

[EventSubscriber(ObjectType::Codeunit, Codeunit::"Item Jnl.-Post Line", 'OnAfterInitItemLedgEntry', '', False, False)]

local procedure OnAfterInitItemLedgerEntry(var NewItemLedgEntry: Record "Item Ledger Entry";

ItemJournalLine: Record "Item Journal Line")

var

begin

NewItemLedgEntry."M.R.P." := ItemJournalLine."M.R.P.";

NewItemLedgEntry."Pack Size" := ItemJournalLine."Pack Size";

end;

Regards

Amit Sharma

www.erpconsultors.com

Was this reply helpful? Yes No
Eva2020 10 on at

Like (0)

Report

and in the case of BC On-Prem (CAL), do we just need to add this one line code only to InitItemLedgerEntry function?

Do i also need to add the new field in ILE and Item Jnl line both?

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,111 Moderator on at

Like (0)

Report

[quote user="Eva2020"]
Hello Inge,

We only use one shipment for one invoice.
[/quote]
Yes, i understand that. But if i was you i would try to avoid designing a solution that is based on an assumption that your business never will change so you will have several shipments per. invoice or several invoices per. shipment.

You have all the required information available in the value entries. And when you are at the item ledger entries is just one click away.

Was this reply helpful? Yes No