24/11/2021 - Summarisation of Sales and Purchase Lines

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.

    • Related Articles

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

    • What options are available for creating Purchase Order Lines?

      If you go into Purchasing>Purchase Orders and click on the 'Lines' tab you can enter lines in both Batch or single entry modes as follows: - Selecting from a user-defined List - Selecting Items in batch - Selecting Descriptors in batch - Selecting ...

    • How do you setup Purchase Foreign Currency in Ostendo?

      The attached article details how to setup Foreign Currency for purchasing within Ostendo.

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