Edit Payables Checks "Comment" Field

(0) Share

Report

Posted on by Community Member

Hello:

For prepayments, can the "Comment" field in the Edit Payables Checks window be referenced in EFT files?

Thanks!

John

Categories:

Microsoft Dynamics GP

I have the same question (0)

All responses (15)

Answers (1)

cdinh 295 User Group Leader on at

Like (0)

Report
Copy link

Link copied!

Hi John,

Yes, you can add a "Comment" Field in your EFT File.

Here are the steps:

1. You need to add a Comment field in your EFT File Format >> Select Line Type = Detail >> In my example I position it at the very end...field 11, then set your length (max 30) and description.

2. On field 11, click on show button on the right to display table mappings.

Look for Table Name <PM Paid Transaction History File > and Field Name < Transaction Description. <SAVE>

3. In Edit Payables Check Comment, enter your description.

Note: You may need to go to Purchasing >> Transaction >> Edit Check -- if you have more than one record

4. Generate EFT like you normally do.

Here you go... EFT File with Comment.

Hope this helps!

Regards,

Cecile Dinh

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Cecile:

Thank you, for that great information!

I have a question. If the end user is processing prepayments where the checks cut are not yet applied to anything, will those prepayments appear in the PM Paid Transaction History File? That is the only "roadblock", in terms of using that particular table.

John

Was this reply helpful? Yes No
cdinh 295 User Group Leader on at

Like (0)

Report
Copy link

Link copied!

Hi John,

If you are using "Select Checks" it automatically apply the Invoice to payment because you are selecting which Invoice are to be paid.

Yes, those payments will become HIST after posting and will appear PM Paid Transaction History file.

If the payment is entered in "Manual Payment" window, it will be in OPEN status after posting if there's no Invoice applied to it.

Regards,

Cecile

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi There, Cecil"

The end user cuts checks for prepayment, without applying them to invoices in the Edit Payables Checks window. So, it sounds like the checks would not be in history.

Does the EFT File Format Maintenance window reference any open payables table?

John

Was this reply helpful? Yes No
cdinh 295 User Group Leader on at

Like (0)

Report
Copy link

Link copied!

Hi John,

I see - when the end user process the Select Checks, he goes to "EDIT CHECK" then the Edit Payable window will show up.

In my example earlier, it was done by selecting " Edit Check Batch" window and selecting the Invoices to be paid.

But either way, the "Comment" will still show in the EFT File even if it is in OPEN table or Unapplied.

Record 1: Open payment or unapplied

Record 2: Open payment or unapplied

Here is your EFT File would look like:

Regards,

Cecile Dinh

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Cecile:

For such open and unapplied checks, what table in the EFT File Format Maintenance window would be used?

John

Was this reply helpful? Yes No
cdinh 295 User Group Leader on at

Like (0)

Report
Copy link

Link copied!

Hi John,

You would still use PM Paid Transaction History File and field name Transaction description for OPEN or Unapplied.

Best regards,

Cecile Dinh

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Cecile:

I tested this, here on my laptop, and the prepayment did not go into the PM Paid Transaction History file but into the PM Transaction Open File, instead.

Does the EFT File Format Maintenance window offer "PM Transaction Open File" in the Table Name drop-down list?

John

Was this reply helpful? Yes No
Verified answer

cdinh 295 User Group Leader on at

Like (0)

Report
Copy link

Link copied!

Hi John,

If you look at the SQL Table, yes it will show in OPEN table. But the testing I did in EFT File format is exactly what I've shown in the screenshot above. Both open and history goes into EFT file. Have you configured your EFT File Format yet?

Regards,

Cecile

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Again, Cecile!

I have not. I'm suprised that the EFT File Format Maintenance window pulls data from the open table, even upon referencing the PM Paid Transaction History table.

Thanks, for verifying! I really appreciate the help!

John

Was this reply helpful? Yes No