Sep 17, 2007

Gross up, out of the box

This article describes the configuration steps for the grossup or gross to net functionality. The seeded fast formulas are used, but you could implement your own variations on them.

1. define an element type.

  • In the Advance tab, set Gross up (which activates the iterative flag and the process seperate)
  • define input values, based on the inputs of the seeded fast formula default_grossup.
    • Pay Value
    • Amount
    • Additional amount
    • Low gross
    • High gross
    • Remainder
    • To within
    • Method (defaulted to interpolation)
    • Grossup balance
  • map the input values to the inputs of the fast formula (which is in this case a 1-1) via the iterative rules button.

  • (optional) exclude grossup balances, via the exclude balances button. Only those balances that are defined as grossup show up in the list to be excluded.
2. Link the seeded fast formula calc_grossup_pay_value to the element type created above. The output of that fast formula (payment_amount) must be linked directly to the pay value.

3. Define an element link, and happy testing.

Yes you can change the names of the input values, since a mapping is foreseen by the payroll engine, and also the fast formulas can be used as a template for your custom solution, although i would not advise that.

Grossup only works from an element entry, so you can not activate it from an indirect run result.

result name

type

input value

severity

ADDITIONAL_AMOUNT

Adjust

Additional amount

.

CHANGER

Adjust

Changer

.

GROSSUP_BALANCE

Adjust

Grossup balance

.

HIGH_GROSS

Adjust

High gross

.

LOW_GROSS

Adjust

Low gross

.

MESG

Message

_

Information

REMAINDER

Adjust

Remainder

.

STOPPER

Stop

_

.

Sep 5, 2007

BEE Spreadsheet Interface

We wanted to load BEE batch element lines via Excel. And we remembered somehow it was described as new standard functionality a few family packs ago.

So just search metalink and there we go. At least, that was the plan. Metalink came with a lot of results, pointing to web ADI, error messages and how to work around them, but a simple doc that describes how to activate the functionality was not found.

I guess Google set the search standards too high.

But ok, a new try the next day on some slightly different keywords, and all of a sudden "BEE Spreadsheet Interface" docs showed up within the top 40 list. So that was the magic search string.

And from that moment on we found some docs, and one hour later a first xls (sorry spreadsheet) was loaded.

Before you ask it: note 341427.1 did the trick.