Page History
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 .
- Grain Inventory section
- Storage Liability
- 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 :
- 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)