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

ERROR ON SALES INVOICE

(9) Share

Report

Posted on by MD-01071455-0

143

Hi Community,

Today I'm here with a new question. I'm facing an error while posting a sales invoice in which I assigned locations and bin codes but facing follwoing errror while posting invoice. Can you help me where I'm doing an error.

Thanks in advance

Bin Code must be equal to '' in Item Journal Line: Journal Template Name=, Journal Batch Name=, Line No.=0. Current value is 'WEST'.

Categories:

Microsoft Dynamics NAV

Dynamics 365 Business Central

I have the same question (0)

All responses (12)

Answers (0)

Suggested answer

Alex A 2,884 on at

Like (5)

Report

I think it doesn't like the Bin Code... What are your Location card settings, in the Warehouse FastTab of the Location card?

Was this reply helpful? Yes No
MD-01071455-0 143 on at

Like (5)

Report

@Alex A

please find the location card warehouse field

Was this reply helpful? Yes No
Suggested answer

Alex A 2,884 on at

Like (5)

Report

Basically, on the Location card, 'Bin Mandatory' needs to be paired with 'Require Pick' so you can use a Warehouse Pick because you can't enter the Bin Code directly on the Sales Invoice Line. You enter the Bin Code on the Warehouse Pick.

Was this reply helpful? Yes No
MD-01071455-0 143 on at

Like (5)

Report

@Alex A

There is no warehouse pick nor we want pick we want direclty post from sales invoice. Also for other sales invoice with same location and bins we can post.

Was this reply helpful? Yes No
Suggested answer

Alex A 2,884 on at

Like (5)

Report

When you posted on your other Sales Invoice, does the inventory get deducted from that bin WEST (directly)? Do you see the bin inventory level going down in that bin?

Was this reply helpful? Yes No
MD-01071455-0 143 on at

Like (5)

Report

@Alex A, Yes inventory is going down when we create any sales shipment and any negative adjustment.

Was this reply helpful? Yes No
Suggested answer

OussamaSabbouh 5,798 on at

Like (4)

Report

Hello,

The error happens because your location uses Bin Mandatory but no warehouse picks/shipments. BC expects the Bin Code to be blank when posting directly.

→ Remove Bin Code on the sales line, or enable Require Shipment/Pick and post via a warehouse shipment.

Regards,

Oussama Sabbouh

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

Jeffrey Bulanadi 8,760 on at

Like (3)

Report
Hi,

Bin Code must be equal to '' in Item Journal Line: Journal Template Name=, Journal Batch Name=, Line No.=0. Current value is 'WEST'

is a classic mismatch between location setup and transaction data. BC is telling you that the location you're posting to does not require bins, but your transaction includes a Bin Code (WEST), which violates the expected structure.

Here’s how to resolve it:

Check the Location Card setup

Go to the Location Card for the location used in the sales invoice.

If Bin Mandatory is disabled, then BC expects no Bin Code on the transaction.

If Bin Mandatory is enabled, then Bin Code must be present and valid.

Review the Bin Code assignment

If the location does not require bins, remove the Bin Code from the sales line or journal line.

If the location does require bins, make sure the Bin Code is valid and matches the location’s bin setup.

Validate the Item Card setup

Check whether the item has a Default Bin Code assigned.

If the item is being posted to a location without bins, remove the default bin or ensure it’s ignored during posting.

Check warehouse settings for the location

If you’re using warehouse features like Directed Put-away and Pick, the system expects bin-level control.

If these features are off, bin codes should not be passed unless explicitly required.

Integration or customization check

If the data is coming from an external system or extension, make sure the Bin Code field is not being populated incorrectly.

Review any AL code or API mappings that might be injecting Bin Code values into the journal line.

Helpful Reference
Resolving Bin Code errors in BC – Prudence Consulting
Warehouse setup and bin logic – Microsoft Learn
Community thread: Bin Code must be equal to blank

If you find this helpful, feel free to mark this as the suggested or verified answer.

Cheers
Jeffrey

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

Alex A 2,884 on at

Like (1)

Report

What I'm getting at is:

Inventory is going down by posting a Sales Invoice without a Warehouse Pick, but can you see the specific inventory in that 'WEST' bin going down?

The reason why I ask is that there are two ledgers in BC/NAV:

Item Ledger Entries (Total Location inventory levels)

Warehouse Ledger Entries (specific Bin inventory levels)

I don't have access to your system to test, but I'm trying to find out if having only 'Bin Mandatory' as a Location card setting, and then doing a transaction directly from a Sales Invoice will deduct from both ledger's? I didn't think it would but you can test this because you have this exact scenario.

So please answer the following questions:

Having 'Bin Mandatory' on, with no other warehouse setting turned on on the Location card:

1.) Can you see any existing and recent ledger entries in the Warehouse Ledger Entries? Go to Bin Contents and find Warehouse Ledger Entries from there, and check.

2.) Did you put (and do you have) Inventory in the 'WEST' bin, and can you see your specific inventory totals in the 'WEST' bin from the Bin Contents page?

3.) If you add up the Item Ledger Remaining Quantity for that Item what is the total?

4.) Does that total from #3 match the total if you add up the Warehouse Ledger Remaining Quantity for that Item in Bin 'WEST'?

* In other words, filter these two ledgers and compare them to see if their totals match for that item.

** Is the Item Ledger Entries total inventory going down along with the specific bin inventory level in the Warehouse Ledger Entries? Are they in sync when you don't use a Warehouse Pick (with Require Pick) but only post from a Sales Invoice with your current Location card settings?

Regards,

Please mark the answers if they are helpful

Was this reply helpful? Yes No
Suggested answer

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

Like (1)

Report

Hi, hope the following can give you some hints.

How to set up the Location mandatory and Bin mandatory in Dynamics 365 Business Central

https://yzhums.com/33037/

Thanks.

ZHU

Was this reply helpful? Yes No