Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 305 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Entering Bank Detais and setting up BACS
Daragh
Member Posts: 3
Hi All,
I'm looking for some help with regards to entering Bank Details into Navision. And if possible some information on how to set up BACS?
We're hoping to move from CHQ runs to BACS very soon, and i've been given the task in entering bank details for each vendor and if i can set up BACS with our BACS providor.
The first question i have is how do i go about entering the sort code within the Bank Account. Would i enter it like 20-00-00 or simply 200000?
I've been looking into setting up BACS on NAV and i've seen a file where i need to enter a "BACS FILE NAME" and then there a tick function for "IMPORT BACS FILE". Can anyone help with advice on this please?
Many thanks
Daragh
I'm looking for some help with regards to entering Bank Details into Navision. And if possible some information on how to set up BACS?
We're hoping to move from CHQ runs to BACS very soon, and i've been given the task in entering bank details for each vendor and if i can set up BACS with our BACS providor.
The first question i have is how do i go about entering the sort code within the Bank Account. Would i enter it like 20-00-00 or simply 200000?
I've been looking into setting up BACS on NAV and i've seen a file where i need to enter a "BACS FILE NAME" and then there a tick function for "IMPORT BACS FILE". Can anyone help with advice on this please?
Many thanks
Daragh
0
Comments
The sort code format can just be numeric, eg 987654, but more on the BACS file format itself in a moment...
The BACS routine is run from the payment journal. Instead of printing cheques, you export a BACS file. The File Path you mention in the Purchase & Payables Setup window is the default file path you would like the BACS text file to be exported to. If you tick the "Import BACS File" option, then a copy of the file is saved in NAV against the related BACS Register for future reference.
It is good practice to create a new Payment Method for BACS so you can filter on it and you will need to set up a BACS Bank Account against every Vendor you would like to pay via BACS and specify this as the "BACS Account No."
BACS File Format: Unfortunately each Bank uses it's won BACS file format, so Microsoft only provide a "generic" BACS file export routine that outputs the data that is typically required. You will need your solution partner or NAV developer to amend your one to suit your bank's format or to create a new one based on the standard version.
Try this out on a test copy of your live system or the Cronus demo company and see how it works.
Good luck
Best regards
Edward
Lead Consultant
Theta
Very helpful.
I'll do some testing on this and if you don't mind i'll post on the forum my results.
Kind regards,
Daragh