web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics NAV (Archived)

Facing some transactions in inventory interim account in navision

(0) ShareShare
ReportReport
Posted on by 3,518

Hello to all,

I am using nav2013 and facing negative amount in inventory interim account. In interim account there so many transactions with positive and negative adjustment and at the end of year it shows negative amount. In inventory GL Reconciliation it shows Direct posting as warning. How to resolve this?

Please suggest as soon as possible. I will wait for your suggestions.

Thanks

*This post is locked for comments

I have the same question (0)
  • ManishS Profile Picture
    86 on at

    It might be some one has posted to this account directly.

  • Paras mehan Profile Picture
    3,518 on at

    Hi Manish,

    Thanks for response.

    But there are so many entries for single order with different amount and that order is also in Trading account.

  • ManishS Profile Picture
    86 on at

    Simple copy these entries to excel and do a pivot.

    The entries which are getting knocked off remove them and check the other entries which are not getting knocked off.

  • Paras mehan Profile Picture
    3,518 on at

    Hi manish,

    There are not 2 or 3 records. its around 2 years transactions are wrong.

  • ManishS Profile Picture
    86 on at

    Then why not do it month on month.

  • Paras mehan Profile Picture
    3,518 on at

    Hi Manish, sorry we couldn't close month on month , and due to that only issue we are facing, kindly give me some suggestion how to get rid of same.

    Thanks

  • ManishS Profile Picture
    86 on at

    You cannot get rid of this without knowing the reason.

    If the user had entered the entry then simply pass a Journal Voucher.

    If it has been posted by system then you must know the reason to resolve it.

  • Paras mehan Profile Picture
    3,518 on at

    Hi manish,

    those all entries posted by system . I am trying to know the reason of this happening from last some days but unable to find the reason. Now what to do ?

    Thanks.

  • Suggested answer
    RobertasR Profile Picture
    5,004 on at

    Hi Paras,

    there might be 3 reasons for this:

    1. Somebody posted directly to this account. It would make almost impossible to find

    2. You have sales shipments or purchase receipts that are not invoiced; or sales returns / purchase returns that are not credited.

    3. The account is used in some other setup (see 'Where-used' for the account to make sure).

    Clearing the account of wrong /direct postings might require day or more of the highly skilled consultant. I hope it's just the case of missing invoices :)

    Robertas

  • Paras mehan Profile Picture
    3,518 on at

    Hi Robertas

    Thanks for response.

    That all system created entries. Some of the entries related to transfer order and some GL entries without any order.

    Please suggest what to do. should need to close the year.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans