Featured Post

Dynamics GP 2018 is now Released

It is officially published that Microsoft Dynamics GP 2018 is available, the download link is provided below: Product download page ...

Friday, July 26, 2013

Inventory Transaction Flow

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;

  1. Available
  2. Batch receiving
  3. Marked to post
  4. Marked to print
  5. Marked to update
  6. 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..IV10000 | Inventory Transaction Work
#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.



Inventory Transaction Flow


Best Regards, 
Mahmoud M. AlSaadi



No comments:

Post a Comment