Invoice attaching to the wrong organization

Overview

After adding a new organization, you find that sometimes, when creating an invoice for an item, it attaches to another organization instead of the one intended.

Information

This could be due to a delay in the system in the user creation and association with the Organization you created which is why you were not having the option to choose that org in the previous attempts.

To solve this issue you must void the existing item and generate a new one. This can be done by using the article:  OnDemand: Creating, Editing, and Voiding an Invoice.

If you need further assistance,  please create a support ticket and include a screenshot of the invoice with the name of the organizations concerned.

<supportagent>

The queries have to be run on the relevant client DB, construct those and follow the SRT.
Note to L2 agent / Developer: The queries to be run on the DB (i.e. moving invoice and transaction/ activity) are listed below. You can also refer to 3177869 

use <client DB>;
update act_items set organization_id=<correct Org id> where organization_id=<Wrong org id> and person_id=<person id>;
update act_accts_receivable set organization_id=<correct Org id> where organization_id=<Wrong org id> and invoice_number = <invoice number>;
update act_invoices set organization_id=<correct Org id> where organization_id=<Wrong org id> and invoice_id = <invoice id>;
update act_orders set organization_id=<correct Org id> where organization_id=<Wrong org id> and purchase_id=<purchase id>;

</supportagent>

 

Comments

0 comments

Please sign in to leave a comment.