<@UE3DBP8JC> what are you trying to do with it?
# suiteflows
Scotty
10/30/2019, 3:15 PM@pmendola what are you trying to do with it?
p
pmendola
10/30/2019, 3:20 PMwe sell consignments and take offers on items, so we want to adjust that est ext cost at the time of the sale (if an item is being sold below list) to do some math based on the consignment percentage being recorded on each item.
s
Scotty
10/30/2019, 4:10 PMIs this related to the COGS entry or something else? The est ext cost is what your COGS hit would be so that is not likely to change (IMO).
Scotty
10/30/2019, 4:10 PMIf you are trying to calculate something else you could create a new column and put your calculation there. I have done this before.
Scotty
10/30/2019, 4:11 PMThis would not affect your COGS but it would show you whatever you the amount you are looking to see
p
pmendola
10/30/2019, 6:16 PMso we found that changing the ext cost doesnt do anything to the real COGS (which i guess why it's called esimate) so we really only use the field for reporting and for easily knowing what our payouts are (we pay out the "cost" essentially). we do the accounting adjustments with a contra account at the end of the month. good idea to make it a custom field though!
s
Scotty
10/30/2019, 6:43 PMSadly its just a view field and does nothing in the background. Glad you got it figured out though.
2 Views