I have a site with multiple companies. They are currently using EFT for receivables in one and want to copy the customer's EFT Setup to another. The same customers are already in both. I've identified the main EFT table as SY06000. Are there any other's that should be considered? Please advise. Thank you.
The SY06000 table is the table that holds the EFT Information for the Customers and Vendors. This is linked to the Remit To Address assigned to the Vendor. This should be the only table for Vendor/Customer EFT information. It does not include the checkbook information, Email information or EFT Setup information.
The one thing that you will need to keep in mind is the Vendor ID has to be the same between both companies as the SY06000 also contains the Vendor ID. The column for this is the CustomerVendor_ID. The next column in the table is the ADRSCODE which links to the address ID that is assigned the EFT Information. Normally assigned to as the Remit To Address in the Vendor Setup. However, you can setup eft for which ever Address ID you want that is assigned to the Vendor.
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
1,018
Share
Report
All responses (
Answers (
