In our previous blog, we had discussed about OE Posting Journal report from Order Entry module. Going further, in this blog post we will discuss about GL Posting Journal report under General Ledger reports.
GL Posting Journals report contains the account wise detail record as per posting sequence with accounts credit & debit amount. This report fetches the data from all transactions like GL journal entry, Purchase Order transactions, Order entry transactions, Accounts payable & Accounts Receivable transactions.
To print this report, navigate to:
General Ledger–>GL Reports–>Posting Journals Report
This report is used to print the posted transactions which arise from any other module which effect display in General Ledger after posting batches.
Once any Order entry, Purchase order, Accounts payable & Accounts receivable batch is created, then you need to run the Day End Processing before printing this report to get the effect in GL module or else you need to create GL batch for any transaction manually. We have multiple selections in UI, refer below screenshot:-
You can also print the report with various ranges as from & to posting sequence. In the above screen, you have to select any one of journals like posting journals or errors or previous posting journals & errors. The advantage of this posting journal report is that you can print errors also while generating error batch at the time of posting GL batch. You can also print previous posting journals. Another filter criteria is depend on your journals selection.
The report can be sorted by posting the sequence as well as account number, also report can print in source & functional currency, this all filter criteria can set by user as per his requirements.
The report selected by sorting the account no & only posting journal will be displayed in the source as well as in functional currency, Refer below screenshot:-
In posting journal report you can also see the credit & debit amounts in the source as well as in the functional currency for all bathes in all modules. If you use multicurrency accounting then, posting journal report displays some additional information like currency, transaction total in source, exchange rate, & functional currency etc. In above report you had selected currency source as well as functional so you can see the credit & debit amount in both currencies for particular GL account.
Greytrix a globally recognized Premier Sage Gold Development Partner is a one stop solution provider for Sage ERP and Sage CRM needs. Being recognized and rewarded for multi-man years of experience, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third party add-on development and implementation expertise.
Greytrix offers unique GUMU™ integrated solutions of Sage 300 with Sage CRM, Salesforce.com and Magento eCommerce along with Sage 300 Migration from Sage 50 US, Sage 50 CA, Sage PRO, QuickBooks, Sage Business Vision and Sage Business Works. We also offer best-in-class Sage 300 customization and development services and integration service for applications such as POS | WMS | Payroll | Shipping System | Business Intelligence | eCommerce for Sage 300 ERP and in Sage 300c development services we offer services such as upgrades of older codes and screens to new web screens, newer integrations using sdata and web services to Sage business partners, end users and Sage PSG worldwide. Greytrix offers over 20+ Sage 300 productivity enhancing utilities that we can help you with such as GreyMatrix, Document Attachment, Document Numbering, Auto-Bank Reconciliation, Purchase Approval System, Three way PO matching, Bill of Lading and VAT for Middle East.
For more details on Sage 300 and 300c Services, please contact us at email@example.com. We will be glad to assist you.