Movie Magic Budget Account Mask Field

New option in the Movie Magic Budget Upload to automatically split the MMB Account codes into an Eclipse compatible format when you upload the budget into Eclipse using the tab delimited text file: Budget Upload via Movie Magic (Tab Delimited)

This should reduce the necessary manual work required to split MMB Account Codes in Notepad++ to an Eclipse compatible format so you no longer need to remove dashes, add spaces, etc before you upload the file.

But please note that the account codes in your entire budget must still be in a consistent format for each budget line, so some minor edits may be required before you can upload it into Eclipse using the account masking field.

In the Movie Magic Budget screen, input a value in the Account Mask field to split the account code automatically to an Eclipse compatible format when you upload the budget file. Refer to the table below for corresponding formats.

Open

If the Account Mask field is left blank, then the budget upload does not do any account format conversion and you will need to ensure the accounts are in the correct format before uploading the budget (by editing it in Notepad++)

MMB Code Format Input	Eclipse Code Format Output	Account Mask Field to use

MMB Code Format Input	Eclipse Code Format Output	Account Mask Field to use
123-45	123 45	PPP DD or PPP-DD (ignores everything except P and D)	Open
12-34	12 34	PP DD
1234	12 34
1234	1234
12345	123 45

Account Mask Key:
P = Prod Code Character
D = Detl Code Character