Table of Contents

Stock Handling

In this article, you will learn how to handle stock corrections and counting between Business Central to Pulpo WMS.

Stock Correction

Stock correction is done in Pulpo WMS. In that case, stock_correction_finished webhook message is sent to Business Central via Azure Service Bus.

Webhook Message is saved to Pulpo WMS Webhook Message table and from there is parsed and saved to Pulpo WMS Movement table. Movement Lines contain list of corrected items and quantities.

After Movement Line is inserted, if there are no errors:

  • New Item Journal Line is created based on setup
    • If quantity is positive, Entry Type is Positive Adjustment
    • If quantity is negative, Entry Type is Negative Adjustment
    • If quantity is 0, no line is created
  • Created Item Journal Lines are automatically posted if that option is picked in setup

Counting

There are 3 types of counting in Pulpo WMS:

  • Product and position
  • Position
  • Multiple

When stock counting is done (audited) in Pulpo WMS app, counting_task_closed webhook message is sent to Business Central via Azure Service Bus.

Webhook Message is saved to Pulpo WMS Webhook Message table and from there is parsed and saved to Pulpo WMS Movement table. Movement Lines contain list of counted items, expected, counted quantities as well as information if stock was corrected in case of differences.

After Movement Line is inserted, if there are no errors:

  • If counted and expected quantity are equal, nothing happens and movement line is marked as processed
  • If there's difference in quantities but correction isn't done in Pulpo WMS, nothing happens and movement line is marked as processed
  • Otherwise, new Item Journal Line is created based on setup
    • If expected quantity is higher then counted quantity, Entry Type is Negative Adjustment
    • If expected quantity is lower then counted quantity, Entry Type is Positive Adjustment
  • Created Item Journal Lines are automatically posted if that option is picked in setup

Counting task Movements can also be used to compare complete stock in Business Central and Pulpo WMS. Counting is done on Physical Inventory Journals page. Filter when calculating inventory should be same as when counting was done in Pulpo WMS, and filtering should be done based on one Pulpo WMS location. After calculation is done, action "Calculate Qty. (Phys. Inventory)" should be used to compare inventory between Business Central and Pulpo WMS:

  • Opens the page where Counting Date filter can be picked
  • Sets Qty. (Phys. Inventory) to 0 in all lines
  • Updates Qty. (Phys. Inventory) field for correct lines (based on Item No. and Variant Code) or creates new lines if they're missing

After action, user must manually click Post if they want stock correction to be done in Business Central.