Roadking
Member
Hi List,
I've investigated this to no end. JDE has cannot provide any assistance to the level of investigation that has already been performed. Perhaps there is someone here that can help me out.
We are on OneWorld Xe, Update 5, with Distribution and H/R baseline ESU's installed. Our platform is AS/400, NT, Citirix Server. We are using DSI for all of our warehouse transactions. We use the following modules:
Address Book
G/L
A/R
A/P
Fixed Assets
Inventory
Sales
Purchasing
Advanced Warehouse
We use branch plant processing, and use three way matching for our PO receipts. Landed Cost is turned on. Average Cost is turned on to update online.
We use receipts routing with two stages - the last stage updates inventory. 95% of receipts are in foreign currency and converted to domestic. Our inventory is valued in base currency.
Our costing method is Average Cost at the Branch Plant level. Our inventory (F41021) is relieved at pack confirm based on UDC 40/IU being populated with all of our Sales Document Types.
We have set UDC 40/AV to include only the following to update average cost since average cost should only be updated on incoming transactions.
ND3N4113 DSI Inventory Transfers
ND3N4114 DSI Inventory Issues/Adj.
ND3N4309 DSI Receipt Routing
ND3N4312 DSI PO Receipts
P4112 Inventory Issues
P4113 Inventory Transfers
P4114 Inventory Adjustments
P4312 Purchase Order Receipts
P43214 Reverse Purchase Order Receipt
P43250 Receipt Routing Movement
P43291 Landed Cost Selection
Here's the issue:
1. All transactions from the F4111 and the F0911 match on a daily basis according to the R41543 Item Ledger/Account Integrity Report.
2. All transactions posted on any specific G/L date in the Cardex (F4111) can be identified in the G/L when the Inventory Journal Report (R41550) is compared to the Invnentory account in the G/L (F0911). In effect duplicating the integrity report above.
3. We post all picked/packed/shipped sales orders through invoicing and end of day, post all of the inventory G/L batches.
4. The Inventory Valuation Report (R41590) is run using the average cost bucket (02) to determine the value of inventory.
5. The F0902 balance is then compared to the Inventory Valuation in number 4 above. These two blanaces do not agree.
6. We perform this reconciliation throughout the day and each time the difference between the two balances grows. On a daily basis, the NET change in the variance continues to grow and represents a SIGNIFICANT amount of cost.
Basically, my best guess is that something is happening to our average cost in the F4105 and not creating Journal Entries in the G/L. OR something is happening to the F4105 balances and should NOT be occurring. I have a feeling that DSI transactions might be affecting the F4105 values, however I have not been able to identify any JDE programs or DSI scripts incorrectly updating the F4105 through any of the audit fields in any of the inventory files.
I hope I've provided enough information. Any help or comments would be appreciated.
Thanks
Marco
[email protected]
I've investigated this to no end. JDE has cannot provide any assistance to the level of investigation that has already been performed. Perhaps there is someone here that can help me out.
We are on OneWorld Xe, Update 5, with Distribution and H/R baseline ESU's installed. Our platform is AS/400, NT, Citirix Server. We are using DSI for all of our warehouse transactions. We use the following modules:
Address Book
G/L
A/R
A/P
Fixed Assets
Inventory
Sales
Purchasing
Advanced Warehouse
We use branch plant processing, and use three way matching for our PO receipts. Landed Cost is turned on. Average Cost is turned on to update online.
We use receipts routing with two stages - the last stage updates inventory. 95% of receipts are in foreign currency and converted to domestic. Our inventory is valued in base currency.
Our costing method is Average Cost at the Branch Plant level. Our inventory (F41021) is relieved at pack confirm based on UDC 40/IU being populated with all of our Sales Document Types.
We have set UDC 40/AV to include only the following to update average cost since average cost should only be updated on incoming transactions.
ND3N4113 DSI Inventory Transfers
ND3N4114 DSI Inventory Issues/Adj.
ND3N4309 DSI Receipt Routing
ND3N4312 DSI PO Receipts
P4112 Inventory Issues
P4113 Inventory Transfers
P4114 Inventory Adjustments
P4312 Purchase Order Receipts
P43214 Reverse Purchase Order Receipt
P43250 Receipt Routing Movement
P43291 Landed Cost Selection
Here's the issue:
1. All transactions from the F4111 and the F0911 match on a daily basis according to the R41543 Item Ledger/Account Integrity Report.
2. All transactions posted on any specific G/L date in the Cardex (F4111) can be identified in the G/L when the Inventory Journal Report (R41550) is compared to the Invnentory account in the G/L (F0911). In effect duplicating the integrity report above.
3. We post all picked/packed/shipped sales orders through invoicing and end of day, post all of the inventory G/L batches.
4. The Inventory Valuation Report (R41590) is run using the average cost bucket (02) to determine the value of inventory.
5. The F0902 balance is then compared to the Inventory Valuation in number 4 above. These two blanaces do not agree.
6. We perform this reconciliation throughout the day and each time the difference between the two balances grows. On a daily basis, the NET change in the variance continues to grow and represents a SIGNIFICANT amount of cost.
Basically, my best guess is that something is happening to our average cost in the F4105 and not creating Journal Entries in the G/L. OR something is happening to the F4105 balances and should NOT be occurring. I have a feeling that DSI transactions might be affecting the F4105 values, however I have not been able to identify any JDE programs or DSI scripts incorrectly updating the F4105 through any of the audit fields in any of the inventory files.
I hope I've provided enough information. Any help or comments would be appreciated.
Thanks
Marco
[email protected]