Material Issues: When running this GI, Customer # is not being shown.

​@ccharris01 

Could you share the GI please?

Yes, a screenshot showing the Results of your GI, along with the GI requested by ​@aiwan will be most helpful in solving your question. Thank you!

This is the GL Trans details:  Standard Acumatica view that you cannot customize through Edit GI.

1. Customer/Vendor is blank  (Info is available on the ISS)
2. Trans Description is part Desc.  (Part # would be better)
3. If you return to the ISS, you can add SO#, but not Customer or Line.
4. In the GL - SO, WO, Part # should all be available.  To create a GI for this, there are too many related tables, creating multiple duplicate records

5. 

   If anyone has created a GI showing GL transaction details for MFG I would be grateful.  I am looking to follow a part through the entire MRP process.  SO, WO, WIP, FG, Variance, Ship, Invoice/COGS.  

6. Yes, I know entering the SO does not create any GL transactions, nor does running MRP.  Once the WO is created and transactions start, it would be nice to have WO and Part # referenced on every transaction - Labor, Material issue, OH.

​@ccharris01 

Could you please explain ISS?

FYI, this is not a GI, it looks similar but is actually a data view defined in the code of Acumatica.

It looks like this is an inventory transaction. You can create a GI which links the GLTran line back to INTran, which you would then link back to the SOShipment record. The trick to not having duplicates is utilising a join which is similar to this:

GLTran Inner Join INRegister

Module Equals =’IN’

BatchNbr Equals BatchNbr

INRegister Inner Join INTran

DocType Equals DocType

RefNbr Equals RefNbr

INTran Inner Join SOShipment

SOShipmentType Equals ShipmentType

SOShipmentNbr Equals ShipmentNbr

The use of Module Equals =’IN’ should prevent any duplication you may receive if you did not include it prior.

ISS is Inventory>Issues  which is the source GI.

While I understand your joins, the problem is the different sources required to each GL transaction based on the different refnbr Acumatica uses.  Labor is different the material issues, which is different from closing WIP and posting variance, which is different than shipping, which is different than posting the sale/cogs.   

It was a lot easier in my last software, as the MFG transactions were all one type, requiring one join.

I appreciate it is a lot of tables to join, I have attached a similar GI I have.

Another way is via customisation. Your VAR would be the first point of call.