Inventory > Transaction Processing > Inventory Movements

Inventory Movements

You use this program to process transactions against your stock items.

These transactions (although unrelated to any sales transaction) do affect the movement of inventory throughout the company. Sales-related transactions are processed using the Accounts Receivable and Sales Order Processing modules.

Toolbar and menu

Field Description
Options  
Preferences Configure default settings that must be used when processing transactions.
Change Period Use the Change Posting Period program to indicate the period to which you want to post the transactions entered for the current run of the program.

You can post transactions to the Current month, Previous month 1 or Previous month 2 providing the access status for the period is set to open and you selected the option: Stock balances > Retain last 12 months’ opening stock balances (Inventory Setup - History tab).

You can only post Adjustments, Bin Transfers and Expense Issues transactions to a previous posting month if you are retaining your last 12 months' opening balances (Inventory Setup - History tab).

Change Date

Indicate the date for which you want to process the transactions for the current run of the program.

This facility should be used with caution - see Transaction Date.

New Select this to add a new transaction.
Transaction type

Select the transaction you want to process.

This defaults to your selection at the preference: Default transaction type (Preferences).

None of these options can be performed on a stock item defined as a Notional part (Stock Code Maintenance - Descriptive tab).

In line with generally accepted accounting principles, any transaction that could affect the unit cost is only allowed in the current period. Therefore, if you change the processing period to a previous period using the Change Period option, then only the following options are available for posting into a previous period:

  • Adjustments
  • Bin Transfers
  • Expense Issues

Only the transactions to which you have access are available (Operator Maintenance - Security).

Receipts

Select this option to record the receipt of items into stock from your suppliers, usually where a purchase order has not been raised in advance.

This option is not available if you are denied access to the activity: Inventory stock receipts (Operator Maintenance - Security).

Adjustments

Select this to adjust the on hand quantity of an item either positively or negatively.

This option is not available if you are denied access to the activity: Inventory stock adjustments (Operator Maintenance - Security).

Cost Changes

Select this option to change the cost of a stock item.

This option is not available if you are denied access to the activity: Inventory stock cost changes (Operator Maintenance - Security).

Cost Modifications

Select this to adjust the inventory cost of a specific quantity of stock items (e.g. to change the cost of a batch of items received into stock where the cost was incorrectly entered).

This option is not available if you are denied access to the activity: Inventory cost modifications (Operator Maintenance - Security).

This option is disabled if your company inventory costing method is set to FIFO or Standard, or you selected FIFO valuation (Inventory Setup). If you selected Costing per warehouse (Inventory Setup - General tab) and you did not select FIFO valuation, then the Cost Modifications option is enabled, but you cannot perform a cost modification against a warehouse with a costing method defined as Standard (Warehouse Maintenance).

Transfers OUT Select this to transfer items out of a source warehouse. These items remain in transit until you record the transfer into the destination warehouse.

This option is not displayed if you are denied access to the activity: GIT transfers In/Out (Operator Maintenance - Security).

Transfers IN Select this to receive items in transit into the destination warehouse.

This option is not applicable if you are denied access to the activity: GIT transfers In/Out (Operator Maintenance - Security).

Immediate Transfers Select this to transfer items out of the source warehouse and into the destination warehouse in one transaction.

You would use this option when the transportation time between the warehouses is short; the transfer has already been completed; or if the destination warehouse does not have the facility to record the receipt of the transfer.

If multiple bins are installed (Inventory Setup) and you are not using the full goods in transit transfers facility (Inventory Setup), then you must use this option to transfer ECC items and/or traceable items.

Immediate transfers ignore cost multipliers defined against the warehouse (see Warehouse Maintenance for Stock Code).

No Destination Transfers Select this to transfer stock out of a warehouse, thereby decreasing the stock on hand in that warehouse, specifying a destination warehouse.

You should only use this when you need to write off stock because it was damaged whilst in transit. The transaction type is TRF and the general ledger code defined for transfers at Inventory level is used even if the option to select the ledger code at transaction time is selected.

This transaction should not be required when using the full goods in Transit system, as that provides for this type of functionality.

Physical Counts

Select this to change the quantity of stock on hand to a counted amount.

This option is not available if you are denied access to the activity: Inventory physical count (Operator Maintenance - Security).

You cannot select Physical Counts when:

  • multiple bins are in use in the selected warehouse (Inventory Setup).
  • the item is traceable (Stock Code Maintenance).
  • you selected Previous month 1 or Previous month 2 from the Change Period menu.
Bin Transfers

Select this to record the transfer of items from one bin to another.

This is not available if you are denied access to the activity: Inventory bin transfers (Operator Maintenance - Security).

Expense Issues

Select this to record the issue of items from inventory for miscellaneous purposes.

This is not available if you have been denied access to the activity: Inventory expense issues (Operator Maintenance - Security).

Backflushing

Select this to record the manufacture of items without using a Work in Progress job.

This is not available if you are denied access to the activity: Inventory backflushing (Operator Maintenance - Security).

You cannot perform this function if the Inventory and Work in Progress modules are not in the same month and year.

A stock item defined as a Co-product (Stock Code Maintenance - Descriptive tab) can only be backflushed on a route on which it has its own structure (i.e. the co-product item is not attached to a notional part).

Print journal Select this to print the Inventory journals created from the posted transactions during the current run of the program.

Once the journals are printed, the system returns you to the main SYSPRO menu.

Alternatively, you can use the Inventory Journal Report program to print the inventory journals.

Post

Select this to post the transaction.

Refer to Processing for processing details when using Actual Costing.

Post

This screen is displayed when you select the Post option.

Field Description
OK to post transaction?  
OK Select this to post the transaction.

If you are processing a Transfer in and you changed the quantity for a serialized or a lot traceable item, then the GIT Lots and Serials Query program is displayed.

Cancel Select this to return to the previous screen without posting the transaction.

Preferences

You use the Preferences option from the Options menu to configure default settings that must be used when processing transactions within the Inventory Movements program.

Field Description
Default transaction type Indicate the default type of transaction you want to process when processing Inventory movements.

The entry in the Transaction type field defaults to your selection at this preference.

If you are denied access to process the preferred transaction type (Operator Maintenance), then the entry in the Transaction type field defaults to the first transaction type you are allowed to process.

Clear reference/notation after each transaction Select this to clear all text in the Reference and Notation fields after each transaction is posted. If you do not select this option then your last entry made at these fields is retained for the next transaction.
Clear serial number field after entry

Select this to clear the Serial number field of the Serial Entry for Receipts program after each entry when entering serial numbers for a receipt. The field is cleared when you select the Add option.

If you do not select this option, then the previous serial number you entered remains displayed in the Serial number field of the Serial Entry for Receipts program.

You typically select this option if you are using a scanning device to automatically record serial numbers.

Give warning when processing a kit receipt Select this to be warned whenever you process the receipt of a kit item.
Give information about generated lot Select this to display information about generated lots.
Warn if transferring lots with different dates

Select this to be able to process a bin transfer transaction when the same lot number is stored in two separate bins, but the expiry date against the lot number is different in each bin.

This preference is only enabled if the activity: Warn if lot has different dates is allowed against your operator code (Operator Maintenance - Security).

Give warning about blank concession number entered Select this to be notified whenever a blank concession number is assigned to a transaction.
Warn if transferring bin on hold

Select this to display a warning message when processing a bin transfer and the From bin or To bin is on hold. You can accept the warning message and still process the transaction.

If you do not select this preference, then you cannot process a bin transfer transaction when either the From bin or To bin is on hold.

Prompt for posting Select this to be prompted you to confirm the posting of transactions. If you do not select this option, then transactions are posted automatically when you select the Post option.
Backflush level  
All Select this to default to issuing components from all levels in the bill when using the backflushing facility.
First Select this to issue components from the first level of a bill only when using the backflushing facility.
Exclude comps/ops against a bought out part Select this to default to ignoring components and operations held against a bought out item.
Goods in Transit transfer in You can only access these fields when the full Goods in Transit transfers facility is installed (Inventory Setup).
Automatically set line to complete Select this to enable the Transfer complete by default when you process a Transfer IN at the target warehouse.
Use default warehouse bin location

Select this to default to using the bin location held against the warehouse assigned to the stock item when processing a Transfer In. If you do not select this option, then you must specify a bin location to use.

You can enter a different bin when processing the transfer in transaction.

Bin location to use Enter the default bin location to use if you did not select the preference: Use default warehouse bin location. You can enter a different bin when processing the Transfer In transaction.
Create bin location if not on file

Select this to automatically create the bin location if it does not exist.

Your selection at the option: Allow creation of bins when processing inventory transactions (Inventory Setup) does not apply in this case.

Use stock description from originating SCT

Select this to display the stock description entered when the SCT was created using the Sales Order Entry program and not the description defined against the stock item (Stock Code Maintenance) when receiving in the transfer.

If you do not select this preference, then the description defined against the stock item is always displayed when receipting in the transfer, irrespective of whether a different description was entered when using the Sales Order Entry program.

Update originating order with GIT receipt details Select this to automatically release a normal sales order which was placed into back order when you process a GIT receipt.

This only applies if you created a SCT from a normal sales order which was placed into backorder due to insufficient stock.

Goods in Transit transfer out You can only access these fields when the full Goods in Transit transfers facility is installed (Inventory Setup) and
Print multiple lines per GIT document

Select this to print one transfers out document that contains multiple lines processed against a GIT reference for the current run of the program. The document is printed when you select the Last transfer before printing option that is displayed when you select to post the transaction.

If you do not select this option, then a separate transfers out document is printed for each transaction processed against a GIT reference for the current run of the program.

This option applies only if you indicated that you require Transfers out documents to be printed on-line (Inventory Setup).

Give warning if lot is on hold

Select this to be able to allocate lots that are on hold when processing a GIT Transfer Out transaction.

This preference is only enabled if the activity: GIT Transfer of lots on holdis enabled against your operator code.

Save

Select this to save the preferences against your operator code, until next you change them.

Close Select this to save the preferences for the current run of the program only.

Transaction Date

You use the Change Date option from the Options menu to set the date that must be used for the transactions for the current run of the program.

Transaction Date

The transaction date defaults to the current system date, if you selected the option: Set accounting date to system date (Operator Maintenance). The transaction date is used as the journal start date and the inventory movement date.

For example, if the transaction extends over two days (e.g. the processing of the transaction begins before midnight and ends after midnight) then the actual date of posting is used instead of the date on which the program was loaded. In this example, the date after midnight is used as the transaction date.

[Note]

We recommend that you exercise caution when setting the transaction date.

A number of programs provide the facility to change the date that must be used for the transaction.

If you change the transaction date manually, then the entered date is used regardless of the actual date on which the transaction is posted.

Regardless of the date you enter, however, the transaction is posted to the General Ledger period that matches the period of the module at the time the transaction is posted (i.e. posting to the General Ledger is period-driven, not date-driven).

Because reports are date-driven, changes to the transaction date can affect the information that is included in the report.

Inventory Movements

This screen is displayed when you select the Change Date option from the Options menu.

Field Description
Transaction date  
OK Select this to set the transaction date to the date you entered.
Cancel Select this to return to the previous screen without changing the transaction date.

Receipts

You use the Receipts option to record the receipt of items into stock from your suppliers, usually where a purchase order has not been raised in advance.

If FIFO costing is required for the company or the warehouse into which the receipt is being processed (Inventory Setup), then processing a receipt automatically creates a new FIFO bucket.

Field Description
Transaction details  
Warehouse

This indicates the warehouse against which you want to process the transaction.

[Note]

If you have configured a default warehouse at operator or company level, then it is displayed here automatically. The operator default takes precedence.

Stock code This indicates the item against which you want to process the transaction.
Description This indicates the description defined against the Stock code (Stock Code Maintenance).
Long description This indicates the long description defined against the stock code (Stock Code Maintenance). It enables you to verify that you entered the correct stock code.
Quantity

This indicates the quantity of items that you are receiving into stock. You can specify a negative quantity (i.e. to indicate a reversal of a previous receipt) providing there is enough on hand stock available.

If your Costing method is set to Average and you selected the option: Do not calculate average cost on negative receipt (Inventory Setup - General tab), then the average cost of the stock item is not recalculated when you process a negative receipt. In this case, the variance between the current average cost and the cost entered is posted to the Warehouse variance account defined against the warehouse to which the stock item belongs (see Warehouse Maintenance).

If your Costing method is set to FIFO and you selected the option: Use zero cost bucket for returns (Inventory Setup - Options tab), and you are processing a negative receipt, then if the FIFO bucket selected by the program has a zero cost, the returned quantity is added to the FIFO bucket but no change is made to the unit cost of the bucket. If the option: Use zero cost bucket for returns is not selected, then a new FIFO bucket is created with the returned quantity and the current warehouse cost.

If your Costing method is set to FIFO, then when you process a negative receipt and you do not enter a Unit Cost and when prompted 'Do you want to adjust a specific Bin' you select 'No', then the transaction value on the inventory document is calculated as QTY * unit price from the First FIFO bin.

If you are using FIFO/LIFO costing and you enter a negative quantity, you are given the opportunity to process the transaction into a specific FIFO/LIFO bucket (see Adjust Specific Bucket).

Stocking uom This indicates the stocking unit of measure for the stock item.
Revision

Indicate the specific revision to use of the stock item.

You cannot change the revision of serialized ECC items once you have allocated the serial numbers.

This applies only when the stock item is defined as ECC controlled (Stock Code Maintenance).
Release

Indicate the specific release to use of the item.

You cannot change the release of serialized ECC items once you have allocated the serial numbers.

This applies only when the stock item is defined as ECC controlled (Stock Code Maintenance).
Receipt cost This indicates the cost associated with the receipt of the item into stock.
Cost uom This indicates the cost unit of measure for the receipt cost.
Cost basis

Indicate the basis for the receipt cost.

The receipt cost is always entered as a Unit cost when receipting an item into a warehouse that uses standard costing.

Field Description
Unit Select this to indicate that the receipt cost relates to a single unit of the stock item.
Total Select this to indicate that the receipt cost relates to the total value of items received into stock.
Bin location

This indicates the bin location into which the items will be received.

You can enter a single bin or assign items to multiple bins using the Multiple Bins option.

[Note]
  • Items can be assigned to a maximum of 50 bins per transaction.

  • You can only access the Bin location field if the option: Multiple bins is selected (Inventory Setup) and multiple bins are used in the warehouse entered (Warehouse Maintenance).

  • If you indicated that you require on-line documents (Inventory Setup) then you can only enter a single bin.

  • For a positive receipt, you must specify the bin location in which you are going to store the item. If the bin already exists, the receipt quantity is added to the existing quantity in the bin. If the bin does not exist, it is automatically created providing the option: Allow creation of bins when processing inventory transactions (Inventory Setup - Options tab) is selected. If this option is not selected, you must either enter an existing bin or use the Inventory Bin Maintenance program to create a new bin.

    For a negative receipt, you can only select a single bin. In addition, you must enter an existing bin as a bin is not automatically created irrespective of your selection at the option: Allow creation of bins when processing inventory transactions (Inventory Setup - Options tab).

Multiple bins

This option enables you to enter multiple bins against the receipt.

You can only select this option if the option: Multiple bins in use (Warehouse Maintenance) is selected against the warehouse for which you are processing the transaction.

This option is not available when processing a negative receipt. For a negative receipt, you can only select a single bin.

A maximum of 50 multiple bin locations can be entered per transaction.

This option is not available if you are printing inventory documents online (Inventory Setup). The reason is that in online document only a single line is printed, but if you enter multiple bins, a document record is created for each bin entered. If you therefore entered more than one bin, the document printed would be incorrect.

Lot

This indicates the lot to which you want to assign the item.

You cannot receipt the item into an expired lot if the activity: Allow receipts against expired lots is denied against your operator code (Operator Maintenance - Security).

If you selected the option: Lot number to be equal to job number (Lot Traceability Setup) and job numbers are defined as numeric (Company Maintenance - Key Types tab), then the lot number you enter must be numeric.

If you selected the option: Same lot to be used on multiple stock codes (Lot Traceability Setup), then you can reuse the same lot number for different stock codes when processing a receipt.

You can only access the Lot field if:

Concession

This indicates the concession number associated with the lot. A concession number is typically required for traceable stock items and indicates the customer's acceptance of an item that deviates from the original specification, but which is still fit for purpose.

If you need to record a concession number against a lot, then ensure that you enter it during the receipt process as you cannot capture it later. You can select the preference: Give warning about blank concession number entered to display a warning message when you do not enter a concession number.

This field is disabled when processing a negative receipt.

Lot expiry date This indicates the expiry date of the lot.

This field is disabled when processing a negative receipt.

Serial numbers

This option enables you to capture manual and batch serial numbers for any serialized items being received into stock using the Serial Entry for Receipts program.

A maximum of 1000 serial numbers per receipt can be receipted against a single stock code.

Use single ABC type elements

Select this to include pre-production elements in the calculation of costs. These costs are added to the receipt cost entered. Only pre-production elements of cost defined with a calculation method of single are applied.

You can select this option only if you configured your Bill of Material options to include activity based costing.

Reference This enables you to enter a journal reference that is associated with the transaction and which is printed on the Inventory Journal Report.
Notation This enables you to enter a notation associated with the transaction and which is printed on the Inventory Journal Report.
Non-merchandise details

These options enable you to distribute non-merchandise costs related to an inventory receipt.

This option is only enabled if:

  • the option: Apply cost multiplier when processing receipts is selected (Inventory Setup - Options tab)
  • a cost multiplier greater then one is defined against the warehouse for the stock item being receipted (Warehouse Maintenance for Stock Code)
  • the option: Apply cost multiplier is selected (Receipts screen)
Apply cost multiplier

Select this to apply a cost multiplier to the transaction. This enables you to indicate what portion of the transaction value comprises non-merchandise costs (e.g. freight, duty, tax, etc).

You can only select this option if you have configured your Inventory Setup options to apply a cost multiplier when processing receipts and if a cost multiplier value greater than 1 has been assigned to the stock item (Warehouse Maintenance for Stock Code).

The Last cost of the item only includes the cost multiplier value if you selected the option: Include non-merchandise costs in last cost (Inventory Setup - General tab)

Refer to Cost Multiplier Calculations for additional information.

Cost multiplier

This defaults to the cost multiplier defined against the warehouse for the stock item being receipted (Warehouse Maintenance for Stock Code), but can be changed.

This indicates what portion of the transaction value of the stock item comprises non-merchandise costs (e.g. freight, duty, tax, etc.).

Refer to Cost Multiplier Calculations for additional information.

Enter non-merchandise cost Select Yes if you want to enter the actual non-merchandise value, rather than using the value in the cost multiplier field.
Non-merchandise cost

You use this field to enter the actual non-merchandise amount to apply to the transaction.

This field is only enabled when you selected Yes at the Enter non-merchandise cost field.

Non-merchandise distribution Select this option to distribute the non-merchandise cost to specific General Ledger codes (see Non-merchandise Distribution).
G/L Details  
Ledger code

This indicates the ledger account that will be credited with the receipt.

[Note]

You can only access this field if Inventory is linked to the General Ledger and you have configured your Inventory options to request the ledger code for these transactions (Ledger Code Options).

Ledger code description This indicates the description defined against the ledger code.

Multiple Bins

You use the Multiple Bins option to distribute the receipt quantity to multiple bins within the warehouse selected.

You can only select the Multiple Bins option if:

  • the option: Multiple bins in use (Browse on Warehouses) is selected against the warehouse for which you are processing the transaction
  • you have not selected to print receipt documents online (Inventory Setup - Documents tab)
  • you are not processing a negative receipt
  • you are not printing inventory documents online (Inventory Setup). The reason is that in online document only a single line is printed, but if you enter multiple bins, a document record is created for each bin entered. If you therefore entered more than one bin, the document printed would be incorrect.
[Note]

A maximum of 50 multiple bin locations can be entered per transaction.

Field Description
Delete

Select this to remove the highlighted entry from the list of bins allocated.

Save and Close

Select this to accept the information you entered and to return to the previous screen.

Close

Select this to return to the previous screen.

Apply Undistributed

Select this to apply the difference between the total receipt quantity and the total of the quantities already allocated to bins to the current bin.

Bin

Enter the bin location to which you want to assign the item.

If the bin does not exist, it is automatically created providing you are processing a positive receipt and the option: Allow creation of bins when processing inventory transactions (Inventory Setup - Options tab) is selected. If this option is not selected, you must either enter an existing bin or use the Inventory Bin Maintenance program to create a new bin. Bins are not automatically created for negative receipts.

Quantity Enter the quantity of the item you want to assign to the bin location.

Adjustments

You use the Adjustments option to adjust the on hand quantity of an item either positively or negatively.

A positive adjustment quantity increases the item's on hand quantity, while a negative adjustment amount decreases the item's on hand quantity. This option does not affect the unit cost of the item.

Field Description
Transaction details  
Warehouse

This indicates the warehouse against which you want to process the transaction.

[Note]

If you have configured a default warehouse at operator or company level, then it is displayed here automatically. The operator default takes precedence.

Stock code This indicates the item against which you want to process the transaction.
Description This indicates the description defined against the stock code (Stock Code Maintenance).
Long description This indicates the long description defined against the stock code (Stock Code Maintenance). It enables you to verify that you entered the correct stock code.
Quantity

This indicates the quantity of the stock item that you want to adjust. You can specify a negative quantity (i.e. to indicate a reversal of a previous receipt) providing there is enough on hand stock available.

If you are using FIFO/LIFO costing and you enter a negative quantity, you are given the opportunity to process the transaction into a specific FIFO/LIFO bucket (see Adjust Specific Bucket).

You cannot process a negative adjustment into a previous period when using FIFO valuation. The message: There are no FIFO buckets with enough stock available to post this transaction is displayed.

Stocking uom This indicates the stocking unit of measure for the stock item.
Revision

Indicate the specific revision to use of the stock item.

You will be unable to change the revision of serialized ECC items once you have allocated the serial numbers.

This field is only enabled if the stock item is defined as ECC controlled (Stock Code Maintenance).
Release

Indicate the specific release to use of the item.

You cannot change the release of serialized ECC items once you have allocated the serial numbers.

This field is only enabled if the stock item is defined as ECC controlled (Stock Code Maintenance).
Bin location

This indicates the bin location of the item for which you want to adjust quantities.

If you are processing a positive adjustment and the bin does not exist, then it is automatically created providing the option: Allow creation of bins when processing inventory transactions (Inventory Setup - Options) is selected. If this option is not selected, you must either enter an existing bin or use the Inventory Bin Maintenance program to create a new bin.

If you are processing a negative adjustment, you need to enter an existing bin, as the bin cannot be automatically created.

You can only access the Bin location field if the warehouse is configured to use multiple bins (Warehouse Maintenance).

Lot

This indicates the lot number of the item for which you want to adjust quantities.

This only applies to stock items defined as traceable (Stock Code Maintenance - Tracking).

If you selected the option: Same lot to be used on multiple stock codes (Lot Traceability Setup), then the same lot number could be allocated to different stock codes.

Update original quantity received

Select this to update the original quantity received for the lot when adjusting the quantity of a lot traceable item. The OrigQtyReceived in the LotDetail table is adjusted.

When deselected, the original quantity received for the lot does not reflect the adjustment made to the item.

Serial Numbers

This option enables you to capture manual and batch serial numbers for any serialized items being received into stock using the Serial Entry for Receipts program.

You can only adjust an existing serial number (i.e. you cannot create a new serial to which to process an adjustment).

You can only process a positive adjustment against a Manual serialized item if a negative adjustment was previously processed for the item and the item has not yet been sold.

[Note]

A maximum of 1000 serial numbers per receipt can be receipted against a single stock code.

Reference Enter a journal reference that is associated with the transaction and which is printed on the Inventory Journal Report.
Notation Enter a notation associated with the transaction and which is printed on the Inventory Journal Report.
G/L Details  
Ledger code

This indicates the ledger account to which the adjustment amount must be posted. If you process a negative adjustment (reduce stock), then this account is debited. If you process a positive adjustment (increase stock) then this account is credited.

You can only access this field if Inventory is linked to the General Ledger and you have configured your Inventory options to request the ledger code for these transactions (Ledger Code Options).

Ledger code description This indicates the description defined against the ledger code.

Cost Changes

You use the Cost Changes option to change the cost of a stock item.

If you selected the setup option: FIFO valuation (Inventory Setup - General tab), then when you select the Post option, you are prompted to update either the warehouse cost or a specific FIFO bucket with the new cost (see FIFO Valuation).

Field Description
Transaction details  
Warehouse

This indicates the warehouse against which you want to process the transaction.

[Note]

If you configured a default warehouse at operator or company level, then it is displayed here automatically. The operator default takes precedence.

Stock code This indicates the item against which you want to process the transaction.
Description This indicates the description defined against the stock code (Stock Code Maintenance).
Long description This indicates the long description defined against the stock code (Stock Code Maintenance). It enables you to verify that you entered the correct stock code.
New cost This indicates the new cost for the item based on either the unit cost or the total cost of items held on file.
Cost uom This indicates the costing unit of measure for the item.
Cost basis
Field Description
Unit Select to indicate that the entered new cost is applicable to each unit of the item held on hand.

For example: If you enter a new cost of 50, then the unit cost of each item on hand is set to 50.

Total Select to indicate that the entered new cost is applicable to the total number of items held on hand.

For example: If you enter a new cost of 50 then SYSPRO divides this amount by the quantity of the item on hand and updates the unit cost of the item accordingly. Rounding errors are indicated on the Inventory Journal Report.

Update last cost with new cost Select this to update the last cost with the new cost entered.
Reference Enter a journal reference that is associated with the transaction and which is printed on the Inventory Journal Report.
Notation Enter a notation associated with the transaction and which is printed on the Inventory Journal Report.
G/L Details  
Ledger code

This indicates the ledger account to which the adjustment amount must be posted. If you reduce the cost value against the stock item, then this account is debited. If you increase the cost value against the stock item, then this account is credited.

You can only access this field if Inventory is linked to the General Ledger and you have configured your Inventory options to request the ledger code for these transactions (Ledger Code Options).

Ledger code description This indicates the description defined against the ledger code.

FIFO Valuation

When you process a cost change for an item and you selected the setup option: FIFO valuation (Inventory Setup - General tab), then the following is displayed:

[Note]

This prompt is not displayed when you have FIFO valuation and FIFO costing enabled for the warehouse or company. When FIFO costing is in use, the cost of a specific FIFO bucket is used in transactions and not the 'warehouse cost'. The 'warehouse cost' is a weighted average of all the FIFO buckets.

However, if you have FIFO valuation and Standard costing enabled, then you can select to update the warehouse cost or the FIFO bucket cost with the cost change.

Field Description
Do you wish to adjust the cost in a specific bin?

This option enables you to update the warehouse cost or the FIFO bucket cost with the cost change.

If you want to update the cost in both the warehouse and the FIFO bucket, then you need to process two transactions and select Yes for one transaction and No for the other (duplicate) transaction.

Yes Select this to use the FIFO - LIFO Bins for Stock Code program to update the cost of a specific FIFO bucket.

The warehouse value is not affected by the value of the cost change. No inventory journal is created. A FIFO journal is created, but this does not affect your inventory valuation or your General Ledger inventory control accounts.

No

Select this if you want to update the warehouse cost and not the FIFO bucket with the cost change. An inventory journal is created for the transaction and your inventory valuation is affected by the cost change.

You would select this option if, for example, you receipted stock into a warehouse at the incorrect cost and now want to adjust the cost of that stock in that warehouse.

Cancel Select this to return to the previous screen without adjusting either the warehouse cost or a FIFO bucket.

Cost Modifications

You use the Cost Modifications option to adjust the inventory cost of a specific quantity of items (e.g. to change the cost of a batch of items received into stock where the cost was incorrectly entered). The system applies the total change of the entered items to the quantity on hand.

You would normally use this option when you wanted to adjust the cost of a specific number of items that were received into stock.

[Note]

You cannot process Cost modifications if your Inventory costing method is set to FIFO or Standard, or you selected FIFO valuation (Inventory Setup).

If you selected Costing per warehouse (Inventory Setup - General tab) and you have not selected FIFO valuation, then the Cost Modifications option is enabled, but you cannot perform a cost modification against a warehouse with a costing method defined as Standard (Browse on Warehouses).

Field Description
Transaction details  
Warehouse

This indicates the warehouse against which you want to process the transaction.

If you configured a default warehouse at operator or company level, then it is displayed here automatically. The operator default takes precedence.

Stock code This indicates the item against which you want to process the transaction.
Description This indicates the description defined against the stock code (Stock Code Maintenance).
Long description This indicates the long description defined against the stock code (Stock Code Maintenance). It enables you to verify that you entered the correct stock code.
Quantity This indicates the specific quantity of items for which you want to modify the costs.
Stocking uom This indicates the stocking unit of measure for the item.
Previous cost This indicates the current unit cost of the item.
Cost uom This indicates the cost unit of measure for the item.
New cost This indicates the new cost you want to assign to the quantity of the item specified.
Cost basis
Field Description
Unit Select to indicate that the entered new cost is applicable to each unit of the item held on hand.

For example: If you enter a new cost of 50, then the unit cost of each item on hand is set to 50.

Total Select to indicate that the entered new cost is applicable to the total number of items held on hand.

For example: If you enter a new cost of 50 then SYSPRO divides this amount by the quantity of the item on hand and updates the unit cost of the item accordingly. Rounding errors are indicated on the Inventory Journal Report.

Reference Enter a journal reference that is associated with the transaction and which is printed on the Inventory Journal Report.
Notation Enter a notation associated with the transaction and which is printed on the Inventory Journal Report.
G/L Details  
Ledger code

This indicates the ledger account to which the total value of the cost modification must be posted.

You can only access this field if Inventory is linked to the General Ledger and you have configured your Inventory options to request the ledger code for these transactions (Ledger Code Options).

Ledger code description This indicates the description defined against the ledger code.

Transfers OUT

You use the Transfers OUT option to transfer a stock item out of a source warehouse.

Stock on hand is decreased at the source warehouse, while stock is placed in transit for the target warehouse.

The item remains in transit until you record the transfer into the destination warehouse using the Transfers IN option.

If you selected the option: Use full goods in transit transfers facility (Inventory Setup) then:

  • a transfer OUT from a warehouse creates goods in transit records indicating that stock was transferred from the source warehouse to the target warehouse. These records include any lots, bins or serials involved in the transfer.

  • each goods in transit transfer is identified by a reference number which is generated according to your numbering method specified within the Inventory Setup options.

  • an operator preference allows you to print, on a single document, all goods in transit transfers OUT per reference number. The document is printed when you select the option indicating the last transfer before printing.

  • you can select to append lines to an existing GIT reference number provided that it is for the same run of the program (see Goods in Transit Reference).

Field Description
Transaction details  
Warehouse Indicate the warehouse out of which the item must be transferred.

If you have configured a default warehouse at operator level (Operator Maintenance) or at company level (Company Maintenance), then it is displayed here automatically. The operator default takes precedence.

Stock code Indicate the item you want to transfer.
Description This indicates the description defined against the stock code (Stock Code Maintenance).
Long description This indicates the long description defined against the stock code.
Quantity Indicate the quantity of the stock item you want to transfer out of the selected warehouse.

The number of decimals for the quantity is defined against the stock item (Stock Code Maintenance).

Stocking uom This indicates the stocking unit of measure defined against the stock code.
Revision

Indicate the specific revision of the item that you want to transfer.

You cannot change the revision of a serialized ECC item once you have allocated the serial numbers.

This field is only enabled for items defined as ECC controlled (Stock Code Maintenance).

Release

Indicate the specific release of the item that you want to transfer.

You cannot change the release of a serialized ECC item once you have allocated the serial numbers.

This field is only enabled for items defined as ECC controlled (Stock Code Maintenance).

Bin location

Indicate the bin location of the item being transferred.

You must indicate the bin location of the warehouse from which stock is being transferred if that warehouse is defined as having multiple bins (Warehouse Maintenance).

You can only transfer items from one bin at a time. For example: If you wanted to record the transfer of 100 items from bin ABC in warehouse AA, to bins 123 and 456 in warehouse BB, you would have to record the transfer as two transactions.

Lot

Indicate the lot number of a traceable item being transferred.

You cannot transfer traceable items using the Out (no destination) option.

If you selected the option: Same lot to be used on multiple stock codes (Lot Traceability Setup), then the same lot number could have been allocated to different stock codes.

To be able to allocate a lot that is on hold when processing a GIT Transfer OUT transaction, the following must apply:

  • The activity: GIT transfer of lots on hold must be set to allowed against your operator code.
  • You must select the preference: Give warning if lot is on hold.

Lots on hold cannot be allocated if automatic depletion is applied (Inventory Setup).

The hold status of a lot that is transferred between warehouses when you process a GIT Transfer In is retained (i.e. if the lot transferred in is On Hold in the source warehouse it is marked as On Hold in the target warehouse).

New warehouse Indicate the warehouse into which the item must be transferred (i.e. the destination warehouse).

If the stock item does not exist in this warehouse, then the following message is displayed when you select the Post function:

'The destination warehouse does not exist. Do you wish to create it?' is displayed.

The warehouse/stock code link is created when you select OK, providing the warehouse is defined (Warehouse Maintenance) and you have access to the warehouse (Operator Maintenance) and the rule defined against the eSignature Inv Stock warehouse added is met (Electronic Signatures).

Serial numbers

Select this to use the Serial Entry for Receipts program to define the serial number(s) of the item you are transferring.

This option is only enabled when serial tracking is required for the item you are transferring (Stock Code Maintenance - Tracking).

Reference This is the journal reference that is associated with the transaction and which is printed on theInventory Journal Report.

If you are using the full goods in transit system and you set Goods in transit reference to Manual (Inventory Setup), then you are prompted to enter a reference when you save the transaction.

If the Goods in transit reference option is not set to Manual, then this field is disabled as the system generates the reference number automatically.

Notation Enter a journal notation that is associated with the transaction and which is printed on the Inventory Journal Report.
GIT Query Select this to use the Browse on GIT References program to view details held against goods in transit reference numbers.

This option is only available if you selected the setup option: Use full Goods in Transit transfers facility (Inventory Setup).

G/L Details  
Ledger code

This indicates the General Ledger account that will be debited with the transfer value for transfers out and credited with the transfer value for transfers in.

This ledger account would typically be the clearing account for stock transfers.

You can only access this field if Inventory is linked to the General Ledger and you have configured your Inventory options to request the ledger code for these transactions (Ledger Code Options).

Ledger code description This indicates the description defined against the ledger code.

Goods in Transit Reference

If you selected the option: Use full Goods in Transit transfers facility (Inventory Setup), then when you process more than one goods in transit Transfer OUT to the same warehouse during the same run of the program, the following options are displayed when you select the Post option:

Field Description
Append to existing reference

Select this to add the details of the current transfer Out transaction to an existing goods in transit transfer out reference for the same warehouses.

If you do not select this option, then a new goods in transit reference is created for the current transfer out transaction.

Goods in transit reference

Enter a reference number for the goods in transit document for the current transaction.

This field is only enabled if you selected to number goods in transit references manually (Inventory Setup).

Last transfer before printing

This option is only enabled when you select the Preference: Print multiple lines per GIT document. The preference enables you to print one transfers out document that contains multiple lines processed against a GIT reference for the current run of the program.

You select this option to indicate that the current transfer out transaction is the last transaction you are processing for the warehouse combination during the current run of the program and that you want to generate the transfer document.

Print multiple lines per GIT document

Select to be able to print one transfers out document that contains multiple lines processed against a GIT reference for the current run of the program. The document is printed when you select the Last transfer before printing option that is displayed when you select to post the transaction.

If you do not select this option, then a separate transfers out document is printed for each transaction processed against a GIT reference for the current run of the program.

You cannot access the Goods in Transit transfer out fields if the full Goods in Transit transfers facility is not installed (Inventory Setup).

This facility applies only if you indicated that you require Transfers out documents to be printed on-line (Inventory Setup).

GIT Query Select this to view details held against goods in transit reference numbers using the Browse on GIT References program.
Post Select this to process the transaction and optionally print an inventory transfer document using the Inventory Document Print program.
Cancel Select this to return to the previous screen.

Transfers IN

You use the Transfers IN option to record that items in transit are being received into the destination warehouse.

The Transfers IN facility varies depending on whether or not you are using the full good in transit facility (Inventory Setup - General tab).

The following fields are displayed in the Transfers IN pane if you have NOT selected the option: Use full Goods in Transit transfers facility (Inventory Setup - General tab):

Field Description
Transaction details  
Warehouse Indicate the warehouse into which the item must be transferred (i.e. the destination warehouse).

If you have configured a default warehouse at operator level (Operator Maintenance) or at company level (Company Maintenance), then it is displayed here automatically. The operator default takes precedence.

Stock code Indicate the item you want to transfer in.

The item must currently be in transit.

Description This indicates the description defined against the stock code (Stock Code Maintenance).
Long description This indicates the long description defined against the stock code.
Quantity Indicate the quantity of the stock item you want to transfer into the selected warehouse.

The number of decimals for the quantity is defined against the stock item (Stock Code Maintenance).

Stocking uom This indicates the stocking unit of measure defined against the stock code.
Revision

Indicate the specific revision of the item that you want to transfer.

You cannot change the revision of a serialized ECC item once you have allocated the serial numbers.

This field is only enabled for items defined as ECC controlled (Stock Code Maintenance).

Release

Indicate the specific release of the item that you want to transfer.

You cannot change the release of a serialized ECC item once you have allocated the serial numbers.

This field is only enabled for items defined as ECC controlled (Stock Code Maintenance).

Bin location

Indicate the bin location of the item being transferred.

You must indicate the bin location of the warehouse into which stock is being transferred if that warehouse is defined as having multiple bins (Warehouse Maintenance).

You will only be able to supply a bin that does not exist if the option: Allow creation of bins when processing inventory transactions is selected (Inventory Setup) and the transfer quantity is positive.

You can only transfer items from one bin at a time. For example: If you wanted to record the transfer of 100 items from bin ABC in warehouse AA, to bins 123 and 456 in warehouse BB, you would have to record the transfer as two transactions.

Lot

Indicate the lot number of a traceable item being transferred.

If you selected the option: Same lot to be used on multiple stock codes (Lot Traceability Setup), then the same lot number could have been allocated to different stock codes.

The hold status of a lot that is transferred between warehouses when you process a Transfer IN is retained (i.e. if the lot transferred out is On Hold in the source warehouse it is marked as On Hold in the destination warehouse.

Serial numbers

Select this to use the Serial Entry for Receipts program to define the serial number(s) of the item you are transferring in.

This option is only enabled when serial tracking is required for the item you are transferring in (Stock Code Maintenance).

See also Custom form fields for serialized items on transfers.

Reference This indicates the journal reference that is associated with the transaction and which is printed on theInventory Journal Report.
Notation Enter a journal notation that is associated with the transaction and which is printed on the Inventory Journal Report.
G/L details  
Ledger code

This indicates the General Ledger account that will be debited with the transfer value for transfers out and credited with the transfer value for transfers in.

This ledger account would typically be the clearing account for stock transfers.

You can only access this field if Inventory is linked to the General Ledger and you have configured your Inventory options to request the ledger code for these transactions (Ledger Code Options).

Ledger code description This indicates the description defined against the ledger code.

Transfers IN (GIT)

If you selected the option: Use full goods in transit transfers facility (Inventory Setup) then you need to select the GIT transfers to process from a review of outstanding transfers.

The record of outstanding transfers controls the transfer in process.

The GtrDetail record is set to Locked as it is read in to the list of detail records waiting to be processed. This is to prevent two operators trying to transfer in the same information at the same time. It is only released when the transfer process in is complete. It is possible that some records could be left locked if the process has terminated abnormally. The flag is reset by the Inventory Balance GIT balance process - Reset GIT details (Inventory Period End).

You can select to receipt the total quantities transferred, or you can change the receipt quantity to effect a partial receipt.

For a partial receipt, the transfer line can be completed by updating the source warehouse with the difference in stock quantity and posting an adjustment transaction, or by writing off the stock and posting an expense transaction.

If the target warehouse is defined as transfer supplied (Warehouse Maintenance) then the system establishes whether any lead time and/or cost multiplier exists between the two warehouses. Lead time and/or cost multiplier entries defined against a specific stock code/warehouse combination take precedence. If these entries are not defined at stock code level, then the program uses entries defined at warehouse level (Browse on Warehouse Move Matrix). If entries are not located in the matrix then a lead time of zero (0) and a cost multiplier of one (1) is used.

When transferring stock from a non-FIFO costing warehouse into a FIFO costing warehouse and FIFO valuation is in use, the cost against the sending warehouse is used as the receipt cost.

Each goods in transit transfer is identified by a reference number which is generated according to your numbering method specified within the Inventory Setup options.

If you selected the Preference: Update originating order with GIT receipt details and the stock item was linked to a sales order using the Back Order Review program, then the backorder quantity is moved to the shipped quantity field on the sales order when the supply chain transfer is transferred in.

When you process a Transfer In for an SCT created in the Sales Order Entry program and you are using the EC VAT system (Tax Options), an EC VAT arrivals recorded if the source warehouse belongs to an EC VAT company (i.e. when an SCT transfer is transacted from an EC warehouse to a local warehouse within the EU). Note that this only applies to SCTs and not to normal warehouse GITs in.

Normal Transfer journals are created.

See also Custom form fields for serialized items on transfers.

Warehouse Transfers In

Indicate the transfer references you want to display in the review:

Field Description
Start Review Select this to review the selected transactions.
Close Select this to return to the previous screen.
GIT transfer selection  
Warehouse This indicates the warehouse for which you want to review the transfers in.
Notation This enables you to enter a notation associated with the transaction and which is printed on the Inventory Journal Report.
Transfer type selection  
Inventory Select this to review warehouse transfers.
Supply chain Select this to review supply chain transfers.
GIT references  
GIT reference selection Indicate the goods in transit reference numbers you want to include in the review.
Source warehouses  
Source warehouse selection Indicate the source warehouse(s) you want to include in the review.
Stock codes  
Stock code selection Indicate the stock code(s) you want to include in the review.
Creation dates  
Creation date selection Indicate the creation date(s) you want to include in the review.
Due dates  
Due date selection Indicate the due date(s) you want to include in the review.
Product class  
Product class selection Indicate the product class(es) you want to include in the review.

Transfers in for Warehouse Listview

When you select the Start Review option, the transactions you selected are displayed in a listview.

[Note]

GIT transactions which are flagged as being 'In process' are not included in the listview.

If you experienced a problem whilst processing a GIT transfer, you can run the Balance function of the Inventory Period End program and select the option: Balance goods in transit to clear the 'in process' flag. The GITs will then be displayed in the listview.

Column Description
Selected

You use this column to select/deselect the GIT references you want to include/exclude as part of the transfer.

The number of lines you selected to process are displayed at the bottom of the listview.

You can typically use your right mouse button from anywhere in the listview pane to select one of the following options:

  • Change Quantity

    Select this to change the receipt quantity to effect a partial receipt (see Change Quantity for Line).

  • Select All Lines

    Select this to mark all lines displayed as selected.

    You select this option if you want to transfer all displayed lines into the selected warehouse.

  • Deselect All Lines

    Select this to deselect all lines displayed.

    You typically select this option if you previously selected all lines, but now only want to include a few lines in the Transfers IN transaction.

Reference This indicates the journal reference number associated with the transaction.
Stock code See Inventory Query.
Description This indicates the description for the stock code.
Type This indicates whether the line is an inventory or a supply chain transfer.
Source This indicates the warehouse from which the item is being transferred.
Qty transferred This indicates the quantity which was transferred out of the source warehouse.
Qty received This indicates the quantity transferred in to the destination warehouse to date.
Qty outstanding This indicates the difference between the quantity transferred and the quantity received.
Uom This indicates the unit of measure for the transfer.
Due date This indicates the calculated delivery date for the item. Non-working days are not taken into account when calculating this date if the Use absolute days when applying lead time to transfer supplied items option is enabled (Inventory Setup).
Creation date This indicates the date on which the transfer out was created.
Product class This indicates the product class to use for the transaction.
Change Quantity for Line

The following options are displayed when you select the Change quantity option from the Line Details pane or you use your mouse button to select the Change Quantity option from within the listview:

Field Description
Accept and Close Select this to accept the information you entered and to return to the previous screen.

If you changed the quantity for a serialized or a lot traceable item, then when you select the Post option from the main Inventory Movements screen, the GIT Lots and Serials Query program is displayed. The GIT Lots and Serials Query program is not displayed when you receipt in the full quantity.

Cancel Select this to ignore any changes you made and to return to the previous screen.
Quantity change details  
Warehouse This displays the warehouse into which the item must be transferred.
Source warehouse This displays the warehouse from which the item was transferred.
Stock code This displays the stock code for which you are changing the quantity.
Description This indicates the description defined against the stock code (Stock Code Maintenance).
Long description This indicates the long description defined against the stock code (Stock Code Maintenance).
Quantity outstanding

This displays the quantity still outstanding against the transfer in (i.e. the quantity of the item which is currently in transit).

If you have not processed any transfers in, then this field displays the quantity originally transferred out from the source warehouse. If you have processed partial receipts for the item, then this field displays the difference between the quantity originally transferred out and the quantity already transferred in.

Quantity

Enter the quantity you want to transfer in.

You will be unable to process an over receipt into the target warehouse and adjust the quantity in the source warehouse if this would cause a negative quantity in the source warehouse and the option: Stock on hand allowed to go negative is set to No for the source warehouse (Inventory Setup - General tab).

If you have been denied access to the operator activity: GIT under-receipt of GIT transfers (Operator Maintenance), then you will be unable to mark the transaction as complete if the receipt quantity is less than the quantity outstanding.

Similarly, if you have been denied access to the operator activity: GIT over-receipt of GIT transfers (Operator Maintenance), then you will be unable to mark the transaction as complete if the receipt quantity is more than the quantity outstanding.

Bin location

Specify a single bin the location into which the stock must be receipted in the target warehouse. This is required if the warehouse into which you have transferred the item is defined as having multiple bins (Warehouse Maintenance).

You can only transfer items from one bin at a time. For example: If you wanted to record the transfer of 100 items from bin ABC in warehouse AA, to bins 123 and 456 in warehouse BB, you would have to record the transfer as two transactions.

If the Preference: Use default warehouse bin location is selected, then the bin defined against the stock code's warehouse is the default bin location, but this can be overwritten. If you this preference is not selected, then you must supply a bin location to be used by default. Again, this can be overwritten when processing the transfer in transaction. The bin you ultimately supply must exist unless the Preference: Create bin location if not on file is selected.

Your selection at the option: Allow creation of bins when processing inventory transactions (Inventory Setup) does not apply in this case.

Notation Enter a narration relevant to the quantity change.
Transfer complete

Indicate whether or not the transfer is complete.

If you receipt the total quantity outstanding then the transfer is marked as complete. The in transit quantity for the target warehouse is reduced and the on hand quantity is increased by the receipt quantity.

You cannot access this field if you are denied access to the operator activities: Inventory stock adjustments and Inventory expense issues or if you are denied access to the source warehouse (Operator Maintenance).

Action back to source These options are only available when you process a partial receipt and you select the option: Transfer complete (i.e. the quantity transferred in to the destination warehouse is less than the quantity transferred out of the source warehouse.

Because the transfer is marked as complete, you will not transfer additional quantities in to the destination warehouse for this transaction. These options enable you to specify what to do with the balance of the quantity you have not transferred in to the destination warehouse.

Source transaction  
Adjustment Select this to transfer the balance of the quantity not transferred in to the destination warehouse back in to the source warehouse.
Expense issue

Select this to expense the balance of the quantity. Inventory is reduced by the balance of the quantity and its value.

You typically expense the balance of the quantity if the items were damaged in transit and the cost of returning them to the source warehouse exceeds their value or if the items were sent to the destination warehouse to be used as samples.

Ledger code

Enter the General Ledger code to which the expense issue amount must be debited.

This is only enabled when you select the option: Expense issue.

Ledger code description This indicates the description defined against the ledger code.
Transfer IN Cost Multiplier

The following options are displayed if a transfer cost multiplier is defined for transfers between the warehouses you are processing (see Browse on Warehouse Move Matrix).

Field Description
Processing The following fields are displayed for information purposes:
Reference This indicates the GIT reference you are processing.
Line This indicates the line number on the GIT you are processing.
Stock code This indicates the stock code you are transferring in.
Source warehouse This indicates the warehouse that initiated the transfer.
Apply transfer cost multiplier Select this to apply the transfer cost multiplier to the selected line transfer.
Transfer cost multiplier This defaults to the transfer multiplier defined in the warehouse move matrix for transfers between the selected source and target warehouses (see Browse on Warehouse Move Matrix), but can be changed.
Enter non-merchandise cost

Select this to change the transfer cost calculated by the system.

If you select this option then you can override the default cost displayed in the Non-merchandise cost field.

Non-merchandise cost

This indicates the transfer cost amount to be processed against the item.

Non-merchandise costs are only included in the Last cost of the item if you selected the option: Include non-merchandise costs in last cost (Inventory Setup).

Refer to Cost Multiplier Calculations for additional information.

Save Select this to proceed to the non-merchandise distribution screen.
Skip Item Select this if you do not want to process any transfer amount against this item.
Non-merchandise Distribution

This screen is displayed when you select to apply a transfer cost multiplier.

This enables you to process the transfer costs to the appropriate general ledger code(s).

You will be unable to process the transfer amount(s) to the selected ledger code(s) until the distribution amount is zero.

Refer to Cost Multiplier Calculations for additional information.

Field Description
Delete Select this to delete the distribution line currently highlighted in the listview.
Save and Close Select this to save the information and to return to the previous screen.
Close Select tis to return to the previous screen.
Apply Undistributed Select this to apply the undistributed value to the Amount field of the currently highlighted line.
Reference This indicates the GIT reference against which the transfer cost must be processed.
Ledger code

This indicates the ledger code to which the transfer cost must be processed.

This defaults to the ledger code defined against the GIT warehouse in the GIT warehouse matrix (see GIT Receipt with Apportionment), but can be changed.

Amount This field indicates the transfer amount to be processed to this ledger code.

Line Details

The details displayed in this pane relate to the Goods in Transit line currently highlighted in the listview.

Field Description
Header Details
  • GIT reference (see Browse on GIT References)
  • Operator

    This indicates the code of the SYSPRO operator who processed the Transfer OUT.

  • Transfer type

    This indicates whether the line is an inventory warehouse or a supply chain transfer.

  • Source warehouse

    This indicates the warehouse from which the item was transferred.

  • Target warehouse

    This indicates the warehouse into which the item must be transferred.

Line Details
  • Original quantity

    This indicates the quantity of the item which was originally transferred out of the source warehouse.

  • Received quantity

    This indicates the quantity of the item currently received into the destination warehouse.

  • Outstanding quantity

    This indicates the quantity of the item currently still in transit (i.e. transferred out of the source warehouse, but not yet transferred into the destination warehouse).

  • Change quantity

    Select this to change the receipt quantity to effect a partial receipt (see Change Quantity for Line).

  • Lot/Serials (see GIT Lots and Serials Query)
  • FIFO/LIFO buckets (see Inventory Query of LIFO/FIFO Bins)
  • Transactions (see Transactions for GIT Reference)

Immediate Transfers

You use the Immediate Transfers option to transfer items out of the source warehouse and into the destination warehouse in one transaction.

You would use this option when the transportation time between the warehouses is short; the transfer has already been completed; or if the destination warehouse does not have the facility to record the receipt of the transfer.

During immediate transfers, the 'date of last cost change' is updated to the transaction date only if there is a cost difference in the receiving warehouse.

[Note]
Field Description
Transaction details  
Warehouse Indicate the warehouse out of which the item must be transferred.

If you have configured a default warehouse at operator level (Operator Maintenance) or at company level (Company Maintenance), then it is displayed here automatically. The operator default takes precedence.

Stock code You use this field to indicate the item you want to transfer.
Description This indicates the description defined against the stock code (Stock Code Maintenance).
Long description This indicates the long description defined against the stock code.
Quantity Indicate the quantity of the stock item you want to transfer out of the selected warehouse.

The number of decimals for the quantity is defined against the stock item (Stock Code Maintenance - General).

Stocking uom This indicates the stocking unit of measure defined against the stock code.
Revision

This enables you to indicate the specific revision of the item that you want to transfer.

You cannot change the revision of a serialized ECC item once you have allocated the serial numbers.

This field is only enabled for items defined as ECC controlled (Stock Code Maintenance - Tracking tab).

Release

This enables you to indicate the specific release of the item that you want to transfer.

You cannot change the release of a serialized ECC item once you have allocated the serial numbers.

This field is only enabled for items defined as ECC controlled (Stock Code Maintenance - Tracking tab).

Bin location

Indicate the bin location in the source warehouse from which the item is being transferred.

This is required if the source warehouse is defined as having multiple bins (Warehouse Maintenance).

You will only be able to supply a bin that does not exist if the option: Allow creation of bins when processing inventory transactions is selected (Inventory Setup - Options tab) and the transfer quantity is positive.

You can only transfer items from one bin at a time.

For example: If you wanted to record the transfer of 100 items from bin ABC in warehouse AA, to bins 123 and 456 in warehouse BB, you would have to record the transfer as two transactions.

Lot

Indicate the lot number of a traceable item being transferred.

If you selected the option: Same lot to be used on multiple stock codes (Lot Traceability Setup), then the same lot number could have been allocated to different stock codes.

To be able to allocate a lot that is on hold when processing a Transfer Out transaction, the following must apply:

  • The activity: GIT transfer of lots on hold must be set to allowed against your operator code.
  • You must select the preference: Give warning if lot is on hold.

Lots on hold cannot be allocated if automatic depletion is applied (Inventory Setup - Depletion tab).

The hold status of a lot that is transferred between warehouses when you process a GIT Transfer In is retained (i.e. if the lot Transferred In is On Hold in the source warehouse it is marked as On Hold in the target warehouse).

New warehouse Indicate the warehouse into which the item must be transferred (i.e. the destination warehouse).

If the stock item does not exist in this warehouse, then the following message is displayed when you select the Post function:

'The destination warehouse does not exist. Do you wish to create it?' is displayed.

The warehouse/stock code link is created when you select OK, providing the warehouse is defined (Warehouse Maintenance) and you have access to the warehouse (Operator Maintenance) and the rule defined against the eSignature Inv Stock warehouse added is met (Electronic Signatures).

New bin location Indicate the bin into which the item must be transferred in the destination warehouse.

This is required if the destination warehouse is defined as having multiple bins (Warehouse Maintenance).

You will only be able to supply a bin that does not exist if the option: Allow creation of bins when processing inventory transactions is selected (Inventory Setup - Options tab) and the transfer quantity is positive.

Serial numbers

Select this to use the Serial Entry for Receipts program to define the serial number(s) of the item you are transferring.

This option is only enabled when serial tracking is required for the item you are transferring (Stock Code Maintenance - Tracking).

See also Custom form fields for serialized items on transfers.

Reference Enter a journal reference that is associated with the transaction and which is printed on theInventory Journal Report.
Notation Enter a journal notation that is associated with the transaction and which is printed on the Inventory Journal Report.
GIT Query Select this to use the Browse on GIT References program to view details held against goods in transit reference numbers.

This option is only available if you selected the setup option: Use full Goods in Transit transfers facility (Inventory Setup - General tab).

G/L Details  
Ledger code

This indicates the General Ledger account that will be debited with the transfer value for transfers out and credited with the transfer value for transfers in.

This ledger account would typically be the clearing account for stock transfers.

You can only access this field if Inventory is linked to the General Ledger and you have configured your Inventory options to request the ledger code for these transactions (Ledger Code Options).

Ledger code description This indicates the description defined against the ledger code.

No Destination Transfers

You use the No Destination Transfers option to transfer stock out of a source warehouse, without specifying the destination warehouse details for the item(s) being transferred. This decreases the stock held in the source warehouse.

This can be used to record stock shrinkage, breakage, theft, etc.

[Note]

You cannot use this option for items defined as traceable (Stock Code Maintenance).

Field Description
Transaction details  
Warehouse You use this field to indicate the warehouse out of which the item must be transferred.

If you have configured a default warehouse at operator level (Operator Maintenance) or at company level (Company Maintenance), then it is displayed here automatically. The operator default takes precedence.

Stock code Indicate the item you want to transfer.
Description This indicates the description defined against the stock code (Stock Code Maintenance).
Long description This indicates the long description defined against the stock code.
Quantity Indicate the quantity of the stock item you want to transfer out of the selected warehouse.

The number of decimals for the quantity is defined against the stock item (Stock Code Maintenance - General).

Stocking uom This indicates the stocking unit of measure defined against the stock code.
Revision

Indicate the specific revision of the item that you want to transfer.

You cannot change the revision of a serialized ECC item once you have allocated the serial numbers.

This field is only enabled for items defined as ECC controlled (Stock Code Maintenance - Tracking).

Release

Indicate the specific release of the item that you want to transfer.

You cannot change the release of a serialized ECC item once you have allocated the serial numbers.

This field is only enabled for items defined as ECC controlled (Stock Code Maintenance - Tracking).

Bin location

Indicate the bin location of the item being transferred.

You must indicate the bin location of the warehouse from which stock is being transferred if that warehouse is defined as having multiple bins (Warehouse Maintenance).

You will only be able to supply a bin that does not exist if the option: Allow creation of bins when processing inventory transactions is selected (Inventory Setup - Options tab) and the transfer quantity is positive.

Serial numbers

Select this to use the Serial Entry for Receipts program to define the serial number(s) of the item you are transferring.

This option is only enabled when serial tracking is required for the item you are transferring (Stock Code Maintenance - Tracking).

Reference Enter a journal reference that is associated with the transaction and which is printed on theInventory Journal Report.
Notation Enter a journal notation that is associated with the transaction and which is printed on the Inventory Journal Report.
GIT Query Select this to use the Browse on GIT References program to view details held against goods in transit reference numbers.

This option is only available if you selected the setup option: Use full Goods in Transit transfers facility (Inventory Setup - General tab).

G/L Details  
Ledger code

This indicates the General Ledger account that will be debited with the transfer value for transfers out and credited with the transfer value for transfers in.

This ledger account would typically be the clearing account for stock transfers.

You can only access this field if Inventory is linked to the General Ledger and you have configured your Inventory options to request the ledger code for these transactions (Ledger Code Options).

Ledger code description This indicates the description defined against the ledger code.

Physical Counts

You use the Physical Counts option to change the quantity of stock on hand to a counted amount.

The system replaces the quantity on hand with the new quantity counted. Any variance is recorded in the movement file as a stock adjustment.

[Note]
  • You cannot select Physical Counts if:

    • the selected warehouse is configured for multiple bins (Inventory Setup).

      In that case, you must use the Stock Take System to record any physical changes.

    • the item is traceable (Stock Code Maintenance).
    • you selected Previous month 1 or Previous month 2 from the Change Period menu.

      If you need to adjust the stock on hand position for a previous month, you must use the Adjustments option.

Field Description
Transaction details  
Warehouse

This indicates the warehouse against which you want to process the transaction.

If you defined a default warehouse at operator or company level, then it is displayed here automatically. The operator default takes precedence.

[Note]

Multiple bins cannot be in use in this warehouse (Inventory Setup).

Stock code This indicates the item against which you want to process the transaction.
Description This indicates the description defined against the stock code (Stock Code Maintenance).
Long description This indicates the long description defined against the stock code (Stock Code Maintenance). It enables you to verify that you entered the correct stock code.
Quantity

This indicates the number of items on hand that you have counted.

The system replaces the quantity on hand with the new quantity entered. Any variance is recorded in the Inventory Movement file as a stock adjustment.

Stocking uom This indicates the stocking unit of measure for the item.
Bin location Indicate the bin location in which the item was counted.
Reference Enter a journal reference that is associated with the transaction and which is printed on the Inventory Journal Report.
Notation Enter a notation associated with the transaction and which is printed on the Inventory Journal Report.
G/L Details  
Ledger code

This indicates the ledger account to which the stock count adjustment value is posted. If the stock quantity is reduced then this account is debited. If stock quantity is increased, then this account is credited.

You can only access this field if Inventory is linked to the General Ledger and you have configured your Inventory options to request the ledger code for these transactions (Ledger Code Options).

Ledger code description This indicates the description defined against the ledger code.

Bin Transfers

You use the Bin Transfers option to record the transfer of items from one bin to another.

[Note]
  • You can only process Bin transfers if multiple bins are required (Inventory Setup).

  • There is no link between bins and serials in this program. After processing a bin transfer for serialised items, you need to use the Transaction Posting program to record the serial numbers.

  • The system does not view bin transfers as an inventory movement. Therefore, unless you selected the option: Record movements for bin transfers (Inventory Setup - Options tab), details are recorded only in the journal file (i.e. details are not recorded in the movement file).

  • You will be prevented from processing a bin transfer transaction when either the From bin or To bin is on hold unless you selected the Preference: Warn if transferring bin on hold. In that case, a warning message is displayed if a bin is on hold, but you can elect to continue with the transfer.

Field Description
Transaction details  
Warehouse

This indicates the warehouse against which you want to process the transaction.

[Note]

If you have configured a default warehouse at operator or company level, then it is displayed here automatically. The operator default takes precedence.

Stock code This indicates the item against which you want to process the transaction.
Description This indicates the description defined against the stock code (Stock Code Maintenance).
Long description This indicates the long description defined against the stock code (Stock Code Maintenance). It enables you to verify that you entered the correct stock code.
Quantity

This indicates the quantity of items you want to transfer between bins.

You cannot post a bin transfer transaction if this will cause the bin quantity to go negative and stock is not permitted to go negative (Inventory Setup).

Stocking uom This indicates the stocking unit of measure for the item.
Revision

Indicate the specific revision to use of the stock item.

You will be unable to change the revision of serialized ECC items once you have allocated the serial numbers.

This field is only enabled if the stock item is defined as ECC controlled (Stock Code Maintenance).
Release

Indicate the specific release to use of the item.

You will be unable to change the release of serialized ECC items once you have allocated the serial numbers.

This field is only enabled if the stock item is defined as ECC controlled (Stock Code Maintenance).
From bin This indicates the bin from which you want to transfer items. This bin must already exist on file.
Lot

This indicates the lot number of the stock item that is being transferred.

If you selected the option: Same lot to be used on multiple stock codes (Lot Traceability Setup), then the same lot number could have been allocated to different stock codes.

[Note]

The Lot field is displayed only if the item being transferred is defined as a traceable item (Stock Code Maintenance).

If you want to process a bin transfer when the same lot number is stored in two separate bins, but the expiry date against the lot number is different in each bin, then you must select the preference: Warn if transferring lots with different dates. If this option is not selected, then you will be unable to process the transfer.

To bin

This indicates the bin to which you want to transfer items.

If the bin does not exist, it is automatically created providing the option: Allow creation of bins when processing inventory transactions (Inventory Setup - Options tab) is selected. If this option is not selected, you must either enter an existing bin or use the Inventory Bin Maintenance program to create a new bin.

Reference Enter a journal reference that is associated with the transaction and which is printed on the Inventory Journal Report.
Notation Enter a notation associated with the transaction and which is printed on the Inventory Journal Report.

Expense Issues

You use the Expense Issues option to record the issue of items from inventory for miscellaneous purposes.

The quantity entered is subtracted from the quantity on hand and costed at the current inventory cost.

Field Description
Transaction details  
Warehouse

This indicates the warehouse against which you want to process the transaction.

[Note]

If you have configured a default warehouse at operator or company level, then it is displayed here automatically. The operator default takes precedence.

Stock code This indicates the item against which you want to process the transaction.
Description This indicates the description defined against the stock code (Stock Code Maintenance).
Long description This indicates the long description defined against the stock code (Stock Code Maintenance). It enables you to verify that you entered the correct stock code.
Quantity

This indicates the quantity of items that you want to issue as an expense transaction.

If you enter a negative issue quantity (to reverse a previously issued amount) the negative issue quantity is valued at the current warehouse cost and not at the original issue cost.

If you are using FIFO/LIFO costing and you enter a negative quantity, you are given the opportunity to process the transaction into a specific FIFO/LIFO bucket (see Adjust Specific Bucket).

You cannot process a negative expense issue into a previous period when using FIFO valuation. The message: There are no FIFO buckets with enough stock available to post this transaction is displayed.

Stocking uom This indicates the stocking unit of measure for the item.
Revision

Indicate the specific revision to use of the stock item.

You will be unable to change the revision of serialized ECC items once you have allocated the serial numbers.

This field is only enabled if the stock item is defined as ECC controlled (Stock Code Maintenance).
Release

Indicate the specific release to use of the item.

You will be unable to change the release of serialized ECC items once you have allocated the serial numbers.

This field is only enabled if the stock item is defined as ECC controlled (Stock Code Maintenance).
Bin location

This indicates the bin from which you want to issue the item as an expense transaction.

For a positive issue, you must indicate the bin from which you are going to issue the quantity of the item. You will only be able to supply a bin that does not exist if the option: Allow creation of bins when processing inventory transactions (Inventory Setup - Options tab) is selected and stock is allowed to go negative in the warehouse. This is not applicable to traceable, ECC controlled or serialized items as these may never go negative.

For a negative issue, if the bin does not exist, it is not automatically created, so you must either enter an existing bin or use the Inventory Bin Maintenance program to create a new bin.

Lot

Enter the lot number from which the item being issued as an expense transaction must be taken.

You can only access this field if the item is defined as traceable (Stock Code Maintenance - Tracking).

If you selected the option: Same lot to be used on multiple stock codes (Lot Traceability Setup), then the same lot number can be used for different stock codes.

Serial Numbers

Use the Serial Entry for Receipts program to capture manual and batch serial numbers for any serialized items being processed.

A maximum of 1000 serial numbers per transaction can be processed against a single stock code.

Reference Enter a journal reference that is associated with the transaction and which is printed on the Inventory Journal Report.
Notation Enter a notation associated with the transaction and which is printed on the Inventory Journal Report.
G/L Details  
Ledger code

This indicates the ledger account that will be debited with the value of the expense issue. This ledger code would typically be of an expense account type.

You can only access this field if Inventory is linked to the General Ledger and you have configured your Inventory options to request the ledger code for these transactions (Ledger Code Options).

Ledger code description This indicates the description defined against the ledger code.

Adjust Specific Bucket

This screen is displayed when you process a negative expense issue, a negative receipt or a negative adjustment (i.e. you enter a negative value in the Quantity field) and you are using FIFO or LIFO costing at company level (Inventory Setup) or you are using FIFO costing in the specific warehouse in which the transaction is being processed (Warehouse Maintenance).

Field Description
Do you wish to adjust the quantity in a specific bucket?  
Yes

Select this to use the FIFO - LIFO Bins for Stock Code program to select the FIFO/LIFO bucket into which the quantity must be reversed.

This enables you to reverse the issue in the FIFO/LIFO bucket from which it was issued.

No

Select this if you do not want to specify a specif FIFO/LIFO bucket for the reversal.

If you select this option, then the latest FIFO/LIFO bucket is updated by default.

Cancel Select this to return to the previous screen.

Backflushing

You use the Backflushing option to record the manufacture of items without using a Work in Progress job.

The system uses the manufactured item's bill of materials (see Structures and Routings) to determine the material and labor charges to be included.

Backflushing enables you, in one process, to issue the materials from inventory, apply standard labor costs, and receive the finished good back into stock. This option is particularly relevant in situations where the benefits derived from creating a job to track the activity on the job floor do not justify the cost of processing all the data normally required for a job.

By default, components are issued from the warehouse to use defined against the Bill of Material structure (Structures and Routings).

Before performing the Backflushing transactions, you need to indicate which warehouse you want to issue the components from when backflushing, and the level of backflushing you require.

[Note]
  • Backflushing does not support Manufacturing Units of Measure for any parent items (it always uses the stocking unit of measure). Backflushing uses the stocking values of the components held on the BomStructure table. Components are back flushed in the manufacturing unit of measure when they are set to use the manufacturing unit of measure.

  • Unlike in the Work in Progress module, the “material issues” for the item you are back flushing are done in retrospect (i.e. the item has already been manufactured and therefore should have consumed the materials listed in the BOM).

    Therefore, there is no real material control or traceability when back flushing is used.

Field Description
Warehouse for Components  
Issue from 'warehouse to use'

Select this to issue the components from the warehouse to use assigned to the component (Stock Code Maintenance - Descriptive).

If you do not select this option, then you can use the field to define the warehouse from which the component must be issued when backflushing.

If you select this option, then you must select the option: Ignore warehouses defined on structure record. If you select only the option:Issue from 'warehouse to use' and a warehouse is defined against the bill of materials structure for the component (Structures and Routings), then that warehouse is used.

If you defined a floorstock warehouse (WIP Setup) then this warehouse is used only if you select this option.

Warehouse to issue from

Indicate the specific warehouse from which you require components to be issued.

If you selected the option: Multiple binsin use against the warehouse (Warehouse Maintenance), then the components are issued from the default bin location defined against the specific warehouse (Warehouse Maintenance for Stock Code) you enter here. If insufficient stock is available in that bin, a message is displayed. If stock is available in other bins, then you need to perform a Bin Transfer to transfer the available stock to the default bin defined against the warehouse to issue from.

[Note]
  • If you enter a warehouse to issue from, then you must select the option: Ignore warehouses defined on structure record. If you do not select the option: Ignore warehouses defined on structure record and a warehouse is defined against the bill of materials structure for the component (Structures and Routings), then that warehouse is used.

Ignore warehouses defined on structure record

Select this if you do not want to issue the components from the warehouse to use defined against the bill of materials structure for the component (Structures and Routings).

If you do not select this option, then the components are issued from the warehouse to use defined against the bill of materials structure for the component (Structures and Routings), irrespective of any other Warehouse for components options you selected.

Backflush level  
All Select this to process all levels in the bill of material.
First Select this to issue components only from the first level of the bill of material, regardless of the number of levels in the bill.
Exclude comps/ops against a bought out part

Select this option to ignore components and operations held against a bought out item.

Depending on your manufacturing process, you may require bought out items to be made in, in which case you could assign components and/or operations to the bought out item.

This option enables you to indicate whether you want to process these components and operations at the time of backflushing.

If you select this option and you have stock on hand for the bought out parent item, it will not backflush the components attached to the bought out item.

OK Select this to accept the information you entered and to proceed to the next screen to define the options you require for the receipting of the finished item into stock.
Cancel Select this to ignore any selections you made and return to the previous screen.

Backflushing

When you post a backflushing transaction:

  • The cost is calculated using the materials and labor issued for the backflush.

  • For labor postings to be generated, the Work in Progress module must be installed. If the Work in Progress module is not installed, then the value of operations (both subcontract and internal) is accumulated, together with material costs to calculate the transaction value for the receipt of the parent item. This is the value posted against the receipt journal against the parent item. However, because WIP is not installed, no contra entry (issue journal) for labor can be posted for the operations as the labor journal is not created and the work center efficiency files are not updated.

    If the Work in Progress module is installed, then labor journals are created within the Work in Progress system if any operations are held against the parent item being backflushed.

  • If you are using AB Costing, then when performing a multi-level backflush, the system only issues ABC elements against the parent part or the final part not the components. Therefore the ABC elements need to be associated with bringing the element into stock. The system assumes that the cost of the component item has the relative ABC elements against it and does not recalculate it when the parent part is brought back into stock. When a backflush is performed, the system looks at the component requirements based on the sub-assembly requirements and then issues the required components based on this. It does not first carry out the sub-assembly issue and then the parent part issue. Therefore if there are any ABC Elements attached to the sub-assembly these will not be issued when backflushing is carried out.

  • Inventory journals are created for each material issue.

  • If a by-product is included as a negative material allocation in a parent item, the by-product is receipted into stock as a negative issue transaction.

  • Irrespective of your selection at the setup option: Stock on hand allowed to go negative (Inventory Setup - General tab), items defined as Floorstock (Stock Code Maintenance) which are stocked in the floorstock warehouse (WIP Setup) will always be allowed to go negative when backflushing, regardless of your warehouse settings or costing method.

  • If you are using FIFO/LIFO costing and you enter a negative quantity, you are given the opportunity to process the transaction into a specific FIFO/LIFO bucket (see Adjust Specific Bucket).

  • If you selected Backflush level - All and backflushing finds no stock for a sub-assembly, then it explodes through to the sub-assembly's components to issue (i.e. the sub-assembly is treated as a phantom part). That is, the component of the sub-assembly is issued during backflushing (all levels) if there is no stock of the sub assembly.

    If there is stock of the sub-assembly, then the sub-assembly is issued and not the components.

  • Components on Full hold (Maintain Hold Status) are not back flushed.

  • Components on Partial hold (Maintain Hold Status) are back flushed if you are allowed the activity: Inv Release stock on partial hold (Operator Maintenance) and you select Yes when promoted to backflush the item.

  • ECC controlled components are not back flushed when the job allocation on hold option (Hold material allocations - Change Orders) is selected in an Engineering Change Order (ECO).

  • When backflushing soft phantoms, if there is stock on hand of the soft phantom then this is issued to the parent. If there is no stock of the soft phantom then the components of the soft phantom are issued.

  • The quantity for an ECC controlled item is issued from the oldest revision/release that has a quantity available, when the ECC consumption method for the component is set to Deplete oldest and the option Deplete oldest rev/rel first during Backflushing (Bill of Materials Setup) is enabled.

    If the option Allow issues from multiple rev/rels is also enabled (Bill of Materials Setup), then the next revision/release is depleted if there is insufficient quantity in the oldest revison/release. When this option is not enabled, the oldest rev/rel is not depleted when there is insufficient quantity to issue and the next revision/release with sufficient quantity on hand is used instead.

Field Description
Transaction details  
Warehouse

This indicates the warehouse in to which the parent part must be receipted.

If you configured a default warehouse at operator or company level, then it is displayed here automatically. The operator default takes precedence.

Stock code This indicates the finished part or sub-assembly that you want to backflush (receive into stock).
[Note]
  • You will be unable to backflush a stock code that is configured with a Part category of: Kit part or Planning bill (Stock Code Maintenance).

  • You can only backflush a bought out item if you enabled the option: Allow backflush of bought out items (Inventory Setup).

You cannot backflush a stock item which is on Full hold and you are warned if on Partial hold (Stock Code Maintenance). The latter gives you the option to stop or continue with the transaction.

Description This indicates the description defined against the stock code (Stock Code Maintenance).
Long description This indicates the long description defined against the stock code (Stock Code Maintenance). It enables you to verify that you entered the correct stock code.
Quantity

Indicate the quantity of the item you want to backflush.

If the system encounters sufficient quantity of the components to manufacture the parent item, then it reduces stock by the required amount according to the bill of material structure.

Similarly, if stock on hand is allowed to go negative in the warehouse(s) from which the backflush is processed, the components are issued and stock is reduced by the required amount according to the bill of material structure.

If there is an insufficient quantity of an item and stock on hand is not allowed to go negative in the warehouse(s) from which the backflush is processed, then the backflushing transaction cannot be completed.

If there is insufficient quantity available of a sub-assembled item to manufacture the item and you selected to backflush All levels of the bill, then the system issues the quantity that is available and continues with the next level of the bill of material. It issues enough of the components of the sub-assembled item to make up the required quantity of the sub-assembled item. If you selected to backflush only the First level of the bill of materials and insufficient stock exists for the backflush, then the transaction cannot be completed, unless stock on hand is allowed to go negative (the remainder of the levels is not checked).

If you are using FIFO/LIFO costing and you enter a negative quantity, you are given the opportunity to process the transaction into a specific FIFO/LIFO bucket (see Adjust Specific Bucket).

Stocking uom This indicates the stocking unit of measure for the item.
Revision

Indicate the specific revision to use of the stock item.

You cannot change the revision of serialized ECC items once you have allocated the serial numbers.

This field is only enabled if the stock item is defined as ECC controlled (Stock Code Maintenance).
Release

Indicate the specific release to use of the item.

You cannot change the release of serialized ECC items once you have allocated the serial numbers.

This field is only enabled if the stock item is defined as ECC controlled (Stock Code Maintenance).
Current cost This field displays the current cost per unit of the item. This field cannot be changed when backflushing as it is automatically calculated using the cost of material and labor issued for the backflush.
Cost uom This indicates the costing unit of measure for the item.
Bin location

Indicate the bin location into which the parent item must be received.

If the bin does not exist, it is automatically created providing the option: Allow creation of bins when processing inventory transactions (Inventory Setup - Options tab) is selected. If this option is not selected, you must either enter an existing bin or use the Inventory Bin Maintenance program to create a new bin.

If the default bin against a component is not defined, then the bin is assumed to be the same as the warehouse code.

If multiple bins are not in use for the warehouse from which the backflush is being processed, then this field defaults to the default bin for the warehouse and cannot be changed.

When processing a negative backflush quantity, the bin location must exist against the parent item (i.e. the item must have been issued against the parent item for that specific bin location).

Lot

Enter the lot number from which the item must be backflushed.

You can only access the Lot field if:

If you selected the option: Same lot to be used on multiple stock codes (Lot Traceability Setup), then the same lot number can be used for different stock codes.

Concession

A concession is usually required if you selected a traceable stock item. If you do not enter a concession in association with a specific lot number, the system prompts you to either enter a concession number or continue without one.

[Note]

If you need to record a concession number against a lot, then ensure that you enter it during the backflushing process as you will be unable to capture it later.

You can select the preference: Give warning about blank concession number entered to display a warning message when you do not enter a concession number.

Lot expiry date This indicates the expiry date of the lot.
Serial Numbers Select this to capture manual and batch serial numbers for any serialized items being received into stock using the Serial Entry for Receipts program.
Use single ABC type elements

Select this to include pre-production elements in the calculation of costs. These costs are added to the receipt cost entered. Only pre-production elements of cost defined with a calculation method of single are applied.

[Note]

You can only select this option if you enabled the option: Activity based costing required (Bill of Materials Setup).

Reference Enter a journal reference that is associated with the transaction and which is printed on the Inventory Journal Report.
Notation Enter a notation associated with the transaction and which is printed on the Inventory Journal Report.
Non-merchandise details  
Apply cost multiplier

Select this to apply a cost multiplier to the transaction. This enables you to indicate what portion of the transaction value comprises non-merchandise costs (e.g. Freight, duty, tax, etc). See Backflushing Cost Multiplier.

You can only select this option if you have configured your Inventory Setup options to apply a cost multiplier when processing receipts and if a cost multiplier value greater than 1 has been assigned to the stock item (Warehouse Maintenance for Stock Code).

G/L Details  
Ledger code

You use this field to indicate the ledger account to which the backflushing transaction must be posted.

You can only access this field if Inventory is linked to the General Ledger and you have configured your Inventory options (Ledger Code Options) to request the ledger code backflushing for transactions.

Ledger code description This indicates the description defined against the ledger code.

Backflushing Options

This screen is displayed when you select the Post option.

Field Description
Options Indicate whether to add the value of set-up time, startup time or teardown time to the backflushing value. This is useful if you backflush an item several times in a day, but you only require these times to be calculated once.
[Note]
  • Irrespective of whether or not you select to include the set-up, startup and teardown times when backflushing, the run time and the fixed and variable overheads are posted to the General Ledger.

    The ledger accounts are determined by the General Ledger integration codes defined against the work centers linked to the operation(s).

  • Fixed and variable overheads are calculated using the run time and the times selected at this option.

    Fixed overheads are calculated as:

    Fixed rate x (Run time + Set-up time + Startup time + Teardown time).

    Therefore, if you do not select any of these options, then the Fixed overheads are calculated as: Fixed rate x (Run time).

    Similarly, if you select only set-up time, then the Fixed overheads are calculated as: Fixed rate x (Run time + Set-up time).

    The variable overheads are calculated in the same manner, but using the variable overhead rate.

  • A labor journal is always created, even if the calculated times are all zero.
Include set-up time Select this to add the value of set-up time to your backflushing value.
Include startup time Select this to add the value of startup time to your backflushing value.
Include teardown time Select this to add the value of teardown time to your backflushing value.
Job number

If the stock item you are backflushing is defined as traceable (Stock Code Maintenance), then you must make an entry in this field. The entry made is not validated as it is a user defined job reference field.

This is a dummy job number which serves as a link from the materials to the parent item.

An entry can only be made here if the item being backflushed is defined as traceable.
Alternate routing required Select this to indicate a different routing to be used for the issue of materials and operations.
[Note]

You can only access this field if you enabled the option: Alternate routings required (Bill of Materials Setup).

OK

Select this to continue processing.

If labor operations are included in the bill of material structure of the sub-assembly (and the Work in Progress module is installed) then the cost of these operations is included in the cost of the backflushed item.

If the Work in Progress module is not installed then labor journals are not created and work center efficiency files are not updated.

If Work in Progress is installed then labor journals are created if any operations are held against the part being backflushed, or if a shortage of a sub-assembly (against which operations are held) occurs.

A labor journal is always created, even if the calculated times are all zero.

Cancel Select this to return to the previous screen.

Backflushing Cost Multiplier

The Cost Multiplier screen is displayed if a cost multiplier value greater than 1 is assigned to the stock item and you selected Yes at the option: Apply cost multiplier field.

Field Description
Cost multiplier This defaults to the cost multiplier value defined against the item but can be changed.
Enter non-merchandise cost

Select this to change the cost multiplier value calculated by the system.

If you select this option then you can override the default value displayed in the Non-merchandise cost field.

Non-merchandise cost

Enter the non-merchandise value you want to apply to the transaction.

You can only enter a value in this field if you selected the option: Enter non-merchandise cost.

Refer to Non-merchandise Distribution.

OK Select this to apply the calculated or entered non-merchandise value to the transaction.
Cancel

Select this to exit the Cost Multiplier screen without applying the non-merchandise value.

[Warning]

If you select this option, then the following message is displayed:

Inventory journals have already been posted. If you cancel now, non-merchandise distribution will not be posted. Do you still wish to cancel this transaction?

If you select Yes, (i.e. you cancel out of the Cost Multiplier screen) then the cost multiplier is applied to the cost of the item in inventory, but the non-merchandise entry for the cost multiplier value is not posted to the General Ledger. This results in a difference between the item's value in the Inventory module and its value in the Inventory control account in the General Ledger. This difference must be manually journalized using the GL Journal Entry program.

Stock Information

This contains stock information that is displayed while you enter transaction details for an item.

Field Description
Warehouse This indicates the warehouse in which the transaction is being processed.
Stock code This indicates the code of the stock item being processed.
Stocking uom This indicates the stocking unit of measure of the stock item.
Stock on hand Quantity physically in the warehouse.
Stock available

Quantity on hand less allocated to sales orders.

Allocated to sales orders is the quantity on back order + sales order to ship quantity. These quantities exclude unallocated Scheduled Order back order and ship quantities.

Stock free Quantity on hand - sales order ship quantity. This quantity excludes unallocated Scheduled Order ship quantities.
In transit Outstanding non-immediate warehouse transfers.
Allocated Quantity on back order + sales order ship quantity + outstanding materials to be issued to jobs (this includes allocations to both confirmed and unconfirmed jobs) + quantity reserved for WIP allocations.
On order Quantity of outstanding purchase orders and jobs.
On back order Sales order back order quantity. This quantity excludes unallocated Scheduled Order back order quantities.
In inspection Quantity of purchased items awaiting inspection (i.e. receipted into inspection but not receipted into stock).
Cost uom This indicates the cost unit of measure of the stock item.
Current cost This indicates the current cost of the stock item.

Recap Totals

The totals displayed in this pane are updated each time you post a transaction.

Field Description
Session details
  • Transaction date

    This indicates the date on which the transactions were posted.

  • Posting period

    This indicates the inventory period in which the transactions were posted.

  • Hash quantity

    This indicates the total number of items processed in all transactions during the current run of the program, regardless of the unit of measure (e.g. if 12 units and 13 boxes were processed, then the value shown here would be 25.

Receipts
  • Receipts posted

    This indicates the number of receipt transactions posted.

  • Receipts value

    This indicates the total value of receipt transactions posted.

Adjustments
  • Adjustments posted

    This indicates the number of adjustment transactions posted.

  • Adjustments value

    This indicates the total value of adjustment transactions posted.

Expense issues
  • Issues posted

    This indicates the number of expense issue transactions posted.

  • Issues value

    This indicates the total value of expense issue transactions posted.

Transfers IN
  • Transfers in posted

    This indicates the number of transfers in transactions posted.

  • Transfers in value

    This indicates the total value of transfers in transactions posted.

Transfers OUT
  • Transfers out posted

    This indicates the number of transfers out transactions posted.

  • Transfers out value

    This indicates the total value of transfers out transactions posted.

Cost changes
  • Cost changes posted

    This indicates the number of cost change transactions posted.

  • Cost changes value

    This indicates the total value of cost change transactions posted.

Physical counts
  • Physical counts posted

    This indicates the number of physical count transactions posted.

  • Physical counts value

    This indicates the total value of physical count transactions posted.

Cost modifications
  • Cost modifications posted

    This indicates the number of cost modification transactions posted.

  • Cost modifications value

    This indicates the total value of cost modification transactions posted.

List of Journals

This displays journal header information for the transactions posted during the current run of the program.

Field Description
Journal This indicates the journal number created for the transaction.
Journal date This indicates the date on which the transaction was processed.
Warehouse This indicates the warehouse in which the transaction was processed.
Operator This indicates the operator who processed the transaction for the journal.

Journal Entries

This displays the journal lines for the journal selected in the list of Journals pane.

Column Description
Stock code This indicates the code of the stock item used for the transaction.
Transaction This indicates the transaction type.
Quantity This indicates the transaction quantity.
Value This indicates the transaction value.

Inventory Transaction Types

The table lists the transaction types which occur in the Inventory module.

These transaction types are stored in the Inventory Movement files/tables and are printed on the Inventory Journal and Distribution Reports.

Option Description
REC R - Receipt
ADJ A - Adjustment
ISS I - Issue
PHY P - Physical count
CHG C - Change
MOD M - Modification
TRF T - Transfer
REC G - GRN (Goods Received Note)
REC g - Cost multiplier non-merchandise variance
REC c - GRN cost multiplier entry
BFL B - Backflushing variance
TOT t - TOTAL variance entry
VAR s - Variance caused by standard cost transfer
VAR v - Variance caused by standard cost transfer
VAR a - Variance caused by average cost calculation
ABC X - ABC journal record
ABC x - ABC variance journal
VAR w - WIP automatic write-off variance
GTR z - GIT cost multiplier
GTR z - GIT cost multiplier non-merchandise variance
BIN b - Bin transfer for multiple bins (journal and movement only)
INS W - WIP inspection
SCR S - WIP inspection scrap
REW O - WIP inspection rework
DSP d - Dispatch note issue
DSP D - Dispatch note reversal
VAR f - FIFO rounding
Inventory Journal Status

Following are the possible statuses for inventory journals:

  • Status 0 - Not printed

  • Status 1 - Journal printed

  • * - Journal in process

Cost Multiplier Calculations

You can add the calculated cost multiplier value to the receipt cost of an item when using the Inventory Movements program to process a Receipt or a GIT Transfer In when you enabled the option: Include non-merchandise costs in last cost (Inventory Setup - Options tab).

If you are using the full Goods in Transit facility (GIT Transfers) and you want to apply a cost multiplier for items which are transfer supplied, then you must also select the option: Apply cost multiplier when processing receipts (Inventory Setup - Options tab). This enables you to specify the portion of the transaction value that comprises non-merchandise costs and to store these values in nominated ledger accounts.

The cost multiplier is defined against a stock item using the Warehouse Maintenance for Stock Code program.

The values calculated using a cost multiplier depend on the costing method you defined for Inventory (Inventory Setup - Options tab).

  • Using a costing method other than Standard:

    Total Transaction value = Quantity x New Cost x Cost Multiplier

    Total Merchandise Value = Quantity x New Cost

    Total Non-merchandise value = Transaction Value - Merchandise Value

  • Using Standard Costing:

    Total Transaction Value = Quantity x Standard cost

    Total Merchandise Value = (Quantity x Standard Cost) / Cost Multiplier

    Total Non-merchandise value = Transaction Value - Merchandise Value

Notes and warnings

Custom form fields for serialized items on transfers

  • Custom form fields defined against a serial are transferred when processing an Immediate transfer and a Transfer in (GIT) for batch and manual serials and when processing a Transfer in (where the full goods in transit transfers facility is not in use) for manual serials only.

    Custom form fields are not transferred for batch serial items when using the normal warehouse Transfer in transaction (i.e. when not using the full GIT facility), because the system does not know which warehouse the specific quantity was transferred from. This is only available in the INVTRF file if FIFO is in use. This is a limitation of batch serials in a non-GIT company.

GL analysis considerations

  • If the GL analysis required option is enabled for a ledger account used in this program (General Ledger Codes or GL Structure Definition) then the GL Analysis program is displayed when you post the transaction, so that you can enter the analysis details.

    The Ask Me Later function is only available when the option: Force GL Analysis - GL journal posting is enabled for the sub-module (General Ledger Integration - General Ledger tab).

    General Ledger analysis entries are always distributed in the local currency, regardless of the currency in which the original transaction is processed.

eSignature considerations

Electronic Signatures provide security access, transaction logging and event triggering. This enables you to increase control over your system changes.

Access to the following eSignature transactions within this program can be restricted at Operator, Group, Role or Company level. You configure this using the Electronic Signatures program.

eSignature Transaction Description
Inv Receipt

Controls access to the New function for Receipts in the Inventory Movements program.

Inv Stock adjustment

Controls access to the New function for Adjustments in the Inventory Movements program.

Inv Cost change

Controls access to the New function for Cost Changes in the Inventory Movements program.

Inv Expense issue

Controls access to the New function for Expense issues in the Inventory Movements program.

Inv Bin transfer

Controls access to Bin Transfers in the Inventory Movements program.

Inv GIT Transfers Out

Controls access to the New function for GIT Transfers OUT in the Inventory Movements program.

Inv Immediate Transfers

Controls access to the New function for Immediate Transfers in the Inventory Movements program.

Inv GIT Transfers In

Controls access to the New function for GIT Transfers IN within the Inventory Movements program.

Inv Cost modification

Controls access to the New function for Cost modifications in the Inventory Movements program.

Inv Physical count

Controls access to the New function for Physical counts in the Inventory Movements program.

Inv Warehouse Transfers Out

Controls access to the New function for Warehouse Transfers OUT in the Inventory Movements program.

Inv Warehouse Transfers In

Controls access to the New function for Warehouse Transfers IN within the Inventory Movements program.

Inv Warehouse Transfers Out/No Destination

Controls access to the New function for Warehouse No Destination Transfers OUT in the Inventory Movements program.

Inv Stock warehouse added

Controls access to the New Warehouse function in the Inventory Movements, Warehouses for Stock Code and Warehouse Maintenance for Stock Code programs.

Inserting Application Help

You would typically follow this procedure to display help for the current program in a customized pane that can be pinned to the program window.

Information includes step-by-step instructions for the various functions available within the program, including a brief overview of what the program does, what setup options are required and how to personalize the program.

  1. Open the program for which you want to insert application help into a customized pane.

    This functionality is only available for a program that has panes.

  2. Right-click any form field.

    You can also click the triangle menu icon that appears in the title area of a pane.

  3. Select Insert Application Help from the context-sensitive menu.

    The application help appears in a pane within your program. You can reposition the pane using the docking stickers or pin it to the program window.

Removing the Application Help pane

If you no longer want to display application help in a pane for your current program, you can simply remove it.

  1. Select the Close icon in the right-hand corner of the application help pane.

  2. Confirm that you want to delete the pane.