Public Profile
  • Recognize CC, POC project revenue in the contract currency

    You know what I am talking about. The "estimated" revenue is always posted in the local accounting currency.

    - If a "Percentage of Completion" or a "Completed Contract" fixed fee project has 2 milestones where the second milestone is billed at the end upon the project acceptance,

    - and the Project contract currency <> Accounting currency,

    - and the project duration is more than one month (or whatever frequency is chosen to import exchange rates),

    ...then the revenue and the billing amount are never going to match, neither the Billed WIP and Recognized WIP balance accounts.

  • Implement (EU) VAT directives on PSA project invoices

    The PSA project invoices (the 2 versions - the PSA Project invoice and the Contract project invoice) do not support the European tax directions texts (those shown on the sales order invoice) such as

    "EC directive blah-blah-blah, subject to reverse charge" or "Tax exempt, 3rd country delivery" etc.

    This is because the data provider PSAProjInvoiceDP only fill the projInvoiceLocalizationTmp table for a few Eastern European countries, but not the Western European ones.

  • Electronic Reporting: implement functions DIV and MOD

    In the GER, please implement embedded functions

    DIV(real _operand, int _divisor) for integer division with truncation and

    MOD(real _operand, int _moduloBy) for the modulo division.

    In addition, please implement a scope attribute in the Counter element to have multiple counters running in parallel and for example be able to assign the same counter in the same record at 2 places.

    My blog http://erconsult.eu/blog/electronic-reporting-er-cookbook/ documents my struggles with this regards.