Transactions

This option option displays all transactions associated to this product.  The user can double click on a document to see the details of the selected document.

Warehouse: The user can select from the drop-down list the warehouse to see this information.  By default, the system shows for all warehouses.

Vendor/Customer: The user can select from the drop-down list whether to see these transactions for Vendors or Customers or for both Vendors and Customers.

Vendor/Customer Selection: If the user selects Vendor/Customer in the previous option, this field will default to ALL.  However, if the user select Vendors or Customers, the user can select a particular vendor or customer to see the transactions. If the user wants to see for all customers or all vendors, the user can skip this field and the system will put all automatically in this field and they system will display for all vendors or for all customers.

Type: The user can select a Type of Transaction from the drop-down list.  All transactions shows by default.  Types of transactions are as follow:

          1- SLI = Receiving Slips

          2- PAY = Purchase Invoices

          3- INV = Sales Invoices

          4- PHY = Physical Count

          5- PRD = Production

          6- PHC = Physical Count Cancelled

          7- C/M = Cost Modification

Period: The information displayed is by period. No period can be manually entered.  They must be selected from the drop-down list. This list is populated by the period that currently exist in your system.

Date: Transaction Date

Type: Transaction Type. Please refer to Field Type above.

Whse: Transaction Warehouse

Vendor/Customer: Vendor or Customer number depending on the transaction Type.  SLI and PAY = Vendor / INV and PHY = Customer

Document: Transaction /Document number.

Quantity: Transaction quantity

Cost: Unit cost at time of transaction

Qty Applied: This quantity is the difference in Quantity entered from the Receiving Slip to the Purchase Invoice. For example, if you received 15 and invoiced 17, under the transaction PAY, you will see 17 under quantity and 2 under qty applied.

New Cost:  This field represents the new average cost that the system calculated during the Invoice entry when changes occurs in the cost.  Basically, this field displays the "Moving Weighted Average Landed Cost".

Adjustment: When there's a difference between the Receiving Slips Cost and the Purchase Invoice Cost and several of this product were sold, the system cannot apply the difference of cost to the items since they were sold so the system will make a dollar adjustment and will be displayed in this field.

Lot Number:  FIFO lot number if applicable