web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Changing text in Bacs file

(0) ShareShare
ReportReport
Posted on by

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??

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Tim Foster Profile Picture
    8,515 on at
    RE: Changing text in Bacs file

    Since you are asking about a BACS file, can I assume you are in the UK?  (I honestly had to Google this file format.)

    Could you please outline the menu path you use to generate this file?

    I don't have any experience with the UK localization of GP.  I suspect what you're looking for is equivalent to EFT file layouts in US and Canadian localizations.  This is accessed via Cards >> Financial >> EFT File Format

    Tim

  • Verified answer
    Ian Grieve Profile Picture
    22,784 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.

  • Community Member Profile Picture
    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

  • Community Member Profile Picture
    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

  • Verified answer
    Ian Grieve Profile Picture
    22,784 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
    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
    22,784 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
    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
    22,784 on at
    RE: Changing text in Bacs file
    I meant in Card >> Creditor Maintenance.
  • Community Member Profile Picture
    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?

Under review

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.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans