Question

View WIP Transactions by production order

  • 10 February 2023
  • 9 replies
  • 296 views
Freeman Helmuth
Rank
Userlevel 4
Badge

Is there any way to view all the transactions affecting the WIP account for a particular production order?

 

9 replies

Freeman Helmuth
Rank
Userlevel 4
Badge

Having a GI that shows this, would help mitigate the problem in this idea. This is very similar to the issue I’m dealing with:


Negative quantity cost adjustments should also update the last manufacturing cost layer | Community (acumatica.com)

Chris Hackett
Rank
Userlevel 7
Badge

Hi @Freeman Helmuth  were you able to find a solution? Thank you!

Chris ~ Let us know how we're doing: https://forms.office.com/r/xmJUdZ1QE5 - A member helped you, please *Like* their post. A member provided an answer to your question, please mark it as *Best Answer*.
iqraharrison48
Rank
Userlevel 7
Badge +6

@Freeman Helmuth does the Work in Process report work for you? it’s available under reports and you can specify the production order and the corresponding WIP account 

Iqra ~ If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
Freeman Helmuth
Rank
Userlevel 4
Badge

@iqraharrison48  No it doesn’t. I need a report that shows the actual materials in the WIP account. This is important when we perform period inventory counts to verify that the materials in WIP are correct. I was able to create a generic inquiry that kind of does this but it’s very slow and clunky.

 

It’s not our highest priority right now so I’m not putting a lot of effort into it, but if an Acumatica team member would at least point me in the right direction for which tables to join this would be helpful.

iqraharrison48
Rank
Userlevel 7
Badge +6

@estebanperalta54 is this something you might be able @Freeman Helmuth with?

Iqra ~ If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
cmoreland
Rank
Userlevel 4
Badge

I was curious if you were able to resolve this. 

It does not matter what you bear, but how you bear it. ~Seneca
Michaelh
Rank
Userlevel 5
Badge

Any news on this? I can get every transaction posted against the Production, but I can’t get who is “active”. 

Example output:

 

Tran Type Item ID Qty OP Code
Issue COMPONENT 1 1,000.00 OP Code: 0010
Issue COMPONENT 2 1,000.00 OP Code: 0010
Backflush Labor Finished Good 0.00 OP Code: 0060
Variable Overhead Finished Good 0.00 OP Code: 0060
Operation MFG to Inventory Finished Good 1,000.00 OP Code: 0060
Operation MFG to Inventory Finished Good 1,000.00

OP Code: 0010

 

As a Human, I know that only the FINISHED GOOD 1,000 unit cost is in WIP from the 0060 OP CODE, how do you know which transactions are still in WIP and who are just historical?

In case anyone wants the full list of Transactions agianst a Production Order (great for audits), you want the AMMTran table.

 

Permanent Newb, don't let the posts fool you.
Michaelh
Rank
Userlevel 5
Badge

Thanks @di93 for the help.

 

If you ALWAYS fulfill the entire Production Order, no partials or jumping between OP codes, then you can use this code in the PRODUCTION ORDER group:

=max([AMMTran.OperationID])

This will give you the largest OP CODE used in the Transactions for the Production Order. I set this to a variable called “$OP” who resets on the group for the Production Order.

Now under the details segment, where my transactions appear, I set the visibility flag to:

=AMMTran.OperationID=$OP

So if the transaction has an OP code that matches the highest OPCode for this transaction set, then I want it displayed. Easy Wins.

Permanent Newb, don't let the posts fool you.
jeremyd45
Rank
Userlevel 5
Badge +1

I will have to look, but I think I have built one of these for a customer in the past. Essentially they wanted to look at production efficiency.  

Be the change you want to see

Reply


Terms & ConditionsCookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved