J
Jason
I am not really happy with the way RMS handles purchase orders shipping costs
and the lack of features for international customers. I also can't figure out
the foreign currency features, other than from a POS tendering standpoint. I
am looking for a workaround to these problems:
- The Formula feature does not allow you to multiply the PO costs by a factor.
- The shipping costs inexplicably does not factor into the Item Cost when
the PO is received. This is part of the inventory value and should be
factored into the costs!
Why?
I import goods to my country where I am charged ocean freight, various
duties and fees, and handling costs. Since each item has seperate rates and
costs associated with it, I simplify the process by figuring out the total
cost for each invoice in my local currency and then apply a factor to the
invoice/PO cost.
I need to send my suppliers in the US a PO with the US cost of the item.
However, when I receive it into inventory, I need to change the PO costs to
my local currency and apply a factor to account for the shipping, duties, and
other costs incurred that will form my Inventory Value.
If the shipping cost field worked where it applies the amount to the items
on the PO before calculating item costs when committing to the database, my
problems would be solved. I would enter the POs in US dollars, then figure
out my factor and use the shipping cost field to apply my other costs and
convert to local currency.
If the Formula feature allowed you to multiply the PO costs by a factor, my
problems would similarly be solved.
As it stands now, I make my PO in US dollars, give it to my supplier, and
when my goods arrive, I calculate my total cost in local currency and come up
with a factor to multiply each line item cost by. I manually input these
values. This is not fun when there are hundreds of line items, and especially
not fun when you make a mistake and can't find the line item causing the
problem.
I guess a SQL statement might be able to multiply the PO costs by a factor
that is prompted for. I would have no idea how to do this, however.
Am I missing something with the Formula feature or shipping cost field?
Also, is there something I am missing about the foreign currency features of
RMS?
Your comments would be greatly appreciated.
and the lack of features for international customers. I also can't figure out
the foreign currency features, other than from a POS tendering standpoint. I
am looking for a workaround to these problems:
- The Formula feature does not allow you to multiply the PO costs by a factor.
- The shipping costs inexplicably does not factor into the Item Cost when
the PO is received. This is part of the inventory value and should be
factored into the costs!
Why?
I import goods to my country where I am charged ocean freight, various
duties and fees, and handling costs. Since each item has seperate rates and
costs associated with it, I simplify the process by figuring out the total
cost for each invoice in my local currency and then apply a factor to the
invoice/PO cost.
I need to send my suppliers in the US a PO with the US cost of the item.
However, when I receive it into inventory, I need to change the PO costs to
my local currency and apply a factor to account for the shipping, duties, and
other costs incurred that will form my Inventory Value.
If the shipping cost field worked where it applies the amount to the items
on the PO before calculating item costs when committing to the database, my
problems would be solved. I would enter the POs in US dollars, then figure
out my factor and use the shipping cost field to apply my other costs and
convert to local currency.
If the Formula feature allowed you to multiply the PO costs by a factor, my
problems would similarly be solved.
As it stands now, I make my PO in US dollars, give it to my supplier, and
when my goods arrive, I calculate my total cost in local currency and come up
with a factor to multiply each line item cost by. I manually input these
values. This is not fun when there are hundreds of line items, and especially
not fun when you make a mistake and can't find the line item causing the
problem.
I guess a SQL statement might be able to multiply the PO costs by a factor
that is prompted for. I would have no idea how to do this, however.
Am I missing something with the Formula feature or shipping cost field?
Also, is there something I am missing about the foreign currency features of
RMS?
Your comments would be greatly appreciated.