Wednesday, June 15, 2016

No Ledger and Never Ledger

No Ledger

The hours journal when posted with a Line Property = Chargeable, will NOT post in GL. The transaction cost will hit the GL only when the transaction will be invoiced / billed (project invoice posting). The project invoice and the cost will be posted to GL on the same voucher.



'Post Cost' routine can also be used to post the cost to GL and then the transaction can be invoiced later. However the cost (which will be posted to GL using the 'Post Cost' routine) will post on a separate voucher than the voucher posted for project invoice.



Never Ledger

Cost will NEVER be posted to GL. Not after the posting of transaction and not after the project invoice. 'Post Cost' routine will also not post the transaction for the project where the cost are set for 'Never Ledger'. However system will simulate the posting behavior in the background for 'Never Ledger' and will complain if the period is closed.

Thanks
Sarang


Pay when Paid : Observations


1. Standard PwP only woks for Project PO's. PO can be invoiced out of project ONLY after it is invoiced. By this i mean, if the PO cost value is 100 and sale value is 150, then unless and until PO is invoiced, user will not be able to raise the project invoice for the sale amount of PO .i.e. 150.

2. After the customer payment and vendor payment in posted in full, the lines (data in PwP screen) still stays in the PwP screen with settled amount displayed in the vendor and customer section.

3. If you reverse the customer payment (i.e. remove the link between the customer invoice and customer payment from 'Closed transactions editing') then on the PwP screen, the 'Payment due' field in the 'Customer invoice' section again starts displaying the amount. But this DOES NOT affect the supplier side, as supplier side payment is already paid. By this i mean, the 'Supplier invoice' and 'Supplier invoice lines' section still displays that the 'Settled amount' is full amount and the 'Ready for payment' in the 'Supplier invoice lines' section displays 'Yes'.

4. If you now reverse the vendor payment also  (i.e. remove the link between the vendor invoice and vendor payment from 'Closed transactions editing') then on the PwP screen, the 'Settled amount' field in the 'Supplier invoice' again starts displaying the 0 (ZERO) amount. But this DOES NOT affect the 'Supplier invoice lines' section. By this i mean, that the 'Ready for payment' is still set to 'Yes' and if the supplier payment journal is created for that supplier, the 'Amount to settle' field in 'Functions > Settlement' for that invoice, displays the entire amount. This actually is a bug.

5. So the whole scenario is that the customer payment and vendor payment against the respective invoices are removed (reversed) and the invoices are again open. However the PwP amount released automatically as a result of customer payment initially, still remains as released and the supplier payment journal can be posted against it, even if the customer invoice is not settled (as a result of reversing the payment).

6. Pay when paid screen will behave exactly same for the 'Negative' invoice (Credit Note), the way it behaves for the 'Positive' invoice. PwP respects the credit note in exactly similar fashion as invoice. This will mean the unless and until the customer credit note is settled, the system will NOT release the supplier credit note for settlement. This is bit strange, but this is how it behaves.

7. Customer invoice can be settled either by customer payment or credit note. PwP will release the supplier invoice line for payment, if the customer invoice line is settled by payment or by credit note. However if the credit note is created by 'Functions - Select for credit note' then the settlement of that credit note against the invoice will NOT release the supplier invoice line for payment. This is a bug which might have been resolved in the recent versions.

8. Supplier invoice and the Customer invoice will be displayed in the transnational currency in the standard pay-when-paid form. For .e.g. if the base currency / company currency is USD, then there are 4 scenarios possible.

  • If the Supplier invoice is in USD and Customer invoice is in USD, then the PwP form will display the values in USD for both the supplier invoice and customer invoice.
  • If the Supplier invoice is in USD and Customer invoice is in GBP, then the PwP form will display the values in USD for the supplier invoice and will display the values in GBP for customer invoice.
  • If the Supplier invoice is in GBP and Customer invoice is in GBP, then the PwP form will display the values in GBP for both the supplier invoice and customer invoice.
  • If the Supplier invoice is in GBP and Customer invoice is in USD, then the PwP form will display the values in GBP for the supplier invoice and will display the values in USD for customer invoice.


More points to be added as and when spotted.

Thanks
Sarang