Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

 

Daily position inquiry Position Inquiry will show all the inventory related transaction such as how much Invenntory Inventory received against Company owned and custoemr customer owned and what is the total of this day.

We have mainly 3 section in the daily position inquiry.

  1. Grain Inventory section Inventory 
  2. Storage Liability 
  3. Company owned Ownership

Header

We want to show the Commodity/Item and the Date Range used for this dashboardThis screens allows you to filter by Beginning Date, End Date, Commodity and Item

Grain Inventory Section

This will give the Daily balances for Grain Brought In, Grain Shipped Out and any AdjustmentsFirst row  is the beginning balance for the date range

  1. Beginning Inv.  -  This is the first row in the Grain Inventory grid. This should be the Inventory (In House, which includes

...

  1. Delayed Pricing) as of the Beginning Date -1 Day 

we            We are showing the NET net  Inventory Receipts for the given day.

For instance :

...

a. Open Ticket management

...

b. Create a load in ticket against the distributions type Grain Bank (Grain Bank is customer type)

...

c. Distribute the same.

...

d. Now the Storage liability section will show a sub section Grain bank and in that IN column will show the Load in qty against the grain bank. 

...

     The same will be reflected in the Grain inventory "Inv In"

...

      Another Instance :  

    1. Open Ticket management

...

    1. Create a load out  ticket against the distributions type Grain Bank( Grain Bank is customer type)

...

    1. Distribute the same.

...

    1. Now the Storage liability section Grain bank OUT column will show the Load out qty against the grain bank. 

The same will be reflected in the Grain inventory "Inv OUT"

3.

...

Grain Inventory Adjustment 

    a. Open inventory adjustment from

...

inventory module

    b.Enter the adjustment for the same item.

   c  This number should be reflected in the Adjustment column in Grain inventory.

4. Balance inventory 

      Inv in- Inv out +/- Adjustment. = Balance inventory

 


Grain inventory IN =

...

Sum of Storage Liability IN + Company ownership IN + DP 

Grain inventory OUT = sum of Storage Liability OUT + company ownership OUT

 


Storage

...

Liability  

When ever user create a Customer owned Load in or Load out it will reflect in this section 

For instance 

5. Open Ticket management and Create a load in  ticket against the distributions type Open storage ( open storage is customer type) and distribute the same . now the Storage liability section will show a new subsection called open storage and Open storage In column will show the Load out qty against the grain bank. 

The same will be reflected in the Grain inventory "Inv OUT"

Company

...

Ownership 

Company Owned Section – Unpaid

...