Adding to the existing data in FE NXT scenario is not allowed through Patch Budget endpoint

Rehan Khan

Hi,


We tried a case here, where data existed for a particular FE account and project id combination for the first month i.e. January 2015. We then tried to update the data present in existing scenario id for three months through Patch Budget endpoint. But, we found that, we need to provide 12 months of data using Patch Budget endpoint. In this way, it will overwrite January 2015 data which is already present in the FE database. In my case, I just want to update February and March data. I do not want to touch remaining months data, that should remain the same.

If we provide three months of data in the JSON file, then we get an error –



Same requirement had been posted by us on April 30, 2018 and had received the reply till May 18, 2018, please find the following link for your reference - 

https://community.blackbaud.com/forums/viewtopic/493/39612?post_id=151980#p151980


Regards,

Rehan / Vaibhav.

 

Eddie Barker

Hi Rehan,

When you patch a budget line, you are editing "the entire thing" so changing lines in that endpoint will replace the existing budget lines. You will have to send it all the information it needs to pass budget validation in your call, including columns (of the 12, if you're doing it for a year).


Thanks!

Rehan Khan

Hi Eddie,


Thanks. 


But in the current following scenarios - 

1) FE NXT budget scenario contains data for four months i.e. July, Aug, Sept & Oct for a particular FE account combination (all the other months show zero in FE budget scenario), now again data for Nov & December is loaded in the same scenario & for the same FE account combination, in this case, it should update/load data for only two months that are loaded from PP, while the data in all other months should remain the same.

2) Same goes in case when say, we are loading data for four entities i.e. Ent1, Ent2, Ent3 & Ent4 from PP to FE NXT in two attempts. First we are loading for entities Ent1 & Ent2 and in second attempt we are loading for entities Ent3 & Ent4, in this case, the data present in entities Ent1 & Ent2 should also remain intacct with data loaded for entities Ent3 & Ent4 during the second attempt. 


Please let me know, what are the options left for me. 


Regards,

Rehan / Vaibhav.   

Eddie Barker

Unfortunately, due to the way that budgets work in Financial Edge NXT, you do still have to patch the entire line as described above. I've got this recorded in our backlog for consideration when we revisit and enhance budgeting. Thanks!