HI, We are getting a message in the “Post Inventory Cost to GL” function. An inventory items (we know which one) was setup without the dimensions setup and now we get a error when running this that says "Select a Dimension Value Code for the Dimension Code COMPANY for G/L Account 1600. G/L account 1600 is our inventory account and has been posted to for years, the dimensions have not changed for months - so a quick process of elimiation would point to the item card. We fixed the dimenstions on the item card - but it didn’t fix the error. I suppose there is missing dimension codes in a ledger/journal type table somewhere. Could anyone just point to the table or possible tables that we should check out to “patch” the data. [8D] Or if you think we need to look in a different direction, let us know. Thanks, Terry for ShankDoor
If it is a Global Dimension (1 or 2): 32 - Item Ledger Entry 5802 - Value Entry (Corresponding to Item Ledger Entry) 17 - G/L Entry (Corresponding to Value Entry) For any Dimension: 355 - Ledger Entry Dimension (for the corresponding tables above) This involves changing the G/L Dimensions as well. A couple of other options are: 1) Turn the Dimension Mandatory Flag off and run the adjust. 2) Turn automatic cost posting off, run the Adjust and then find the problem entry in T-5802. You can then add the dimensions for this record in T-5802 and T-355 only, you wouldn’t have to change the G/L. The problem here is if this isn’t the final adjustment.
Hi Chris, We truned the Dimension Mandatory flag off and it worked fine. We had to turn it off for the Inventory and Cost of Goods Sold account in the G/L. Thanks a lot for your help. Dan