EXPEDIENT SOFTWARE

Going beyond software performance.

Stock Adjustment

Helen
March 24, 2016
Bond Warehouse (AU)

This screen is used where quantities of stock may need to be changed. Quantities may need to be updated due to

  • Movement of stock to a different bin location

  • Resubmission of the N20 with different quantities

  • Return of Freight to the Bond Warehouse

  • Damaged/Pillaged Pieces

Field Name

Description

Validation

Default

Entry Information

Click FIND and enter the Job No or Entry No that requires the Stock Adjustment

N/A

Blank

Last Version No

This field displays the Version number for the N20 that was last successful submitted. This should be compared against the Vers. No column in the In Bond Line Information table. Different version numbers indicate that Stock Adjustments have occurred since the successful submission of the N20. Differences will be highlighted in red

N/A

N/A

Establishment ID

This displays the Bond Warehouse Establishment ID that the N20 was checked into

N/A

N20

In Bond Line Information

This table displays the Entry Lines and Part Numbers checked into the Bond Warehouse for the selected N20 Entry. Only Entry Lines and Parts that are currently in the Bond Warehouse will be shown.

Inv. No

This is the Entry Number for the Entry Line and Part Number on the row

N/A

Supplier Invoice

Inv. Line No

This is the Supplier Invoice Line Number for the Entry Line and Part Number on the row

N/A

Supplier Invoice

Entry Line No

This is the Entry Line Number for the Entry Line and Part Number on the row

N/A

N20

Vers. No

This is the version number for the update to the Entry Line and Part in the Bond Warehouse. This number will increment by 1 every time the details of the Entry Line and Part are updated in the Stock Adjustment Screen. This number will be highlighted in red if the Version Number on the row is different to the N20 last version number.

N/A

System Generated

Part No

This is the Supplier Part Number on the Supplier Invoice Line in the N20 Entry

N/A

Supplier Invoice

Inv. QTY

This is the Invoice Quantity for the Part on the Supplier Invoice Line. This can be updated

N/A

Supplier Invoice

Current QTY

This is the Quantity in stock in the Bin Location or the Bond Warehouse if you site is not using Bins. This can be updated

N/A

System Generated

Customs QTY

This is the Customs Quantity for the Supplier Invoice Line in the Unit Quantity reported to Customs. This can be updated

N/A

N20 Entry

UQ

This is the Unit Quantity reported to Customs

N/A

N20 Entry

CVAL

This is the Customs Value for the current stock in the Bond Warehouse or the Bin Location for the Part on the Entry Line. This can be updated

N/A

System Generated

WUV

This is the Customs Value per Part Unit, using the Customs UQ, based on the information from Customs in the N20. This can be recalculated automatically by clicking or updated manually.

N/A

System Generated

T&I UV

This is the T&I Value per Part Unit, using the Customs UQ, based on the N20. This can be recalculated automatically by clicking or updated manually.

N/A

System Generated

Bin No

This column will appear where your site has Bin Locations. This is the current location of the Part on the Entry Line. This can be updated manually or click to select from a list of available Bin Locations.

Valid Bin Location for Bond Warehouse

Current Bin Location

Bin QTY

This column will appear where your site has Bin Locations. This is the Quantity currently in the displayed Bin Location. This can be updated. . If the Quantity entered is less than the Current QTY the Bin Entry screen will appear allowing the Quantity to be assigned to multiple Bin Locations.

Update the quantity in the current Bin Location and assign quantities to the new Bin Location until the original Current Qty is matched.

This screen will not allow updates where the quantity in the Bin has already been assigned to a Pick List that is waiting for a successful N20 or EDN.

Bin Quantity must not exceed Current Quantity, or less than Quantity already assigned to a Pick List

Current Bin QTY

Multi Bin

This column will appear where your site has Bin Locations. This column will display ‘*’ if the Part on the Entry Line is stored in more than one Bin Locations

N/A

System Generated

Reason for Adjustment

This field appears in UPDATE mode and text must be entered to explain the need to update values. The reason text will appear in the Bond Warehouse Status screen and the Bond Details Report

Mandatory

Blank

Movement of Stock within the Bond Warehouse (BINS only)

  1. To change the Bin Location the stock was originally checked into following these steps
  2. Find the Job Number or Entry Number in the Stock Adjustment screen
  3. Select
  4. Find the Part Number in the Bin Location you want to change.
  5. If all the parts are moving to a new Bin Location click in the Bin No column and update the Bin Location for the row.
  6. If some of the parts are moving to a new Bin Location update the Bin QTY to the new Quantity in the original Bin Location. The Bin Entry screen will appear to allow you to enter the quantities moved to the new Bin Locations. A ‘*’ will appear in the Multi Bin column when you save the changes in the Bin Entry screen.
  7. Enter the Reason for the Bin Location update
  8. Click to save the update

Update to N20 after Check In

To reflect updates in the last N20 submission in the Bond Warehouse, e.g. a change in quantities on the Supplier Invoice, follow these steps

  1. Find the Job Number or Entry Number in the Stock Adjustment screen
  2. Select
  3. Do you want to reset the information for all the Entry Lines in the Bond Warehouse?
  4. YES
  • Select the toolbar button
  • Select to Continue. Expedient will update the Invoice QTY, WUV, T&I UV and the tariff codes to match the last successful submission of the N20. The Current Quantity will be recalculated to account for the new Invoice Quantity and the quantities allocated to outstanding Pick Lists
  1. NO
  • Click on the Entry Line you want to update to match the N20
  • Select the toolbar button
  • Select to Continue. Expedient will update the Invoice QTY, WUV, T&I UV and the tariff codes to match the last successful submission of the N20 for that Entry Line Number only. The Current Quantity will be recalculated to account for the new Invoice Quantity and the quantities allocated to outstanding Pick Lists
  1. Enter the Reason for the Bin Location update
  2. Click to save the update

Freight Return

If stock has been released from the Bond Warehouse and is subsequently returned the Entry Line can be added back to the Entry in the Stock Adjustment screen provided the entire Entry has not been released. If there are still quantity on at least one entry line for the N20 Entry and Entry Line can be manually added in the Stock Adjustment screen.

  1. If your site uses Bin Locations add the Bin Location and confirm the quantity in the Bin
  2. Select
  3. Find the Job Number or Entry Number in the Stock Adjustment screen
  4. Click into the next blank row in the ‘In Bond Line Information’ table. Enter the Inv. No and Inv. Line No. Rest of the line will be populated to match the last successful N20 Entry line. The Current Quantity will match the Invoice Quantity.
  5. Enter the Reason for the Bin Location update
  6. Click to save the update
Updated: March 24, 2016 — 5:07 am
EXPEDIENT SOFTWARE GUIDE © 2015