{"id":16734,"date":"2017-10-24T12:24:19","date_gmt":"2017-10-24T12:24:19","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?p=16734"},"modified":"2024-03-19T06:49:07","modified_gmt":"2024-03-19T06:49:07","slug":"simplified-ap-invoice-report-in-sage-300","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2017\/10\/24\/simplified-ap-invoice-report-in-sage-300\/","title":{"rendered":"Simplified AP Invoice Report in Sage 300"},"content":{"rendered":"

Enterprise Resource Planning is a type of software that connects day-to-day business process including order management, inventory and customer relationship management. The main application of an ERP Software<\/a> is to collect and organize data from various levels and provide the management with a clear picture of profit and loss.<\/p>\n

New Stuff<\/em>:\u00a0<\/strong>GL Report with Source Document Tax Amount<\/a><\/p>\n

In this blog, we will discuss AP invoice – How to export\/ maintain the record of AP invoice Entries using AP Invoice Utility.<\/p>\n

We have a solution to maintain\/export all those data to Excel Sheet from\u00a0Sage 300<\/a>.<\/p>\n

In Sage 300 ERP, we have developed a new utility to Export Number of Batches using a single User Interface (we will Consider Only AP- INV, AP-CREDIT, AP-DEBIT Transaction)<\/p>\n

Refer Below screen:-<\/strong>
\n\"\"<\/a>User needs to select path using Select Path file Option (excel file location) and Utility will work and System create Excel file including number of Batches automatically based on data entered in Selected Posting date field Option. (This will be manual process. User has to select (browse) file & Export it.)<\/p>\n

The Export format is as follows:-
\n\"\"<\/a>Note: – <\/strong>At the time of Exporting Excel file if system found Blank value of any field from AP invoice Respective screen then value should be print blank in Exported Excel.<\/p>\n

Field Mapping:-<\/strong><\/p>\n