Why negative stock inventory still can post A/R invoice

[Former Member]

Hi,

I don't want to post A/R invoice, when negative stock inventory of the item.

Could anyone find out the solution for me.

Already set the below settings in the SAP:

1)  item master data - inventory data - tick Manage inventory by warehouse

2)  System initialization - Document setting - general - tick block negative inventory by Item stetting

Still I can post the A/R invoice, when no stock ( It's allow negative stock inventory)

Using : SAP B1 ver 9.0 PL 10.

Thanks & Regards,

Siva.

[julie_jamieson2 · Accepted solution]

THe Goods receipt with a post date of 3/7 was in fact posted with a system date of 2/7, so the stock was available to be issued for the AR Invoice, and you can see that it has issued with the same cost as applied after the Goods Receipt.

The issue you have is with timing only....

[Former Member · Accepted solution]

Hi Julie,

You are correct.

One more thing why the report shows negative inventory means, the report generated by "Posting date".  In this case we should generate by "System date" .

Now I can't see the negative inventory in my report.

Thanks Julie 🙂

Regards,

Siva .

[Former Member]

Hi Siva,

You have got your answer. Please close your thread.

All those accumulated quantities are calculated at run time. If you run report based on posting date, it may not be able to reflex the actual system posting status. Even you enter the posting date as later date in GRPO, system will not prevent posting AR invoice if the stock is in the system already.

Thanks,

Gordon

[kothandaraman_nagarajan]

Hi,

Tested in 8.82 PL 04 and found above settings are blocking posting of quantity with zero stock.

Conditions are:

1. Under inventory tab, you should select manage inventory by warehouse

2. Your item master should ticked as inventory item

3. Refer below screen shot:

Thanks & Regards,

Nagarajan

[Former Member]

Hi Nagaraj,

My SAP version is 9.0 PL10.

Thanks & Regards,

Siva.

[kothandaraman_nagarajan]

Hi,

If you need, I will check it through team viewer? If yes, please send ID and password now.

Thanks & Regards,

Nagarajan

[kothandaraman_nagarajan]

Hi,

Please post screen shot of AR invoice with status and quantity field. If you enter negative quantity system increase stock level of the item.

Thanks & Regards,

Nagarajan

[Former Member]

Hi Nagaraj,

My question is why allow negative inventory after set all the SAP settings?

Why I need to increase the stock level of the item (Already we are protected by the settings right).

Thanks & Regards,
Siva

[Former Member]

Hi Nagarajan,

Kindly refer below attachment for your ref.,

Thanks & Regards,

Siva

[former_member197621]

Hi,

I think you have posted audit report based on posting date, run your report based on system date and post your feedback.

[Former Member]

Hi Sivakumar,

Please check whether the Warehouse in the AR Invoice lines have inventory.

Check Form settings and click Warehouse

Regards

JO.

[Former Member]

Hi Jiju,

I have checked it's zero stock (for all the warehouses)

Thanks & Regards,

Siva

[Former Member]

Hi

So Sivakumar, did you post that AR Invoice?

Also check this

In order to block negative inventory for each warehouse, the following settings should be made:

1. Go to Administration -> System Initialization -> Document Settings -> General Tab, make sure 'Block Negative Inventory' is checked.

2. Go to Item Master Data -> Inventory tab, make sure 'Manage Inventory by Warehouse' is checked.

https://websmp230.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/smb_searchnotes/display.htm?note_langu=...

[Former Member]

Hi Jiju,

I already followed your all the settings.  Still I can post the A/R invoice.

I thinks it's an "Application Bug". Please share your opinion , if you have.

Thanks&regards,

Siva

[former_member197621]

Hi,

Check the item is marked as "Inventory Item".

[Former Member]

Hi prasanna,

Yes. It's an inventory item.

Thanks & Regard,

Siva

[KennedyT21]

Hi SivaKumar..

Have you selected the block Release/receipt under the document settings ?

can you post the screen shot of the document settings...

Regards

Kennedy

[Former Member]

[Former Member]

Hi kennedy,

Still allow the system .  Can post the AR invoice

[former_member205766]

Hi

Uncheck the Allow Stock Release without item cost in Administration => System Initilization => Company Details => Basic Initilization TAB

Go to Document Setting => Check the Block Inventory by =>  You Inventory Settings.

With Regards

Balaji

[Former Member]

Hi Balaji,

Do you mean untick allow stock release without item cost?

[former_member205766]

Hi Siva

Yes. Check the block Release/receipt under the document settings.

Go to Administration => System Initilization => Document Settings

With Regards

Balaji