Description |
Steps:
1. Create Inventory Transfer with Shipment required.
# Inventory > Inventory Transfer
# From Location = 0001 - Fort Wayne
# To Location = 0002 - Indianapolis
# *Shipment Required = checked*
# Item grid
## Item No = Rebuild1
## From Sub Location = Raw Station
## From Storage = RM Storage
## Ownership = Own
## Transfer Qty = 2
## To Sub Location = Indy
## To Storage = Indy Storage
# Click Post
# Click Close
{color:#ff0000}Issue: Missing In Transit entry in Inventory table that resulted to not balaced GL table and IC table.{color}
Acceptance Criteria: Re-align the Inventory Transfer posting with the In-Transit costing used in Shipment.
Used this query to verify IC and GL
select strBatchId, strTransactionId, dblQty, dblUOMQty, dblCost, intItemLocationId, intSubLocationId, intStorageLocationId, * from tblICInventoryTransaction where strTransactionId = 'IT-18'
select strBatchId, strTransactionId, intAccountId, strDescription, dblDebit, dblCredit, * from tblGLDetail where strTransactionId = 'IT-18'
First
!pastedImage_d77634_0.png!
If Inventory Transfer - Shipment required has impact on Inventory and Inventory in Transit accounts, therefore IC table should reflect 2 entries. +2 qty and -2 qty.
Use this queries to check if IC and GL is balanced.
select 'tblICInventoryTransaction', sum(t.dblQty * t.dblCost + t.dblValue)
from tblICInventoryTransaction t
where t.strTransactionId = 'IT-18'
and t.ysnIsUnposted = 0
select 'tblGLDetail',sum(g.dblDebit - g.dblCredit)
from tblGLDetail g inner join tblGLAccount ga
on g.intAccountId = ga.intAccountId
inner join tblGLAccountGroup gg
on gg.intAccountGroupId = ga.intAccountGroupId
where g.strTransactionId = 'IT-18'
and gg.strAccountGroup like 'Inventor%'
and g.ysnIsUnposted = 0
!pastedImage_d77634_1.png!
|