Hi Andrew,

Yes to both questions.
Is tech support team can suggest me anything?

Regards
Victor

Hello Victor,

Manual Proration of Misc Charges changed significantly in 81C, the first release of Adagio PurchaseOrders.

In your sample dataset, DOS is the home currency.

If you look at your last print screen, the 1st Misc Charge, Brokerage, is fully allocated. The $91.51 DOS is $70.39 USD
The 1st item shows $20.50 as the Alloc Cost - Home (DOS) . When you edit the first item detail, the Allocated misc. field shows the amount in USD to match the currency of the item vendor. The USD amount is $15.77.

The 2nd items shows 23.09 in DOS and 17.76 in USD. The 3rd item shows $47.92 DOS or $36.86 USD.

Now, to manually allocate the Freight, you need to figure out what the $888.76 is in USD. The currency rate is 1.3 so you have to increase the Allocated cost on the items by $683.66 USD.

To add $274.17 DOS to the 1st item, you need to calculate what the USD amount is. Based on the exchange rate, you need to add $210.90 USD to the $15.77.

Do the same calculation for the other items.

When you are done, the sum of the Alloc Costs – Home total for the 3 Items must equal the sum of the Alloc Costs – Home for the 2 Misc Charges.

Hello,

Do you think this is correct?
Try to do this weird exercise for 150 line order and you'll understand that is impossible to complete in reasonable time frame.

From the other hand, what is the accounting software for?
I think this issue must be corrected as follows:

1. Miscellaneous charges should be processed in selected vendor currency.
2. Separate field for manual proration must be added below the existing "Allocated Misc.".
3. Running total for manually prorated amount should be shown.

Please let me know if you think it is unreasonable or you have any other solution in mind. Because the current workaround you offered won't be in use until this process is corrected.

Regards
Victor

Victor

Why are you doing manual allocation in the first place? Is the error resulting from an auto proration significant enough to justify the cost of your time to do the manual proration?

Hello Victor,

Technical Support has the same question as Doug - why are you doing manual proration over 150 items?

While in PurchaseOrders for Adagio only a few proration methods worked without error, in Adagio PurchaseOrders you can prorate expenses by Relative Weight, Relative Quantity and Equal Line as well as Relative value and manually.

Hi All,

First of all: if manual proration is an option it must function properly.

Our company is in sporting goods business. Lot of items imported from oversees and freight for different type of items is always consolidated. Example of items that could be shipped in the same container: ping pong balls, kattlebells, sport watches, foam rollers, training and conditioning equipment.
This is what we need manual proration for: to allocate freight cost to items correctly.

Regards
Victor

Hello Victor,

Manual proration does function properly, although you may find the method tedious.

The question is whether the automatic proration of freight charges results in any material difference from the amounts you are calculating manually.

MANUAL PRORATION D O E S N O T FUNCTION PROPERLY !!!

If I'm not mistaken we talking about ACCOUNTING software here. All business transactions should be processed properly without catting any corners.
In addition to Freight Custom duties require manual proration as well. Duty rates fluctuate from 0% to 11,5% for different items and calculated on separate XL worksheet. I'm not even mentioning that landed cost components could be a defined as one of the item properties in IC.

At least please fix your tedious manual proration method.

Victor

Hello Victor,

You have already said that you are using a spreadsheet to manually allocate the costs among the lines on your receipt. If you insist on using the manual proration, then add two columns to the spreadsheet to calculate the amount to prorate in the currency of the item vendor and have the spreadsheet tell you the amounts to enter.

ONCE AGAIN:
ANUAL PRORATION D O E S N O T FUNCTION PROPERLY !!!

Please fix your tedious manual proration method.

Victor