infor.com
concierge
infor u
developer portal
Home
Groups
VISUAL - Enterprise Customer Community
Managing Customers, Addresses, and Contacts
Legacy Contributor
We are using Visual 6.5.1, and upgrading to 7.X; but, not much has changed in the visual architecture affecting this issue.
The problem we are having is that the Customer Order, and the Invoice forms, store the Customer ID and not the Customer Name, Address, Contact, etc. So, you cannot recreate a historical document- for instance, a CO or an INVOICE if the CUSTOMER RECORD has changed.
Here are 2 examples where this causes problems:
1. Customer is in Georgia, and orders parts in 2013. In 2014, he moves to Florida. In 2014, we get a Florida Sales Tax audit for 2013, which says that that shipment was sent to FLORIDA and not GEORGIA, and now they want back taxes.
2. Customer owes money, from an order in late 2013. In December, he sells the business; new owner calls in and gives new business name. In January, we place account on Hold. Need to print copies of orders & invoices that were sent to old owner. But now, the orders say that they were sold to the New Business Name.
Has anyone else run into this? how do you work around this?
Find more posts tagged with
Comments
ztrue
Our work around is to archive all documents communicated outside of the building. All POs, Invoices, Shipping Documentation, etc... are stored as PDFs for this explicit reason.
Legacy Contributor
Thank you, Zach- before we moved, we used to archive paper copies of everything- I guess I'm lazy and want the database to be able to do the work for me... so, I guess I could use the UDF's and a macro or trigger to record a shipment address of record...
-
ztrue
You may be able to setup a secondary table inside of the visual DB or maybe a secondary "Archive" database that gets written to via trigger.
These systems make the most sense to me, but our process is the one we have been using for ever. Getting traction for it to change is sometimes tough.
Legacy Contributor
If you want to do an additional table, the Data Extender from Truefit Innovations is a tried and tested tool.
www.truefitinnovation.com/.../
Important Links
Community Hubs
Discussion Forums
Groups
Community News
Popular Tags
ION Connect
ION Workflow
ION API Gateway
Syteline Development
CPQ Discussion Ask a Colleague
Infor Data Fabric
Infor Document Management (IDM)
LN Development
API Usage
FAQs, How-To, and Best Practices