WareHouse : How can we get the Qty in Stock without GL entries ?

[Former Member]

Hello

The question may look contradictory but we want to manage quantities in stock, without triggering financial postings.

In fact, we want to make Deliveries / Good entry with zero posting

Following few advises given in the forum, Iu2019ve set:

1 - In the System Init > Company Details..Basic Initialization tab, Iu2019ve have checked Allow Stock Release without Item cost

2 - Also, Manage Item Cost per warehouse has been checked

But I still have financial postings.

Did I miss something?

If I declare the warehouse as "drop ship", I don't have any financial posting at all (correct) but I can't retrieve the movements either (thus it is impossible for me to calculate the physical qty on this warehouse)

Any clue?

Stephane

[K_Pauquet]

Hi Stephane,

as soon as you choose: 'Use Perpetual Stock System' in the company details/basic initialisation tab, the system is defined to produce a journal entry for any stock movement.

All items marked as 'stock item' in the header area of the item master data are affected by this.

If you want for the financial transaction to take place only at the invoicing level, please use a non-perpetual stock system. As long as there are no journal entries in a new database, you may change this setting.

Using non-perpetual stock the quantities can still be managed, yet without financial postings.

Please see he document:

How to make the initial settings in Business One

All the best,

Kerstin

[Former Member]

Hi Stephane

WE had a similar scenario for a customer - we recommended Purchase Account posting system

regards

Manian

[Former Member]

Hi Stephanie,

Do you want to make adjustments in quantities w/o affecting the Item Cost and w/o making Journal Entries?

Laurence Resubal

[Former Member]

Hi Stephane,

To allow stock posting without any g/l posting to SAP is by using periodic inventory system (in contrast to perpetual inventory system currently you use).

To do it, unfortunately you have to create it from zero again by creating new company. In the Company Details tab Basic Initialization un-tick option of "Use Perpetual Inventory". From now on, no posting will be made in any stock posting to SAP. Manual journal entry should be made to reflect inventory related transaction.

To help you post necessary adjustment entry to adjust inventory g/l to the last ending balance SAP provided you with the "Inventory Valuation Report".

Hope it help

Dody

Edited by: Dody Purwanto on Jun 9, 2008 5:57 AM

[Former Member]

The settings you described to not relate to GL posting. "Allow release without item cost" means that you can sell or otherwise release an item that has a zero cost in the system. "Manage by Warehouse" means that quantities are maintained for each warehouse separately, not for all warehouses combined.

If you really do not want to have any values posted to GL when items are received or sold, you will need to make all of the transactions debit and credit the same account, so that the net posting will be zero. For example, a goods receipt PO debits inventory and credits allocation - if they are both the same account, the posting will net to zero and no journal will be created. Similarly, a delivery credits inventory and debits cost of goods. So if inventory, allocation, and cost of goods are all the same account, there will be no posting. You can set this in the GL determinations.