FASTR Balances

[BenP76]

Hi

I'm new to this site, so forgive me if I've posted to the wrong forum!

We have a couple of accounts which, for all intents and purposes look fine in JDE. However, when we try to include them in a FASTR, their balance is 100 times what it should be. For instance, an OK account with a balance on 100.50 shows as 101, whereas one of the erroneous ones with a balance of 134156.47 shows as 13415647.

I've checked the F0902 to make sure the balance is okay in thre, and it is, and I've created an audit file against the FASTR, and it recognises that the actual balance is 134156.47, but still displays it as 13415647 rather than 134156.

Can anyone offer any advice? i don't know if it is something which has been overlooked in the account setup, or the FASTR design, or if it is something deeper.

I've attached a quick download of the problem, and have highlighted the cells where it is happening, just to make it more clear what I am babbling on about!

As far as I can see the accounts are set up exaclty the same as others which are displayed normally within the FASTR, so I am at a bit of a loss what to do next.

Would appreciate any guidance on the matter, and will answer any questions anyone may have about it, as I appreciate I haven't done a very good job of presenting my predicament !

Many thanks

Ben

 

[jmd0252]

You might want to check your override default information. The division factor, the default edit code, and the default decimals. They can make your numbers look "funny",, also,, there is a better web site for JDE problems..

http://www.jdetips

is a site better suited than here,, not many Edwards users are around her.

 

[BenP76]

After scratching my head for a bit, I checked the CRCX code in the F0902 file, and for some reason the currency was not GBP (the currency for the company) it was ESB!

I believe that since the peseta did not have decimal units the FASTR was not applying a DIV/100 formula to these 2 balances.

I DFU'd the F0902 records back to a GBP currency code, and everything is now fine. Will remember this in case it ever happens again!

Hopefully this will help anyone else who has the same problem - check your AA currency in the F0902.

Thanks to all who had a look in an attempt to help.

Ben