Versions Compared

Old Version 2

changes.mady.by.user Cavinne Callado

Saved on

compared with

New Version Current

changes.mady.by.user Cavinne Callado

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Inventory Receipt Grid Line Item Columns
Column NameDescription
Order NumberOrder number of purchase contract, purchase order or transfer order.
Item No.*Item no. of the selected item.
DescriptionDescription of the selected Item.
Load ContractCheck box to determine load contracts.
Ordered UOMWill dispaly the UOM used from the selected purchase contract/purchase order.
OrderedWill display the ordered quantity of the selected purchase contract/purchase order.
Received so farWill display the total quantity of received items from the selected purchase contract/purchase order.
Qty to Receive*

Quantity and receipt UOM of the selected item.

Currency UnitWill display the currency used for the line item.
CostWill display the cost of the item. will default to a cost from Last Cost field of Item screen > Pricing tab > Last Cost field. Enter a new cost if necessary.
Cost UOMThis will display the cost UOM of the item. Changing the Cost UOM will update the Cost field since these 2 fields are directly connected. The cost to show in the Cost field is the cost per UOM selected from Cost UOM.
Gross/Net UOMAlso known as the weight UOM of the item. Will default to blank. Usually used for lotted items.
GrossWill display the gross quantity of the item.
NetWill display the net quantity of the Item.
Line TotalWill display the line total of the item. Qty to receive * cost. Computed automatically base on UOM's used.
Tax Group

Will display the tax group of the inventory receipt. Coming from (current hierarchy):

  1. Inventory Transaction (manual selection)
  2. Vendor Special Taxing
  3. Company Location
  4. Vendor Location
Tax

will show the tax computed for the item. If there's no tax class assigned from the Tax Group field then it will show 0.00.

Tax Setup is Tax Group, Tax Class (From Category) and tax code.

Forex Rate TypeWill display forex rate type of the line item. If there is a default setup in company config it will display automatically.
Forex RateWill display rate type of the line item. If there is a default setup in company config it will display automatically.
Storage Location (17.1 Sub Location)Will display the storage location on wheren the item will be received.
Storage Unit (17.1 Storage Location)Will display the storage unit on wheren the item will be received.
Discount scheduleWill display discount schedule of the item.
Unit retailWill show the value entered for the item from Item screen > Retail Price for the selected Location.
Gross MarginWill show a number computed as (Unit Retail - Unit Cost) / Unit Retail.
Container No.This will display the container number of the line item.
Lot TrackingWill display the lot tracking type of the item.
Lot Tracking Grid Columns
Column NameDescription
Lot NumberUser can manually enter Lot Number when item selected from the Item grid is Lot Tracked - Manual. If item selected from the Item grids is Lot Tracked - Serial Number, leave this blank. The system will generate the serial number as you receive the item. Serial Number generated will take the predefined serial number from Starting Numbers screen > Inventory > Lot Number.
Parent Lot NumberWill display parent lot number. User can enter manually.
Lot UOMBy default, will display the UOM selected from Gross/Net UOM in the Item grid. User can change LOT UOM manually.
QuantityBy default it will display the net quantity of the line item. User can manually enter lot quantity.
GrossWill display Gross quantity of the lot.
TareWill display tare quantity of the lot. User can enter manually.
Net QuantityAuto compute. Net = Gross - Tare.
Lot Wgt UOMBy default, it will display UOM selected from Item grid > Gross/Net UOM for the selected item. You will not be able to change this since this field is read-only.
Storage UnitBy default, will display Storage unit selcted from Item grid > Storage Location for the selected item. User will not be able to change this since this field is read-only.
Expiry DateAuto compute base on item manufacturing setup and ir receipt date.
Lot AliasWill display lot alias. User can manual enter lot alias,
Stated Gross Per UnitManually enetered by the user.
Stated Tare Per UnitManually enetered by the user.
Stated Net Per UnitAuto compute Stated Gross per Unit - Stated Tare Weight.
Stated Total NetAuto compute Stated Gross per Unit - Stated Tare Weight.
Phy vs StatedAuto compute Net Weight - Stated Total Net.
Container No.Will display the container number of the lot.
Garden 
OriginWill display the country of origin of the item.
Season/Crop YearManually entered by the user to display season/ crop year.
Vendor Lot IDManually entered to display vendor lot id.
Manufactured DateDisplay the manufacturing date of the lot.
RemarksUser can enter remarks for the lot.
Condition

By default, it will display the company config setup for lotted items. There are 4 types of conditions:

  • Sound/Full - will require the user to receive the same line item net quantity and lot net quantity.
  • Slack
  • Damaged
  • Clean Weight - user can receive the item even if there's a discrepancy in line item net quantity vs lot net quantity.
CertifiedWill display the certification date.