Cliff Dillard Posted December 7, 2017 Report Share Posted December 7, 2017 I am evaluating the software and trying to import from a prior system. I need clarification on the cost fields, specifically SUBTOTAL, TOTAL COST, and ESTIMATED VALUE. These fields do not show up when mapping data so I took my best guess, which appears to be incorrect. Here is the scenario: I have an item that I purchased 2 of at $25.00 each. I now value them at $10 each. On my current system the fields would be Quantity:2, Unit Cost: $25.00, Unit Value: $10, Total Cost: $50.00, Total Current Value: $20 I mapped Unit Cost and Unit Value to users fields as I did not see where this was supported. I mapped Total Cost to Base Cost (thinking this would equate to Subtotal) I mapped Total Current Value to Current Value But when I look at the item after import I see the following: Subtotal $30.00 (so this appears to be calculated and I don't understand the algorithm) Total Cost: $50.00 (I expected Total Cost to be Subtotal plus taxes (which are zero) but it appears to have what I mapped into Base Cost. Estimated Value: $30 (another apparent calculation which I need to understand) Could someone elaborate on these cost fields and how they are calculated? Thank you. Update: After further review other items in the import appear to have followed the logic I expected. The item in question was the first in the import file; perhaps something was corrupt with my file. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You are posting as a guest. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.