Revel | Action Type Calculation User Guide




TABLE OF CONTENTS


Introduction

 This user guide for calculating Action type From Revel POS System.

Note: The same approach apply to all Action Types, the only difference is the filtering process as follows:


COGS

Revel 

  1. Report → Other Reports → Ingredient Inventory Log → Filters → Used 

  2. Inclusions → Used




Wastage

Revel 

  1. Report → Other Reports → Ingredient Inventory Log → Filters → Wastage

  2. Inclusions → Used  




Adjustment 

Revel 

  1. Report → Other Reports → Ingredient Inventory Log → Filters → Adjustment 

  2. Inclusions → Used




Return 

Revel 

  1. Report → Other Reports → Ingredient Inventory Log → Filters → Return 

  2. Inclusions → Used




Calculating process

  1. Determine the type of action 

    1. Report → Other Reports → Ingredient Inventory Log → Filters → Return 




  1. Preferences → check the following points → Save 

    1. Cost Details 

    2. Quantity Details

    3. Inventory value Details




  1. Export → Excel 



  1. Customize Sheet :

    1. Type → Advanced 

    2. Additional filed → ingredient Class




  1. After downloading the Sheet, there are two ways to calculate Action type:

    1. Directly from the In.Change value column



The sum of the In.Change value column values = The Action type value




b.Use the following equation:

Inventory quantity * Cost before



The sum of the New Column values = The Action type value








Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article

Preview
0 of 0