You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Next »

 

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

We have mainly 3 section in the daily position inquiry .

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

Header

We want to show the Commodity/Item and the Date Range used for this dashboard

Grain Inventory Section

This will give the Daily balances for Grain Brought In, Grain Shipped Out and any Adjustments

First row  is the beginning balance for the date range. This should be the Inventory (In House, which includes DP) as of the Beginning Date -1 Day 

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

For instance :

  1. Open Ticket management and Create a load in ticket against the distributions type Grain Bank( Grain Bank is customer type) and distribute the same . 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 bank inventory "Inv In"

 

 

Column C – we are showing the NET Inventory Shipments for the given day

Column D – we are showing the NET Inventory Adjustments for the given day (could be positive or negative)

Column E – we are showing the Inventory Balance for the given day (should equal to E-1 + B - C + D)

This will give the Daily balances for Grain Brought In, Grain Shipped Out and any Adjustments

 

Company Owned Section – Unpaid

Cell J7 is the beginning balance for the Month. This should be the Open Vouchers and any DP Grain as of the End of the Prior Month

Column H – we are showing the new Vouchers for the day AND new Inventory Receipts distributed to DP for the given day

Column I – we are showing Vouchers that have been paid for the given day

** If the Voucher is created and paid in the same day, it should still show in both the IN and the OUT columns (see Row 13)

Column J – we are showing the Unpaid Balance for the given day (should equal to J-1 + H - I)

 

Company Owned Section – Paid

Here we are showing the difference between the Inventory balance for the day and the Unpaid Balance for the day. This should equal E - J.  The calculation should also be done for the Balance Forward Row (in this case Row 7).  This number CAN go negative

 

Total Company Owned

This will be the Unpaid Balance + the Paid Balance ( J + K)

 

 

 

 

 

 

 

 

  • No labels