Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP forum
Answered

Changing text in Bacs file

Posted on by Microsoft Employee

When exporting a BACS file from GP into a text file, I would like to change the line called F03. Where in GP can I change this??

  • Verified answer
    Ian Grieve Profile Picture
    Ian Grieve 22,782 on at
    RE: Changing text in Bacs file
    Yes, the ability to email was introduced in GP2010 R2.
  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Changing text in Bacs file

    I do not have those options in cards > creditor maintenance. The only options I have are Options > Address > Accounts.

    Is this again due to using an old version?

  • Verified answer
    Ian Grieve Profile Picture
    Ian Grieve 22,782 on at
    RE: Changing text in Bacs file
    I meant in Card >> Creditor Maintenance.
  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Changing text in Bacs file

    That is too bad as Im stuck with the GP10 version. Sorry to be think but what do you mean by loading a creditor? Do you mean pulling up an outstanding invoice through "transactions by creditor"?

    Tnxs again for getting me up to speed with GP.

  • Verified answer
    Ian Grieve Profile Picture
    Ian Grieve 22,782 on at
    RE: Changing text in Bacs file

    I think the email remittance is a GP 2010 function.

    However, if it isn't then load a creditor and click the Email button in the bottom right corner.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Changing text in Bacs file

    That's great - found it. Tnx a million.

    Would you happen to know how I activate a supplier to have the remit advice sent out by email? I have not used GP for 18 mths and have forgotten where the "little" box is that I need to tick to email the remit advice automatically when processing payments.

    Kind regards

    Tina

  • Verified answer
    Ian Grieve Profile Picture
    Ian Grieve 22,782 on at
    RE: Changing text in Bacs file

    The PM EFT Payment Report is modified via Report Writer (Tools >> Customise >> Report Writer); the way I have done this before is to add some VBA to the report which generates the EFT file in the required output when the report is generated.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Changing text in Bacs file

    Thanks Ian - very helpful. I am using version 10 and I have System Admin access. How do I access the PM EFT Payment register?

    Kind regards

    Tina

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Changing text in Bacs file

    Hi Tim

    Tnx so much for your reply. I am based in London. I do not have the EFT File format option under cards > Financial. Is there another way? FYI I am using GP version 10.

    Kind regards

    Tina

  • Verified answer
    Ian Grieve Profile Picture
    Ian Grieve 22,782 on at
    RE: Changing text in Bacs file

    BACs files are maintained in the EFT File Format window which Tim mentioned.

    However, that window only became available in GP10 in the UK so if your BACS file format predates that version, then it might be a customisation of a report such as the PM EFT Payment Register.

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,989 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,588 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans