receivings

 

Product Receiving transactions are used to receive products from vendors or farms. The selected farm or other facility will need to be set up as a Vendor if products will be received from them. A receiving transaction can only be created from an open, posted purchase order. The receiving transaction determines the value of the product based on the costs defined in the purchase order. If the receiving transaction is multi-currency, the exchange rate will be established based on the rate that is in effect at receiving.

 

A Purchase Order must be created prior to creating a receiving transaction.

The following procedures are outlined in the Product Receivings document:

 

Create a Product Receiving Transaction

Product Receiving Header

The receiving header contains the base data to outline the product receiving. The header is divided into three sections to group the data. Most of the information, with the exception of the fields in the General tab, is derived from the associated purchase order.

 

 

  1. In BMTS>BIM>Transactions>Products, select Receivings.
  2. In the Product Receivings main index, click to create a new receiving transaction.

General

The General tab contains the details related to the product receiving.

 

  1. In the Product Receiving screen, click on the General tab.
  1. From Farm No, select the farm where the product will be received.
  2. From Vendor No, enter or select the code for the vendor that is receiving the product.
  3. Haulage Vendor No is an optional field that allows the user to select the haulage vendor in order to filter the purchase order selection list to only include purchase orders with a combination of the product vendor and the haulage vendor no.
  4. Trans Date displays the date the transaction was created, and the date that the product was received into inventory. This will also represent the accounting date.
  5. Event Date displays the date the transaction occurred. Event Date defaults from Trans Date with an option to modify. The event date does not affect inventory or accounting transactions.
  6. Ref No is a unique reference number used to identify the inventory product. This can be automatically or manually entered.
  7. Trans Time displays the time the transaction was created.
  8. Selecting the Void flag will cancel the receiving transaction.
  9. In the Comments field, enter any additional information related to the transaction.

Wt Scale Reading

The Wt (Weight) Scale Reading tab contains information related to the weight scales, if applicable. The fields in the Wt Scale Reading tab are derived from the purchase order, if necessary.

 

  1. Vehicle No is an optional field to enter the vehicle that delivered the product. Vehicles are defined: in Admin>Business>General>Definitions>Vehicles.
  2. Scale No is an optional field to enter the scale on which the truck was weighed. Select the scale from the drop-down menu, if desired. Scales are defined in: Admin>Business>General>Definitions>Weight Scales.
  3. External Vehicle is an optional field to identify an external vehicle that delivered the product. This is a text field with no validation.
  4. External Driver is an optional field to identify an external driver that delivered the product. This is a text field with no validation.
  5. Gross Zero/Gross Zero Weight Button is used if a zero weight is required.
  6. Gross Zero Weight Date Time indicates the date and time that the gross zero weight was recorded.

  7. Gross Zero Weight Scale Ref is a reference number generated from the scale for the gross zero weight.

  8. Gross Button is the total weight of the vehicle and the product. The button is used if there are scales integrated to the receiving process.  This field can be manually entered or interfaced from a scale.

  9. Gross Wt Date Time displays the date and time that the gross weight was recorded at the scale.

  10. Gross Wt Scale Ref displays the reference number for the gross weight scale reading.

  11. Tare Zero Weight Button is used if a tare zero weight is required.

  12. Tare Zero Weight Date Time displays the date and time that the tare zero weight was recorded at the scale.

  13. Tare Zero Weight Scale Ref is a reference number generated from the scale for the tare zero weight.

  14. Tare/Tare Button is the tare weight of the vehicle. This field can be manually entered or interfaced from a scale.

  15. Tare Wt Date Time displays the date and time that the tare weight was recorded at the scale.

  16. Tare Wt Scale Ref displays the reference number for the tare weight scale reading.

  17. Net is the difference between gross and tare. This field can be manually entered or, if weights are entered, it is calculated automatically.

  18. Status is automatically set in the process when the vehicle is weighed. Available options are: No Weight, In  Process, and Complete.

Derived

The fields in the Derived tab default from the purchase order with no option to modify.

  1. Record Type displays the type of receiving transaction and will default to 'Farm'.
  2. Farm Type displays the type of farm.
  3. Cost Center No displays the cost center where the product will be received.
  4. Cost Center Name displays the name of the center where the product will be received..
  5. Farm Name displays the name of the farm that is receiving the product.
  6. Vendor Name displays the name of the vendor that is receiving the product.
  7. Haulage Vendor Name displays the name of the haulage vendor, if applicable.

Receiving Details

After completing the header of the product receiving transaction, the Details tab also must be completed in the creation process.

  1. Click on the Details tab and select to create a new line detail.
  2. The Purchase Order Inventory dialog box will appear.

 

 

  1. Select the required purchase order and in the Vendor Units Received field, enter the number of vendor units to be received.
  2. Click 'OK'.

 

 

  1. Complex PO No indicates the purchase order that is being received. Purchase orders must be in 'Posted' status. Purchase orders will be filtered based on the cost center and vendor selected in the header.
  2. Product No displays the unique pre-defined number of the product that is being received.
  3. Product Name displays a description of the product.
  4. Vendor SKU No indicates the vendor product being purchased.
  5. Vendor SKU Name displays the name of the vendor product.
  6. Lot No is a unique identification number for the product, and is generally used for medications and vaccinations.
  7. Location No indicates the location where the product is stored.
  8. Units Received indicates the number of units received. The will default based on the units entered in the Purchase Order Inventory dialog box.
  9. Unit Description displays a description of the unit. This will default from the selected vendor sku that is being received, and cannot be modified.
  10. Units Per indicates the number of units per order. This will default from the selected vendor sku that is being received, and cannot be modified.
  11. Quantity displays the amount of units required for the receiving transaction.
  12. Amount is a calculated field representing the product amount prior to add-ons and taxes. Amount = Vendor Units x Unit Price.

 

  1. Expiration Date represents the date that the product expires.
  2. Total Add Ons represents the total amount of the assigned premium add-ons that are defined in the child gird.
  3. Total Discounts represents the total amount of the assigned discount add-ons that are defined in the child gird.
  4. Total Taxes represents the total amount of applicable taxes assigned to the line item.

  5. Total Amount is a calculated field that represents the total value of the receiving. Total Amount  = Amount + Total Add Ons - Total Discounts + Total Taxes.

  6. Free Quantity displays the amount of free units being received.

  7. Total Quality displays the total amount of units being received, including any free units.

  8. Bill of Lading is an optional reference number on the shipping document that identifies the transaction

  9. In the Comments field, enter any additional information related to the line item.

  10. Currency No indicates the currency used on the transaction and defaults based on the currency assigned to the purchase order as defined, with no option to modify. The currency rate will be determined based on the rate that is in effect for the Trans Date.

  11. Currency Name displays a description of the currency.

  12. The Prepaid Final Receiving flag will be selected if the purchase order is a Prepaid Purchase Order.  If the product has multiple shipments or receivings, check the Prepaid Final Receiving flag to indicate that this is the last receiving transaction.

 

Additional Details

Within the Details tab, there is a child grid with additional details relating to the receiving add-ons. The details will default from the purchase order.

 

Premium and Discount Add-Ons

The add-ons must be pre-defined in General>Products>AddOns prior to adding to the receiving transaction. 

 

  1. Click  on the Complex No PO tab to display the child grid.

 

 

  1. Product No displays the code of the selected add-on.
  2. Product Name defaults from Product No and displays a description of the add-on.

  3. Transaction Basis is a read-only field that defaults from the selected add-on and determines how the add-on is calculated on orders. Options are: Per Unit, Percentage, Flat Rate, or Free Percentage.

  4. Payment Type is a read-only field that derives from the purchase order and determines when the add-on payment is made.

  5. Payee Type is an optional field that indicates the source type for the premium or discount add-on.

  6. Transaction Entity ID is a required field if a different Payee Type is selected. If Payee Type is set, the selected  vendor or cost center name will appear in this field.

  7. Pay Calculation Type defaults from the vendor sku and determines the base amount of the add-on calculation.

    1. Product Amount - the add-on is calculated based on only the product amount and does not include any other add-on in the calculation of the amount.

    2. Net Amount - the add-ons is calculated based on the net amount of the transaction based on the product amount including other add-on amounts, but excluding taxes.

  8. Vendor Calculation Type  determines if the payment is calculated based on the base add-on logic using Transaction basis or if the add-on amount is only deducted from the vendor payment.
      1. Normal - the add-on is calculated based on the rules established by Transaction Basis and the Payment Type defined in the vendor SKU and sales SKU.

      2. Deduction Only - the add-on is calculated based on the rules established by Transaction Basis, however the add-on is only deducted from the vendor payment.

  9. Taxable identifies if the item is taxable or non-taxable when the add-on is purchased.

  10. Currency No defaults based on the currency assigned to the purchase order as defined, with no option to modify.

  11. Currency Name defaults from Currency No and displays a description of the currency type.

  12. Amount displays the total cost of the add-on.

 

Taxes

If the product and/or premiums/discounts are taxable, the tax code must be assigned on the Taxes tab. The tax amount will then be calculated based on the taxable order amounts.

 

 

  1. Tax Codes identifies the tax code to be applied to the product and premiums/discounts for the selected line item. The Taxable flag must be selected in the product and premiums/discounts for taxes to calculate.

  2. Tax Name describes the selected tax code.

  3. Amount is the total amount of tax applicable on the product.

Post a Product Receiving Transaction

Once the Product Receiving transaction has been created and saved, the transaction needs to be posted. The posting process locks the receiving transaction to prevent edits, and creates the journal transaction to record the liability. The UnPost option unlocks the receiving transaction and reverses the journal transactions.

 

  1. In the Product Receivings main index, select the required receiving transaction and right-click to select 'Post'. Alternatively, click the green check mark in the top menu bar and select 'Post'.
  2. To un-post a product receiving transaction, select the required transaction and right-click to select 'Unpost'.  This process will set the transaction status to 'Reversed' status, which allows the transaction to be edited.

Journal Transaction

The posting process creates the journal transaction. The journal will record the product to inventory and create the accounts payable accrual.

 

DEBIT Farm Product Inventory
CREDIT Accounts Payable Accrual