WO cancellation screen

Here the entire WO issue document can be canceled at once. The document is presented in its entirety – per batch, per serial number and per bin location on separate lines. The amounts can be pre-allocated or entered manually. Double cancellation is not possible.

Approach: The program performs a posting for the same price as the issue to the same account. A normal receipt document is generated.

Note: Using average price or FIFO valuation deviations can occur. With FIFO, in general no cancellation with correct prices is impossible.

Note: This window is also opened, when scrap is posted back for re-use after issue. Therefore, setup in Configuration wizard under Production > FDC > View time receipts: Post back scrap material.

With serial numbers, the posting is done to the same internal number. There is no new serial creation. Prerequisite: The serial number was not manually posted.

Column

Meaning

Document

Document number.

Line

Row number.

Item

Item.

Description

Description from Item

Batch

Batch ID. or Serial number from Issue document. It's not possible to change this

Warehouse

Warehouse. System inserts the warehouse from which the issue document was created.

It is possible to change this to every warehouse with the following rule:

- The warehouse is available for the item

- The warehouse is not locked

- The warehouse is free for production receipt (see warehouse setting)

- Not an external warehouse

The System supports WMS, SAP and Beas Bin Managed warehouses beas 9.3 PL 2 HF 2

Bin location

If this is a WMS, SAP or Beas bin managed warehouse, you can define the Bin location.

This field is only editable if this is a bin/managed warehouse.

The system does not insert the bin location from an issue document automatically if it is in an SAP or WMS managed warehouse.
Customizing, WMS and SAP Support from beas 9.3 PL 2 HF 2

Beas supports WMS, Beas, and SAP Business One Bin Management (Beas 9.3 PL3)

The field has the following components:

Orange arrow :

List of all bins where the item is located.

Selection (Drop-down)

A list opens to select the desired bin location.

bin_dropdown

The selected drop-down option displays the following information in receipt documents:

•	Bin Location

•	Warehouse Area

•	First item in this bin location

•	Stock of the first item in this bin location

The list can be modified in the Configuration wizard.

The selected drop-down option displays the following information in issue documents:

•	All stock information of all bin locations with batch- and serial number information.

•	Reserved Batch quantities information

bin_dropdown-issue

The dropdown contains information on reserved quantities in 3 columns:

Batch_dropdown_QTYS

The batch entry in the list is displayed in RED color if the Batch is not free.

Quantity-related information:

Field	Description
Available	Available quantity is = Inventory - reserved quantity + reserved quantity for current work order position. This quantity is displayed in GREEN, if quantity is reserved for the currently used Bill of Materials position.
Reserved for BoM	Reserved Quantity for this BoM Position
Reserved Quantity	Total reserved Quantity

Select or List - Icon

By using the selection icon, an adjustable selection list opens. Window settings and templates are supported.

The Definition of the bin location is mandatory.

If the bin location is not defined, Beas uses the default bin location for this item for the specified transaction type.

This is entirely managed by SAP Business One.

Drop-down for volume or weight is not supported. Columns are always 0.

beas 9.3 PL 2

Bin location is mandatory.
Drop-down for volume and weight not supported.

This list can be modified in the Configuration Wizard. General manipulation is possible using the stockmanagement.src file or window-related changes using Windowevent setbindropdown.

The following priorities are considered:

1.	Window-related customization (windowevent setbindropown)

2.	General changes (stockmanagement.src)

3.	Settings in the Configuration wizard

In the e_bindropdownbsl variable, the ODATA command can be defined.

It is beneficial to use the Beas service layer, because Beas supports different warehouse systems that use different tables and logic.

The standard functions for receipt and issue are as folows:

file stockmanagement.src

function binreceiptdropdown

setvar=e_bindropdownbsl=BinLocation(<e_binwhscode,bsl>)?$mask=1

end function

function binissuedropdown

setvar=e_bindropdownbsl=WareHouseStock(<e_binwhscode,bsl>)?$select=BinLocation/BinCode,BinLocation/BinColor,OnHand,UoMCode,Batch,IVersionId,BatchAttribute1,BatchAttribute2,ExpirationDate&$filter=ItemCode eq <e_itemcode,bsl> and OnHand gt 0

end function

For receipt, use BinLocation.

For issue, use WareHouseStock.

For more information, see Beas Service Layer documentation.

Example

-- file stockmanagement.src --

// BinReceipt: Show all Bin Locations, ordered by OnHand descending, BinCode ascending:

function binreceiptdropdown

setvar=e_bindropdownbsl=BinLocation(<e_binwhscode,bsl>)?$select=BinLocation/BinCode,BinLocation/BinColor,OnHand&$orderby=OnHand desc,BinLocation/BinCode asc

end function

// BinIssue: Show only Bin Locations where OnHand > 0 of the selected ItemCode, ordered by OnHand descending, BinCode ascending:

function binissuedropdown

setvar=e_bindropdownbsl=WareHouseStock(<e_binwhscode,bsl>)?$select=BinLocation/BinCode,BinLocation/BinColor,OnHand,UoMCode,Batch&$filter=ItemCode eq <e_itemcode,bsl> and OnHand gt 0&$orderby=OnHand desc, BinLocation/BinCode asc

end function

Attention:

This is available only up to Beas 9.3 PL 1 – in maintenance.

This list can be modified in the Configuration Wizard. General manipulation is possible using the stockmanagement.src file or window-related changes using Windowevent setbindropdown.

The following priorities are considered:

1.	Window-related customization (windowevent)

2.	General changes (stockmanagement.src)

3.	Settings in the Configuration wizard

Window-specific adjustments:

Call the setbindropdown user event. The dropdown:bin_from variable can be defined.

Example:

windowevent setbindropdown

setvar=e_bindropdown=ddsql=select "BINCODE" from "BEAS_WHSBIN" where "WhsCode"=<e_binwhscode,dbstring> order by "STORAGESORT"

end event

Note: This window event is supported in every window where the selection field is available.

General adjustment

Use the stockmanagement:binreceiptdropdown() fuction to store a custom drop-down configuration.

file stockmanagement.src

function binreceiptdropdown

setvar=e_bindropdown=ddsql=select "BINCODE" from "BEAS_WHSBIN" where "WhsCode"=<e_binwhscode,dbstring> order by "STORAGESORT"

end function

Quantity

Quantity from issue document.

Canceled

Previously canceled quantity.

Cancellation

How much to be canceled now.

UoM

Unit of measurement.

Price

Price from issue document.

Currency

Currency.

WO cancellation window