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 :
Finance | Project Operations, Human Resources, ...
Unanswered

FIFO Method and Returns with QA and MRP

(0) ShareShare
ReportReport
Posted on by 248

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:
I have the same question (0)
  • Jeff Grant Profile Picture
    on at

    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

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 > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 660 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 549 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 307 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans