{"id":36848,"date":"2026-02-24T09:54:31","date_gmt":"2026-02-24T09:54:31","guid":{"rendered":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?p=36848"},"modified":"2026-02-24T10:01:24","modified_gmt":"2026-02-24T10:01:24","slug":"custom-bank-integration-in-sage-300-using-acctype-optional-field","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2026\/02\/24\/custom-bank-integration-in-sage-300-using-acctype-optional-field\/","title":{"rendered":"Custom Bank Integration in Sage 300 Using ACCTYPE Optional Field"},"content":{"rendered":"\n

In Sage 300 ERP<\/a><\/u>, Banks require different file formats or identifiers<\/strong> based on the type of bank account<\/strong> for example, Current Account<\/strong> or Savings Account<\/strong>. However, Sage 300 does not provide a standard field in the Vendor master to store account type information that can be directly consumed by a bank integration program.<\/p>\n\n\n\n

To solve this limitation, we implemented a custom solution using Optional Fields<\/strong> in Sage 300. This blog explains how the ACCTYPE <\/strong>optional field<\/strong>, stored in CSOPTFIELD<\/strong>, is created, mapped, and used in a Custom bank integration EXE<\/strong> to dynamically populate account type details in the bank TXT file.<\/p>\n\n\n\n

The EXE then generates a TXT file in a company-specific format<\/strong>, supporting configurable field sequences and custom separators such as \u201c@\u201d<\/strong>. This flexible design enables the same solution to adapt to different company requirements.<\/p>\n\n\n\n

By automating data extraction and TXT file creation from the AP module, this customization , minimizes errors, and ensures consistency between Sage 300 transactions.<\/p>\n\n\n\n

New Stuff: –<\/strong> OE Ship via codes report in Sage300<\/a><\/p>\n\n\n\n

Please refer below screenshot of the user interfaces for the \u201c Custom Bank Integration in Sage 300 Using ACCTYPE Optional Field<\/strong>“.<\/p>\n\n\n\n

\"\"<\/a><\/center>
Figure 1 : Sage 300 Common Service Optional Field Screen<\/center><\/font>\n\n\n\n

<\/p>\n\n\n\n

<\/p>\n\n\n\n

<\/p>\n\n\n\n

<\/p>\n\n\n\n

\"\"<\/a><\/center>
Figure 2 : Vendor Master Mapping Optional Field Screen in sage 300<\/center><\/font>\n\n\n\n

<\/p>\n\n\n\n

<\/p>\n\n\n\n

<\/p>\n\n\n\n

\"\"<\/a><\/center>
Figure 3 : Bank Integration Exe in sage 300<\/center><\/font>\n\n\n\n

<\/p>\n\n\n\n

Output:
<\/strong><\/u><\/em>
<\/p>\n\n\n\n

DFT@IN@78678-09091@INR@9061.90@@20260130@@@@@@@@@@@@@Chloride Systems@@@@2<\/strong><\/u>@1234567890@@@@@@NEFT@HDFC0000339@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@customer_service@chlorideus.com@@@@@@@@@@@@@CITI14@3@CITIBA@@@@@@@@@@@@@@@@@@@<\/em>@greytrix
INV@ .<\/em>
INV@ .<\/em>
INV@ .<\/em>
INV@ .<\/em>
INV@Invoice Number Inv Date Inv Amt TDS% TDS Ded Net Pay .<\/em>
INV@AP\/INV\/123 20260130 6146 4.00 246 5900<\/em>.<\/p>\n\n\n\n

Optional Fields:<\/strong><\/u><\/em><\/p>\n\n\n\n

Steps For adding the Optional field into sage 300.<\/p>\n\n\n\n