{"id":31078,"date":"2025-07-31T10:22:50","date_gmt":"2025-07-31T10:22:50","guid":{"rendered":"https:\/\/www.greytrix.com\/blogs\/sagex3\/?p=31078"},"modified":"2025-07-31T10:22:50","modified_gmt":"2025-07-31T10:22:50","slug":"how-can-we-split-line-wise-journal-entries-generated-from-customer-bp-invoices-through-automatic-journals-in-sage-x3","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagex3\/2025\/07\/31\/how-can-we-split-line-wise-journal-entries-generated-from-customer-bp-invoices-through-automatic-journals-in-sage-x3\/","title":{"rendered":"How can we split line-wise journal entries generated from customer BP invoices through automatic journals in Sage X3"},"content":{"rendered":"\n

Sage X3<\/a> is an enterprise resource planning (ERP) solution that helps organizations manage all operations and data within a unified software system. It includes various modules such as Sales, Purchasing, Inventory, Projects, Financials, and more.
One of our clients requested that the Accounts Inquiry screen display line-wise journal entries corresponding to individual lines from customer BP invoices, instead of a single consolidated journal line. To accommodate this requirement, we updated the automatic journal line configuration accordingly.<\/p>\n\n\n\n

Steps to Implement the Change:
Step 1:<\/strong><\/p>\n\n\n\n

Navigate to:
All > Setup > Financials > Accounting Interface > Automatic Journals
In the Automatic Journal screen, open the BPCIN journal type, then go to the Lines section as shown in the screenshot below.<\/p>\n\n\n\n

New Stuff:<\/strong> How to Display the Approver\u2019s Name and the Date of Approval in Crystal Report<\/a><\/p>\n\n\n\n

\"Fig01:<\/a><\/center>\n
Fig01: Automatic Journal screen<\/center><\/font>\n\n\n\n

Step 2:<\/strong>
Go to line no. 2, then click on the Formulas section.
Next, add the required formulas in the following lines:
Line 27 \u2192 Description
Line 52 \u2192 Line Identifier
Formula : num$([F:SIL]LIG)<\/em><\/strong>
Refer to the screenshots below for the exact formula entries.<\/p>\n\n\n\n

\"Fig02:<\/a><\/center>\n
Fig02: Automatic Journal screen (Lines)<\/center><\/font>\n\n\n\n
\"Fig03:<\/a><\/center>\n
Fig03: Automatic Journal screen (Formula)<\/center><\/font>\n\n\n\n
\"Fig04:<\/a><\/center>\n
Fig04: Automatic Journal screen (Formula)<\/center><\/font>\n\n\n\n

By following the above steps u can full fill the requirement.<\/p>\n\n\n[about_us_blog_common]\n","protected":false},"excerpt":{"rendered":"

Sage X3 is an enterprise resource planning (ERP) solution that helps organizations manage all operations and data within a unified software system. It includes various modules such as Sales, Purchasing, Inventory, Projects, Financials, and more.One of our clients requested that the Accounts Inquiry screen display line-wise journal entries corresponding to individual lines from customer BP\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":[8,13],"tags":[2576,176,2480,1822],"class_list":["post-31078","post","type-post","status-publish","format-standard","hentry","category-sage-erp-x3","category-integration","tag-accounts","tag-automatic-journal","tag-customer-bp-invoice","tag-sage-x3"],"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/31078","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=31078"}],"version-history":[{"count":9,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/31078\/revisions"}],"predecessor-version":[{"id":31087,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/31078\/revisions\/31087"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/media?parent=31078"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/categories?post=31078"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/tags?post=31078"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}