24/11/2021 - Summarisation of Sales and Purchase Lines
Summarisation of Sales and Purchase Lines
|
|
|
As indicated in the Daily Summaries Article published 23th November 2021 we have now built in an enhancement whereby Sales and / or Purchase Lines can be summarised at a Cost Centre level within an invoice being posted to the Accounting Software.
The purpose of this is to reduce the volume of line records being posted to the Accounting Software. For example, if we have a 50 line invoice, each line is presently posted to the Accounting Software. If this enhancement is turned on, Ostendo would summarise the Posting Journal down to one line per Cost Centre / Tax Code. At some sites, this would dramatically reduce data volumes being posted across to the Accounting Software.
Summarisation of Sales Invoice Lines can be configured independently to Purchase Invoice Lines thereby providing a level of flexibility. eg: Sales Lines could be summarised whereas Purchase Invoice Lines might be left as detailed.
Points To Be Aware Of:
- Summarisation will lose the itemised detail of the invoice lines eg: Item Codes, Descriptions, Qty's and Ext pricing
- Sales and Purchase Invoices will always posted immediately to the Accounting Software based on your posting frequency set in the System Master. These transactions are NOT posted based on the System Settings Daily Summary rules. ie: the posting will always occur "Today" not the following day.
- You should be mindful the Accounting Software you are integrating to is not making use of other software or features that may require all invoice line details to show. eg: third party pay now software used for end customers to download their invoice from the Accounting Software to pay.
- This enhancement is only available to sites integrating with MYOB AR Live / QBO, Xero and Sage Evolution
Implementation Of This Enhancement:
- Tonight (24/11/21) we will be deploying Minor Updates for both Update 238 and Update 242 that will include this logic if this new feature is to be turned on.
- To turn this feature on......
- Create two new User Defined Constants (File -> Customisation Configuration -> User Defined Constants) exactly as follows ensuring they are specified as a "Yes/No" Constant Type:
- Summarise Purchase Invoice Lines
- Summarise Sales Invoice Lines
- Ensure both Constants are set to either True (to turn this feature on) or False (to turn it off). Ostendo will process these transactions in their detailed form if no Constant exists.
|
|
|
Ian
Comments