Re: Financial transaction - accounting transactions

[Paul Foxworthy]

Hi Ingo,

It's conventional to record a deposit to a bank account as a debit.

Have a look at
https://courses.lumenlearning.com/boundless-accounting/chapter/the-basics-of-accounting/
especially the "Perspective" section halfway down.

Debits and credits can be counter-intuitive. For an income or expense
account, they do what you'd expect: e.g. new income is a credit to an
income account. Assets and liabilities are different - an increase in an
asset is a *debit*. One think to think about this is that from the
perspective of the bank, your deposit is a liability - they owe you the
money and you may ask for it back in future. If they ever take out a bank
fee, the transaction would have a credit to the bank account (an asset) and
a debit to your bank fees account (an expense).

Cheers

Paul Foxworthy


On 21 March 2018 at 21:33, Ingo Wolfmayr  wrote:

> Hi,
>
> I have a question regarding financial transaction, in detail the service
> "postFinAccountTransToGl".
>
> When I create a "deposit" or a "withdraw" it creates the same accounting
> transactions except changing the type of accounting transaction.
>
> Maybe I missunderstand the financial transactions. This is what I am
> trying to do:
> A customer made a payment 100$. The bank subtracts a fee from my account
> 5$. I thought by making a transaction "withdraw" I could submit the fee to
> the appropriate glaccount and subtracting it from the financial account
> (2nd part is fine).
> Goal:
> Debit: 5$ Fees
> Credit: 5$ Bank
>
> Current situation:
> Credit: 5$ Fees
> Debit: 5$ Bank
>
> Creating a deposit creates the same financial transactions.
>
> When I create an adjustment with a negativ amount, the glaccounts are on
> the right side, but the value is negativ, which at the end leads to the
> same result.
>
> I would be glad if someone could help me on this.
>
> Best regards,
> Ingo
>



-- 
Coherent Software Australia Pty Ltd
PO Box 2773
Cheltenham Vic 3192
Australia

Phone: +61 3 9585 6788
Web: http://www.coherentsoftware.com.au/
Email: i...@coherentsoftware.com.au

Manufacturing/Reverse Assembly and Inventory Item Ids

[james]

When issuing goods out due to the manufacturing process is there a way
to know in advance which inventory item ID the manufacturing process
will issue the components out of?  This information would be helpful for
a picker to go the the right location sequence ID/bin to grab the right
product if located in multiple locations.  When the manufacturing
process is complete is there a way to indicate where you want the finish
good to reside as far as the location sequence ID.

On the opposite side as far as reverse assembly is concerned...is there
a way to indicate which location you want to grab a product to reverse
assemble.  Is there a way to indicate the products generated from that
process where they reside?

Thanks,

James






 Original Message 
Subject: RE: Odd or is this a Bug?
From: 
Date: Thu, March 15, 2018 1:26 pm
To: user@ofbiz.apache.org

Is this how the system is suppose to perform or are we doing something
wrong

 Original Message 
Subject: Odd or is this a Bug?
From: 
Date: Mon, March 12, 2018 7:18 pm
To: user@ofbiz.apache.org

So I was exploring credit agreements tonight and noticed something
pretty odd:

1. If a customer exceeds their credit limit the system does not prevent
orders or give an alert. The system only stops an invoice from being
created at the completion of packing (product is picked and almost out
the door)
2. If you don't have a credit limit agreement created then a customer
can place as many buy as many products as he wants from you. Seems odd
that for credit limits to truly work ...every customer has to have an
agreement of $0 credit limit. This seems odd. It should be that all
customers by default have a $0 credit and the system prevents orders
from going out the door. Is this a bug or am I crazy?

Thanks,

James

RE: Financials ->Month End Close Procedures

[james]

Too Late :)
Already bought your book Sharon.  Can't go wrong with more information. 
Thanks for the details below!  Especially reopening of closed periods.  

 Original Message 
Subject: Re: Financials ->Month End Close Procedures
From: Sharan Foga 
Date: Wed, March 21, 2018 1:46 am
To: 

Hi James

You don’t need to buy my book, to find out about this. :-) 

I’ve gone through the main process below with some links to the
screens in our demo.
So the main things you need are:

Time Periods
https://demo-stable.ofbiz.apache.org/accounting/control/TimePeriods?organizationPartyId=Company

To make sure that your time periods (monthly ones are setup). The last
time I checked OFBiz still needed the periods to be setup a bit like
this

Start Date 1 January 20XX End Date 1 February 20XX because the
comparison for whether a transaction is within the range is a less than
comparison. So setting the period end date to 31st January 20XX will
miss the transactions for the 31st January. 

Make sure the period is active

GL Account Type Defaults Account Mapping
https://demo-stable.ofbiz.apache.org/accounting/control/GlAccountAssignment?organizationPartyId=Company

You need a mapping to make sure that:
- ‘Profit Loss ‘ GL account type is mapped to your account for
Net Income 
- 'Retained Earnings' GL account type is mapped to your account for
Retained Earnings

Month End Closing
https://demo-stable.ofbiz.apache.org/accounting/control/TimePeriods?organizationPartyId=Company

To close the month simply close the time period and Period closing
accounting transaction should automatically be created and posted (Do
this in the company settings not at the global GL accounts level)

Period Closing Accounting Transaction
To find the Period Closing Transaction, go to 

https://demo-stable.ofbiz.apache.org/accounting/control/FindAcctgTrans 

Re-opening a Closed Period
You used to be able to do this via the Edit Custom Time Period screen
https://localhost:8443/accounting/control/updateCustomTimePeriod 

but that is no longer the case. 

The workaround is to edit Time Period entity record to make it active.
There is a flag that indicates whether the period is active or not
– just change it.
https://demo-stable.ofbiz.apache.org/webtools/control/FindGeneric?entityName=CustomTimePeriod

- Reverse the accounting transaction for the original period closing.
(Just go into the original accounting transaction and use the Revert
option)
- Do your accounting adjustments 
- Close the period again

I think that having the ability to re-open a closed Time Period is a
something that is quite useful so would probably suggest that we look at
re-implementing something that does this.

I hope this helps and if anyone else has other ideas or suggestions then
please feel free to add your feedback.

Thanks
Sharan
On 2018/03/20 13:17:56,  wrote: 
> 
> Can someone point me in the right direction for Month End Close
> Accounting Procedures in Ofbiz. As well how to re-open a closed period?
> 
> Thanks,
> 
> James
>

RE: OFBiz and Camel integration updated

[james]

Is there a list of the end points?
 Original Message 
Subject: OFBiz and Camel integration updated
From: Bilgin Ibryam 
Date: Wed, March 21, 2018 3:06 am
To: user@ofbiz.apache.org

hi all,

a quick heads up. I've been getting requests to fix the ofbiz-camel
integration demo and finally did it.
It works with the latest version of OFBiz and Camel
Also added a nice diagram demonstrating how the integration works.

https://github.com/bibryam/ofbiz-camel

Cheers,

-- 
Bilgin Ibryam
ASF Member | Architect at Red Hat
http://ofbizian.com | @bibryam

Kubernetes Patterns http://leanpub.com/k8spatterns (in progress)
Camel Design Patterns https://leanpub.com/camel-design-patterns

Re: Outgoing payment to financial account?

[Sharan Foga]

Hi Ingo

Is there a reason why you need to use a financial account for this? Or will a 
billing account do? (Because at first glance it sounds like billing account 
might be able to do this easier than a financial account.)

Thanks
Sharan

On 2018/03/21 15:25:26, Ingo Wolfmayr  wrote: 
> Hi,
> 
> is it possible to have a "customer return invoice" with an outgoing payment 
> to the financial account as a customer credit. I have the following case:
> 
> - Invoice 1000€
> - Incoming Payment 1000€
> 
> - Return Invoice 1000€
> - Outgoing Payment 200 €
> - 800 € should stay as credit as a new invoice for the customer has been 
> created with 800€ to be paid.
> 
> The return invoice cannot be closed until the outgoing payment matches the 
> invoice amount - same with the 2nd invoice.
> 
> Thanks for any hint!
> 
> Best regards,
> Ingo
> 
> 
> 

Re: Financial transaction - accounting transactions

[Sharan Foga]

Hi Ingo

So you've setup a financial account to mirror you bank account and when the 
customer payment comes in, it already has the fees taken out? Or does the whole 
customer amount come into the account as one figure and then the bank takes out 
their fee? 

Also are you manually depositing (i.e creating deposits) for customer payments 
or are you letting OFBiz automatically do it when the customer pays?

Either way - I'll take a look and get back to you.

Thanks
Sharan

On 2018/03/21 10:33:30, Ingo Wolfmayr  wrote: 
> Hi,
> 
> I have a question regarding financial transaction, in detail the service 
> "postFinAccountTransToGl".
> 
> When I create a "deposit" or a "withdraw" it creates the same accounting 
> transactions except changing the type of accounting transaction.
> 
> Maybe I missunderstand the financial transactions. This is what I am trying 
> to do:
> A customer made a payment 100$. The bank subtracts a fee from my account 5$. 
> I thought by making a transaction "withdraw" I could submit the fee to the 
> appropriate glaccount and subtracting it from the financial account (2nd part 
> is fine).
> Goal:
> Debit: 5$ Fees
> Credit: 5$ Bank
> 
> Current situation:
> Credit: 5$ Fees
> Debit: 5$ Bank
> 
> Creating a deposit creates the same financial transactions.
> 
> When I create an adjustment with a negativ amount, the glaccounts are on the 
> right side, but the value is negativ, which at the end leads to the same 
> result.
> 
> I would be glad if someone could help me on this.
> 
> Best regards,
> Ingo
> 

Re: Financials ->Month End Close Procedures

[Michael Brohl]

Thought exactly the same 😀

Regards,
Michael



> Am 21.03.2018 um 10:27 schrieb Taher Alkhateeb :
> 
> Valuable info! seems like a glaring "must-go-to-the-manual" thing
> 
>> On Wed, Mar 21, 2018 at 11:46 AM, Sharan Foga  wrote:
>> Hi James
>> 
>> You don’t need to buy my book, to find out about this. :-)
>> 
>> I’ve gone through the main process below with some links to the screens in 
>> our demo.
>> So the main things you need are:
>> 
>> Time Periods
>> https://demo-stable.ofbiz.apache.org/accounting/control/TimePeriods?organizationPartyId=Company
>> 
>> To make sure that your time periods (monthly ones are setup). The last time 
>> I checked OFBiz still needed the periods to be setup a bit like this
>> 
>> Start Date 1 January 20XX End Date 1 February 20XX because the comparison 
>> for whether a transaction is within the range is a less than comparison. So 
>> setting the period end date to 31st January 20XX will miss the transactions 
>> for the 31st January.
>> 
>> Make sure the period is active
>> 
>> GL Account Type Defaults Account Mapping
>> https://demo-stable.ofbiz.apache.org/accounting/control/GlAccountAssignment?organizationPartyId=Company
>> 
>> You need a mapping to make sure that:
>> - ‘Profit Loss ‘ GL account type is mapped to your account for Net Income
>> - 'Retained Earnings' GL account type is mapped to your account for Retained 
>> Earnings
>> 
>> Month End Closing
>> https://demo-stable.ofbiz.apache.org/accounting/control/TimePeriods?organizationPartyId=Company
>> 
>> To close the month simply close the time period and Period closing 
>> accounting transaction should automatically be created and posted  (Do this 
>> in the company settings not at the global GL accounts level)
>> 
>> Period Closing Accounting Transaction
>> To find the Period Closing Transaction, go to
>> 
>> https://demo-stable.ofbiz.apache.org/accounting/control/FindAcctgTrans
>> 
>> Re-opening a Closed Period
>> You used to be able to do this via the Edit Custom Time Period screen
>> https://localhost:8443/accounting/control/updateCustomTimePeriod
>> 
>> but that is no longer the case.
>> 
>> The workaround is to edit Time Period entity record to make it active. There 
>> is a flag that indicates whether the period is active or not – just change 
>> it.
>> https://demo-stable.ofbiz.apache.org/webtools/control/FindGeneric?entityName=CustomTimePeriod
>> 
>> - Reverse the accounting transaction for the original period closing. (Just 
>> go into the original accounting transaction and use the Revert option)
>> - Do your accounting adjustments
>> - Close the period again
>> 
>> I think that having the ability to re-open a closed Time Period is a 
>> something that is quite useful so would probably suggest that we look at 
>> re-implementing something  that does this.
>> 
>> I hope this helps and if anyone else has other ideas or suggestions then 
>> please feel free to add your feedback.
>> 
>> Thanks
>> Sharan
>>> On 2018/03/20 13:17:56,  wrote:
>>> 
>>> Can someone point me in the right direction for Month End Close
>>> Accounting Procedures in Ofbiz.  As well how to re-open a closed period?
>>> 
>>> Thanks,
>>> 
>>> James
>>> 

Re: [DOC] Documentation Mentors

[Sharan Foga]

Hi Badar

I've spoken to Swapnil (Mane since we have more than one!:-) and he is willing 
to help you and be your mentor. 

Thanks
Sharan

On 2018/03/14 20:24:25, Badar Ali  wrote: 
> Dear Sharan,
> 
> Hoping your good. I am unable to add my status as "Writer" in front of my 
> name column in Doc. team list. I am getting this notification, "
> 
> Access to add and change pages is restricted. See: 
> https://cwiki.apache.org/confluence/display/OFBIZ/Wiki+access
> Wiki access - OFBiz Project Open Wiki - Apache Software 
> ...
> cwiki.apache.org
> Due to spam, the infrastructure team has restricted the access to all ASF 
> Confluence open wikis (Confluence is shared by all ASF projects). If you want 
> to add or edit ...
> 
> ". Sorry it's my first time so don't know how things work. I also want a 
> Mentor.
> 
> 
> Regards,
> 
> Badar Ali.
> 
> 
> 
> From: Sharan Foga 
> Sent: Monday, March 12, 2018 8:27 PM
> To: user@ofbiz.apache.org
> Subject: [DOC] Documentation Mentors
> 
> Hi All
> 
> One of the things we want to introduce for the documentation work is ensuring 
> that we have some experienced OFBiz people working with people that are new 
> or less experienced.
> 
> Being a Mentor
> =
> At the moment Michael and myself have indicated that we are available to be 
> documentation mentors. The main role will be to :
> 
> - help the documentation contributor you are mentoring get started
> - provide general background OFBiz help and support
> 
> The objective is to give  the newer people more confidence so they can pick 
> up and work on any of the documentation tasks.
> 
> I can see in our team list that there are a few other experienced OFBiz 
> people :-) , so if you are willing to help out someone new then please add a 
> Yes to the ‘Willing to be a Mentor” column.
> 
> Finding a Mentor
> ==
> Those of you who would like a mentor then please edit the Documentation Team 
> wiki page and put ‘Need a Mentor’ in the Mentor column next to your name. 
> We will then try and allocate someone to you.
> 
> I know that not everyone will want or need a mentor, but it's good o have the 
> option.
> 
> Thanks
> Sharan
> 
> 

Re: OFBiz and Camel integration updated

[Michael Brohl]

+1
Regards,
Michael


> Am 21.03.2018 um 17:16 schrieb Taher Alkhateeb :
> 
> Super awesome Bilgin,
> 
> Maybe we should consider moving this work to plugins given how useful this
> feature could be? The license is compatible and the work joins two great
> apache projects.
> 
>> On Wed, Mar 21, 2018, 1:06 PM Bilgin Ibryam  wrote:
>> 
>> hi all,
>> 
>> a quick heads up. I've been getting requests to fix the ofbiz-camel
>> integration demo and finally did it.
>> It works with the latest version of OFBiz and Camel
>> Also added a nice diagram demonstrating how the integration works.
>> 
>> https://github.com/bibryam/ofbiz-camel
>> 
>> Cheers,
>> 
>> --
>> Bilgin Ibryam
>> ASF Member | Architect at Red Hat
>> http://ofbizian.com | @bibryam
>> 
>> Kubernetes Patterns http://leanpub.com/k8spatterns (in progress)
>> Camel Design Patterns https://leanpub.com/camel-design-patterns
>> 

Re: OFBiz and Camel integration updated

[Taher Alkhateeb]

Super awesome Bilgin,

Maybe we should consider moving this work to plugins given how useful this
feature could be? The license is compatible and the work joins two great
apache projects.

On Wed, Mar 21, 2018, 1:06 PM Bilgin Ibryam  wrote:

> hi all,
>
> a quick heads up. I've been getting requests to fix the ofbiz-camel
> integration demo and finally did it.
> It works with the latest version of OFBiz and Camel
> Also added a nice diagram demonstrating how the integration works.
>
> https://github.com/bibryam/ofbiz-camel
>
> Cheers,
>
> --
> Bilgin Ibryam
> ASF Member | Architect at Red Hat
> http://ofbizian.com | @bibryam
>
> Kubernetes Patterns http://leanpub.com/k8spatterns (in progress)
> Camel Design Patterns https://leanpub.com/camel-design-patterns
>

Outgoing payment to financial account?

[Ingo Wolfmayr]

Hi,

is it possible to have a "customer return invoice" with an outgoing payment to 
the financial account as a customer credit. I have the following case:

- Invoice 1000€
- Incoming Payment 1000€

- Return Invoice 1000€
- Outgoing Payment 200 €
- 800 € should stay as credit as a new invoice for the customer has been 
created with 800€ to be paid.

The return invoice cannot be closed until the outgoing payment matches the 
invoice amount - same with the 2nd invoice.

Thanks for any hint!

Best regards,
Ingo

Re: OFBiz and Camel integration updated

[Jacques Le Roux]

Le 21/03/2018 à 14:53, Bilgin Ibryam a écrit :

On Wed, Mar 21, 2018 at 10:39 AM, Jacques Le Roux
 wrote:

Looks quite good, thanks Bilgin !

"Licensed under The MIT License." why not ASL2 :) ?

no specific reasons, but more copy paste from other projects of mine.
btw what is the difference and does it matter really? I'm curious?
B.

MIT is more permissive, it fits if you don't care to protect your work at all and is 
easier for "users" (developers who use the code) to work with
But actually there are not much differences:
https://www.quora.com/Whats-the-difference-between-Apache-v2-0-and-MIT-license-What-are-the-major-consequences-of-using-Apache-software-over-MIT
I asked because you are an ASF member, so thought that you would prefer ASL2. 
But of course that's up to you, and depends on cases. Seems to fit here.

Jacques





Jacques



Le 21/03/2018 à 11:06, Bilgin Ibryam a écrit :

hi all,

a quick heads up. I've been getting requests to fix the ofbiz-camel
integration demo and finally did it.
It works with the latest version of OFBiz and Camel
Also added a nice diagram demonstrating how the integration works.

https://github.com/bibryam/ofbiz-camel

Cheers,

Re: OFBiz and Camel integration updated

[Bilgin Ibryam]

On Wed, Mar 21, 2018 at 10:39 AM, Jacques Le Roux
 wrote:
> Looks quite good, thanks Bilgin !
>
> "Licensed under The MIT License." why not ASL2 :) ?

no specific reasons, but more copy paste from other projects of mine.
btw what is the difference and does it matter really? I'm curious?
B.

>
> Jacques
>
>
>
> Le 21/03/2018 à 11:06, Bilgin Ibryam a écrit :
>>
>> hi all,
>>
>> a quick heads up. I've been getting requests to fix the ofbiz-camel
>> integration demo and finally did it.
>> It works with the latest version of OFBiz and Camel
>> Also added a nice diagram demonstrating how the integration works.
>>
>> https://github.com/bibryam/ofbiz-camel
>>
>> Cheers,
>>
>



-- 
Bilgin Ibryam
ASF Member | Architect at Red Hat
http://ofbizian.com | @bibryam

Kubernetes Patterns http://leanpub.com/k8spatterns (in progress)
Camel Design Patterns https://leanpub.com/camel-design-patterns

Re: How to Configure Ofbiz SSL

[Jacques Le Roux]

Short answer: preferably look at letsencrypt for a free certificate (must be 
renewed every 3 months but there are tools for that)

For instance for the trunk demo we use

  ## SSL directives
  SSLEngine on
  SSLCertificateFile "/etc/letsencrypt/live/ofbiz-vm2.apache.org/cert.pem"
  SSLCertificateKeyFile "/etc/letsencrypt/live/ofbiz-vm2.apache.org/privkey.pem"
  SSLCertificateChainFile "/etc/letsencrypt/live/ofbiz-vm2.apache.org/chain.pem"
  SSLCACertificatePath    "/etc/ssl/certs"

  ## Custom fragment
  ProxyRequests Off
  ProxyPreserveHost On
  # do not proxy letsencrypt cert renewal requests
  ProxyPass /.well-known !
  ProxyPass / ajp://localhost:8009/

I let you figure the rest out

We should really update the Apache+OFBiz+Technical+Production+Setup+Guide

HTH

Jacques


Le 21/03/2018 à 12:09, Schumann Ye a écrit :

Dear Gurus,

Can anyone be so kind to show me how to configure ofbiz ssl for a test 
deployment (on a given domain)?
I'd been struggling on this topic for days but still without any clue.

What I have done is as follows:
1.  I try the link 
https://cwiki.apache.org/confluence/display/OFBIZ/Apache+OFBiz+Technical+Production+Setup+Guide
But it ask us to submit the CSR to a third CA authority like VeriSign.
I would like to test it only so if possible I would go for a free CA 
service first.
Then with www.sslforfree.com I could download 
the following 3 files:
1.1 ca_bundle.crt
1.2 certificate.crt
1.3 private.key
What should I do then?
2.  Another option is with keytool function I would like to create a 
self-signed CA.
But it still failed and I guessed I didn't do it in the right way.

Pls help!!!

Best Regards
Schumann

How to Configure Ofbiz SSL

[Schumann Ye]

Dear Gurus,

Can anyone be so kind to show me how to configure ofbiz ssl for a test 
deployment (on a given domain)?
I'd been struggling on this topic for days but still without any clue.

What I have done is as follows:
1.  I try the link 
https://cwiki.apache.org/confluence/display/OFBIZ/Apache+OFBiz+Technical+Production+Setup+Guide
   But it ask us to submit the CSR to a third CA authority like VeriSign.
   I would like to test it only so if possible I would go for a free CA service 
first.
   Then with www.sslforfree.com I could download the 
following 3 files:
1.1 ca_bundle.crt
1.2 certificate.crt
1.3 private.key
   What should I do then?
2.  Another option is with keytool function I would like to create a 
self-signed CA.
   But it still failed and I guessed I didn't do it in the right way.

Pls help!!!

Best Regards
Schumann

Re: OFBiz and Camel integration updated

[Swapnil Mane]

Wow, thanks so much Bilgin for your contribution! :-)


- Best Regards,
Swapnil M Mane

On Wed, Mar 21, 2018 at 3:36 PM, Bilgin Ibryam  wrote:

> hi all,
>
> a quick heads up. I've been getting requests to fix the ofbiz-camel
> integration demo and finally did it.
> It works with the latest version of OFBiz and Camel
> Also added a nice diagram demonstrating how the integration works.
>
> https://github.com/bibryam/ofbiz-camel
>
> Cheers,
>
> --
> Bilgin Ibryam
> ASF Member | Architect at Red Hat
> http://ofbizian.com | @bibryam
>
> Kubernetes Patterns http://leanpub.com/k8spatterns (in progress)
> Camel Design Patterns https://leanpub.com/camel-design-patterns
>

Re: OFBiz and Camel integration updated

[Jacques Le Roux]

Looks quite good, thanks Bilgin !

"Licensed under The MIT License." why not ASL2 :) ?

Jacques


Le 21/03/2018 à 11:06, Bilgin Ibryam a écrit :

hi all,

a quick heads up. I've been getting requests to fix the ofbiz-camel
integration demo and finally did it.
It works with the latest version of OFBiz and Camel
Also added a nice diagram demonstrating how the integration works.

https://github.com/bibryam/ofbiz-camel

Cheers,

Financial transaction - accounting transactions

[Ingo Wolfmayr]

Hi,

I have a question regarding financial transaction, in detail the service 
"postFinAccountTransToGl".

When I create a "deposit" or a "withdraw" it creates the same accounting 
transactions except changing the type of accounting transaction.

Maybe I missunderstand the financial transactions. This is what I am trying to 
do:
A customer made a payment 100$. The bank subtracts a fee from my account 5$. I 
thought by making a transaction "withdraw" I could submit the fee to the 
appropriate glaccount and subtracting it from the financial account (2nd part 
is fine).
Goal:
Debit: 5$ Fees
Credit: 5$ Bank

Current situation:
Credit: 5$ Fees
Debit: 5$ Bank

Creating a deposit creates the same financial transactions.

When I create an adjustment with a negativ amount, the glaccounts are on the 
right side, but the value is negativ, which at the end leads to the same result.

I would be glad if someone could help me on this.

Best regards,
Ingo

OFBiz and Camel integration updated

[Bilgin Ibryam]

hi all,

a quick heads up. I've been getting requests to fix the ofbiz-camel
integration demo and finally did it.
It works with the latest version of OFBiz and Camel
Also added a nice diagram demonstrating how the integration works.

https://github.com/bibryam/ofbiz-camel

Cheers,

-- 
Bilgin Ibryam
ASF Member | Architect at Red Hat
http://ofbizian.com | @bibryam

Kubernetes Patterns http://leanpub.com/k8spatterns (in progress)
Camel Design Patterns https://leanpub.com/camel-design-patterns

Re: Financials ->Month End Close Procedures

[Taher Alkhateeb]

Valuable info! seems like a glaring "must-go-to-the-manual" thing

On Wed, Mar 21, 2018 at 11:46 AM, Sharan Foga  wrote:
> Hi James
>
> You don’t need to buy my book, to find out about this. :-)
>
> I’ve gone through the main process below with some links to the screens in 
> our demo.
> So the main things you need are:
>
> Time Periods
> https://demo-stable.ofbiz.apache.org/accounting/control/TimePeriods?organizationPartyId=Company
>
> To make sure that your time periods (monthly ones are setup). The last time I 
> checked OFBiz still needed the periods to be setup a bit like this
>
> Start Date 1 January 20XX End Date 1 February 20XX because the comparison for 
> whether a transaction is within the range is a less than comparison. So 
> setting the period end date to 31st January 20XX will miss the transactions 
> for the 31st January.
>
> Make sure the period is active
>
> GL Account Type Defaults Account Mapping
> https://demo-stable.ofbiz.apache.org/accounting/control/GlAccountAssignment?organizationPartyId=Company
>
> You need a mapping to make sure that:
> - ‘Profit Loss ‘ GL account type is mapped to your account for Net Income
> - 'Retained Earnings' GL account type is mapped to your account for Retained 
> Earnings
>
> Month End Closing
> https://demo-stable.ofbiz.apache.org/accounting/control/TimePeriods?organizationPartyId=Company
>
> To close the month simply close the time period and Period closing accounting 
> transaction should automatically be created and posted  (Do this in the 
> company settings not at the global GL accounts level)
>
> Period Closing Accounting Transaction
> To find the Period Closing Transaction, go to
>
> https://demo-stable.ofbiz.apache.org/accounting/control/FindAcctgTrans
>
> Re-opening a Closed Period
> You used to be able to do this via the Edit Custom Time Period screen
> https://localhost:8443/accounting/control/updateCustomTimePeriod
>
> but that is no longer the case.
>
> The workaround is to edit Time Period entity record to make it active. There 
> is a flag that indicates whether the period is active or not – just change it.
> https://demo-stable.ofbiz.apache.org/webtools/control/FindGeneric?entityName=CustomTimePeriod
>
> - Reverse the accounting transaction for the original period closing. (Just 
> go into the original accounting transaction and use the Revert option)
> - Do your accounting adjustments
> - Close the period again
>
> I think that having the ability to re-open a closed Time Period is a 
> something that is quite useful so would probably suggest that we look at 
> re-implementing something  that does this.
>
> I hope this helps and if anyone else has other ideas or suggestions then 
> please feel free to add your feedback.
>
> Thanks
> Sharan
> On 2018/03/20 13:17:56,  wrote:
>>
>> Can someone point me in the right direction for Month End Close
>> Accounting Procedures in Ofbiz.  As well how to re-open a closed period?
>>
>> Thanks,
>>
>> James
>>

Re: Financials ->Month End Close Procedures

[Sharan Foga]

Hi James

You don’t need to buy my book, to find out about this. :-) 

I’ve gone through the main process below with some links to the screens in 
our demo.
So the main things you need are:

Time Periods
https://demo-stable.ofbiz.apache.org/accounting/control/TimePeriods?organizationPartyId=Company

To make sure that your time periods (monthly ones are setup). The last time I 
checked OFBiz still needed the periods to be setup a bit like this

Start Date 1 January 20XX End Date 1 February 20XX because the comparison for 
whether a transaction is within the range is a less than comparison. So setting 
the period end date to 31st January 20XX will miss the transactions for the 
31st January. 

Make sure the period is active

GL Account Type Defaults Account Mapping
https://demo-stable.ofbiz.apache.org/accounting/control/GlAccountAssignment?organizationPartyId=Company

You need a mapping to make sure that:
- ‘Profit Loss ‘ GL account type is mapped to your account for Net Income 
- 'Retained Earnings' GL account type is mapped to your account for Retained 
Earnings

Month End Closing
https://demo-stable.ofbiz.apache.org/accounting/control/TimePeriods?organizationPartyId=Company

To close the month simply close the time period and Period closing accounting 
transaction should automatically be created and posted  (Do this in the company 
settings not at the global GL accounts level)

Period Closing Accounting Transaction
To find the Period Closing Transaction, go to 

https://demo-stable.ofbiz.apache.org/accounting/control/FindAcctgTrans 

Re-opening a Closed Period
You used to be able to do this via the Edit Custom Time Period screen
https://localhost:8443/accounting/control/updateCustomTimePeriod 

but that is no longer the case. 

The workaround is to edit Time Period entity record to make it active. There is 
a flag that indicates whether the period is active or not – just change it.
https://demo-stable.ofbiz.apache.org/webtools/control/FindGeneric?entityName=CustomTimePeriod

- Reverse the accounting transaction for the original period closing. (Just go 
into the original accounting transaction and use the Revert option)
- Do your accounting adjustments 
- Close the period again

I think that having the ability to re-open a closed Time Period is a something 
that is quite useful so would probably suggest that we look at re-implementing 
something  that does this.

I hope this helps and if anyone else has other ideas or suggestions then please 
feel free to add your feedback.

Thanks
Sharan
On 2018/03/20 13:17:56,  wrote: 
> 
> Can someone point me in the right direction for Month End Close
> Accounting Procedures in Ofbiz.  As well how to re-open a closed period?
> 
> Thanks,
> 
> James
>