I want to modify my field

(I gave it its subject back, though it's not very descriptive; it should be "Recreating Quickbooks" -)

Yes, I'm still alive. Somewhat. I've been creating an "eBase" type solution for a non-profit. Not really tricky, but lots of files.

I think you can do what you want. I saw, without getting into gruesome detail, that you had some extra fields in your Nominal Ledger, which you were trying to make work. That's more or less the method.

The trick you missed was to include the "plain" number field in the calculation. Here are the players:

Net

Gross

VAT

Also, normally:

_cNet = Gross - VAT

_cGross = Net + VAT

_cVAT = Gross - Net

For any given transaction, 2 of the numbers will be plain, and one is calculated.

Each file that feeds into this central file will have its own pattern for data entry, which must be enforced, because entering data in all 3 could leave 1 wrong. So the 3rd number is always only a calculation field, different fields in the portal for different files. No record in Nominal Ledger will have conflicting patterns on any given record.

Change the calculations to:

_cNet = Case ( not IsEmpty(Net), Net,

not IsEmpty(Gross) and not IsEmpty(VAT), Gross - VAT,

"")

_cVAT = Case( not IsEmpty(VAT), VAT,

not IsEmpty(Gross) and not IsEmpty(Net), Gross - Net,

"")

_cGross = Case( not IsEmpty(Gross), Gross,

not IsEmpty(Net) and not IsEmpty(VAT), Net + VAT,

"")