Jump to content

Understanding Cost Fields

Cliff Dillard

Recommended Posts

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.

Link to comment
Share on other sites

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.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...