Skip to main content

Notifications

Announcements

Forum Structure Changes Complete – Update Your Subscriptions!
News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Stock Status versus HITB
Finance | Project Operations, Human Resources, ...
Answered

Stock Status versus HITB

(0) ShareShare
ReportReport
Posted on by RR-07061806-0 45
Good day,
 
I am looking at a stock status for a location and not seeing a value. I went to the item quantities Smartlist and I am seeing 3 items with a returned quantity. When I pull a HITB for the same location I am seeing a negative value, with quit a few items and the items that have a quantity returned are not included in the HITB.
 
The location was merged into another so I'm trying to clean up what is there since with the merge everything should have gone across. My question is where do I start and what should I look for.
 
I am thinking if it is not in the stock status the value is not recorded in the GL?? And what do I do with the negative value the HITB is seeing?
 
Regards
 
Rosemary
  • RR-07061806-0 Profile Picture
    RR-07061806-0 45 on at
    Stock Status versus HITB
    Good day,
     
    Lisa, thank you for your response, I understand where you're coming from and yes, I will try this in our Test company and see how things work out.
     
     
    Regards
    Rosemary
  • Suggested answer
    Lisa at AonC.com Profile Picture
    Lisa at AonC.com 3,070 on at
    Stock Status versus HITB
    >>I don't understand your statement, 'were the posting accounts set up in a way that the GL is correct even though Stock Status is wrong'.
     
    Rosemary - 
     
    I have seen people set up their Returned Posting Account in a way that things appear in balance (when Returned quantities are hanging out there).
     
    If you have access to a Test Company, I recommend testing how things look if you transfer the Returned Quantity Type (Transactions > Inventory > Transfer Entry) and then see how the HITB and Stock Status appear for the item. 

    There is also the Microsoft Dynamics GP > Tools > Routines > Reconcile to GL option for inventory that may help.

    A test company will be your best friend in this process.
  • Verified answer
    RR-07061806-0 Profile Picture
    RR-07061806-0 45 on at
    Stock Status versus HITB
    Thank you Lisa and Beat for your response.
     
    I hope I don't sound too confused, the GL and the HITB does not balance, in attempting to identify the inconsistencies the quantity returned was observed. Yes, there has been multiple Inventory Reconciles but normally the option to include history is usually unticked. I do think the merger may have contributed to some of the differences. 
     
    Lisa, it was when I included the different qty types that I saw a value for the returned items which referenced the GL Inventory account. I like the suggestions and questions asked, yes there are multiple variables, but I think if the returned quantities are transferred to a specific location, it may help identify why the GL is out of balance.
     
    I don't understand your statement, 'were the posting accounts set up in a way that the GL is correct even though Stock Status is wrong'.
     
    Regards
     
    Rosemary 
  • Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at
    Stock Status versus HITB
    Rosemary,
    To add to what Lisa already said, have you run an Inventory Reconcile after the locations were merged ?  GP might not have updated all the quantities after the merger... 
    Regards,
    @GP_Beat
  • Suggested answer
    Lisa at AonC.com Profile Picture
    Lisa at AonC.com 3,070 on at
    Stock Status versus HITB
    Ugh.  Using any Qty Type than "On Hand" can be tricky to report.  Stock Status only recognizes the On Hand Quantity.

    HITB has the option to include other Qty Types.  

    Regarding clean-up, if the issue is the Returns should be part of On Hand, you'll need to do an Inventory Transfer to move the Quantity Type = Returned to Quantity Type = On Hand (keeping the site the same).

    There are lots of variables to determine the actual cleanup process.  (For example, were the posting accounts set up in a way that the GL is correct even though Stock Status is wrong?  Is SS and HITB in balance?  Should the returns not be returned to On Hand?  Do you need a separate Returned site?)

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

News and Announcements

Forum Structure Changes Complete – Update Your Subscriptions!

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,900 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,275 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans