Frx 6.7 sp12 is not picking budget from Microsoft Dynamics GP 10 sp5. I have tried on solution from this forum where i checked the Rebuild GL indexes but it failed. I dont think my FRx has any problems though. But i can pinpoint where the problem might be in GP.
I ran checklinks for Budget Master but still the problem is not resolved.
Anyone who has come across this problem please assist. I was thinking of uninstalling Frx abd reinstalling it but i stringly feel Frx is okay.
I would suggest you, login with SQL Management Studio and run a select on GL00201 and validate if the budget you imported by chance has the column YEAR1 as 0, if this is the case then you will need to update the budget year on the detailed table to be picked up by FRx.
This code is provided as is with no warranties:
update p set p.year1 = a.year1 from GL00201 p join GL00200 a on a.budgetid = p.budgetid where p.year1 = 0
Francisco G. Hillyer - Rose Business Solutions
Try to delete the .g32 files in the Sysdata directory. That should reside on the server.
Dan Liebl, CMA CPIM | Senior Consultant | OTT,Inc | DLiebl@OTT-inc.com
Other Microsoft Sites
I'm a Customer
I'm a Partner
Use the official Twitter tags:
#MSDYNCOMM | #CONV13