Applying principles MS Dynamics NAV
J.Skorkovský, PhD.; ESF MU (KPH)


Ledger Entries
(created by Purchase and Sales Orders, Item Journals, Consumption, Production and Transfers)
Item
Purchase           Quantity = 10 pc  Remaining=0          Unit Cost = 1  Cost Amount = 10
Open=Yes         EN=100
Comments : EN=Item Entry Number ;  t=time in order to se seqences
Purchase           Quantity = 10 pc  Remaining=0          Unit Cost = 2  Cost Amount = 20
Open=Yes         EN=101
Sales                Quantity = 8 pc  Remaining=0      Sales Amount = 16  Cost Amount = 20
Open=No   EN=102
Stock value =10
Stock value =30
Purchase           Quantity = 10 pc  Remaining=2           Unit Cost = 1  Cost Amount = 10
Open=Yes         EN=100
Stock value =22
Sales                Quantity =  4 pc  Remaining=0      Sales Amount = 8      Cost Amount = 20
Open=No     EN=103
Purchase           Quantity = 10 pc  Remaining=0           Unit Cost = 1  Cost Amount = 10
Open=No         EN=100
Purchase           Quantity = 10 pc  Remaining=8          Unit Cost = 2  Cost Amount = 20
Open=Yes         EN=101
Stock value =16
t1
t2
t1
t2
30=10+20
22=30 -1x8
16=22 -1x2-2x2
t2
t1 – apply after first sale
t2 – apply after second sale
t2