AP Journal Material Returns Tab


You may use this tab to specify the non-purchase order inventory items that are being returned to the Vendor for credit; if the item being returned was originally purchased on a Purchase Order, you should create a Credit PO to implement the return.

When the transaction is completed, the system will reduce the On Hand quantity in the Inventory Item record and in Job History to adjust for the return. If the item was associated with a Work Order, Job History will be adjusted for invoicing purposes but the item itself will still appear on the INV Inventory materials tab.

The GL accounts entered on this tab cannot be the same as any of the header accounts on the GL or Main tabs.

Important Fields:

The quantity of the item you are returning.

U of Measure:
This display-only field is maintained by the system; it defaults from the Inventory Item record.

Unit Cost:
The cost per unit to be credited.

The extended cost for this item: the Unit Cost times the Qty.

GL Account
The expense account to be credited for the return of this item. The display-only GL Account Name field defaults from the GL Account record.

GL Entity:
The Id of the GL Entity for which the original expense was incurred. This field is optional but should be entered if your firm departmentalizes or tracks profit centers.

The Location the part is being returned from.

Optional. Enter a brief description of this transaction detail.

Inventory Item Id:
The Inventory Item being returned.

Serial/Lot Id:
If you are returning serialized or lot controlled inventory, this field must be filled in with the identifying Serial Number or your firm's Lot Control Id (if Lot Control is implemented in your firm's database).

Account Name:  GL Entity Name:
These display-only fields are maintained by the system.

Work Order Id:
This field should only be filled in if this item was previously imported into a Work Order.

Equipment Id:
If the user enters a Work Order Id, the system will default in the first piece of equipment on the Work Order’s Equipment tab UNLESS this behavior is disabled via registry (see Registry Option - Do Not Default Equipment Id). If the user double clicks on this field, the system will display a list of all equipment associated with the Client Site referenced in the Work Order.

If the sys-ffv-global setting 'DefaultEquipmentFromWorkorder' is set to false, the user is allowed to set the Equipment Id back to blank. If this registry option is not present or set to true, the Equipment Id must be completed if a Work Order Id is referenced.

This indicates the Job (if any) that will be credited with the return.

Cost Category Id:
(Optional). A Job Cost Category with a Cost Type of Material or Equipment should be selected. This field supports enhanced filtering provided by the Cost Code's Job Cost Category Usage Filter. Cost Categories are validated (relative to Cost Codes) during data entry upon leaving the Cost Category Id field.  The full relationship is validated again when leaving the line or saving the record.

Job Cost Code Id:
The Job Cost Code Id; this field is required only if a Work Order Id is not filled in. Press Alt+F7 or double-click left on this field to select from a list of Job Cost Code Id's. The display-only Job Cost Code Name field defaults from the Job Cost Code record.

Job Bill Itm Id:
If a Job Cost Code Id is specified, this field must be filled in with the appropriate Billing Item Id to be credited with the return.

Other Rate Id:  Bill Type Id:
These fields default from the Vendor Record. The Bill Type Id field is required.

Flag this field if this item was ordered as a contract extra that you billed your customer for.

Revenue Rate:
This field defaults from the Rate Schedule for the Job (or Work Order) and determines how the Unit Price adjustment to Job History will be calculated:

If Markup is selected, the Revenue Rate will default from the Markup table (specified in the Rate Schedule for this Job). For example, a 120% markup applied to an item costing $100 would generate a unit price of $220. A 30% markup applied to an item costing $100 would generate a unit price of $130.

Margin enables the user to set the desired profit margin ((Unit Price - Unit Cost)/Unit Price)for this item in the Revenue Rate field. When a Margin is entered, the system will adjust the unit price to correspond to the desired margin.

If you select Multiplier, the system will multiply the figure in Revenue Rate X Unit Cost to obtain the Unit Price. For example, a multiplier of 1.2 applied to an item costing $100 would yield a unit price of $120.

If the Bill Type Id is set to Unit Price, and this inventory item is flagged for unit pricing, the system will use the Unit Price in the Inventory Item record that applies to the Price Level specified in this Work Order. In this case, the Revenue Rate will equal the Unit Price.

Select the Billing Type of n/a if a special price has been agreed on for this customer. In this case, you will leave the Revenue Rate field blank, and enter the Amnt Revenue fields directly.

Revenue Amount
The amount that you billed your client for this service.