Dynamics Community Forum Thread Details

Manufacturing Reverse Material Issue

Happy Friday -

Okay - Soliciting Feedback -

In GP Manufacturing........FIFO Perpetual Inventory Valuation

Create MO

Build Pick List

Issue Raw Materials (Component Transaction Entry) (decrease item quantities from stock by issuing to WIP)

-----GL and Inventory Transactions are created with the system date. everything is great. Go to item Stock Inquiry - transaction is last record, etc...........

Reverse Issue Raw Materials - This is the process of reversing the material issue process (Component Transaction Entry) (Take from WIP and put back into Stock)

----GL Transaction (created with the system date)

----Inventory Transaction is created - the document (high level) has a date - today's system date - but the individual items have different dates depending totally on where the 'stack' was dated that the original receipt quantity used.........go to item stock inquiry (expect to see the 'return to stock transaction as last record).....can't easily find the record...............

In other words -

Issue Materials on April 1st - everything says April 1st

Reverse Issue - the individual items will be put back into inventory based upon the date of the receipt in IV10200 table - not based on today's date........(April 1st) - some will be in March, others in February - maybe even prior year.......every item has a different date....

This can easily be seen by looking at the Item Stock Inquiry Screen - the end user (in my case) happens to use that screen to 'verify' something came out of inventory or was put properly back into inventory.......when the end user performs the reverse issue transaction the 'receipt' back in is not the last record in the screen - the end user will see the out transaction (material issue) and will not see the put back in (reverse issue transaction) in some cases the put back in is dated prior year....etc.

At first glance - I was very concerned about tying out Inventory to GL and the ramifications - about the system updating IV30300 table with something other than current date) but after reviewing the SEE30303 Table - everything is fine........the two SEE30303 records are dated today - thus if HITB is used - no worries.

My question is - Is this a 'bug' or in the community's opinion an acceptable functionality of GP Manufacturing?

Hope I described situation well enough to solicit feedback..........

I agree it's by design. I explained it to my client by using an extreme cost example.

Let's say we purchase Item A (Quantity = 1) for $1000 on Mar 15.

We then purchase a second Item A (Quantity = 1) for $5000 on March 25.

We create an MO on April 2 and consume the $1000 Item in Inventory.

On Apr 3 we reverse issue and have to put Item A back into stock. Should we put it back into stock on Apr 3 or March 15?

It's probably best to put it back into stock on March 15th............restore the original FIFO stack.

Otherwise - in wild cases of huge cost differences - end users could manipulate the FIFO system by issuing and reverse issuing materials to manipulate costs of a FG. It's hard to think somebody might do it - but you never know.

Once I explained that if they use HITB - Historical Inventory Balances and GL would be fine......they seemed more receptive.

Thanks for response Tim.

Quick Links

Leaderboard