Allow post and send only when there's inventory.

(0) Share

Report

Posted on by yaza

Hi there,

I'm struggling with something. I have a sales order and when I choose to 'post and send', I select 'ship and invoice' after I finish all the steps I get the error message 'Insufficient inventory'. But still a posted sales invoice is created with 0 value lines. How can I stop the post and send if there's no items inventory. I'm pretty new in AL language I have a project and already have an extension on the sales order page.

Any help will be appreciated.

Thanks in advance.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (6)

Answers (1)

Suggested answer

YUN ZHU 93,222 Super User 2025 Season 2 on at

Like (2)

Report

RE: Allow post and send only when there's inventory.

Hi, This appears to be a customization issue.

You can step through the debugger to see when the sales invoice was created but not rolled back when the error was reported.

This may be related to Commit method or temporary tables.

Hope this can give you some hints.

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Mohana Yadav 60,969 Super User 2025 Season 2 on at

Like (0)

Report

RE: Allow post and send only when there's inventory.

You can set "Prevent Negative Inventory" on the item to Yes.

Was this reply helpful? Yes No
yaza 50 on at

Like (0)

Report

RE: Allow post and send only when there's inventory.

Hi I think you are right we have some customisations. I have an after insert trigger on "Sales Invoice Header" and there I do a commit. But the error comes after this action and the SalesInvoice is already committed. But when I remove the commit from this after insert in the correct situation (with no error), the app freezes and nothing happens. Have you got any idea why this is?

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,045 Moderator on at

Like (1)

Report

RE: Allow post and send only when there's inventory.

Maybe you should try to share the code that you have written?

Was this reply helpful? Yes No
Verified answer

YUN ZHU 93,222 Super User 2025 Season 2 on at

Like (1)

Report

RE: Allow post and send only when there's inventory.

I think it is the "Commit" problem, I suggest to remove this Commit.
If it freezes, there may be an infinite loop in processing , and you should investigate that.

Although it is more troublesome, if you debug step by step, you should be able to find the cause of the problem.

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
yaza 50 on at

Like (2)

Report

RE: Allow post and send only when there's inventory.

The commit was the problem indeed here's my code:

Table extension: SalesInvoiceShipping extends "Sales Invoice Header"

tableextension 50400 SalesInvoiceShipping extends "Sales Invoice Header"

{

trigger OnAfterInsert()

var

UpdateRef: codeunit "Update Ref";

EnableText: Text;

EnableBool: Boolean;

begin

UpdateRef.QueueExport(Rec."No.")

end;

}

Codeunit UpdateRef:

codeunit 50418 "Update Ref"

{

procedure QueueExport(RecNo: Code[20])

var

SalesHeader: record "Sales Invoice Header";

ExtWarehouseRef: record "Ext Warehouse Ref";

begin

if SalesHeader.Get(RecNo) then begin

ExtWarehouseRef.Init();

ExtWarehouseRef."No." := RecNo;

ExtWarehouseRef."Order Status" := 'Queued';

ExtWarehouseRef."Order Export Time" := CurrentDateTime();

ExtWarehouseRef.Insert(true);

//Commit(); this was the problem

end;

end;

}

After I removed the commit, my problem was solved and the sales invoice was no longer created with 0 value lines.

Thank you very much for all the help.

Was this reply helpful? Yes No