[v7] Advances Received not populated

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! :slight_smile:

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

Please raise an issue in github (https://github.com/frappe/erpnext/issues).

Pushed a fix in hotfix branch.

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