Frequently Asked Question

Purchases made outside Canada can be purchased in the foreign countries currency

In addition to the currency enhancement, three additional fields allow the system to roll into the average cost @ the time of Purchase Order Receipt, Freight, Brokerage and Additional Costs. These values can be entered as part of the PO receiving or as a default % in the Supplier Maintenance screen. In addition where Duty is applicable @ the part level, this cost rolls up as a part of the cost

Default GL Accounts

System Utilities à System Set-up à Purchasing à Parameter Maintenance à Screen 3 S/O Defaults and Smoothing

System Utilities à System Set-up à Purchasing à Parameter Maintenance à Screen 2 System Configuration

All values posted into the GL are in Canadian dollars

* Note; each branch has to have GL codes amended @ the Branch level

Foreign Exchange Rate

Purchasing à Data Maintenance à Currency

Foreign Exchange Rates are a global setting and can be added or changed in this screen

Fields:

1 – Code = Currency

2 – Rate = Exchange Rate

3 – Update Prices = If the currency rate has changed this should be set to Y if you want to update the selling prices based on the new rate.

4 – Last Update = Date that prices were last updated for this currency rate based on a change in Currency Rate

Supplier Set-Up

Purchasing à Data Maintenance à Supplier

While the Exchange Rate is global the Supplier Maintenance screen is where you select the currency you are going to buy in.

Fields:

19 – Currency; select currency

21 – Price Level = Base; the field in the Inventory Maintenance screen the supplier’s price is displayed from their price list

• Enter “B” in this field for all foreign exchange suppliers

29 – Update Last Cost to Inventory Y/N; at time of PO receipt “Y” will update Canadian selling prices “N” will not update selling prices but average price is updated.

34 – Freight Percentage; if a default percentage for freight costs is to be added to all receivings for this supplier

35 – Brokerage Percentage; if a default percentage for brokerage costs is to be added to all receivings for this supplier

36 – Other Charges; any additional costs such as a pallet cost or insurance

* These default costs are applied for every part linked to the supplier both when goods are received in the calculation of the landed cost and when Canadian cost and selling prices are calculated

Inventory Maintenance Screen

Inventory à Data Maintenance à Master File à Product Master

Fields:

Base Cost/Core – Suppliers cost and core price in there currency from price file

Tax Code | Duty % | Season – Part tax code | duty % for the part which is applied into the landed cost of the goods at the time of PO receipt and when Canadian prices are calculated.

Purchase Order

Foreign purchase orders will print with the suppliers base cost

Purchase Order Receipt

Purchasing à Purchase Order Receipts à PO Receipts Input

Fields:

Currency – the currency the purchase order was cut in and the exchange rate

Price Level – relating to the Supplier, “B” = Base Price

Freight – freight costs are entered here, are spread evenly across all SKU’s on the purchase order and are in CDN dollars

Brokerage – brokerage costs are entered here, are spread evenly across all SKU’s on the purchase order and are in CDN dollars

Other Costs – any other cost associated with the acquisition of the PO can be entered here and are spread evenly across all SKU’s on the purchase order and are in CDN dollars

If these values are left blank the percentages assigned to the supplier, if any, will be used to calculate approximate costs.

PO Receipts Journal

The PO Receipts journal will include these additional costs