We recently went through a complete set of number changes in our Ledger, using the KOM number changer. After completion of these number changes, I went through each subledger and changed all of the default numbers.

Everything seems to be working fine, EXCEPT for inventory adjustments. When these are retrieved to the ledger, they have a rate type on them of "SP" which does not exist in our system. The only rate type we have is "AV"

As mentioned, this is only happening for the Inventory module. I cannot see in Inventory WHERE to change this. Any help you would be able to provide would be wonderful. Thank you.

Check the Company Profile. There is a Rate Type selection there that handles Inventory transactions except for receipts.

For Receipt entries, the rate type is part of the exchange rate finder. If you only have AV in your system, this will be the only one that appears.

Actually, the rate type in Inventory is set at "AV", so I am unsure where the heck the "SP" is coming from. Sorry to lead you astray, the Profile was the FIRST place I checked!

Hi Barb,

1) Are you using MultiCurrency?
2) Which transaction type(s) are showing up with 'SP' as the rate type in GL. Receipts, shipments, adjustments, stock transfers, assemblies?
3) Could you have had 'SP' as a rate type on the Inventory company profile in the past, so older transactions have 'SP'. But newer transactions now show 'AV' correctly?

If you have 'AV' set in the Company Profile, then all new transactions (except receipts) will use this. Receipts allow exchange rate selection and thus can change the rate type.

1) Yes, we are using Multicurrency.
2) IC Adjustments are the ones showing up most frequently with the "SP" rate. IC Adjustments are new, only created the day they are entered.
3) "SP" I do recall showing up before, it had something to do with our merging three data bases in to one.

I cannot remember how we fixed this, or really how the original problem occured when we merged our data bases, but I do remember the "SP".

Is there anywhere other than Profile that I can look? I have checked all modules, and cannot find the "SP" anywhere. Very frustrating.
Also, all existing Purchase Orders now have the incorrect default accounts on them. Is there any way to change this, other than deleting all purchase orders and reentering?

Thank you.

Thanks for the information.

I see that when posting an adjustment on a multi-currency Inventory database, 'SP' is getting written to the sub-ledger batch instead of the value 'AV' that I had set in the company profile. This is a program problem, likely un-detected because 'SP' is the rate type for the sample multicurrency data.

I see that all the other transaction types - shipments, stock transfers, assemblies and physical inventory adjustments - are correctly posting 'AV' to the sub-ledger batch. So Adjustment posting is the only one with this problem.

Thanks for your patience - I'll forward this issue to development.

Hmmm, okay if I curse? I have been able to find a way to change the batches once they are retrieved to the ledger, so they can be posted correctly, but it is entirely tedious and completely cumbersome.

Any idea when this may be fixed?

Also, there was the question, not sure you can help, (I know Purchase Orders is not a Softrak module), but there is a problem of existing PO's with incorrect default ledger account numbers. Is there a way to change the "old" defaults on existing PO's to the new numbers without deleting and re-entering Purchase Orders?

Thank you for answering.

Hi Barb,

Thanks for noticing this problem in Inventory. If you are not using the SP rate, why not make its rules identical to the AV rate as a workaround until the problem is fixed.

thanks Andrew we will try it as a work around.
Bruce

We noticed today that the same problem is occuring when we use A/P Manual Checks. Could you please look at this in your sample data as well, just to ensure that it is not our error?

Thank you.