Inventory Items Cost Increased and we don't know why

(0) Share

Report

Posted on by chills

120

We have come across a few items where the cost more than doubled which makes it appear they are being sold at a loss. We use the weighted avg cost but we have determined that is working fine. One item we received into inventory on 11/3 and the cost was correct at @ $41 but then something happened and the cost went to $85 showing in inventtrans table and we can't figure out. Has anyone else had this happen and have any idea what could have caused it or any suggestions?

Sample from inventtrans table:

ITEMID	STATUSISSUE	DATEPHYSICAL	QTY	COSTAMOUNTPOSTED	cost per case	CURRENCYCODE	TRANSTYPE	TRANSREFID	INVOICEID	VOUCHER	INVENTTRANSIDTRANSFER
FB-PK32T-W	0	10/31/2014	102	4320.23	42.36	USD	7			10089
FB-PK32T-W	1	10/31/2014	-102	-4320.23	42.36	USD	7			10089
FB-PK32T-W	1	11/1/2014	-8	-334.48	41.81	USD	0	SO-268481	INV-218017	INV-218017
FB-PK32T-W	0	11/3/2014	96	3982.08	41.48	USD	3	PO-115666	90545704	API-110017086
FB-PK32T-W	1	11/3/2014	-16	-1369.12	85.57	USD	6	95569		ITV086640	2563365
FB-PK32T-W	0	11/3/2014	16	1369.12	85.57	USD	6	95569		ITV086640	2563364
FB-PK32T-W	1	11/3/2014	-32	-2738.24	85.57	USD	6	95572		ITV086643	2563372
FB-PK32T-W	0	11/3/2014	32	2738.24	85.57	USD	6	95572		ITV086643	2563371
FB-PK32T-W	1	11/3/2014	-16	-1369.12	85.57	USD	6	95575		ITV086646	2563398

ITEMID	STATUSISSUE	DATEPHYSICAL	QTY	COSTAMOUNTPOSTED	cost per case	CURRENCYCODE	TRANSTYPE	TRANSREFID	INVOICEID	VOUCHER	INVENTTRANSIDTRANSFER	DATEEXPECTED	DATEFINANCIAL
FB-PK32T-W	0	10/31/2014	102	4320.23	42.36	USD	7			10089		10/31/2014	10/31/2014
FB-PK32T-W	1	10/31/2014	-102	-4320.23	42.36	USD	7			10089		10/31/2014	10/31/2014
FB-PK32T-W	1	11/1/2014	-8	-334.48	41.81	USD	0	SO-268481	INV-218017	INV-218017		11/3/2014	11/1/2014
FB-PK32T-W	0	11/3/2014	96	3982.08	41.48	USD	3	PO-115666	90545704	API-110017086		10/29/2014	11/7/2014
FB-PK32T-W	1	11/3/2014	-16	-1369.12	85.57	USD	6	95569		ITV086640	2563365	11/3/2014	11/3/2014
FB-PK32T-W	0	11/3/2014	16	1369.12	85.57	USD	6	95569		ITV086640	2563364	11/3/2014	11/3/2014
FB-PK32T-W	1	11/3/2014	-32	-2738.24	85.57	USD	6	95572		ITV086643	2563372	11/3/2014	11/3/2014
FB-PK32T-W	0	11/3/2014	32	2738.24	85.57	USD	6	95572		ITV086643	2563371	11/3/2014	11/3/2014
FB-PK32T-W	1	11/3/2014	-16	-1369.12	85.57	USD	6	95575		ITV086646	2563398	11/3/2014	11/3/2014

*This post is locked for comments

I have the same question (0)

All responses (10)

Answers (0)

André Arnaud de Cal... 301,158 Super User 2025 Season 2 on at

Like (0)

Report

Hi Chills,

I have seen something similar before. I have done troubleshooting a lot on inventory transations. Within the tables you shared, I can see it was wrong, but not what caused it.

I can see the transaction type where the wrong cost is used, is a transfer order. Can you share the settings of the Inventory Dimension group? For which inventory dimensions did you activate or did not activate the physical and financial inventory?

I think this is just a snapshot of some transactions from this Item? How many transactions does this item have?

Was this reply helpful? Yes No

chills

120 on at

Like (0)

Report

Thanks for your quick reply. I will send you additional info that you may need to help us and if I send the wrong info just let me know. Here is a screen shot of the transfer journal info and complete inventtrans file for the item since 10/30.

Thanks for your quick reply. Please see attached it probably isn’t the exact info that you want but I will send more ASAP.

Thanks!

ITEMID	STATUSISSUE	DATEPHYSICAL	QTY	COSTAMOUNTPOSTED	cost per case	CURRENCYCODE	TRANSTYPE	TRANSREFID	INVOICEID	VOUCHER	INVENTTRANSIDTRANSFER	DATEEXPECTED	DATEFINANCIAL	COSTAMOUNTPHYSICAL	INVENTTRANSID	STATUSRECEIPT	PACKINGSLIPRETURNED	INVOICERETURNED	PACKINGSLIPID	VOUCHERPHYSICAL	COSTAMOUNTADJUSTMENT	SHIPPINGDATEREQUESTED	SHIPPINGDATECONFIRMED	QTYSETTLED	COSTAMOUNTSETTLED	VALUEOPEN	DIRECTION	ACTIVITYNUMBER	DATESTATUS	COSTAMOUNTSTD	DATECLOSED	PICKINGROUTEID	INVENTTRANSIDFATHER	COSTAMOUNTOPERATIONS	INVENTTRANSIDRETURN	PROJID	PROJCATEGORYID	INVENTDIMID	INVENTDIMFIXED	DATEINVENT	CUSTVENDAC	TRANSCHILDREFID	TRANSCHILDTYPE	REVENUEAMOUNTPHYSICAL	ASSETID	PROJADJUSTREFID	TAXAMOUNTPHYSICAL	ASSETBOOKID	INVENTREFTRANSID	PROBABILITYID	DATAAREAID	RECVERSION	RECID
FB-PK32T-W	0	10/31/2014	102	4320.23	42.36	USD	7			10089		10/31/2014	10/31/2014	4320.23	2562475	1	0	0		10089	0	00:00.0	00:00.0	93	3939.04	1	1		00:00.0	4320.23	00:00.0			0				1	0	00:00.0			0	0			0			0	gcn	1501795237	5639777473
FB-PK32T-W	1	10/31/2014	-102	-4320.23	42.36	USD	7			10089		10/31/2014	10/31/2014	-4320.23	2562475	0	0	0		10089	0	00:00.0	00:00.0	-102	-4320.23	0	2		00:00.0	-4320.23	00:00.0			0				1	0	00:00.0			0	0			0			0	gcn	1880793402	5639777474
FB-PK32T-W	1	11/1/2014	-8	-334.48	41.81	USD	0	SO-268481	INV-218017	INV-218017		11/3/2014	11/1/2014	-334.48	2558770	0	0	0	PK-229226	PK-229226	-4.36	00:00.0	00:00.0	0	0	1	2		00:00.0	-334.48	00:00.0	PR-226583		334.48				6792	257	00:00.0	110913		0	0			0			0	gcn	830089233	5639776011
FB-PK32T-W	0	11/3/2014	96	3982.08	41.48	USD	3	PO-115666	90545704	API-110017086		10/29/2014	11/7/2014	3982.08	2549349	1	0	0	88871	APS020639	0	00:00.0	00:00.0	0	0	1	1		00:00.0	3982.08	00:00.0			0				4710	0	00:00.0	1124		0	0			0			0	gcn	466212760	5639763383
FB-PK32T-W	1	11/3/2014	-16	-1369.12	85.57	USD	6	95569		ITV086640	2563365	11/3/2014	11/3/2014	-1369.12	2563364	0	0	0		ITV086640	0	00:00.0	00:00.0	0	0	1	2		00:00.0	-1369.12	00:00.0			1369.12				4710	0	00:00.0			0	0			0			0	gcn	19423469	5639779334
FB-PK32T-W	0	11/3/2014	16	1369.12	85.57	USD	6	95569		ITV086640	2563364	11/3/2014	11/3/2014	1369.12	2563365	1	0	0		ITV086640	0	00:00.0	00:00.0	0	0	1	1		00:00.0	1369.12	00:00.0			-1369.12				7434	0	00:00.0			0	0			0			0	gcn	1497076577	5639779335
FB-PK32T-W	1	11/3/2014	-32	-2738.24	85.57	USD	6	95572		ITV086643	2563372	11/3/2014	11/3/2014	-2738.24	2563371	0	0	0		ITV086643	0	00:00.0	00:00.0	0	0	1	2		00:00.0	-2738.24	00:00.0			2738.24				4710	0	00:00.0			0	0			0			0	gcn	1481148649	5639779341
FB-PK32T-W	0	11/3/2014	32	2738.24	85.57	USD	6	95572		ITV086643	2563371	11/3/2014	11/3/2014	2738.24	2563372	1	0	0		ITV086643	0	00:00.0	00:00.0	0	0	1	1		00:00.0	2738.24	00:00.0			-2738.24				7434	0	00:00.0			0	0			0			0	gcn	1983952914	5639779342
FB-PK32T-W	1	11/3/2014	-16	-1369.12	85.57	USD	6	95575		ITV086646	2563398	11/3/2014	11/3/2014	-1369.12	2563397	0	0	0		ITV086646	0	00:00.0	00:00.0	0	0	1	2		00:00.0	-1369.12	00:00.0			1369.12				4710	0	00:00.0			0	0			0			0	gcn	1907844648	5639779368
FB-PK32T-W	0	11/3/2014	16	1369.12	85.57	USD	6	95575		ITV086646	2563397	11/3/2014	11/3/2014	1369.12	2563398	1	0	0		ITV086646	0	00:00.0	00:00.0	0	0	1	1		00:00.0	1369.12	00:00.0			-1369.12				7434	0	00:00.0			0	0			0			0	gcn	474735921	5639779369
FB-PK32T-W	1	11/3/2014	-16	-1369.12	85.57	USD	6	95591		ITV086662	2563483	11/3/2014	11/3/2014	-1369.12	2563482	0	0	0		ITV086662	0	00:00.0	00:00.0	0	0	1	2		00:00.0	-1369.12	00:00.0			1369.12				4710	0	00:00.0			0	0			0			0	gcn	1074323453	5639779462
FB-PK32T-W	0	11/3/2014	16	1369.12	85.57	USD	6	95591		ITV086662	2563482	11/3/2014	11/3/2014	1369.12	2563483	1	0	0		ITV086662	0	00:00.0	00:00.0	0	0	1	1		00:00.0	1369.12	00:00.0			-1369.12				6792	0	00:00.0			0	0			0			0	gcn	985721807	5639779463
FB-PK32T-W	1	11/3/2014	-16	-1369.12	85.57	USD	6	95643		ITV086714	2563702	11/3/2014	11/3/2014	-1369.12	2563701	0	0	0		ITV086714	0	00:00.0	00:00.0	0	0	1	2		00:00.0	-1369.12	00:00.0			1369.12				4710	0	00:00.0			0	0			0			0	gcn	1968683182	5639779696
FB-PK32T-W	0	11/3/2014	16	1369.12	85.57	USD	6	95643		ITV086714	2563701	11/3/2014	11/3/2014	1369.12	2563702	1	0	0		ITV086714	0	00:00.0	00:00.0	0	0	1	1		00:00.0	1369.12	00:00.0			-1369.12				7434	0	00:00.0			0	0			0			0	gcn	1913969471	5639779697
FB-PK32T-W	1	11/5/2014	-1	-85.57	85.57	USD	0	SO-268745	INV-218281	INV-218281		11/5/2014	11/5/2014	-85.57	2564256	0	0	0	PK-229506	PK-229506	0	00:00.0	00:00.0	0	0	1	2		00:00.0	-85.57	00:00.0	PR-227445		85.57				7434	257	00:00.0	110930		0	0			0			0	gcn	1084138669	5639780290
FB-PK32T-W	1	11/5/2014	-7	-598.99	85.57	USD	0	SO-268776	INV-218252	INV-218252		11/6/2014	11/5/2014	-598.99	2564513	0	0	0	PK-229477	PK-229477	0	00:00.0	00:00.0	0	0	1	2		00:00.0	-598.99	00:00.0	PR-227330		598.99				6792	257	00:00.0	110913		0	0			0			0	gcn	1210608289	5639780561
FB-PK32T-W	1	11/5/2014	-10	-855.7	85.57	USD	0	SO-268776	INV-218252	INV-218252		11/6/2014	11/5/2014	-855.7	2564513	0	0	0	PK-229477	PK-229477	0	00:00.0	00:00.0	0	0	1	2		00:00.0	-855.7	00:00.0	PR-227330		855.7				6792	261	00:00.0	110913		0	0			0			0	gcn	1868081971	5639785117
FB-PK32T-W	1	11/5/2014	-7	-598.99	85.57	USD	0	SO-268776	INV-218252	INV-218252		11/6/2014	11/5/2014	-598.99	2564513	0	0	0	PK-229477	PK-229477	0	00:00.0	00:00.0	0	0	1	2		00:00.0	-598.99	00:00.0	PR-227330		598.99				7434	261	00:00.0	110913		0	0			0			0	gcn	1467732082	5639785091
FB-PK32T-W	1	11/5/2014	-1	-85.57	85.57	USD	0	SO-268785	INV-218253	INV-218253		11/6/2014	11/5/2014	-85.57	2564698	0	0	0	PK-229478	PK-229478	0	00:00.0	00:00.0	0	0	1	2		00:00.0	-85.57	00:00.0	PR-227331		85.57				7434	257	00:00.0	110913		0	0			0			0	gcn	683783535	5639780752
FB-PK32T-W	1	11/5/2014	-5	-427.85	85.57	USD	6	95956		ITV087027	2567464	11/5/2014	11/5/2014	-427.85	2567463	0	0	0		ITV087027	0	00:00.0	00:00.0	0	0	1	2		00:00.0	-427.85	00:00.0			427.85				7434	0	00:00.0			0	0			0			0	gcn	732476921	5639783835
FB-PK32T-W	0	11/5/2014	5	427.85	85.57	USD	6	95956		ITV087027	2567463	11/5/2014	11/5/2014	427.85	2567464	1	0	0		ITV087027	0	00:00.0	00:00.0	0	0	1	1		00:00.0	427.85	00:00.0			-427.85				6792	0	00:00.0			0	0			0			0	gcn	416095315	5639783836
FB-PK32T-W	1	11/5/2014	-5	-427.85	85.57	USD	6	95957		ITV087028	2567467	11/5/2014	11/5/2014	-427.85	2567466	0	0	0		ITV087028	0	00:00.0	00:00.0	0	0	1	2		00:00.0	-427.85	00:00.0			427.85				6792	0	00:00.0			0	0			0			0	gcn	1767696129	5639783838
FB-PK32T-W	0	11/5/2014	5	427.85	85.57	USD	6	95957		ITV087028	2567466	11/5/2014	11/5/2014	427.85	2567467	1	0	0		ITV087028	0	00:00.0	00:00.0	0	0	1	1		00:00.0	427.85	00:00.0			-427.85				7434	0	00:00.0			0	0			0			0	gcn	882554304	5639783839
FB-PK32T-W	1	11/5/2014	-5	-427.85	85.57	USD	6	95961		ITV087033	2567480	11/5/2014	11/5/2014	-427.85	2567479	0	0	0		ITV087033	0	00:00.0	00:00.0	0	0	1	2		00:00.0	-427.85	00:00.0			427.85				7434	0	00:00.0			0	0			0			0	gcn	1732179623	5639783851
FB-PK32T-W	0	11/5/2014	5	427.85	85.57	USD	6	95961		ITV087033	2567479	11/5/2014	11/5/2014	427.85	2567480	1	0	0		ITV087033	0	00:00.0	00:00.0	0	0	1	1		00:00.0	427.85	00:00.0			-427.85				6792	0	00:00.0			0	0			0			0	gcn	590482822	5639783852
FB-PK32T-W	1	11/5/2014	-5	-427.85	85.57	USD	6	95961		ITV087033	2567482	11/5/2014	11/5/2014	-427.85	2567481	0	0	0		ITV087033	0	00:00.0	00:00.0	0	0	1	2		00:00.0	-427.85	00:00.0			427.85				6792	0	00:00.0			0	0			0			0	gcn	521520731	5639783853
FB-PK32T-W	0	11/5/2014	5	427.85	85.57	USD	6	95961		ITV087033	2567481	11/5/2014	11/5/2014	427.85	2567482	1	0	0		ITV087033	0	00:00.0	00:00.0	0	0	1	1		00:00.0	427.85	00:00.0			-427.85				7434	0	00:00.0			0	0			0			0	gcn	742502424	5639783854

Was this reply helpful? Yes No

chills 120 on at

Like (0)

Report

inventtransposting

ITEMID INVENTTRANSID TRANSDATE VOUCHER POSTINGTYPE POSTINGTYPEOFFSET ACCOUNT ACCOUNTOFFSET DIMENSION DIMENSION2_ DIMENSION3_ INVENTTRANSPOSTINGTYPE ISPOSTED PROJID DATAAREAID RECVERSION RECID DIMENSION4_

FB-PK32T-W 2549349 2014-11-03 00:00:00.000 APS020639 82 83 1400 2003 0 1 gcn 1 5640966477 Apex

FB-PK32T-W 2563364 2014-11-03 00:00:00.000 ITV086640 0 0 0 0 gcn 1 5640966400

FB-PK32T-W 2563364 2014-11-03 00:00:00.000 ITV086640 92 220 1400 1220 1 0 gcn 1 5640966401

FB-PK32T-W 2563365 2014-11-03 00:00:00.000 ITV086640 0 0 0 0 gcn 1 5640966402 Apex

FB-PK32T-W 2563365 2014-11-03 00:00:00.000 ITV086640 91 219 1400 2018 1 0 gcn 1 5640966403 Apex

FB-PK32T-W 2563371 2014-11-03 00:00:00.000 ITV086643 0 0 0 0 gcn 1 5640966428

FB-PK32T-W 2563371 2014-11-03 00:00:00.000 ITV086643 92 220 1400 1220 1 0 gcn 1 5640966429

FB-PK32T-W 2563372 2014-11-03 00:00:00.000 ITV086643 0 0 0 0 gcn 1 5640966430 Apex

FB-PK32T-W 2563372 2014-11-03 00:00:00.000 ITV086643 91 219 1400 2018 1 0 gcn 1 5640966431 Apex

FB-PK32T-W 2563397 2014-11-03 00:00:00.000 ITV086646 0 0 0 0 gcn 1 5640966440

FB-PK32T-W 2563397 2014-11-03 00:00:00.000 ITV086646 92 220 1400 1220 1 0 gcn 1 5640966441

FB-PK32T-W 2563398 2014-11-03 00:00:00.000 ITV086646 0 0 0 0 gcn 1 5640966442 Apex

FB-PK32T-W 2563398 2014-11-03 00:00:00.000 ITV086646 91 219 1400 2018 1 0 gcn 1 5640966443 Apex

FB-PK32T-W 2563482 2014-11-03 00:00:00.000 ITV086662 0 0 0 0 gcn 1 5640966533

FB-PK32T-W 2563482 2014-11-03 00:00:00.000 ITV086662 92 220 1400 1220 1 0 gcn 1 5640966534

FB-PK32T-W 2563483 2014-11-03 00:00:00.000 ITV086662 0 0 0 0 gcn 1 5640966535 Apex

FB-PK32T-W 2563483 2014-11-03 00:00:00.000 ITV086662 91 219 1400 2018 1 0 gcn 1 5640966536 Apex

FB-PK32T-W 2563701 2014-11-03 00:00:00.000 ITV086714 0 0 0 0 gcn 1 5640966796

FB-PK32T-W 2563701 2014-11-03 00:00:00.000 ITV086714 92 220 1400 1220 1 0 gcn 1 5640966797

FB-PK32T-W 2563702 2014-11-03 00:00:00.000 ITV086714 0 0 0 0 gcn 1 5640966798 Apex

FB-PK32T-W 2563702 2014-11-03 00:00:00.000 ITV086714 91 219 1400 2018 1 0 gcn 1 5640966799 Apex

FB-PK32T-W 2564513 2014-11-05 00:00:00.000 INV-218252 61 52 1400 5000 1 1 gcn 1 5640974110 Apex

FB-PK32T-W 2564698 2014-11-05 00:00:00.000 INV-218253 61 52 1400 5000 1 1 gcn 1 5640974112 Apex

FB-PK32T-W 2564256 2014-11-05 00:00:00.000 INV-218281 61 52 1400 5000 1 1 gcn 1 5640974727 Apex

FB-PK32T-W 2567463 2014-11-05 00:00:00.000 ITV087027 0 0 0 0 gcn 1 5640972417

FB-PK32T-W 2567463 2014-11-05 00:00:00.000 ITV087027 92 220 1400 1220 1 0 gcn 1 5640972418

FB-PK32T-W 2567464 2014-11-05 00:00:00.000 ITV087027 0 0 0 0 gcn 1 5640972419 Apex

FB-PK32T-W 2567464 2014-11-05 00:00:00.000 ITV087027 91 219 1400 2018 1 0 gcn 1 5640972420 Apex

FB-PK32T-W 2567466 2014-11-05 00:00:00.000 ITV087028 0 0 0 0 gcn 1 5640972421

FB-PK32T-W 2567466 2014-11-05 00:00:00.000 ITV087028 92 220 1400 1220 1 0 gcn 1 5640972422

FB-PK32T-W 2567467 2014-11-05 00:00:00.000 ITV087028 0 0 0 0 gcn 1 5640972423 Apex

FB-PK32T-W 2567467 2014-11-05 00:00:00.000 ITV087028 91 219 1400 2018 1 0 gcn 1 5640972424 Apex

FB-PK32T-W 2567479 2014-11-05 00:00:00.000 ITV087033 0 0 0 0 gcn 1 5640972441 Apex

FB-PK32T-W 2567479 2014-11-05 00:00:00.000 ITV087033 92 220 1400 1220 1 0 gcn 1 5640972442 Apex

FB-PK32T-W 2567480 2014-11-05 00:00:00.000 ITV087033 0 0 0 0 gcn 1 5640972443 Apex

FB-PK32T-W 2567480 2014-11-05 00:00:00.000 ITV087033 91 219 1400 2018 1 0 gcn 1 5640972444 Apex

FB-PK32T-W 2567481 2014-11-05 00:00:00.000 ITV087033 0 0 0 0 gcn 1 5640972445 Apex

FB-PK32T-W 2567481 2014-11-05 00:00:00.000 ITV087033 92 220 1400 1220 1 0 gcn 1 5640972446 Apex

FB-PK32T-W 2567482 2014-11-05 00:00:00.000 ITV087033 0 0 0 0 gcn 1 5640972447 Apex

FB-PK32T-W 2567482 2014-11-05 00:00:00.000 ITV087033 91 219 1400 2018 1 0 gcn 1 5640972448 Apex

FB-PK32T-W 2564513 2014-11-05 00:00:00.000 PK-229477 59 60 1400 1401 0 1 gcn 1 5640974040 Apex

FB-PK32T-W 2564698 2014-11-05 00:00:00.000 PK-229478 59 60 1400 1401 0 1 gcn 1 5640974042 Apex

FB-PK32T-W 2564256 2014-11-05 00:00:00.000 PK-229506 59 60 1400 1401 0 1 gcn 1 5640974673 Apex

FB-PK32T-W 2549349 2014-11-07 00:00:00.000 API-110017086 84 71 1400 4100 1 1 gcn 1 5640977204 Apex

Was this reply helpful? Yes No
André Arnaud de Cal... 301,158 Super User 2025 Season 2 on at

Like (0)

Report

Hi Chills,

I don't know if we can find the cause using this forum, but we can give it a try...

What I'm looking for is if there is history of this item before October 30. Also I would like to know the settings on the inventory dimension group related to this item.

Was this reply helpful? Yes No
Guy Terry 28,924 Moderator on at

Like (0)

Report

Hi Chills,

Can you also say:

How many were left in stock after the 8 were sold on 1st Nov?

On the Item Model Group for the item, is 'Include physical value' ticked or unticked?

The cost amount from InventTrans is actually CostAmountPosted + CostAmountAdjusted. For the transactions you have shown in November, is there any value in the CostAmountAdj field? I assume not, since you won't have done an Inventory Close this month, but please check.

Was this reply helpful? Yes No
chills 120 on at

Like (0)

Report

Hi Andre,

Yes this is an item we have been selling for a long time. Below contains Oct. transactions as well. I will get you the dimension info ASAP. Thank you!

ITEMID STATUSISSUE DATEPHYSICAL QTY COSTAMOUNTPOSTED CURRENCYCODE TRANSTYPE TRANSREFID INVOICEID VOUCHER INVENTTRANSIDTRANSFER DATEEXPECTED DATEFINANCIAL COSTAMOUNTPHYSICAL INVENTTRANSID STATUSRECEIPT PACKINGSLIPRETURNED INVOICERETURNED PACKINGSLIPID VOUCHERPHYSICAL COSTAMOUNTADJUSTMENT SHIPPINGDATEREQUESTED SHIPPINGDATECONFIRMED QTYSETTLED COSTAMOUNTSETTLED VALUEOPEN DIRECTION ACTIVITYNUMBER DATESTATUS COSTAMOUNTSTD DATECLOSED PICKINGROUTEID INVENTTRANSIDFATHER COSTAMOUNTOPERATIONS INVENTTRANSIDRETURN PROJID PROJCATEGORYID INVENTDIMID INVENTDIMFIXED DATEINVENT CUSTVENDAC TRANSCHILDREFID TRANSCHILDTYPE REVENUEAMOUNTPHYSICAL ASSETID PROJADJUSTREFID TAXAMOUNTPHYSICAL ASSETBOOKID INVENTREFTRANSID PROBABILITYID DATAAREAID RECVERSION RECID

FB-PK32T-W 1 10/1/2014 -4 -173.89 USD 0 SO-266067 INV-216128 INV-216128 10/1/2014 10/1/2014 -173.89 2515774 0 0 0 PK-227102 PK-227102 4.47 10/1/2014 1/1/1900 -4 -169.42 0 2 10/1/2014 -173.89 10/31/2014 PR-221360 173.89 6792 257 10/1/2014 110695 0 0 0 0 gcn 1549772010 5639727185

FB-PK32T-W 1 10/2/2014 -15 -668.67 USD 0 SO-266246 INV-216234 INV-216234 9/29/2014 10/2/2014 -668.67 2518990 0 0 0 PK-227213 PK-227213 33.34 9/29/2014 1/1/1900 -15 -635.33 0 2 10/2/2014 -668.67 10/31/2014 PR-221583 668.67 6792 257 10/2/2014 111018 0 0 0 0 gcn 657226974 5639730570

FB-PK32T-W 1 10/7/2014 -1 -44.58 USD 0 SO-266729 INV-216494 INV-216494 10/6/2014 10/7/2014 -44.58 2528476 0 0 0 PK-227506 PK-227506 2.22 10/6/2014 1/1/1900 -1 -42.36 0 2 10/7/2014 -44.58 10/31/2014 PR-222384 44.58 6792 257 10/7/2014 110930 0 0 0 0 gcn 1896605770 5639741704

FB-PK32T-W 1 10/7/2014 -1 -44.58 USD 0 SO-266861 INV-216469 INV-216469 10/8/2014 10/7/2014 -44.58 2531033 0 0 0 PK-227481 PK-227481 2.22 10/8/2014 1/1/1900 -1 -42.36 0 2 10/7/2014 -44.58 10/31/2014 PR-222277 44.58 6792 257 10/7/2014 111791 0 0 0 0 gcn 1687858811 5639744155

FB-PK32T-W 1 10/8/2014 -1 -44.58 USD 0 SO-266981 INV-216617 INV-216617 10/9/2014 10/8/2014 -44.58 2533411 0 0 0 PK-227664 PK-227664 2.22 10/9/2014 1/1/1900 -1 -42.36 0 2 10/8/2014 -44.58 10/31/2014 PR-222780 44.58 6792 257 10/8/2014 111797 0 0 0 0 gcn 1839409926 5639746476

FB-PK32T-W 1 10/8/2014 -1 -44.58 USD 0 SO-266987 INV-216583 INV-216583 10/9/2014 10/8/2014 -44.58 2533520 0 0 0 PK-227630 PK-227630 2.22 10/9/2014 1/1/1900 -1 -42.36 0 2 10/8/2014 -44.58 10/31/2014 PR-222629 44.58 6792 257 10/8/2014 111759 0 0 0 0 gcn 816328604 5639746586

FB-PK32T-W 0 10/13/2014 50 2049 USD 3 PO-115530 90542877 API-110016923 10/10/2014 10/17/2014 2240 2528148 1 0 0 9543 APS020454 0 1/1/1900 1/1/1900 50 2049 0 1 10/17/2014 2049 10/31/2014 0 6792 0 10/13/2014 1124 0 0 0 0 gcn 1328827560 5639741135

FB-PK32T-W 1 10/13/2014 -1 -44.58 USD 0 SO-267282 INV-216836 INV-216836 10/14/2014 10/13/2014 -44.58 2538149 0 0 0 PK-227896 PK-227896 2.23 10/14/2014 1/1/1900 -1 -42.35 0 2 10/13/2014 -44.58 10/31/2014 PR-223256 44.58 6792 257 10/13/2014 111519 0 0 0 0 gcn 1417950205 5639751675

FB-PK32T-W 1 10/14/2014 -2 -89.16 USD 0 SO-267053 INV-216917 INV-216917 10/15/2014 10/14/2014 -89.16 2534389 0 0 0 PK-227990 PK-227990 4.45 10/15/2014 1/1/1900 -2 -84.71 0 2 10/14/2014 -89.16 10/31/2014 PR-223550 89.16 6792 257 10/14/2014 110695 0 0 0 0 gcn 214220073 5639747408

FB-PK32T-W 1 10/14/2014 -4 -178.31 USD 0 SO-267053 INV-216917 INV-216917 10/15/2014 10/14/2014 -178.31 2536688 0 0 0 PK-227990 PK-227990 8.89 10/15/2014 1/1/1900 -4 -169.42 0 2 10/14/2014 -178.31 10/31/2014 PR-223550 178.31 6792 257 10/14/2014 110695 0 0 0 0 gcn 1542101468 5639750106

FB-PK32T-W 1 10/14/2014 -4 -178.31 USD 0 SO-267370 INV-216892 INV-216892 10/14/2014 10/14/2014 -178.31 2539408 0 0 0 PK-227965 PK-227965 8.89 10/14/2014 1/1/1900 -4 -169.42 0 2 10/14/2014 -178.31 10/31/2014 PR-223476 178.31 6792 257 10/14/2014 111004 0 0 0 0 gcn 1640369379 5639753003

FB-PK32T-W 1 10/15/2014 -2 -89.15 USD 0 SO-267479 INV-216984 INV-216984 10/16/2014 10/15/2014 -89.15 2540931 0 0 0 PK-228090 PK-228090 4.44 10/16/2014 1/1/1900 -2 -84.71 0 2 10/15/2014 -89.15 10/31/2014 PR-223712 89.15 6792 257 10/15/2014 111759 0 0 0 0 gcn 639369734 5639754653

FB-PK32T-W 1 10/16/2014 -1 -44.58 USD 0 SO-267476 INV-217007 INV-217007 10/16/2014 10/16/2014 -44.58 2540833 0 0 0 PK-228113 PK-228113 2.22 10/16/2014 1/1/1900 -1 -42.36 0 2 10/16/2014 -44.58 10/31/2014 PR-223780 44.58 6792 257 10/15/2014 110839 0 0 0 0 gcn 512007813 5639754552

FB-PK32T-W 1 10/17/2014 -10 -418.1 USD 0 SO-267218 INV-217142 INV-217142 10/13/2014 10/17/2014 -418.1 2536882 0 0 0 PK-228247 PK-228247 -5.45 10/13/2014 1/1/1900 -10 -423.55 0 2 10/17/2014 -418.1 10/31/2014 PR-224247 418.1 6792 257 10/17/2014 111018 0 0 0 0 gcn 1760766280 5639750347

FB-PK32T-W 1 10/21/2014 -1 -41.81 USD 0 SO-267807 INV-217309 INV-217309 10/21/2014 10/21/2014 -41.81 2546321 0 0 0 PK-228435 PK-228435 -0.54 10/21/2014 1/1/1900 -1 -42.35 0 2 10/21/2014 -41.81 10/31/2014 PR-224560 41.81 6792 257 10/21/2014 110930 0 0 0 0 gcn 1356839711 5639760094

FB-PK32T-W 1 10/21/2014 -2 -83.62 USD 0 SO-267878 INV-217314 INV-217314 10/21/2014 10/21/2014 -83.62 2547565 0 0 0 PK-228440 PK-228440 -1.09 10/21/2014 1/1/1900 -2 -84.71 0 2 10/21/2014 -83.62 10/31/2014 PR-224535 83.62 6792 257 10/21/2014 111004 0 0 0 0 gcn 1112441241 5639761393

FB-PK32T-W 1 10/22/2014 -10 -418.1 USD 0 SO-267801 INV-217390 INV-217390 10/23/2014 10/22/2014 -418.1 2546245 0 0 0 PK-228523 PK-228523 -5.45 10/23/2014 1/1/1900 -10 -423.55 0 2 10/22/2014 -418.1 10/31/2014 PR-224781 418.1 6792 257 10/22/2014 111018 0 0 0 0 gcn 201708867 5639760018

FB-PK32T-W 1 10/22/2014 -1 -41.81 USD 0 SO-267950 INV-217395 INV-217395 10/23/2014 10/22/2014 -41.81 2548565 0 0 0 PK-228528 PK-228528 -0.55 10/23/2014 1/1/1900 -1 -42.36 0 2 10/22/2014 -41.81 10/31/2014 PR-224788 41.81 6792 257 10/22/2014 111730 0 0 0 0 gcn 82432032 5639762581

FB-PK32T-W 1 10/22/2014 -1 -41.81 USD 0 SO-267994 INV-217398 INV-217398 10/23/2014 10/22/2014 -41.81 2549177 0 0 0 PK-228531 PK-228531 -0.54 10/23/2014 1/1/1900 -1 -42.35 0 2 10/22/2014 -41.81 10/31/2014 PR-224787 41.81 6792 257 10/22/2014 110478 0 0 0 0 gcn 1060453709 5639763221

FB-PK32T-W 1 10/24/2014 -27 -1128.88 USD 0 SO-267759 INV-217580 INV-217580 10/20/2014 10/24/2014 -1128.88 2545521 0 0 0 PK-228738 PK-228738 -14.71 10/20/2014 1/1/1900 -27 -1143.59 0 2 10/24/2014 -1128.88 10/31/2014 PR-225238 1128.88 6792 257 10/24/2014 110913 0 0 0 0 gcn 679247612 5639759578

FB-PK32T-W 1 10/24/2014 -1 -41.81 USD 0 SO-268164 INV-217583 INV-217583 10/27/2014 10/24/2014 -41.81 2552552 0 0 0 PK-228741 PK-228741 -0.54 10/27/2014 1/1/1900 -1 -42.35 0 2 10/24/2014 -41.81 10/31/2014 PR-225243 41.81 6792 257 10/24/2014 110835 0 0 0 0 gcn 1333044478 5639766206

FB-PK32T-W 1 10/25/2014 -1 -41.81 USD 0 SO-268094 INV-217596 INV-217596 10/23/2014 10/25/2014 -41.81 2550631 0 0 0 PK-228754 PK-228754 -0.55 10/23/2014 1/1/1900 -1 -42.36 0 2 10/25/2014 -41.81 10/31/2014 PR-225360 41.81 6792 257 10/25/2014 110478 0 0 0 0 gcn 1252120685 5639764868

FB-PK32T-W 1 10/28/2014 -2 -83.62 USD 0 SO-268050 INV-217711 INV-217711 10/29/2014 10/28/2014 -83.62 2550107 0 0 0 PK-228878 PK-228878 -1.09 10/29/2014 1/1/1900 -2 -84.71 0 2 10/28/2014 -83.62 10/31/2014 PR-225627 83.62 6792 257 10/28/2014 110695 0 0 0 0 gcn 1820070134 5639764308

FB-PK32T-W 0 10/31/2014 102 4320.23 USD 7 10089 10/31/2014 10/31/2014 4320.23 2562475 1 0 0 10089 0 1/1/1900 1/1/1900 93 3939.04 1 1 10/31/2014 4320.23 1/1/1900 0 1 0 1/1/1900 0 0 0 0 gcn 1501795237 5639777473

FB-PK32T-W 1 10/31/2014 -102 -4320.23 USD 7 10089 10/31/2014 10/31/2014 -4320.23 2562475 0 0 0 10089 0 1/1/1900 1/1/1900 -102 -4320.23 0 2 10/31/2014 -4320.23 10/31/2014 0 1 0 1/1/1900 0 0 0 0 gcn 1880793402 5639777474

FB-PK32T-W 1 11/1/2014 -8 -334.48 USD 0 SO-268481 INV-218017 INV-218017 11/3/2014 11/1/2014 -334.48 2558770 0 0 0 PK-229226 PK-229226 -4.36 11/3/2014 1/1/1900 0 0 1 2 11/1/2014 -334.48 1/1/1900 PR-226583 334.48 6792 257 11/1/2014 110913 0 0 0 0 gcn 830089233 5639776011

FB-PK32T-W 0 11/3/2014 96 3982.08 USD 3 PO-115666 90545704 API-110017086 10/29/2014 11/7/2014 3982.08 2549349 1 0 0 88871 APS020639 0 1/1/1900 1/1/1900 0 0 1 1 11/7/2014 3982.08 1/1/1900 0 4710 0 11/3/2014 1124 0 0 0 0 gcn 466212760 5639763383

FB-PK32T-W 1 11/3/2014 -16 -1369.12 USD 6 95569 ITV086640 2563365 11/3/2014 11/3/2014 -1369.12 2563364 0 0 0 ITV086640 0 1/1/1900 1/1/1900 0 0 1 2 11/3/2014 -1369.12 1/1/1900 1369.12 4710 0 1/1/1900 0 0 0 0 gcn 19423469 5639779334

FB-PK32T-W 0 11/3/2014 16 1369.12 USD 6 95569 ITV086640 2563364 11/3/2014 11/3/2014 1369.12 2563365 1 0 0 ITV086640 0 1/1/1900 1/1/1900 0 0 1 1 11/3/2014 1369.12 1/1/1900 -1369.12 7434 0 1/1/1900 0 0 0 0 gcn 1497076577 5639779335

FB-PK32T-W 1 11/3/2014 -32 -2738.24 USD 6 95572 ITV086643 2563372 11/3/2014 11/3/2014 -2738.24 2563371 0 0 0 ITV086643 0 1/1/1900 1/1/1900 0 0 1 2 11/3/2014 -2738.24 1/1/1900 2738.24 4710 0 1/1/1900 0 0 0 0 gcn 1481148649 5639779341

FB-PK32T-W 0 11/3/2014 32 2738.24 USD 6 95572 ITV086643 2563371 11/3/2014 11/3/2014 2738.24 2563372 1 0 0 ITV086643 0 1/1/1900 1/1/1900 0 0 1 1 11/3/2014 2738.24 1/1/1900 -2738.24 7434 0 1/1/1900 0 0 0 0 gcn 1983952914 5639779342

FB-PK32T-W 1 11/3/2014 -16 -1369.12 USD 6 95575 ITV086646 2563398 11/3/2014 11/3/2014 -1369.12 2563397 0 0 0 ITV086646 0 1/1/1900 1/1/1900 0 0 1 2 11/3/2014 -1369.12 1/1/1900 1369.12 4710 0 1/1/1900 0 0 0 0 gcn 1907844648 5639779368

FB-PK32T-W 0 11/3/2014 16 1369.12 USD 6 95575 ITV086646 2563397 11/3/2014 11/3/2014 1369.12 2563398 1 0 0 ITV086646 0 1/1/1900 1/1/1900 0 0 1 1 11/3/2014 1369.12 1/1/1900 -1369.12 7434 0 1/1/1900 0 0 0 0 gcn 474735921 5639779369

FB-PK32T-W 1 11/3/2014 -16 -1369.12 USD 6 95591 ITV086662 2563483 11/3/2014 11/3/2014 -1369.12 2563482 0 0 0 ITV086662 0 1/1/1900 1/1/1900 0 0 1 2 11/3/2014 -1369.12 1/1/1900 1369.12 4710 0 1/1/1900 0 0 0 0 gcn 1074323453 5639779462

FB-PK32T-W 0 11/3/2014 16 1369.12 USD 6 95591 ITV086662 2563482 11/3/2014 11/3/2014 1369.12 2563483 1 0 0 ITV086662 0 1/1/1900 1/1/1900 0 0 1 1 11/3/2014 1369.12 1/1/1900 -1369.12 6792 0 1/1/1900 0 0 0 0 gcn 985721807 5639779463

FB-PK32T-W 1 11/3/2014 -16 -1369.12 USD 6 95643 ITV086714 2563702 11/3/2014 11/3/2014 -1369.12 2563701 0 0 0 ITV086714 0 1/1/1900 1/1/1900 0 0 1 2 11/3/2014 -1369.12 1/1/1900 1369.12 4710 0 1/1/1900 0 0 0 0 gcn 1968683182 5639779696

FB-PK32T-W 0 11/3/2014 16 1369.12 USD 6 95643 ITV086714 2563701 11/3/2014 11/3/2014 1369.12 2563702 1 0 0 ITV086714 0 1/1/1900 1/1/1900 0 0 1 1 11/3/2014 1369.12 1/1/1900 -1369.12 7434 0 1/1/1900 0 0 0 0 gcn 1913969471 5639779697

FB-PK32T-W 1 11/5/2014 -1 -85.57 USD 0 SO-268745 INV-218281 INV-218281 11/5/2014 11/5/2014 -85.57 2564256 0 0 0 PK-229506 PK-229506 0 11/5/2014 1/1/1900 0 0 1 2 11/5/2014 -85.57 1/1/1900 PR-227445 85.57 7434 257 11/5/2014 110930 0 0 0 0 gcn 1084138669 5639780290

FB-PK32T-W 1 11/5/2014 -7 -598.99 USD 0 SO-268776 INV-218252 INV-218252 11/6/2014 11/5/2014 -598.99 2564513 0 0 0 PK-229477 PK-229477 0 11/6/2014 1/1/1900 0 0 1 2 11/5/2014 -598.99 1/1/1900 PR-227330 598.99 6792 257 11/5/2014 110913 0 0 0 0 gcn 1210608289 5639780561

FB-PK32T-W 1 11/5/2014 -10 -855.7 USD 0 SO-268776 INV-218252 INV-218252 11/6/2014 11/5/2014 -855.7 2564513 0 0 0 PK-229477 PK-229477 0 11/6/2014 1/1/1900 0 0 1 2 11/5/2014 -855.7 1/1/1900 PR-227330 855.7 6792 261 11/5/2014 110913 0 0 0 0 gcn 1868081971 5639785117

FB-PK32T-W 1 11/5/2014 -7 -598.99 USD 0 SO-268776 INV-218252 INV-218252 11/6/2014 11/5/2014 -598.99 2564513 0 0 0 PK-229477 PK-229477 0 11/6/2014 1/1/1900 0 0 1 2 11/5/2014 -598.99 1/1/1900 PR-227330 598.99 7434 261 11/5/2014 110913 0 0 0 0 gcn 1467732082 5639785091

FB-PK32T-W 1 11/5/2014 -1 -85.57 USD 0 SO-268785 INV-218253 INV-218253 11/6/2014 11/5/2014 -85.57 2564698 0 0 0 PK-229478 PK-229478 0 11/6/2014 1/1/1900 0 0 1 2 11/5/2014 -85.57 1/1/1900 PR-227331 85.57 7434 257 11/5/2014 110913 0 0 0 0 gcn 683783535 5639780752

FB-PK32T-W 1 11/5/2014 -5 -427.85 USD 6 95956 ITV087027 2567464 11/5/2014 11/5/2014 -427.85 2567463 0 0 0 ITV087027 0 1/1/1900 1/1/1900 0 0 1 2 11/5/2014 -427.85 1/1/1900 427.85 7434 0 1/1/1900 0 0 0 0 gcn 732476921 5639783835

FB-PK32T-W 0 11/5/2014 5 427.85 USD 6 95956 ITV087027 2567463 11/5/2014 11/5/2014 427.85 2567464 1 0 0 ITV087027 0 1/1/1900 1/1/1900 0 0 1 1 11/5/2014 427.85 1/1/1900 -427.85 6792 0 1/1/1900 0 0 0 0 gcn 416095315 5639783836

FB-PK32T-W 1 11/5/2014 -5 -427.85 USD 6 95957 ITV087028 2567467 11/5/2014 11/5/2014 -427.85 2567466 0 0 0 ITV087028 0 1/1/1900 1/1/1900 0 0 1 2 11/5/2014 -427.85 1/1/1900 427.85 6792 0 1/1/1900 0 0 0 0 gcn 1767696129 5639783838

FB-PK32T-W 0 11/5/2014 5 427.85 USD 6 95957 ITV087028 2567466 11/5/2014 11/5/2014 427.85 2567467 1 0 0 ITV087028 0 1/1/1900 1/1/1900 0 0 1 1 11/5/2014 427.85 1/1/1900 -427.85 7434 0 1/1/1900 0 0 0 0 gcn 882554304 5639783839

FB-PK32T-W 1 11/5/2014 -5 -427.85 USD 6 95961 ITV087033 2567480 11/5/2014 11/5/2014 -427.85 2567479 0 0 0 ITV087033 0 1/1/1900 1/1/1900 0 0 1 2 11/5/2014 -427.85 1/1/1900 427.85 7434 0 1/1/1900 0 0 0 0 gcn 1732179623 5639783851

FB-PK32T-W 0 11/5/2014 5 427.85 USD 6 95961 ITV087033 2567479 11/5/2014 11/5/2014 427.85 2567480 1 0 0 ITV087033 0 1/1/1900 1/1/1900 0 0 1 1 11/5/2014 427.85 1/1/1900 -427.85 6792 0 1/1/1900 0 0 0 0 gcn 590482822 5639783852

FB-PK32T-W 1 11/5/2014 -5 -427.85 USD 6 95961 ITV087033 2567482 11/5/2014 11/5/2014 -427.85 2567481 0 0 0 ITV087033 0 1/1/1900 1/1/1900 0 0 1 2 11/5/2014 -427.85 1/1/1900 427.85 6792 0 1/1/1900 0 0 0 0 gcn 521520731 5639783853

FB-PK32T-W 0 11/5/2014 5 427.85 USD 6 95961 ITV087033 2567481 11/5/2014 11/5/2014 427.85 2567482 1 0 0 ITV087033 0 1/1/1900 1/1/1900 0 0 1 1 11/5/2014 427.85 1/1/1900 -427.85 7434 0 1/1/1900 0 0 0 0 gcn 742502424 5639783854

FB-PK32T-W 1 11/7/2014 -2 -51.91 USD 0 SO-269147 INV-218425 INV-218425 11/10/2014 11/7/2014 -51.91 2570824 0 0 0 PK-229663 PK-229663 0 11/10/2014 1/1/1900 0 0 1 2 11/7/2014 -51.91 1/1/1900 PR-227774 51.91 7434 257 11/7/2014 110913 0 0 0 0 gcn 1228849879 5639787649

FB-PK32T-W 1 11/7/2014 -2 -51.91 USD 0 SO-269161 INV-218427 INV-218427 11/10/2014 11/7/2014 -51.91 2571008 0 0 0 PK-229665 PK-229665 0 11/10/2014 1/1/1900 0 0 1 2 11/7/2014 -51.91 1/1/1900 PR-227770 51.91 7434 257 11/7/2014 110835 0 0 0 0 gcn 1258277677 5639787837

Was this reply helpful? Yes No
chills 120 on at

Like (0)

Report

Hi Guy,

Thanks for responding! There were 94 cases left after the 8 were sold. I verified that there is nothing in the CostAmountAdj. I don't see a 'Include physical value'. 'Include in unit price' is not ticked and 'latest cost price' is ticked.

Was this reply helpful? Yes No
chills 120 on at

Like (0)

Report

Ok found it!! No the 'Include physical value' is not ticked.

Was this reply helpful? Yes No
chills 120 on at

Like (0)

Report

Is this the info you are looking for?

Inventdim is IN.

CONSISTENT MANDATORY DIMGROUPID DIMFIELDID LINENUM EDITPURCHREQLINE ALLOWBLANKRECEIPT ALLOWBLANKISSUE ACTIVE EDITQUALITYORDER FINANCIALINVENT PHYSICALINVENT PRIMARYSTOCKING EDITINVENTTRANSACTION EDITPURCHLINE EDITSALESLINE EDITPRODUCTION EDITPRODLINE EDITINVENTTRANSFER EDITINVENTLOSSPROFIT EDITINVENTCOUNTING ITEMDIMENSION EDITINVENTQUARANTINEORDER EDITPROJECT EDITASSET SERIALNUMBERCONTROL COVPRDIMENSION PRICEDISCSALES PRICEDISCPURCH EDITINVENTTRANSFERORDER EDITPURCHRFQLINE EDITSMMQUOTATIONLINE DATAAREAID RECVERSION RECID
0 0 IN 2 6.000000000000 1 0 0 0 0 0 0 0 1 1 1 1 1 1 1 1 0 1 1 1 0 0 0 0 1 1 1 gcn 1 5637144849
0 0 IN 3 7.000000000000 1 0 0 1 0 0 1 1 1 1 1 1 1 1 1 1 0 1 1 1 0 0 0 0 1 1 1 gcn 867216225 5637144850
0 0 IN 4 8.000000000000 1 0 0 0 0 0 0 0 1 1 1 1 1 1 1 1 0 1 1 1 0 0 0 0 1 1 1 gcn 1 5637144851
0 0 IN 5 9.000000000000 1 0 0 0 0 0 0 0 1 1 1 1 1 1 1 1 0 1 1 1 0 0 0 0 1 1 1 gcn 1 5637144852
0 0 IN 6 5.000000000000 1 0 0 1 0 0 1 0 1 1 1 1 1 1 1 1 0 1 1 1 0 1 0 0 0 1 1 gcn 927226876 5637144848
1 1 IN 7 1.000000000000 1 0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0 1 1 1 1 1 1 gcn 1 5637144844
1 1 IN 8 2.000000000000 1 0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0 1 1 1 1 1 1 gcn 1 5637144845
1 1 IN 9 3.000000000000 1 0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0 1 1 1 1 1 1 gcn 1 5637144846
1 1 IN 16 4.000000000000 1 0 0 1 0 1 1 1 1 1 1 1 1 1 1 1 0 1 1 1 0 1 0 0 0 1 1 gcn 1 5637144847

Was this reply helpful? Yes No
Guy Terry 28,924 Moderator on at

Like (0)

Report

Hi Chills,

For me, the cost price change between the 3rd and the 7th Nov is all related to the receipt of Purchase order PO-115666 on the 3rd.

The 'Include physical value' tick box is significant. It is unticked. This means that, when calculating the current running average cost price, AX will not use the value of receipts which are not financially updated. In the case of this PO, it means AX will not use the value of the 96 received on the 3rd Nov until the invoice is posted, which happened on the 7th.

So the timeline is:

1st Nov. 8 are Sold (delivered and invoiced).
Inventory close was then run, with a Recalculation. AX makes a Cost Adjustment to this Sales line.
3rd Nov. 96 received, with a value of 3982.08. Because 'Include physical value' is not ticked, AX is not going to use this 3982.08 when calculating the running average cost price.
3rd Nov. Stock transfers, valued at the running average cost price of 85.57.
5th Nov. More transfers, and 26 are sold, at the same cost price.
7th Nov. PO Invoice is posted. Running average cost price now includes the 3982.08
7th Nov. 4 are sold, with new running average cost price of 25.955.

You're going to ask me how AX came up with those two cost prices. I can't answer that. I believe 'Price amplification' could be responsible; it can apply when you have some issue transactions where the cost of the receipts is not available.

http://technet.microsoft.com/EN-US/library/gg243219.aspx

I am fairly sure of two things:

If 'Include physical value' was ticked, you would not have seen these cost prices in this scenario.

As long as you keep invoicing your POs, AX will sort it all out at Inventory close (or, the next Recalculation).

Was this reply helpful? Yes No