Is there a way to tie back sage 300 ap payables to Orchid EFT records

Question

Is there a way to tie back ap payables to Orchid EFT records? We would like to see the effective date for an eft based on the ap invoice number. Is this possible?

kkyle2 · Answer

Are you referring to the Effective Date in the text file that is generated for upload to the bank? If so, to my knowledge, that is only stored in the text file and is established based on the logic in the file format used (NACHA, CAN_EFT...) so I don't think you would find it anywhere in the Orchid EFT tables in order to link it to the invoice # from APOBL (or which ever table you use). However, if you are referring to the Effective Date in the EFT file format that date logic is probably the same for each payment, you would just need to know what the date logic is to compare it to the invoice date (today, tomorrow, next business day....).

Sage 300

Is there a way to tie back sage 300 ap payables to Orchid EFT records

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING