When I try to import excel file to bank entry UI, the header and details files not upload correctly, one bank details data automatic transfer to another bank code when upload, why this? Can anybody help me.
When I try to import excel file to bank entry UI, the header and details files not upload correctly, one bank details data automatic transfer to another bank code when upload, why this? Can anybody help me.
Hi Kanij Sharme this might seem a basic question but have you searched all sheets in the import file for the incorrect bank code to see if its inside the file anywhere? Perhaps do a Search and Replace between the incorrect and correct bank code. The other thing you can do is once you click File -> Import and are about to import the data, right-click on the Contents cell next to Bank Code and hard-set the value to the correct Bank Code, then click OK to import:
Good Luck!
Thanks a lot, I will try this. but this problem arise when I try to import more than one bank at the same time.
OK, also double-check your BANK and SEQUENCENO codes line up between Bank_Entries_Header and Bank_Entries. This is most important to check for your issue. Good luck!
*Community Hub is the new name for Sage City