User Tools

Site Tools


implementation:scan:transactions

7. Inventory Transactions

7.1. Goods Receipt

Select the Goods Receipt option on the Main Menu under the Inventory Transactions section. On the next screen create a new Goods Receipt document or proceed with an already started one.

  • To start a new Goods Receipt, add the Doc. Date and tap the New button. To add a remark, enter the text to the Remarks field.
  • To proceed with a started preliminary document, press the Reload button to load the already started orders. Select the document and tap on the Resume button.
  • To create the Goods Receipt, select the preliminary order and press the Post button.

Goods receipt

On the Goods Receipt (list) screen add the warehouse to the Warehouse field. By default the warehouse is empty or it is the last warehouse in the same document. Scan the item or enter the item code to the Item field. Enter the quantity and press the Add or Upd. button to add the item.

If there are multiple UoMs for the item, you can select a different UoM than the default. Default: inventory/base UoM.

On the grid already added items are listed.

If the warehouse has bin locations, and/or the item is managed by batches/serial numbers, the system proceeds to a screen where the bin location, batch and serial numbers can be added.

  • If the warehouse has bin locations, add the bin location. It is possible to receive the stock into multiple bin locations.
  • If the item is a batch item, add the batch number. It is possible to receive multiple batches.
  • If the item is managed by ‘On every transaction’ serial numbers, scan the serial numbers. To remove a serial number, select the serial number and tap on the Delete button.
  • If the item is managed by ‘On release only’ serial numbers, enter the quantity. The system automatically creates empty (placeholder) serial number records.

The total quantity must be equal to the quantity entered on the previous screen in order to proceed.

Press the Print button to print the item label.

Press the Done button to proceed. The system goes back to the previous screen and saves the entered data.

Press the Cancel button to go back without saving the data.

*Price/Account: a user query has to be defined with the name bx_mobile_wh9_goodsreceipt_pricing.

Parameters Result
[%1] Employee ID
[%2] Warehouse
[%3] ItemCode
Price (BXITPRC)
Currency (BXITCURR)
Account number (BXITACCN)
Distribution Rule (BXITDSTR)

Example query:

 SELECT OITM.AVGPrice as BXITPRC. '$' as BXITCURR FROM OITM WHERE ItemCode=[%3]

7.2. Goods Issue

Select the Goods Issue option on the Main Menu under the Inventory Transactions section.

On the next screen create a new Goods Issue document or proceed with a started one.

  • To start a new Goods Issue, add the Doc. Date and tap the New button. To add a remark, enter the text to the Remarks field.
  • To proceed with a started preliminary document, press the Reload button to load the already started orders. Select the document and tap on the Resume button.
  • To create the Goods Receipt, select the preliminary order and press the Post button.

Goods Issue

On the Goods Issue (list) screen add the warehouse to the Warehouse field. By default the warehouse is empty or it is the last warehouse in the same document. Scan the item or enter the item code to the Item field. Only inventory items can be scanned or selected. Enter the quantity and press the Add or Upd. button to add the item.

If there are multiple UoMs for the item, you can select a different UoM than the default. Default: inventory/base UoM.

On the grid already added items are listed.

If the warehouse has bin locations, and/or the item is managed by batches/serial numbers, the system proceeds to a screen where the bin location, batch and serial numbers can be added.

  • If the warehouse has bin locations, add the bin location. It is possible to receive the stock into multiple bin locations.
  • If the item is a batch item, add the batch number. It is possible to receive multiple batches.
  • If the item is managed by ‘On every transaction’ or ‘On release only’ serial numbers, scan the serial numbers. To remove a serial number, select the serial number and tap on the Delete button.

The total quantity must be equal to the quantity entered on the previous screen in order to proceed.

Press the Print button to print the item label.

Press the Done button to proceed. The system goes back to the previous screen and saves the entered data.

Press the Cancel button to go back without saving the data.

Price/Account: a user query has to be defined with the name bx_mobile_wh9_goodsissue_pricing.

Parameters Result
[%1] Employee ID
[%2] Warehouse
[%3] ItemCode
Price (BXITPRC)
Currency (BXITCURR)
Account number (BXITACCN)
Distribution Rule (BXITDSTR)

Example query:

 SELECT 
   "OITM"."AVGPrice" as "BXITPRC", 
   '$' as "BXITCURR", 
   (select "AcctCode" from "OACT" where "FormatCode" = replace('11100000-01-001-01', '-', '' )) as "BXITACCN" 
FROM 
   "OITM" WHERE "ItemCode" = [%3]

7.3. Inventory Counting

Produmex Scan offers the following processes to perform an inventory counting:

  • Counting: No inventory information is displayed during the counting.
  • Quick Counting: During the counting, the inventory of the bin location/warehouse is displayed.
  • Guided Counting: During the counting, the bin locations and the items from the inventory counting document are listed on the screen as a task list. Only the items that are listed on the document can be counted.

The counting is performed based on an SBO Inventory Counting document.

Inventory Counting document

If the 'Real-time Stock Counting' option is disabled on Produmex Scan General tab, the counting result will be stored in a user table. Synchronize the Inventory counting document in order to update it with the counting results. Synchronization can be initiated from right click menu on the SBO Inventory Counting document.

Synchronize mobile Inventory Counting data

If you work with SAP BO 9.1 the inventory counting will be updated in a real-time. By the other hand, if you work with SAP BO 9.0, the stock data you entered will be saved in a user table of the Produmex Scan add-on that you can export to an excel file. To do that you have to open the Inventory Counting document, right click on an empty area and select 'Export mobile inventory counting data to Excel'. It will create two separate files: one for normal and batch items and one for serial numbered items (it means you have to specify two files). Then you have to start Add Items>Import Items:

After that you have to define the structure of the file from which you import. It should be like this for the batch and normal file:

and for the serial numbers file:

We recommend that you save the template with Save As for later use. You have to specify the file that was created by the add-on for SAP BO, and then it will be imported.

Note:
You have to update the inventory counting document. You cannot have the same item on the same bin location twice in the inventory posting document. So if you reimport your inventory counting, it is advisable to delete the existing lines. You have to import both files generated by the add-on.

7.3.1. Stock Counting

Press the ‘Reload’ button to load the Inventory Counting documents. Every open Inventory counting document is listed. It is possible to filter the documents with the following fields:

  • Inventory counting document number
  • Count Date
  • Counter user/employee

Press the ‘Reload’ button to apply the filter(s).

Displayed information:

  1. Document Number
  2. Counter
  3. Count Date
  4. Remarks from the Inventory Counting document
  5. Counting type

Select the inventory counting document then press the ‘Count Items’ button to start the counting.

Stock Counting 1

On the next screen scan/enter the bin location code you would like to count.

If the warehouse to count does not have bin locations, add the warehouse to the field. The warehouse can also be selected from a list. Press the ‘…’ button. Please note: Only non bin managed warehouses can be selected from the list.

Press the ‘Count’ button to proceed.

Stock Counting 2

On the next screen scan the item then specify the UoM and the batch number. Enter the quantity to the Quantity field. To increase the current value with the entered value, press the ‘Add’ button. To replace the current value with the entered value, press the ‘Upd.’ button. To remove the added quantity, press the ‘Delete’ button.

Items managed by ‘On every transaction’ serial numbers must be counted by scanning the serial numbers.

Items managed by ‘On release only’ serial numbers can be counted by adding the counted quantity.

When a positive difference is counted for on release only items, the serial numbers have to be created manually in SAP Business One after the counting process on the mobile devices is completed. Open the ‘Serial Number Counting’ form from the Inventory Counting document: go to the ‘Counted Qty’ field on the line of the serial numbers and press CRTL + TAB.

On the ‘Serial Number Counting’ form click on the ‘Create…’ button.

Enter the serial numbers to the ‘Serial number’ field or create them automatically after pressing the ‘Automatic Creation…’ button. Please note: It is not possible to create empty serial numbers.

When a negative difference is counted, select the serial numbers to issue manually in SAP Business One after the counting process on the mobile devices is completed. On the ‘Serial Number Posting’ posting screen every serial number on the counted location is selected. Move the serial numbers you would like to keep to the ‘Available Serial Numbers’ grid. Create the serial numbers you would like to issue as described above or issue the empty serial numbers. If there are already registered serial numbers on the counted location, you can allocate those serial numbers as well.

Already counted goods are listed on the screen.

If the 'Show all Stock Counting data on scanners' option is disabled on Produmex Scan General tab, only the number of the counting records is displayed on the screen.

Stock Counting 3

Press the ‘Back’ button to go back to the previous screen. The system will keep the counting results, but the results will not be synchronized with SBO.

Press the ‘Finish’ button to finish the counting of the given bin location. The Inventory Counting document will be updated with the counting result.

  • Items that are stored on the given location but are not listed on the Inventory Counting document will be automatically added to the document.
  • If there is an item on stock on the location that was not counted, the quantity of the item will be set to zero on the location.
  • If there is an item that is not on stock on the location, but was counted during the counting, the quantity of the item will be set to the counted quantity on the location.

Example:
Bin Location content:

  • A1000 – 75pcs
  • A3000 – 200pcs
  • B1000 – 20pcs
  • B2000 – 25pcs

Inventory Counting document: Count A1000 and A3000 on the location.

Stock Counting 01

The user counts 75pcs for A1000 and presses the Finish button.

In SAP Business One, the counted quantity is set to zero for A3000. B1000 and B2000 are added to the Inventory Couning document with zero counted quantity.

Stock Counting 02

Stock Counting 02

7.3.2. Quick Counting

If the Guided Quick Counting option is disabled on the Produmex Scan General tabof Produmex Scan Settings, the Quick Counting option is available in the Inventory section of the Main Menu.

Press the ‘Reload’ button to load the Inventory Counting documents. Every open Inventory Counting document is listed. It is possible to filter the documents with the following fields:

  • Inventory counting document number
  • Count Date
  • Counter user/employee

Displayed information:

  1. Document Number
  2. Counter
  3. Count Date
  4. Remarks from the Inventory Counting document
  5. Counting type

Select the Inventory counting document and press the ‘Count Items’ button.

Quick Counting 1

On the next screen scan or enter the bin location.

If the warehouse to count does not have bin locations, enter the warehouse code into the WH/Bin field. The warehouse can also be selected from a list. Press the ‘…’ button. Please note: Only non bin managed warehouses can be selected from the list.

Already counted bin locations and warehouses are listed on the grid and are marked with a green check mark.

If the ’Display all sheet bin locations for Quick Counting’ option is enabled on the Produmex Scan General tab, every bin location from the Inventory counting document is listed on this screen. The already counted locations are marked with a green check mark.

Quick Counting 2

On the next screen every item from the location/warehouse is listed with the on stock quantity. Items with different batch or serial number are listed on separate lines. Displayed information:

  1. Item Code * Item Description
  2. BN: Batch number
  3. Status:
    • Green check mark: completely packed
    • Orange check mark: not packed/partially packed
  4. Counted quantity/Quantity on stock UoM
  5. SN: Serial number

Scan the item, then specify the UoM and the batch number. Enter the quantity to the Quantity field. To increase the current value with the entered value, press the ‘Add’ button. To replace the current value with the entered value, press the ‘Upd.’ button. To remove the added quantity, press the ‘Delete’ button.

Items managed by 'On every transaction' serial numbers can be counted by scanning the serial numbers.

Items managed by ‘On release only’ serial numbers can be counted by adding the counted quantity.

When a positive difference is counted for on release only items, the serial numbers have to be created manually in SAP Business One after the counting process on the mobile devices is completed. Open the ‘Serial Number Counting’ form from the Inventory Counting document: go to the ‘Counted Qty’ field on the line of the serial numbers and press CRTL + TAB.

On the ‘Serial Number Counting’ form click on the ‘Create…’ button.

Enter the serial numbers to the ‘Serial number’ field or create them automatically after pressing the ‘Automatic Creation…’ button. Please note: It is not possible to create empty serial numbers.

When a negative difference is counted, select the serial numbers to issue manually in SAP Business One after the counting process on the mobile devices is completed. On the ‘Serial Number Posting’ posting screen every serial number on the counted location is selected. Move the serial numbers you would like to keep to the ‘Available Serial Numbers’ grid. Create the serial numbers you would like to issue as described above or issue the empty serial numbers. If there are already registered serial numbers on the counted location, you can allocate those serial numbers as well.

Add the next item or press the ‘Finish’ button to finish the counting and send the result of the counting to SBO.
Press the ‘Back’ button to go back.

For more information please see: Stock Counting

Quick Counting 3

7.3.3. Guided Counting

If the Guided Quick Counting option is enabled on the Produmex Scan General tab of Produmex Scan Settings, the Guided Counting option is available on the Inventory section of the Main Menu.

Make sure that the ‘Display all sheet bin locations for Quick Counting’ option on the Produmex Scan General tab of Produmex Scan settings is enabled.

Press the Reload button to load the Inventory Counting documents. Every open Inventory Counting document is listed. It is possible to filter the documents with the following:

  • Inventory counting document number
  • Count Date
  • Counter user/employee

Press the ‘Reload’ button to apply the filter(s).

Select the inventory counting document then press the ‘Count Items’ button to start the counting.

Displayed information:

  1. Document Number
  2. Counter
  3. Count Date
  4. Remarks from the Inventory Counting document
  5. Counting type

Select the inventory counting document then press the ‘Count Items’ button to start the counting.

Guided Counting 1

On the next screen every bin location from the Inventory Counting document is listed in alphabetical order.

Already counted locations are marked with a green checkmark.

Scan the bin location/warehouse and press the ‘Count’ button.

If the ‘Restricted zone handling in Quick Counting’ option is enabled on the Produmex Scan General tab of Produmex Scan settings, only bin locations that are listed on the screen can be scanned or selected, otherwise the following error message is displayed:

Guided Counting Error 1

Guided Counting 2

On the next screen every item that was selected on the inventory counting document are listed with the current quantity on stock in alphabetical order. Even items from the list that are not available on stock can be scanned for counting, but only strictly the items from the inventory counting document.

Items with different batch or serial number are listed on separate lines.

Displayed information:

  1. Item Code * Item Description
  2. BN: Batch number
  3. Status:
    • Green check mark: completely packed
    • Orange check mark: not packed/partially packed
  4. Counted quantity/Quantity on stock UoM
  5. SN: Serial number

Scan the item then specify the UoM and batch number if needed.

Items managed by 'On every transaction' serial numbers can be counted by scanning the serial numbers.

Only items listed on the screen can be scanned otherwise the following error message is displayed:

Guided Counting Error 2

Guided Counting 3

Add the next item or press the ‘Finish’ button to finish the counting and send the counting results to SBO. Only the stock of the items that are listed on the Inventory Counting document is updated.

If there is an item on stock on the given location that is not listed on the Inventory Counting document, the user cannot register counting data for that item. When the Inventory Counting document is updated with the counting data, the item will not be added to it with zero quantity.

Example:
Bin Location content:

  • A1000 – 75pcs
  • A3000 – 200pcs
  • B1000 – 20pcs
  • B2000 – 25pcs

Inventory Counting document: Count A1000 and A3000 on the location.

Stock Counting 01

The user counts 75pcs for A1000 and presses the Finish button.

In SAP Business One, the counted quantity is set to zero for A3000. Because B1000 and B2000 are not included in the Inventory Counting document, the system does not take them into account when it updates the Inventory Counting document.

Stock Counting 02

Stock Counting 02

implementation/scan/transactions.txt · Last modified: 2019/05/30 09:26 by vise