Skip to Content
author's profile photo Former Member
Former Member

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

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jun 06, 2008 at 09:18 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 09, 2008 at 03:56 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 09, 2008 at 10:43 PM

    Hi Stephanie,

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

    Laurence Resubal

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 11, 2008 at 08:28 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.