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

All responses (9)

Answers (0)

Suggested answer

Inge M. Bruvik 1,025 Moderator on at

Like (0)

Report

RE: Invoice no field should updated when sales invoice posted

[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.
Eva2020 10 on at

Like (0)

Report

RE: Invoice no field should updated when sales invoice posted

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?
Suggested answer

Amit Baru 3,029 on at

Like (0)

Report

RE: Invoice no field should updated when sales invoice posted

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
Eva2020 10 on at

Like (0)

Report

RE: Invoice no field should updated when sales invoice posted

Hello Inge,

We only use one shipment for one invoice.
Eva2020 10 on at

Like (0)

Report

RE: Invoice no field should updated when sales invoice posted

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
Eva2020 10 on at

Like (0)

Report

RE: Invoice no field should updated when sales invoice posted

Hello Zhu,

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

Regards,

Eva
Suggested answer

YUN ZHU 82,945 Super User 2025 Season 1 on at

Like (0)

Report

RE: Invoice no field should updated when sales invoice posted

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
Suggested answer

Nitin Verma 21,546 Moderator on at

Like (0)

Report

RE: Invoice no field should updated when sales invoice posted

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;
Suggested answer

Inge M. Bruvik 1,025 Moderator on at

Like (1)

Report

RE: Invoice no field should updated when sales invoice posted

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.