Hi All,

We just migrated Adagio to 9.2 platform. I could not figure out how to process manual proration of misc. charges when processing receipt in PO (9.2A).
On the receipt we have 2 vendors: actual vendor we receive items from and artificial vendor to process estimated landed cost components.
MC defined in MC table: Freight - manual proration, Brokerage - by relative value.

Please recommend me in simple bullet point form how to process this type of receipt.

Any help will be greatly appreciated.
Victor

Hello,

I have an additional update of this problem:
1. Upgraded PO to 9.2B
2. Item vendor currency - $USD, Misc. charges currency - $CAD
3. Misc. charge that require proration by relative value calculated properly. If I add misc. charge that require manual proration I have to edit line item calculate and add manual proration amount to "Allocated misc." field.
4. After pressing "Post" button error message appears: "Manual allocation of miscellaneous charge for 888.77 was allocated to 1155.40. Edit items and update: Allocated misc." ????????

Can anyone explain to me how to process this transaction properly.

Regards
Victor

Hello Victor,

I don't think that there is a "proper" way to process this receipt, which might explain why there has been no feedback. Adagio PurchaseOrders offers several ways to prorate additional costs because different companies have different business needs.

From the numbers in your second post, I would guess that you have a negative receipt quantity in one of the lines, but I might be mistaken.

Since you upgraded from a previous version, I'm also guessing that you have not changed the way you previously posted receipts. In re-writing Adagio PurchaseOrders, we found many calculation irregularities in Receipt Processing and especially additional cost handling in Purchase Orders for Adagio.

Perhaps you should review your receipt processing method with an Adagio Consultant.

Victor:

I think what happens is the manually prorated misc charge amount you are entering is being treated as being in the same currency as the actual item (so in this case USD). You need to manually convert the amounts you are entering to the equivalent USD. Likely you will have to fiddle with eliminating the rounding error.

Doug is right. Manual Proration has not changed in 92B.

If the currency of the Misc Charge Vendor is not the same as the currency for the Item Vendor, the allocation will need to be made in the Item Vendor's currency.

For example: If the Item is in Source Currency CAD and the Misc Charge is in Home currency USD. The amount entered in the 'Allocated Misc.' needs to be in CAD.

I suggest that you add 'Alloc Costs - Home' to the column editor. The 'Alloc Costs - Home' for all of the item allocations must add up to the amount for the Misc Charge.

Hi All,

I'm under impression that no one even tried to check manual proration functionality:

Once again:
You are ordering inventory items from overseas and have to create an order and pay in $USD.

1. Please create simple 3 line purchase order for vendor (currency $USD).
Your item cost include freight to one of the ports in Canada. Your freight company delivered goods to your warehouse and charged your for freight and other import charges in $CAD.

2. Process of items receipt.
Now interesting part: Change to different vendor ($CAD) and add misc. charge, let say, brokerage prorated by relative value. Then for the same vendor add misc. charge freight that should be prorated manually (due to different item/weight cost). Go to each item "Allocated misc" field and try to enter your proration you calculated in advance. Good luck.

Dear Doug and tech support team,
Do the requirement look unreasonable?
Have you done above described steps?
What can you say? Am I doing something wrong? Is software functioning properly?
Do you have the recommendation how to complete above described transaction?

Regards
Victor

Hello Victor,

Your impression is incorrect. We spent many hours in R&D and QA validating the various cost proration methods.

Please provide specific amounts for your example, and how you expect to see the costs allocated to the inventory items and COGS account. Only when we are discussing an actual example can we determine whether the program is functioning correctly.

Victor:

This also might be an issue were behavior depends upon how your database is set up. In any event testing scenarios to see if the issue can be replicated is beyond what most volunteers that monitor this forum would be willing to do. You may want to get your Adagio consultant to assist you.

Hi All,

Please see the attached pictures and let me know how you would process manual proration as per below:
Line# Item# Description Manual Proration Amt.
1 BG129 BASKETBALL NET LEAGUE 20" 274.17
2 BG131 BASKETBALL NET TRI COLOR 20" 437.05
3 BG150 BASKETBALL NET STEEL CHAIN 19" 177.54
TOTAL DOS: 888.76

Regards
Victor

Hello Victor,

Do we have a copy of this database so that we can make sure we are using the same configuration settings?

Have you placed the fields suggested by support on your Grid so you can see what's going on?