/
Item-

Item-

Field

Description

Field

Description

1

Accounting Variable 1, 2, 3, 4

Default accounting variables to populate transactions.

2

Average Base Cost

The calculated average cost for the Base Unit of Measure of the item. (Inventory Value / Qty. Based on Hand)

3

Base Unit of Measure

The Base Unit of Measure for the item's inventory, such as EA, or LB.

4

Base UOM Record Id

Used to define the record Id from the Item Unit of Measure object for the Base Unit of Measure of the item.

5

Batch Consumption Tolerance %

When consuming this item on a batch manufactured work order, enter the tolerance % permitted.

6

Batch Manufacturing

If checked, the Item is a batch manufacturing parent item.

7

Batch Output Tolerance %

When producing this item, enter the tolerance % to be used on a batch manufacturing work order.

8

Blocked

If checked, no new transactions are allowed to be posted for this item. An Item cannot be blocked unless there is 0 on hand qty. and 0 open transactions.

9

Brand

10

Brand Text

 

11

Catch Weight

If checked, the item is a catch weight item.

12

Catch Weight Tolerance %

If this is a Catch Weight item, enter the tolerance % allowed between the Quantity and the Qty. Base of a Catch Weight item when processing transactions.

13

Chargeback

If checked, the item is a chargeback service item.

14

Configurator1-10

If Use Configurator is checked, the values of these fields are used to construct Item No.

15

Costing Method

The costing method of the Item with two possible options: Standard or FIFO.

16

Country of Origin

The Country where the item is purchased or manufactured.

17

Daily Capacity

Hours Per Day multiplied by No of Capacity.

18

Default Batch Size

The conversion factor of the Default Batch Unit of Measure.

19

Default Batch Unit of Measure

The default Batch Unit of Measure for the batch manufactured item.

20

Default Bin

Define the bin to be used along with the Default Warehouse as the put-away and storage location of the item.

21

Default Shelf

The default Shelf of the item. This is a text field to be printed on the Pack List document. In certain environments, it is more efficient to use a text field to specify where the item is, instead of setting up a full bin management system.

22

Default Warehouse

The default warehouse of the item.

23

Description

Use this field for the description of the item.

24

Disassemble When Receive

If checked, as soon as the item is received on a Whse. Receipts, a dissemble Item Journal will be created and posted to consume the item and output components to inventory.

25

Discontinued

If checked, the item will not be allowed to be entered to Sales Order and Purchase Order.

26

Do Not Check Output Qty.

Used if Report by Routing Step is checked on the Item. If this field is checked, GoldFinch not allow over or under production between routing steps.

27

Do Not Check Qty. When Post

The system administrator can be notified Qty Base on Hand, Qty. Base on Bin Content and Remaining Qty. Base on Hand of the item are the same during the inventory posting routine.

28

Expected Value

The total calculated inventory value of the 'received not invoiced' and 'shipped not invoiced' value based on the Item Ledger Entries.

29

Flushing Method

If Flushing Method = Manual, both output and consumption are posted together on production journals. If Flushing Method = Backward, multiple outputs can be posted using the Daily Production screen, and all of the expected consumption can be posted based on the total output quantity before the work order is finished.

30

Freight Class

This will print on the Bill of Lading.

31

GL Ledger

Populate a default value for transactions if Multiple Ledger feature is enabled.

32

Handling Unit Type

This will print on the Bill of Lading.

33

HazMat

This will print on the Bill of Lading.

34

HazMat Class

This will print on the Bill of Lading.

35

Hours Per Day

Hours per day a Work Center is available to operate.

36

HS Tariff Classification No.

This will print on the Certificate of Origin document.

37

Import Item

38

Indirect Cost %

Used to calculate Indirect Capacity Cost for the Work Center on the Production Journal.

39

Inventory Class

Three possible values: Raw Materials, Subassembly or Finished Goods. This field will define what GL Account is used from the Company Setup. Do Not Change the Picklist Value.

40

Inventory Value

The calculated inventory value of the item based on the Item Ledger Entries. This will be the total of the Expected Value and the Invoiced Value.

41

Invoiced Value

The total calculated invoiced value of the item based on the Item Ledger Entries.

42

Is Allergen

If checked, this item is an allergen. The field is printed on the Receipt Label report.

43

Is Water

If checked, this item is a water item. The net requirement of the water item for a work order is the total gross requirement for the water, less the water quantity already exists for the components that have the active Ingredient % defined on the item formula.

44

Item Category

Use this field to classify items for filtering and reporting.

45

Item Image

46

Item No.

 

47

Item No.-Description

48

Item Posting Group

You can choose to set up the Accounting Posting Setup by Item Posting Group instead of by Item.

49

Item Type

Two possible values: Inventory or Service. Inventory transactions will be tracked for Inventory items, but not for Service type items. Do Not Change the Picklist Value.

50

Landed Cost1-5 %

Used for accrual method of landed cost management.

51

Last Invoiced Base Cost

The last base cost the item was invoiced at or produced at.

52

Last Rollup Date

The last date the Rollup Std. Cost function was run for the item.

53

Lead Time Days

Default for SKUs to be used on Supply Planning.

54

Long Description

Optional field. It can be used with the integration with an E-Commerce platform.

55

Lot Days to Expire

The default number of days a newly entered lot will expire.

56

Lot Picking Option

Define the preferred method of picking lots: FIFO (first in first out), FEFO (first expiration first out), or Bin Ranking. Do Not Change the Picklist Value.

57

Lot Tracked

If checked, a Lot number is mandatory for all inventory transactions.

58

Low Level Code

This is the calculated hierarchical level of the item based on Item Formulas. The lower the number, the higher the hierarchical order. Click Item Calculate Low Level to learn more.

59

Manufacturer

Default manufacturer of the item from the lookup to the Account object.

60

Maximum Quantity

The default maximum quantity of the item for reporting purposes. This value is not currently used in the supply planning calculation.

61

Min. Days to Expire When Pick

The minimum number of days allowed to pick an item before the lot will expire.

62

Net Cost

This will be printed on the Certificate of Origin document.

63

NMFC

This number will be printed on the Bill of Lading.

64

No. of Capacity

Number of machines or work areas available at this Work Center.

65

Non-Sellable

If checked, these items will not be available when searching on Sales Quote, Sales Order, Sales Invoice, and Transfer Order.

66

Old Item No.

The Item number from the legacy system.

67

Outbound Freight

If checked, this service item is used for outbound freight.

68

Outside Service

If checked, this service item is used as an outside service item.

69

Package Type

This will be printed on the Bill of Lading.

70

Preference Criterion

This will be printed on the Certificate of Origin document.

71

Preferred Vendor

Default for SKUs to be used on Supply Planning.

72

Producer

This will print on the Certificate of Origin document.

73

Product Family

Used for classifying items for filtering and reporting.

74

Product Group

Used for classifying items for filtering and reporting.

75

Purchase Description

It will be used on the Purchase Order if it is not blank.

76

Purchase Unit of Measure

Enter the default Unit of Measure to be used on purchase orders.

77

Purchasing Agent

The default Purchasing Agent for the item if applicable.

78

Purchasing Type

The default Purchasing Type for the Item. It is populated on the Sales Line. Do Not Change the Picklist Value.

79

QC Required

Checking this field will require quality control tests to be performed when receiving or producing the item.

80

Qty. Allocated Base

Total Qty. allocated in the Base Unit of Measure for the item.

81

Qty. Available Base

Total Qty. on Hand Base minus Qty. Allocated Base.

82

Qty. Base on Bin Content

The base quantity of the item calculated from all bin content records.

83

Qty. Base on Hand

The base quantity on hand of the item calculated from all item ledger entry records.

84

Qty. Per Pallet

Used on the Daily Production page for the output reporting.

85

Remaining Qty. Base on Hand

The remaining base quantity on hand of the item calculated from all open item ledger entries.

86

Rental Item

Check this field to enable the Rental Management functionality for this item.

87

Reorder Cycle Days

Default for SKUs to be used on Supply Planning.

88

Reorder Policy

Default for SKUs to be used on Supply Planning.

89

Reorder Quantity

Default for SKUs to be used on Supply Planning.

90

Replenishment System

Default for SKUs to be used on Supply Planning. Do Not Change the Picklist Value.

91

Report Output by Routing

If checked, an Output Journal is created for each Routing Step, instead of for the Work Order.

92

Safety Stock

Default for SKUs to be used on Supply Planning.

93

Sales Unit of Measure

Enter the default Unit of Measure to be used on sales orders.

94

Serial No. Series

The numbering series to be used for the serial numbers created for the item.

95

Serial Tracked

If checked, this item requires serial number for all inventory transactions.

96

SF Product

SF Product that is linked to the item. SF Product will be automatically created if SalesCloud integration is enabled.

97

Short Description

Optional field. It can be used with the integration with an E-Commerce platform.

98

Single Batch Printing

If checked, the Batch Report on Work Order will print this item batch by batch.

99

Standard Base Cost

The Standard Base Cost for the item.

100

Standard Base Price

The Standard Base Price for the item.

101

Standard Capacity Base Cost

The Standard Capacity Base Cost for the item. It can be populated when posting Standard Cost Worksheet.

102

Standard Material Base Cost

The Standard Material Base Cost for the item. It can be populated when posting Standard Cost Worksheet.

103

Standard Profit

The calculated standard profit of the item. (Standard Base Price minus Standard Base Cost)

104

Standard Profit %

The calculated standard profit percentage of the item. (Standard Profit divided by Standard Base Price)

105

PO Qty. Tolerance %

For Purchase Inventory Item, percentage allowed for over receipt. For Purchase Service Item, percentage allowed for over invoice. For Work Order Item, percentage allowed for overproduction.

106

Tax Group

The Tax Group for the Item used to calculate Sales Tax.

107

Technical Sheet

Default Technical Sheet for the Item.

108

Total Capacity

Sum of all Capacity created for this Work Center.

109

Total Remaining

Remaining Capacity after Usage is subtracted.

110

Total Usage

Sum of all Usage created for this Work Center.

111

UPC

This should be the GTIN for the Base Unit of Measure and it is used mainly for reporting. GTIN on the Item Unit of Measure is used for scanning.

112

Uploaded to Shopify

If checked, the item has been uploaded to the Shopify website.

113

Uploaded to WooCommerce

If checked, the item has been uploaded to the WooCommerce website.

114

Use Configurator

If checked, GoldFinch can use Configurator 1 to 10 to construct Item No.

115

Weekdays Only

Used in supply planning. If checked, the Order Date will fall on weekdays only.

116

Work Center

If checked, this service item is used as a work center for the routing.

 

Related content