Hi,
Kindly note that in Version 7, when we click on ‘Get Advances Paid’ in Sales Invoice, the table is not populated with advances received. We did not get any error messages though.
Thank you.
Hi there, is there any solution to this?
Thanks! 
Can’t replicate the issue. Can you please update your instance and check again?
I seem to be experiencing the same issue. When converting a sales order to an invoice with advance payments using the new payments received entry the entries are pulled through. However for legacy entries using Journal Entries for advance payments, they are not pulled through.
ERPNext: v7.0.32
Frappe Framework: v7.0.27
Hi
Thanks, I tried to update, I experienced the following exception:
Executing erpnext.patches.v7_0.migrate_mode_of_payments_v6_to_v7 in pfsmain
(4b19e97a49b1c0b2)
Traceback (most recent call last):
File “/usr/lib/python2.7/runpy.py”, line 174, in _run_module_as_main
"__main__", fname, loader, pkg_name)
File “/usr/lib/python2.7/runpy.py”, line 72, in _run_code
exec code in run_globals
File
“/home/frappe/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line
79, in
main()
File
“/home/frappe/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line
16, in main
click.Group(commands=commands)(prog_name='bench')
File
“/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”,
line 716, in call
return self.main(*args, **kwargs)
File
“/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”,
line 696, in main
rv = self.invoke(ctx)
File
“/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”,
line 1060, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File
“/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”,
line 1060, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File
“/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”,
line 889, in invoke
return ctx.invoke(self.callback, **ctx.params)
File
“/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”,
line 534, in invoke
return callback(*args, **kwargs)
File
“/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/decorators.py”,
line 17, in new_func
return f(get_current_context(), *args, **kwargs)
File “/home/frappe/frappe-bench/apps/frappe/frappe/commands/init.py”,
line 24, in _func
ret = f(frappe._dict(ctx.obj), *args, **kwargs)
File “/home/frappe/frappe-bench/apps/frappe/frappe/commands/site.py”,
line 206, in migrate
migrate(context.verbose, rebuild_website=rebuild_website)
File “/home/frappe/frappe-bench/apps/frappe/frappe/migrate.py”, line 27,
in migrate
frappe.modules.patch_handler.run_all()
File
“/home/frappe/frappe-bench/apps/frappe/frappe/modules/patch_handler.py”,
line 26, in run_all
if not run_single(patchmodule = patch):
File
“/home/frappe/frappe-bench/apps/frappe/frappe/modules/patch_handler.py”,
line 60, in run_single
return execute_patch(patchmodule, method, methodargs)
File
“/home/frappe/frappe-bench/apps/frappe/frappe/modules/patch_handler.py”,
line 80, in execute_patch
frappe.get_attr(patchmodule.split()[0] + ".execute")()
File
“/home/frappe/frappe-bench/apps/erpnext/erpnext/patches/v7_0/migrate_mode_of_payments_v6_to_v7.py”,
line 20, in execute
si_doc.save()
File “/home/frappe/frappe-bench/apps/frappe/frappe/model/document.py”,
line 242, in save
return self._save(*args, **kwargs)
File “/home/frappe/frappe-bench/apps/frappe/frappe/model/document.py”,
line 272, in _save
self._validate()
File “/home/frappe/frappe-bench/apps/frappe/frappe/model/document.py”,
line 388, in _validate
self._validate_links()
File “/home/frappe/frappe-bench/apps/frappe/frappe/model/document.py”,
line 630, in _validate_links
frappe.LinkValidationError)
File “/home/frappe/frappe-bench/apps/frappe/frappe/init.py”, line
299, in throw
msgprint(msg, raise_exception=exc, title=title, indicator='red')
File “/home/frappe/frappe-bench/apps/frappe/frappe/init.py”, line
292, in msgprint
_raise_exception()
File “/home/frappe/frappe-bench/apps/frappe/frappe/init.py”, line
265, in _raise_exception
raise raise_exception, encode(msg)
frappe.exceptions.LinkValidationError: Could not find Row #1: Mode of
Payment: Cash
Traceback (most recent call last):
File “/usr/local/bin/bench”, line 11, in
load_entry_point('bench', 'console_scripts', 'bench')()
File “/home/frappe/.bench/bench/cli.py”, line 40, in cli
bench_command()
File “/usr/local/lib/python2.7/dist-packages/click/core.py”, line 716, in
call
return self.main(*args, **kwargs)
File “/usr/local/lib/python2.7/dist-packages/click/core.py”, line 696, in
main
rv = self.invoke(ctx)
File “/usr/local/lib/python2.7/dist-packages/click/core.py”, line 1060,
in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File “/usr/local/lib/python2.7/dist-packages/click/core.py”, line 889, in
invoke
return ctx.invoke(self.callback, **ctx.params)
File “/usr/local/lib/python2.7/dist-packages/click/core.py”, line 534, in
invoke
return callback(*args, **kwargs)
File “/home/frappe/.bench/bench/commands/update.py”, line 60, in update
_update(pull, patch, build, bench, auto, restart_supervisor,
requirements, no_backup, upgrade, force=force)
File “/home/frappe/.bench/bench/commands/update.py”, line 90, in _update
patch_sites(bench_path=bench_path)
File “/home/frappe/.bench/bench/utils.py”, line 161, in patch_sites
run_frappe_cmd('--site', 'all', 'migrate', bench_path=bench_path)
File “/home/frappe/.bench/bench/utils.py”, line 501, in run_frappe_cmd
raise CommandFailedError(args)
bench.utils.CommandFailedError: (‘–site’, ‘all’, ‘migrate’)
Released the fix.
It’s working now, thank you!
1 Like