Page History

Inventory Receipt Header Fields
Field Name	Description
Order Type*

There are several Voucher Types that you can pick from. Each of them change the way the voucher works

This is used to define the type of Inventory Receipt you are to create. There are four types of Inventory Receipt.

Type	Source Type	Description
Purchase Contract	None	Used to process purchase contracts straight from Contract Management module.
	Scale	Used to process purchase contracts from Scale module.
	Inbound Shipment	Used to process inbound shipment contracts from Logistics module.
	Transport	Used to process purchase contracts from transport module.
	Settle Storage	Used to process purchase contracts from grains module.
Purchase Order	None	Used to process purchase orders from Purchasing (A/P) module.l
Transfer Order	None	Used to process transfer orders from Inventory→Inventory Transfer screen when shipment is required.
Direct		Used to directly receive items without using other modules.

Source Type

This is to determine the source of the incoming contract, purchase order or transfer order.

Vendor*

This will display the vendor name on where the item/s came from.

Location*

This will display the location on where the item will be received.

Receipt Date*

This will display on WHEN the item was, is or will be received.

Currency*

This will display the currency used in the inventory receipt.

Receipt No.

This will display the automated receipt no. of the inventory receipt which is created upon saving the transaction.

BOL No.

This will display Bill of Lading No. of the inventory receipt.

Receiver

This will display the receiver name of the inventory receipt.

Freight Terms

This will display the freight terms used for the inventory receipt. Ex. Deliver, Pickup or Truck.

Shift Number

This will display the shift number of the inventory receipt.

Vendor Reference no.

This will display the vendor reference number of the inventory receipt.

Ship From

This will display the locations of the selected vendor.

FOB Point

This will display the Free on Board of the selected freight terms.

Warehouse Ref. No.

This will display the warehouse reference number of the inventory receipt.

Ship Via

This will display default to selected Vendor's location Ship Via setup.

Vessel

This will display the vessel used for the inventory receipt.

Inventory Receipt Grid Line Item Columns
Column Name	Description
Order Number	Order number of purchase contract, purchase order or transfer order.
Item No.*	Item no. of the selected item.
Description	Description of the selected Item.
Load Contract	Check box to determine load contracts.
Ordered UOM	Will dispaly the UOM used from the selected purchase contract/purchase order.
Ordered	Will display the ordered quantity of the selected purchase contract/purchase order.
Received so far	Will 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 Unit	Will display the currency used for the line item.
Cost	Will 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 UOM	This 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 UOM	Also known as the weight UOM of the item. Will default to blank. Usually used for lotted items.
Gross	Will display the gross quantity of the item.
Net	Will display the net quantity of the Item.
Line Total	Will 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): Inventory Transaction (manual selection) Vendor Special Taxing Company Location 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 Type	Will display forex rate type of the line item. If there is a default setup in company config it will display automatically.
Forex Rate	Will 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 schedule	Will display discount schedule of the item.
Unit retail	Will show the value entered for the item from Item screen > Retail Price for the selected Location.
Gross Margin	Will show a number computed as (Unit Retail - Unit Cost) / Unit Retail.
Container No.	This will display the container number of the line item.
Lot Tracking	Will display the lot tracking type of the item.

Lot Tracking Grid Columns
Column Name	Description
Lot Number	User 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 Number	Will display parent lot number. User can enter manually.
Lot UOM	By default, will display the UOM selected from Gross/Net UOM in the Item grid. User can change LOT UOM manually.
Quantity	By default it will display the net quantity of the line item. User can manually enter lot quantity.
Gross	Will display Gross quantity of the lot.
Tare	Will display tare quantity of the lot. User can enter manually.
Net Quantity	Auto compute. Net = Gross - Tare.
Lot Wgt UOM	By 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 Unit	By 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 Date	Auto compute base on item manufacturing setup and ir receipt date.
Lot Alias	Will display lot alias. User can manual enter lot alias,
Stated Gross Per Unit	Manually enetered by the user.
Stated Tare Per Unit	Manually enetered by the user.
Stated Net Per Unit	Auto compute Stated Gross per Unit - Stated Tare Weight.
Stated Total Net	Auto compute Stated Gross per Unit - Stated Tare Weight.
Phy vs Stated	Auto compute Net Weight - Stated Total Net.
Container No.	Will display the container number of the lot.
Garden
Origin	Will display the country of origin of the item.
Season/Crop Year	Manually entered by the user to display season/ crop year.
Vendor Lot ID	Manually entered to display vendor lot id.
Manufactured Date	Display the manufacturing date of the lot.
Remarks	User 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.
Certified	Will display the certification date

VoucherThis is used to create a standard voucher. (Default)Vendor PrepaymentsThis is used to create prepaid that can later be applied to any vouchers. Debit MemoThis is used to create debit memos of purchases received from your Vendors but then decided to return the items.1099 AdjustmentThis is used to create adjustment or correct a 1099 value that is previously filed. This transaction has no financial impact - does not pay the vendor and does not impact gl it is for record keeeping only.ClaimThis is used to create claims for transactions that has a gain or loss during the shipment due to various reasons like weather and damages.Invoice No

The Invoice Number field cannot have a duplicate value unless allowed by the user. The duplicate check is to ensure no duplicates on a single vendor. You are allowed to have duplicates across vendors.

Invoice Date

The date of the Invoice.

Invoice date is used as the basis for terms codes
this does not impact when the transaction is posted to the general ledger

Recur

Option used to create a Recurring Voucher template. Recurring vouchers can not be made from posted vouchers. They are a template for future postings.

Check CommentsPrints anything entered in this field on the check . limited to 25 characters due to space on the check.Post DateThe date the Voucher was (will be) Posted to the General Ledger.TermsTerms can be setup in the Common Info menu. Depending on the selected term, it can change the Due Date and possible discounts given.Due Date

The date the Voucher is due to be paid.

This date can be adjusted even after posting the voucher but not after paying the voucher.

ReferenceAccepts anything entered. For duplicate transactions, this field displays the record number of the original voucher.Ship ViaShipping Method used in the transactionContactThe vendor contact you may speak with on occasion other than your vendor who works at the same company.Ship From

Ship ToThis will display your default company location where merchandise will be shipped.LocationThis will display the default company location.Pay ToThis will display the vendor where merchandise will be paid to.Voucher NoThis is an automatically generated number that is unique for every voucherAP AccountAP Account where GL entry will be posted. This defaults to the AP Account set in Common Info > Company Locations > GL Accounts tabWithheld AmountThe withheld amount applied when payment was made to the transaction.CurrencyCurrency used in the transaction.Ordered ByThe one who created the transaction. Defaulted to the user that is currently logged in.Ship From (Address field)The address of the selected vendor location where merchandises were shipped fromShip To (Address field)The address of the selected company location where merchandises will be shipped toRemarksAccepts any remarks entered.SubtotalTotal before the tax of all the line items entered in the Line Item Detail was applied.TaxThe calculated tax based on the tax code used on every detail. This can be overridden via Tax Details screen.TotalThe computed total by adding Subtotal and taxes of the transaction.Amount PaidThis is the payment amount already made for the voucher.Amount DueIf voucher was partially paid, this displays the remaining amount with no payment yet. If voucher is already paid in full, this shows 0.00.Terms DiscountThis is the computed discount based on the terms used.OverrideOption used to override the computed discount.Due if Paid ByWill show the date when computed discount is available and how much is the voucher total if paid with discount.Inventory Receipt Line Item ColumnsColumn NameDescriptionLoad #

Inbound Shipment record number if selected detail is associated to an Inbound Shipment

ContractContract number if selected detail is associated to a contractContract SeqSequence of the detail in the contract selected.PO #Purchase Order rerord number if selected detail is associated to a purchase orderItem No.Item No. of the item selectedDescriptionDescription of the item selectedMisc DescriptionIf Item No is selected, this also displays the item's description. If item is not available in Items table, user can directly enter miscellaneous item in this field.UOMUOM set for the selected item. If detail is associated to other transactions, then it will default to the UOM used in that transaction. If not, it is defaulted to the stock unit of the item. For misc items, default is blank.OrderedQuantity received for the item.BilledQuantity billed for the item.Sub CurrencyChecked if Currency Unit used for the item is sub currencyCurrency UnitThis is the currency used when item was received. It can be in main currency or in sub currencyRate TypeThe rate type used if currency used in the transaction is different from the functional currency set for the company.Exchange RateIf currency used in the transaction is different from the functional currency set, this is the rate used to convert the amount to base currency when posted to GLCostThis is the cost of the item per UOM selectedCost UOMThis is the unit of measure of the costGross/Net UOMUOM for Gross/Net if used in a selected item associated in a transaction.Net WeightNet Weight of the item recieved.Discount

Percent discount applied manually. (But this is just a display. Discount on payment will still be computed based on terms and date or will still get the discount entered in Terms Discount field if overridden.)

TaxTax computed based on the tax setup if available for the company location used, by vendor or by vendor locationTotalLine total, Cost * Billed qtyActualIf voucher is associated to a contract and additional charges were applied, this is where actual amount is entered. (Column is hidden by default)Difference

Difference of Actual - Total amount. (Column is hidden by default)

Account IDExpense or AP Clearing account used where GL entry will be posted. Account DescriptionDescription of the Expense or AP Clearing account usedCommentsAccepts any comments entered.Storage LocationThis is the storage location of the itemExpected DateDefaulted to today's dateSource NoIf voucher is associated to other transaction, this displays the record no of the source transactionBOLBill of Ladding no1099 FormThis displays the form in which voucher transaction will be included in the 1099 report1099 CategoryAvailable only for 1099 MISC, 1099 PATR and 1099 MISC

.

Page tree

Versions Compared

Old Version 1

New Version Current

Key