Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Stock Status Report Su...
Microsoft Dynamics GP (Archived)

Stock Status Report Sub-totals

(0) ShareShare
ReportReport
Posted on by Robert Cawthorn 295

I want to run the stock Status report everytime we close a Period and then match it to the General Ledger.  Currently the GL and Stock Status Values are off.   I feel like I need to narrow this down by CLASS and see values by CLASS to see where the difference might be.

Is there not a way to GET sub-totals by Class in the Stock Status Report in GP?

Maybe I'm looking at this wrong, but how do you determine what is causing the difference between the Inventory GL Account and the stock Status Values?

Now I'm thinking I need to set up separate INVENTORY Sub-GL Accounts (tied to Class) and then run each Stock Status at Period end to see where the values are showing up differently.

I'm sure I'm not the first to have this problem

Any Suggestions?

 

 

 

 

 

 

 

*This post is locked for comments

  • Suggested answer
    Dale Coulthard Profile Picture
    Dale Coulthard 3,055 on at
    Re: Stock Status Report Sub-totals

    How do you perform close related to month end and inventory?  Do you keep people from receiving, posting sales, and making inventory adjustments to the new month?  We found that the system can change our subledger if we allow any inventory transactions for the new month while we are closing the prior month; therefore, we no longer allow entries into the new month until all sales transactions are posted into the old month, all inventory receipts and transactions are posted to the old month.  Then, we print the stock status and reconcile to the g/l and make adjustments (which are small and usually related to foreign currency issues).  Once the g/l and sub-ledger are reconciled, we open the new month for inventory and sales.  I suspect this option is not feasible for a lot of companies, but it was the only way we could reconcile.

    Best regards,

    Dale

  • Suggested answer
    Richard Whaley Profile Picture
    Richard Whaley 25,195 on at
    Re: Stock Status Report Sub-totals

    OK...10-1 this is your issue with differences between the amount:

    You have a quantity on hand of product x of 10 pieces valued at $10 each.

    You make a sale of 15 pieces and when the next PO receipt walks in the door, you ship and invoice 15 pieces.  Inventory assed is credited for $150.

    Problem is, the PO cost is 12 each.  Now the 5 pieces are receivexd at $12 .  Inventory Stock Status is off from GL by $20 ($2 x 5 pieces)

    This is one issue with Periodic valuation (not a problem with GP, an issue with the valuation method generally).

    To resolve this:

    1.   Receivce and post receipts BEFORE shipping.

    2.   Keep inventory correct

    3.   As an alternate, change to Periodic valuations.  It does not have this problem

  • Robert Cawthorn Profile Picture
    Robert Cawthorn 295 on at
    Re: Stock Status Report Sub-totals

    We are using FIFO Perpetual

  • GPDavid Profile Picture
    GPDavid 2,250 on at
    Re: Stock Status Report Sub-totals

    One helpful piece of information to know before we can offer any assistance: how do you value your inventory items?  Do you use FIFO/LIFO Perpetual, FIFO/LIFE Periodic, or Average Perpetual?

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans