Skip to main content
Solved

Displaying Negative in GI


I am looking at the Issues GI I would like for the Returns to show negatives.  Would someone be able to give me directions on how to make this work.  I am trying to balance our inventory daily and really do not want to have to export it daily and change the numbers to negatives.  This is the balancing that we are doing each day to balance.  

BEGINNING INVENTORY, BAL SHEET, April 30
PLUS:  RECEIPTS
PLUS/MINUS: ADJUSTMENTS
PLUS/MINUS: ISSUES
LESS:  COGS
NET INVENTORY
INVENTORY BALANCE SHEET, May 31
 

Best answer by adharmawansha22

Hi @VBrundage 

Use below mentioned logic to get the results.

This will enable you to get the total cost using @estebanperalta54 ‘s GI. 

Hope this will be helpful for you.

View original
Did this topic help you find an answer to your question?

2 replies

estebanperalta54
Captain II
Forum|alt.badge.img+4

Hi @VBrundage I’m not sure the out of the box Issues GI will show returns because this will be a receipt transaction. You’re better off using the PX.Objects.IN.INTran table which will include all inventory transactional detail including issues and receipts. I’m attaching the xml of a similar GI I’ve done. You can then do a conditional on the results grid like this:

 


Hi @VBrundage 

Use below mentioned logic to get the results.

This will enable you to get the total cost using @estebanperalta54 ‘s GI. 

Hope this will be helpful for you.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings