Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Unanswered

FIFO Method and Returns with QA and MRP

Posted on by 240

We are using Dynamics GP2016 R2. 

We use the Manufacturing module. 

We run MRP nightly. 

Our items are all FIFO Valuation Method. 

We do use multiple Bins, but only one Site for our active inventory.

We use multi-level BOM configurations for all of our components.  This includes MFG and Phantom BOMs.

We do not use Standard Costing. 

We are wanting to implement the QA processing in GP, but there are issues with the FIFO layer values and using original item receipts for items that may need to be returned to the Supplier/Vendor.  

The issue with the FIFO layer valuation is moving the items to a separate Bin and the quantity type after receipt, while the QA process is being completed.  This process was looking to be done so that the MRP demand is not impacted since we've actually received the item in house.  How can this be processed in this manner without messing up the FIFO item values?  How does the multi-bin impact the FIFO layer values, say if we have 5 different Bins that items are being pulled from?  Should there maybe be a separate Bin for after the items have passed QA inspection?

The other issue is that sometimes we don't get the credits from Suppliers, of returned items/goods, before we've already paid them for that PO and we're unable to process the Return Transaction with Credit as the Receipt is not available anymore.  This is causing issues with our AP and PPV Accounting.  Is there a way to mitigate this issue?  

Thank you in advance for your assistance! 

Categories:
  • Jeff Grant Profile Picture
    Jeff Grant on at
    RE: FIFO Method and Returns with QA and MRP

    Hello,

    The complexity of your request would likely be best handed by a Dynamics GP support case(s) as it would require some extensive testing to lend valid recommendation in any of the areas you have outlined.

    However, I am thinking there may be some Manufacturing gurus in the Partner community that will be able to provide some direction via this forum posting in the interim.


    Best Regards,
    Jeff
    Microsoft Dynamics GP Support

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,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans