Data flow from Payment screen to Journal entry on Posting using Automatic Journal

By | August 30, 2021

In Sage X3, Users can create Payments based on Purchase invoices and can see specific data being flowed from invoice screens to the respective payment screens. But what if the user wants specific data to be flowed from Payment to the Journal entry during posting of the payment.

In this blog, we’ll see how to flow the “Description” field present on the General tab of AR/AP Payment screen header to the “Default description” field present on the Header tab of Journal Entry screen as well as the “Description” column present at the lines level on the same screen. All this will be done with the use of Automatic Journals, which creates the Journal data based on Posting of a Payment.

First, to navigate on the following screens below are the steps:

Payment/Receipt screen: All > A/P-A/R accounting > Payment/Receipt entry
Journal Entry: All > Financials > Journal Entry
Automatic Journals: All > Setup > Automatic Journals

For the purpose of making things a bit more clear visually, below are the screenshots fields locations on their respective screens:

New Stuff: How to setup sales targets in Sales Commission Module

Description field on Payment screen
Description field on Payment screen
Default Desc. field on Journal Entry screen
Default Desc. field on Journal Entry screen
Line description fields on Journal Entry screen
Line description fields on Journal Entry screen

Now once we’re familiar with the screens, we’ll first find out the Automatic journal code used for the posted Payment. Follow the below mentioned steps:

Step 1: Check on the respective payment entry whether it’s posted or not. You can do that by checking the POST button (on the right top side on version 12 Sage X3) being enabled or hidden. If it’s hidden the Payment is posted and it’s Journal entry is already created, if not then please post it first.

Step 2: Jump onto its respective Journal entry screen via Accounting document button as shown below.

Accounting document on Payment screen
Accounting document on Payment screen

Step 3: Once on the Journal Entry screen, scroll below to find the Source tab in that look for Source field which’ll show “Automatic generation” and next to it will be Source transaction field showing “PRINC”. This is the Automatic Journal code we’re looking for.

Automatic Journal code on Journal Entry scree
Automatic Journal code on Journal Entry scree

Now that we’ve noted the Automatic Journal code, next steps involve us flowing the data.

Step 4: Now in a new tab, open Automatic Journal and on the left-list search for PRINC. Scroll below to the formula section on screen and check below for the Description and Journal Reference fields as shown:

Description field on Formula section in Automatic Journals screen
Description field on Formula section in Automatic Journals screen

Step 5: The Description field shows from where the data will be flowing to the Default Description field on the Journal Entry screen.
Now we’ve to use Description field data from Payment screen to flow on Default description and Lines description fields on Journal Entry. For this, we need to check where in PAYMENTH table it is storing:

PAYMENTH table in Table dictionary
PAYMENTH table in Table dictionary

Step 6: So use [F:PYH]DES in the Description field as shown in fig. On Step 4.
Note: Before making any change on the Automatic Journal formula field, keep a backup of the existing value present on the fields in case of mistake.

Step 7: Now the data will flow to the Default description field on Journal entry, so to flow the same data on the Lines description as well. Open Lines located on top right on screen as shown:

Lines button on Automatic Journals screen
Lines button on Automatic Journals screen

Step 8: In Lines scroll down to the Formula section and in that look for Description field, here use the same [F:PYH]DES to flow the data. However, if you check on the left-list there are many lines so you need to check which ones will work, for this particular step we used line no. 10 and 18 to make the change.

Line no. 10 & 18 having Description field on Automatic Journals(lines)
Line no. 10 & 18 having Description field on Automatic Journals(lines)

Step 9: Once the changes are done Save the Automatic Journal and perform a restart of the application, this is necessary to take effect.

Step 10: After restart, open the Payment screen and first cancel the previously posted entry using the Accounting cancellation option below the Accounting document as shown in Step 2. Give some time and then repost the Payment, and jump to the Journal Entry screen to see if the data is flowing properly.

Data on Description on Payment screen
Data on Description on Payment screen
Data Flowed to Default description field on Journal Entry screen
Data Flowed to Default description field on Journal Entry screen
Data flowed over to Description fields on Journal Entry screen
Data flowed over to Description fields on Journal Entry screen

In this way, we can make use of the Automatic Journals module to flow data without making changes in Specific scripts.