{"id":29033,"date":"2024-05-09T06:34:31","date_gmt":"2024-05-09T06:34:31","guid":{"rendered":"https:\/\/www.greytrix.com\/blogs\/sagex3\/?p=29033"},"modified":"2024-06-21T07:01:36","modified_gmt":"2024-06-21T07:01:36","slug":"positive-pay-file-generation-functionality-in-sage-x3","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagex3\/2024\/05\/09\/positive-pay-file-generation-functionality-in-sage-x3\/","title":{"rendered":"Positive Pay File Generation Functionality in Sage X3"},"content":{"rendered":"\n

Positive Pay is a banking service designed to mitigate check fraud risks. Customers of the bank provide a file containing account numbers, check numbers, and corresponding dollar amounts for each check. If a check is presented for payment but is not listed in this file, the bank will refrain from processing the payment and will reach out to the customer for further guidance.<\/p>\n\n\n\n

In Sage X3<\/a>, the positive pay file function makes a file with details about checks a company issued. This file goes to the bank. The bank checks if the checks presented for payment are valid using this file. To make a positive pay file generation in Sage X3, first, list the checks you’ve issued with details like the check number, date, and amount. Then, use Sage X3 to make a file in the format your bank needs.<\/p>\n\n\n\n

This file usually has info about each check, like the check number, date, amount, and the payee’s name and account number. When a check is brought to the bank for payment, they use this file to check if it’s valid and issued by your company. Making a positive pay file generation can stop fraud by making sure only allowed checks get paid. Sage X3<\/a> has tools to help you manage issuing checks, including making positive pay files.<\/p>\n\n\n\n

Navigate to access this function:<\/p>\n\n\n\n

A\/P-A\/R accounting -> Payments -> Positive pay file generation<\/strong><\/gwmw><\/gwmw><\/gwmw><\/gwmw><\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Figure 1: Navigation page<\/strong><\/p>\n\n\n\n

Utilize this function to create the Positive Pay bank file, which gathers data from Supplier payments (PAYMENTH) and the check table (CHQNUM) to generate an output file for previously unprocessed records. The file conforms to the specified file format of the bank and encompasses checks with statuses such as Issued, Voided, or Posted. Only records with a null Positive Pay sequence number are included, along with voided checks meeting the same criteria. If a check is voided subsequent to its inclusion in a previous file, the accounting cancellation process will reset the Positive Pay sequence number and creation date. It’s also possible to regenerate the file using the sequence number.<\/p>\n\n\n\n

Select the criteria like select new Generate new file<\/strong> if you want to create a new file or select Regenerate file to modify the already generated positive pay file but here you need to select sequence number. Select the\u00a0Bank\u00a0account,\u00a0From check no.\u00a0And\u00a0To check no. Then, click\u00a0OK. Refer Figure 2.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

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

Figure 2: Positive pay file generation selection screen.<\/strong><\/p>\n\n\n\n

It will generate the log as well as the positive pay file as shown in figure 3.<\/gwmw><\/gwmw><\/gwmw><\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Figure 3: Positive pay file creation log<\/strong><\/gwmw><\/p>\n\n\n\n

\u00a0This positive pay file will look like Figure 4. Which is further submitted to the bank for verification process.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Figure 4: Exported positive pay file<\/strong><\/p>\n\n\n\n

You can explore the folder where the files are kept and check them out. You can also save the files to the “Download” folder in the client directory or save them to the server. By default, the server will save them in the “BQE” folder, but you can choose another location if needed.

You can check the file, but it might be hard to read, especially if you have a lot of files, which could take up a lot of time.<\/gwmw><\/gwmw><\/p>\n\n\n\n

I generated Positive Pay for checks numbered 00022 to 00128. If you’re looking for 00128, there’s no need to go through more files.<\/p>\n\n\n\n

Here’s an easier way: Go to Common Data<\/strong>, then BP Accounting Tables<\/strong>, then Checks<\/strong>, and choose the Bank. Next, on the checkbook line starting from 00022, click the action icon, and from the dropdown menu, choose Check Status<\/strong>.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Figure 5: Check the status of the positive pay file<\/strong><\/p>\n\n\n\n

The Check status displays both the Positive Pay date and the Positive Pay sequence number. It’s important to note that if any check number has a sequence number different from the others, it indicates that it was included in a different file. This distinction helps to track and manage the Positive Pay process effectively, ensuring accurate recordkeeping and fraud prevention measures.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Figure 6: Positive pay seq. number for every check number<\/strong><\/p>\n\n\n\n

This blog demonstrates that the Sage X3 provides user-friendly tools and functionalities to facilitate the Positive Pay process, ensuring smoother operations.<\/gwmw><\/p>\n","protected":false},"excerpt":{"rendered":"

Positive Pay is a banking service designed to mitigate check fraud risks. Customers of the bank provide a file containing account numbers, check numbers, and corresponding dollar amounts for each check. If a check is presented for payment but is not listed in this file, the bank will refrain from processing the payment and will\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2,3,4,5,3162,13,8,3642,9,10,2796,11],"tags":[4157,4155,803,4160,3512,4159,4156,4158,4154,4153,1822,1838,3211,1942,1943,3735],"class_list":["post-29033","post","type-post","status-publish","format-standard","hentry","category-configuration","category-debug","category-faq","category-features","category-greytrix","category-integration","category-sage-erp-x3","category-sage-x3","category-sage-x3-consulting","category-standard","category-technical","category-tips","tag-bp-accounting-table","tag-check-status","tag-file","tag-functionality","tag-generation","tag-pay","tag-pay-file","tag-positive","tag-positive-pay","tag-positive-pay-file-generation","tag-sage-x3","tag-sage-x3-blog","tag-sage-x3-functional-blog","tag-sage-x3-technical-assistance","tag-sage-x3-technical-blog","tag-x3-blogs"],"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/29033","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/comments?post=29033"}],"version-history":[{"count":5,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/29033\/revisions"}],"predecessor-version":[{"id":29266,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/29033\/revisions\/29266"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/media?parent=29033"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/categories?post=29033"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/tags?post=29033"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}