Rounding in Receivings Transaction Entry Window During a Conversion Between Currencies
Thursday, April 22nd, 2010During work with the Receivings Transactions Entry window, we can be met with a situation when we receive 100 items in Canadian Dollars on WIREHOUSE site, and when we go through the Purchase Receipts Inquiry we get two lines, one line with receiving 99 at one unit cost and one line with receiving 1 item at another unit cost.
After receiving the items, the unit cost is translated from Canadian dollars into American dollars and rounded in two decimals. Also, it translates the total cost from Canadian into American dollars, and after receiving the quantity of 99 items at one cost, it rounds the last item to fit the total cost. That is why the last item is represented in a new line.
Look at the following example:
1. Open the window Receivings Transactions Entry like: Transactions -> Purchasing -> Receivings Transactions Entry
2. Enter the new Receipt Number and some Vendor related to Z-C$ (Canadian dollar) currency.
3. Click the button near the Currency ID and set the Exchange Rate to 0.9456270.
4. Enter some Item Number in the scrolling window and make Qty Shipped to be 100.
5. Set the Unit Cost to 1.54 and fill Site ID.
6. Now click the Post button.
7. Open the Purchase Receipts Inquiry window like: Inquiry -> Inventory -> Receipts
8. Chose the same Item Number as in Receivings Transaction Entry window.
9. Choose the same Site ID as in the Receivings Transaction Entry window.
10. Scroll the scrolling window to the bottom, click the expand button and the expected one line will be represented as two lines, one which displays 99 items bought by one cost and one line item with the same item bought by another cost.
