GL Journal - Post to Reservation or Commitment?

[Chuck Boecking]

Hi Everyone,

As the code is written, you cannot use a GL Journal to post an entry of type Commitment or Reservation. You get an Account is Document Controlled error event if the account is not document controlled. Can someone confirm this is the desired behavior?

I have not used Reservation or Commitment enough to know whether creating a manual journal against a Commitment or Reservation is allowed.  It makes sense to me that it would not be allowed since these values are governed by the system. My biggest concern would be if the system made an error, you would have no way to fix it.

Here is the code. The formatting suggests that the second parenthesis after POSTINGTYPE_Actual should not be there.

// Michael Judd (mjudd) BUG: [ 2678088 ] Allow posting to system accounts for non-actual postings

if (line.isDocControlled() && 

( getPostingType().equals(POSTINGTYPE_Actual)) ||

 getPostingType().equals(POSTINGTYPE_Commitment) ||

 getPostingType().equals(POSTINGTYPE_Reservation)

)

{

if it were actually like this, it would make sense that you cannot post to Actual, Commitment, or Reservation if the account is document controlled, but but you could if the posting were of type Budget.

// Michael Judd (mjudd) BUG: [ 2678088 ] Allow posting to system accounts for non-actual postings

if (line.isDocControlled() && 

( getPostingType().equals(POSTINGTYPE_Actual) ||

 getPostingType().equals(POSTINGTYPE_Commitment) ||

 getPostingType().equals(POSTINGTYPE_Reservation)

)

)

{

Please share your thoughts. Thank you for your consideration! 

Regards,

Chuck Boecking

www.chuckboecking.com

[Carlos Antonio Ruiz Gomez]

Good catch Chuck, that's definitely a bug, please open a JIRA ticket and attach your patch

Regards,

Carlos Ruiz

[Louis Charbonneau]

In certain organizations like municipalities, where no annual deficit is allowed, it is important that every department stays within his budget.

Before issuing a Purchase Requisition, the department manager (and/or the system) would check the amount of budget left.

As a controller, i have to make sure no single department exceeds his budget. So at the beginning of the year , i would set aside a chunk of the annual budget

of a department. that i would release toward the end of the year. So when the controller get the over budget signal it is not to late.

To do that, the GL Journal entry of posting type Reservation and/or Commitment is very convenient.

This is one example, there are others, like reserving an amount of the budget for a specific project, until we are in a position of issuing the actual Purchase Requisition or Purchase Order.

[armenrz]

Hi Chuck,

I would normally use Product Expense account in GL Journal for Budget Posting. This is a document controlled account.

If you activate Commitment Type in Acct Schema to Reservation, it will work this way:

When you complete a PR, it will post to Product Expense in Reservation Posting.
After you complete a PO, it post to Commitment Posting and the reservation posting is reversed.
After you complete a AP, it post to actual posting and the commitment posting is reversed.

Initially in Compiere, it is called Encumbrance accounting. The rule is Budget cannot exceed Actual + Commitment + Reservation.

Best regards,

Armen Rizal
Goodwill.co.id

[Chuck Boecking]

Team,

Ticket with patch here.

Commit to release2.1 here.

Thanks Carlos for the quick review and commit.

Thanks to all for your comments.

Regards,

Chuck Boecking

www.chuckboecking.com

[idempuser]

Hi,armenrz

I have followed your procedure in idempiere, gettting budget related value in idempiere,but the problem is that, commitment value not set to zero after the invoice posting, that;s why the budget available value showing wrong amount in the report