14 Nov

Assignment rule (Versino Financial Suite)

Versino Financial Suite

One Assignment rule (Versino Financial Suite) is a rule in account statement processing that automatically assigns lines from an account statement design to a business partner, invoice, or external code after importing them. The corresponding module is under development and not yet available to customers. The details follow the development status.

Context

The rules run across the lines of the design. There are four types:

  • Evidence from the purpose of use: A search pattern extracts proof numbers or customer references from the text and searches them among the open incoming and outgoing invoices. If all matches belong to a business partner, the Partner and Proofs row is generated.
  • Business partner via bank account: The counterpart’s IBAN (otherwise bank code and account number) is compared with the business partner’s bank accounts. There must be exactly one match.
  • Business partner via pattern: A search pattern finds a partner code or part of the partner name in the text.
  • Encrypting external code: From the bank code, a new external code is generated, depending on the direction, reference, and bank connection of the other party. Business One derives the booking method and account from this.

An example illustrates the encoding: The bank provides code 833 with the purpose of „ADS VON“. “. The rule makes this the assignment to the partner’s settlement account.

Two safeguards limit the effect. A line that already has a business partner remains unaffected. In the event of ambiguity, the rule does not apply. Furthermore, the module records a protocol entry for each rule action, for example, „Line 3: Business partner … assigned by rule …“.

The search pattern must fit the length of the serial numbers. A pattern for four-digit to six-digit numbers does not produce an eight-digit number.

Acquisition

The rules of the current bank import add-on can be adopted for each client. Rules using free SQL, on the other hand, must be manually recreated.


 

Versino Financial Suite Webinars.

Experience liquidity planning in SAP Business One live: The webinars on the new Versino Financial Suite

Predictability in unpredictable times: Every management team wants reliable liquidity planning. There is agreement on this. That’s the ideal world. The difficult part...
Financial chat for SAP Business One: How he answers questions about numbers and when he prefers not to answer

Financial chat for SAP Business One: How he answers questions about numbers and when he prefers not to answer

Anyone who does not book in SAP Business One on a daily basis often faces closed doors when it comes to questions regarding the financial system...
Versino Financial Suite Major Release: End of the SAP window cage

Versino Financial Suite Major Release: End of the SAP window cage

Anyone who has two monitors on their desk also uses them. That goes without saying. In the SAP Business...
Account statement processing in SAP Business One: The account statements flow from an input basket via a sorting line to a draft that the accounting department checks with an orange check mark.

Account statement processing: What the Versino Financial Suite will offer in the future — a preview of accounting

An account statement is quickly read. That is the manageable part of the work. The work lies behind that. The statement must be sent to the...
E-invoice check

E-Invoice check by Versino Financial Suite

An e-invoice is quickly generated. SAP Business One includes the XRechnung feature as standard, and those who use cks.eINVOICE or the ...
Cash flow forecasting SAP B1

Cash flow planning in SAP Business One: What the Versino Financial Suite does differently

Cash flow planning is considered a done deal in many medium-sized companies. After all, there are bank statements, there are open items, ...
SAP Business One Netting and Accounts Payable

Netting in SAP Business One: What makes the Versino Financial Suite different

When a business partner is both a customer and a supplier, that sounds like a comfortable situation. You know each other, you trust...
Susa-in-the-Versino-Financial-Suite

Trial Balance in SAP Business One: What the Versino Financial Suite does differently – and why tax advisors notice

The Trial Balance is one of the oldest reports in accounting. Every accounting program has it, and SAP Business One itself...
Wird geladen …