PO Address changing based on client

Hello,
I am trying to generate a PO to one of my vendors for a project. Their address shows up properly, however if I go to settings and assign the PO to the client, the vendor’s city will change to the client’s city.

For example, Vendor1 in NYC will show up 123 9th ave, NYC 10001. Assigning PO to client XY who is based in Ft Lauderdale FL will result in Vendor1’s address being changed to 123 9th ave, Ft Lauderdale FL.

Is this expected behavior, or am I doing something incorrectly?

Hi,

Are you using a standard design?

Yes, I am using the Business design for this. If I try to change to a different design, the PDF will reload, but the design always stays on business no matter what is selected.

Are you changing the design on Settings > Invoice Design or in the settings tab on the edit invoice/purchase order screen?

Within the PO/Invoice itself. If I change it in the Settings menu and click update all records, it does push out to everything. However Changing the design still results in the same issue.

Thanks

@david I’m able to reproduce the problem where changing the PO design doesn’t update the preview in both the Flutter and React apps.

I haven’t been able to reproduce the address issue though.

@hillel I have done a screen recording, if it helps. Here is the link.

I am trying to send a PO and got this in the logs, accompanied by a 500 error on the desktop app.

2024-01-11 16:23:14] production.ERROR: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'invoiceninja.purchaseO>
[stacktrace]
#0 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Database/Connection.php(776): Illuminate\\Database\\Conn>
#1 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Database/Connection.php(407): Illuminate\\Database\\Conn>
#2 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2751): Illuminate\\Database\\>
#3 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2740): Illuminate\\Database\\>
#4 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3294): Illuminate\\Database\\>
#5 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2739): Illuminate\\Database\\>
#6 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3221): Illuminate\\Database\\>
#7 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3149): Illuminate\\Database\\>
#8 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Validation/DatabasePresenceVerifier.php(54): Illuminate\>
#9 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Validation/Concerns/ValidatesAttributes.php(903): Illumi>
#10 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Validation/Concerns/ValidatesAttributes.php(874): Illum>
#11 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Validation/Validator.php(657): Illuminate\\Validation\\>
#12 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Validation/Validator.php(457): Illuminate\\Validation\\>
#13 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Validation/Validator.php(492): Illuminate\\Validation\\>
#14 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Validation/ValidatesWhenResolvedTrait.php(31): Illumina>
#15 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Foundation/Providers/FormRequestServiceProvider.php(30)>
#16 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Container/Container.php(1302): Illuminate\\Foundation\\>
#17 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Container/Container.php(1266): Illuminate\\Container\\C>
#18 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Container/Container.php(1252): Illuminate\\Container\\C>
#19 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Container/Container.php(813): Illuminate\\Container\\Co>
#20 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(957): Illuminate\\Container\>
#21 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Container/Container.php(731): Illuminate\\Foundation\\A>
#22 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(942): Illuminate\\Container\>
#23 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Routing/ResolvesRouteDependencies.php(85): Illuminate\\>
#24 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Routing/ResolvesRouteDependencies.php(50): Illuminate\\>
#25 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Routing/ResolvesRouteDependencies.php(29): Illuminate\\>
#26 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(59): Illuminate\\Routi>
#27 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(40): Illuminate\\Routi>
#28 /var/www/invoiceninja/vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTrac>
#29 /var/www/invoiceninja/vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingRoutingDispatcher.php(19>
#30 /var/www/invoiceninja/vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTrac>
#31 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Routing/Route.php(259): Sentry\\Laravel\\Tracing\\Routi>
#32 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Routing/Route.php(205): Illuminate\\Routing\\Route->run>
#33 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Routing/Router.php(806): Illuminate\\Routing\\Route->ru>
#34 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(144): Illuminate\\Routing\\Router>
#35 /var/www/invoiceninja/app/Http/Middleware/UserVerified.php(40): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\>
#36 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): App\\Http\\Middleware\\User>
#37 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(122): Illuminat>
#38 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(87): Illuminate>
#39 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\Routing\\Middle>
#40 /var/www/invoiceninja/app/Http/Middleware/QueryLogging.php(40): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\>
#41 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): App\\Http\\Middleware\\Quer>
#42 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illumina>
#43 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\Routing\\Middle>
#44 /var/www/invoiceninja/app/Http/Middleware/Locale.php(86): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{clos>
#45 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): App\\Http\\Middleware\\Loca>
#46 /var/www/invoiceninja/app/Http/Middleware/TokenAuth.php(101): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{>
#47 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): App\\Http\\Middleware\\Toke>
#48 /var/www/invoiceninja/app/Http/Middleware/SetDb.php(40): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closu>
#49 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): App\\Http\\Middleware\\SetD>
#50 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(119): Illuminate\\Pipeline\\Pipel>
#51 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Routing/Router.php(805): Illuminate\\Pipeline\\Pipeline>
#52 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Routing/Router.php(784): Illuminate\\Routing\\Router->r>
#53 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Routing/Router.php(748): Illuminate\\Routing\\Router->r>
#54 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Routing/Router.php(737): Illuminate\\Routing\\Router->d>
#55 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(200): Illuminate\\Routing\\R>
#56 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(144): Illuminate\\Foundation\\Htt>
#57 /var/www/invoiceninja/vendor/sentry/sentry-laravel/src/Sentry/Laravel/Http/SetRequestIpMiddleware.php(45): Illuminate>
#58 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Sentry\\Laravel\\Http\\SetR>
#59 /var/www/invoiceninja/vendor/sentry/sentry-laravel/src/Sentry/Laravel/Http/SetRequestMiddleware.php(31): Illuminate\\>
#60 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Sentry\\Laravel\\Http\\SetR>
#61 /var/www/invoiceninja/vendor/livewire/livewire/src/Features/SupportDisablingBackButtonCache/DisableBackButtonCacheMid>
#62 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Livewire\\Features\\Support>
#63 /var/www/invoiceninja/app/Http/Middleware/Cors.php(24): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closur>
#64 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): App\\Http\\Middleware\\Cors>
#65 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php(39): Illuminate\\Pipel>
#66 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\Http\\Middlewar>
#67 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): I>
#68 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.ph>
#69 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\Foundation\\Htt>
#70 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): I>
#71 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(40): Illumin>
#72 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\Foundation\\Htt>
#73 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Il>
#74 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\Foundation\\Htt>
#75 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMainten>
#76 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\Foundation\\Htt>
#77 /var/www/invoiceninja/vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Middleware.php(87): Illuminate\\Pipelin>
#78 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Sentry\\Laravel\\Tracing\\M>
#79 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(119): Illuminate\\Pipeline\\Pipel>
#80 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(175): Illuminate\\Pipeline\\>
#/var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(144): Illuminate\\Foundation>
#82 /var/www/invoiceninja/public/index.php(56): Illuminate\\Foundation\\Http\\Kernel->handle()
#83 {main}

I believe this is the same issue:

Yes, it looks like it. I ran artisan migrate, and get the same “nothing to migrate” message. I will monitor the other thread for updates. Thanks.

I’ve checked in a fix for the po preview

1 Like

I am not sure if it is related, but the PO is still showing the balance, even if expensing it and marking the expense as paid. I just updated to v5.8.10 and the previews are working for changing designs.

Additionally, vendor portal is showing as empty.