Summarisation Of Sales and Purchases Invoice Lines

Summarisation Of Sales and Purchases Invoice Lines

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:

  • Both Update 238 and Update 242 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.

    • Related Articles

    • 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 ...

    • How Do I Invoice A Customer Deposit?

      Occasionally a customer will require an Invoice in order to pay a Deposit for goods on a Sales Order. This process will work for Counter / Delivery Sales Orders and could also be utilised in a similar manner for Jobs. It is suggested as an ...

    • Can I use an Orderpad to generate Order Lines?

      Within Ostendo you can create multiple Order Pad ‘Lists’. Each List can be Customer specific or used for all Customers. Within the List you can define multiple Items. Each Item can also be added multiple times to segregate the Items Variants (such as ...

    • Default Reversal Date for Sales Delivery Picks

      This User Defined Constant modifies the behaviour when Picked Sales Delivery Lines are deleted. By default, Ostendo will date the reversing transaction with the same date as the original pick record. If this constant is used, the reversing ...

    • Default Reversal Date for Sales Delivery Picks

      This User Defined Constant modifies the behaviour when Picked Sales Delivery Lines are deleted. By default, Ostendo will date the reversing transaction with the same date as the original pick record. If this constant is used, the reversing ...