Wednesday, December 19, 2018

Transaction Search for Item Receipts Displays a Positive Quantity and a Negative Quantity values

A positive quantity appears if the item receipt is created from a purchase order. While a negative quantity appears if the item receipt is created from a return authorization. 


To understand this behavior:


1. Create an item receipt from a PO (Transactions > Vendors/Payables > Receive Orders)


2. Create an item receipt from a customer return authorization (Transactions > Customers > Receive Returned Orders)


3. Create a Saved Search:


-  Go to Lists > Search > Saved Searches > New > Transaction.
-  Under the Criteria tab > Standard sub tab, add:
   • Type is Item Receipt   
   • Date is within today   
-  Under the Results tab > Columns sub tab, add:
   • Number
   • Account
   • Quantity
   • Applied To Transaction
-  Preview


The sign of the quantity in the search result does not necessarily reflect the inventory movement. It relates more to the account posted with it instead. 

No comments:

Post a Comment