Understanding
inventory transaction flow comes as an essential value for those who are
engaged in errors troubleshooting, reconciliation and reports generation.
Therefore, I am including a thorough explanation of the following points;
- Batch
- Inventory Work and Detail
- Inventory Posting
- Inventory Inquiries, Smart Lists and Reports Data sources
Batch
Header
#CompanyDB..SY00500 | Posting Definitions Master
DYNAMICS..SY00800 | Batch Activity
To manage
posting and prevent multiple users from having conflicts during batch operations,
GP Dynamics depends on (Batch Status) and (Batch Activity File) The batch
status could be;
- Available
- Batch receiving
- Marked to post
- Marked to print
- Marked to update
- Posting interrupted
During operations on the Batch | when any activity is applied on the batch, GP adds an activity record to the (Batch Activity File) indicating the operation applied on the batch, and changes the batch status accordingly
Completion | When posting and printing and posting are complete, dynamics removes the batch from the activity file (in case it is not recurring) and clear the (batch status) field.
Help Note !
The batch
number is not unique, it can be reused once an existing batch has been posted
(in case it is not recurring)
Inventory Work Header and Detail
#CompanyDB..IV10001 | Inventory Transaction Amounts Work
Summary of
transactions within a Batch is stored in the Work Header File. These
transactions are entered either from Transaction Entry Window or Transfer Entry
Window
The details of the transactions are stored in the Work Detail File and linked with their associated header file On Posting | the transactions are deleted from both files (Header and Details) and moved to History (in case of a single use Batch)
Quantity Allocation for on-hand quantity | the quantities associated with the saved transactions must be reserved and shown in the item card inquiry (the reserved quantity are shown under the quantity allocated field in the item card)
Work Header: Transfer
Bach
Number
|
Bach
Source
|
Document
Number
|
Document
Date
|
Transaction
Quantity
|
Posting
Date
|
GL
Posting Date
|
BCH_1_3
|
IV_Trans
|
Transfer1111
|
2013-07-01
|
120
|
2013-07-01
|
01072013
|
BCH_1_4
|
IV_Trans
|
Transfer1112
|
2013-07-01
|
20
|
2013-07-01
|
01072013
|
Work
Details: Transfer
Document
Number
|
Bach
Source
|
UOM
|
QTY
Base UOM
|
Unit
Cost
|
Extended
Cost
|
From
Location
|
To
Location
|
Transfer1111
|
100XLG
|
Each
|
1
|
10
|
1200
|
Main
|
North
|
Transfer1112
|
128
SDRAM
|
Each
|
1
|
20
|
400
|
Main
|
South
|
Inventory Transactions Posting
#CompanyDB..IV30300
| Inventory Transactions Amounts History
#CompanyDB..IV10200
| Inventory Purchase Receipts Work
#CompanyDB..IV10201
| Inventory Purchase Receipts Work Details
#CompanyDB..SEE30303
| Historical Inventory Trial Balance
On posting, the
transaction details are removed from both; work header and detail files; in
case of a single use batch, and moved into the following tables
As for GL
Posting, it is based on the (post to General Ledger Check Box) on the batch
posting window, which determines of the transactions Details are moved into GL
as well.
IV30300 | Inventory Transaction
Amounts History
Document No.
|
Doc Date
|
Item Number
|
UOFM
|
TRX QTY
|
Unit Cost
|
EXD Cost
|
Location Code
|
To LOCTN
|
QTY Base UOM
|
Transfer1111
|
2013-07-01
|
100XLG
|
Each
|
100
|
10
|
1000
|
Main
|
North
|
1
|
IV10200 | Inventory
Purchase Receipts Work
Receipt Number
|
DATERECD
|
Item Number
|
Location Code
|
QTYRECVD
|
QTYSOLD
|
QTYCOMTD
|
QTYRESERVED
|
UNITCOST
|
ADJUNITCOST
|
Transfer1111
|
2013-07-01
|
100XLG
|
North
|
100
|
0
|
0
|
0
|
10
|
10
|
IV10201 | Inventory Purchase Receipts Work Detail
Item Number
|
TRXLOCTN
|
Doc Date
|
Document No.
|
QTY SOLD
|
UNITCOST
|
100XLG
|
Main
|
2013-07-01
|
Transfer1111
|
100
|
10
|
SEE30303 | Historical Inventory Trial
Balance (Linked to GL through Journal Entry Field)
Item Number
|
Document No.
|
LOCN CODE
|
UOFM
|
BASE QTY
|
Unit Cost
|
EXD Cost
|
JRNENTRY
|
Debit
|
Credit
|
100XLG
|
Transfer1111
|
North
|
Each
|
100
|
10
|
1000
|
125
|
1000
|
0
|
100XLG
|
Transfer1111
|
Main
|
Each
|
-100
|
10
|
-1000
|
125
|
0
|
1000
|
Inventory
Inquiries, Smart Lists and Reports Data sources
Inventory Table
|
Inventory Window
|
SEE30303
|
HITB Activity (Historical Inventory Trial Balance) | Report and Smart List
|
IV10200
|
Stock Status |Report and Smart List
|
IV10200
|
Inventory Purchase Receipt |Report and Smart List
|
IV30300 and IV10200
|
Item Stock Inquiry
|
IV10200 and IV10201
|
Cost Layers (QTY Sold) | Smart List
|
Finally, a
transaction flow diagram is provided below in order to illustrate the ideas
explained above.
Best
Regards,
Mahmoud M.
AlSaadi
No comments:
Post a Comment