Exploring auto journals: what table Is that?

3 minute read time.

Time to go on another exciting adventure exploring the automatic journals!

In our previous outings, we’ve explored small pieces of the auto journals to better understand how they work.  We’ve ventured into:

In today’s adventure, we are going to zero in on the STKRE (Purchase Receipt) Auto journal’s (GESGAU) lines 150 and 160 on 2022 R3 plus a couple Auto journal features. Just a reminder: Auto journals are located under Setup, Financials, Accounting interface.

On the Formula tab for STKRE Amount, someone asked what table is PTD2?  It wasn’t in the Table dictionary. (The Table dictionary can be found under the Technical tab in the Online help center) Was it the table index? Was there a typo on Line 150 and Line 160?

Typically, if we see a formula with [F:XXX], the “F” indicates a table and the “XXX” would be the table abbreviation. [M:XXX] indicate a screen with the abbreviation “XXX.”

Line 150 [F:PTD2]LINAMT*V_COURSDEV

  

Line 160: ar2([F:STJ]AMTDEV)+ar2([F:STJ]VARVAL)-([F:PTD2]LINAMT*V_COURSDEV)- ar2([F:SJV]DOOVEMAT+[F:SJV]DOOVESCO)

 

PDT2 is not a table name abbreviation. It is the name of a temp table declared and called in the FUNSTKACC code. The FUNSTKACC opens the PRECEIPT table and creates the temp table PTD2. We can see FUNSTKACC referenced in the General tab, Processing field

 

While we are in the Auto journals, let’s take a look at the Lines again.  On each of the Formula lines, there is an Actions icon to the right. The drop-down menu contains Formula wizard, Message display, Variables, Parameters. In Exploring auto journals: the “V_” formula, we looked at Variables and Parameters. We will explore Formula wizard and Message

  

Selecting Formula wizard brings the formula from the line into the Wizard screen.  You can modify formulas or create new formulas in the Wizard. Beware! Clicking Verify only checks your syntax. It does not verify that you have valid table or field names in your formula. If the syntax is faulty, it will come back with an “Illegal Character” message. When you click Ok, the Wizard brings over the formula to the Automatic journal Formula line unless there are illegal characters. The Illegal character must be corrected before Ok will populate the line. Closing with the X cancels any changes you made in the Wizard.

 

Selecting Message display, returns the message linked to the “mess” Formula line.

The mess(109,853,1) formula is translated to “Adjusted purchase order/invoice.”

We can also find the mess(109,853,1) using the Calculator from the right list.

Enter the formula and click enter to find the message behind the formula.

Don’t leave yet! I have another fun fact for you. These messages are stored in the Local menus under Development, Data and Parameters, Tables. Our example is Chapter 853, Number 109 with Message Adjusted purchase order/invoice.

 

If this exploration has increased your interest in further Auto journal study, check out the following offerings from Sage University:

In this course, you will learn the structure of and how to configure and use Auto Journals. We'll discuss best practice tips for customizing to your needs, including using accounting codes. Also covered are the most commonly used auto journals that you may consider implementing for your organization.

Attend this expert workshop to gain a holistic view on automatic journals and to understand of how to perform automatic journal adjustments or changes safely in Sage X3. You will also learn tips and tricks and possible adjustments you can make without any development knowledge and applying Sage X3 best practices

I hope this information helps you in your quest to better understand Auto journals.

Take care my X3 friends. Stay safe!