RE: Credit Memos - Please give me your process and opinions!

[james]

We don't have any issues fixing it and contributing back but ai want to
make sure we understand how the system is behaving and we dont miss any
thing.  I just noticed that the system is creating Invoice Type Customer
Return and Invoice type Purchase Return.  If we fully understand from
the ofbiz experts what the system is doing we can fix it.

Thanks,

James

 Original Message 
Subject: Re: Credit Memos - Please give me your process and opinions!
From: Pierre Smits 
Date: Thu, November 09, 2017 3:35 pm
To: user@ofbiz.apache.org

Hi James, all,

Please see inline

Best regards,

Pierre Smits

ORRTIZ.COM 
OFBiz based solutions & services

OEM - The OFBiz Extensions Marketplace1
http://oem.ofbizci.net/oci-2/
1 not affiliated to (and not endorsed by) the OFBiz project

On Thu, Nov 9, 2017 at 9:42 PM,  wrote:

> Pierre - Thanks for the response but I dont believe the system is
> behaving this way. Right now when a return is done against the sales
> order the system is actually creating a payment that can be processed as
> a check. This should NOT be the case.


Any system not behaving in expected ways (read: as competing solutions
do)
is disqualified in the eyes of potential adopters. In our situation (in
general, and in this situation in particular) this is more often than
not
influenced by decisions makers and influencers in the accounting
department
and auditing companies.



> How do I get the system to
> generate the credit note?
>

The easy answer is: fix the problem. Yet that easy answer will require
quite the effort applied. You can either fix it in your own implemented
system, or wait on the OFBiz community to help you.


>
>  Original Message 
> Subject: Re: Credit Memos - Please give me your process and opinions!
> From: Pierre Smits 
> Date: Sat, October 28, 2017 2:00 am
> To: user@ofbiz.apache.org
>
> Hi James,
>
> The simple answer is NOT. On invoice level. And that is regardless of
> whether you're talking about a Sales or Purchase. A sales Credit Note
> (or
> Credit Invoice) is not a payment of the Sales Invoice, and - equally so
> - a
> Purchase Credit Note is not a payment of a Purchase Invoice. For
> convenience purposes I will explain more below using only the sales
> domain.
>
> Both the Invoice and the Credit Note stem from the Order. When the
> Invoice
> has been generated and encompasses all elements regarding the Order, the
> obligation of the customer to pay the (agreed) amount due has been
> established in the debtors sub ledger and in the general ledger. When
> (due
> to whatever reason) a Credit Note is issued, the total obligation is
> reduced. The reference to the order (and other documents as delivery
> notes,
> RMA's, etc) help to identify where it came from.
>
> So the Credit Note reduces the outstanding debt. When subsequently a
> payment from the debtor comes in, all the appropriate Invoices and
> Credit
> Notes should have payments (positive for Invoice, negative for credit
> note).against them. If in anyway the payment is unclear Invoices and
> Credit
> Notes should not be should not be marked against that payment. More
> investigation is required!.
>
> Suppose the following:
> Order = USD 1.000,00, and goods have been delivered
> Invoice = USD 1.000,00.
> RMA is granted for 1 time on the order, valued at USD 100,00
> Credit Note is issued for USD 100,00
> At this moment the outstanding debt (in Accounts Receivable) is 900,00
> for
> the order, but the total position of the debtor can also be higher or
> lower.
>
> Subsequently a payment of UDS 910,00 arrives, but the description is
> unclear. Then you can't tell which Invoices and Credit Notes are
> applicable. If you take the first one(s) that may seem appropriate,
> you're
> creating a confusion that will go from bad to worse. So you need more
> information and keep chasing the debtor.
>
> And when everything regarding the received payment is clear (accepted by
> the accounting department) an accounting transaction must be created to
> ensure that everything is correct:
>
> In the sub ledger the Invoice for USD 1.000,00 will be marked as paid
> Also the Credit Note for USD 100,00 will be marked as paid
> And an undesignated payment of USD 10,00 will also be registered.
>
> I trust this helps.
>
> Best regards,
>
>
>
>
>
> Pierre Smits
>
> ORRTIZ.COM 
> OFBiz based solutions & services
>
> OFBiz Extensions Marketplace
> http://oem.ofbizci.net/oci-2/
>
> On Wed, Oct 25, 2017 at 3:49 PM,  wrote:
>
> > I have been struggling with the Credit Memo and Vendor Credit Memo
> > process for a while and I think this needs a real hard look. Can
> > someone tell me the proper way to apply a Credit Memo generated from a
> > return to the Original Invoice from the sales order.
> >
> > Here is the Example
> >
> > Customer buys GZ1000 for a $1000 and is invoiced for 

Re: Credit Memos - Please give me your process and opinions!

[Pierre Smits]

Hi James, all,

Please see inline

Best regards,

Pierre Smits

ORRTIZ.COM 
OFBiz based solutions & services

OEM - The OFBiz Extensions Marketplace1
http://oem.ofbizci.net/oci-2/
1 not affiliated to (and not endorsed by) the OFBiz project

On Thu, Nov 9, 2017 at 9:42 PM,  wrote:

> Pierre - Thanks for the response but I dont believe the system is
> behaving this way.  Right now when a return is done against the sales
> order the system is actually creating a payment that can be processed as
> a check.  This should NOT be the case.


Any system not behaving in expected ways (read: as competing solutions do)
is disqualified in the eyes of potential adopters. In our situation (in
general, and in this situation in particular) this is more often than not
influenced by decisions makers and influencers in the accounting department
and auditing companies.



> How do I get the system to
> generate the credit note?
>

The easy answer is: fix the problem. Yet that easy answer will require
quite the effort applied. You can either fix it in your own implemented
system, or wait on the OFBiz community to help you.


>
>  Original Message 
> Subject: Re: Credit Memos - Please give me your process and opinions!
> From: Pierre Smits 
> Date: Sat, October 28, 2017 2:00 am
> To: user@ofbiz.apache.org
>
> Hi James,
>
> The simple answer is NOT. On invoice level. And that is regardless of
> whether you're talking about a Sales or Purchase. A sales Credit Note
> (or
> Credit Invoice) is not a payment of the Sales Invoice, and - equally so
> - a
> Purchase Credit Note is not a payment of a Purchase Invoice. For
> convenience purposes I will explain more below using only the sales
> domain.
>
> Both the Invoice and the Credit Note stem from the Order. When the
> Invoice
> has been generated and encompasses all elements regarding the Order, the
> obligation of the customer to pay the (agreed) amount due has been
> established in the debtors sub ledger and in the general ledger. When
> (due
> to whatever reason) a Credit Note is issued, the total obligation is
> reduced. The reference to the order (and other documents as delivery
> notes,
> RMA's, etc) help to identify where it came from.
>
> So the Credit Note reduces the outstanding debt. When subsequently a
> payment from the debtor comes in, all the appropriate Invoices and
> Credit
> Notes should have payments (positive for Invoice, negative for credit
> note).against them. If in anyway the payment is unclear Invoices and
> Credit
> Notes should not be should not be marked against that payment. More
> investigation is required!.
>
> Suppose the following:
> Order = USD 1.000,00, and goods have been delivered
> Invoice = USD 1.000,00.
> RMA is granted for 1 time on the order, valued at USD 100,00
> Credit Note is issued for USD 100,00
> At this moment the outstanding debt (in Accounts Receivable) is 900,00
> for
> the order, but the total position of the debtor can also be higher or
> lower.
>
> Subsequently a payment of UDS 910,00 arrives, but the description is
> unclear. Then you can't tell which Invoices and Credit Notes are
> applicable. If you take the first one(s) that may seem appropriate,
> you're
> creating a confusion that will go from bad to worse. So you need more
> information and keep chasing the debtor.
>
> And when everything regarding the received payment is clear (accepted by
> the accounting department) an accounting transaction must be created to
> ensure that everything is correct:
>
> In the sub ledger the Invoice for USD 1.000,00 will be marked as paid
> Also the Credit Note for USD 100,00 will be marked as paid
> And an undesignated payment of USD 10,00 will also be registered.
>
> I trust this helps.
>
> Best regards,
>
>
>
>
>
> Pierre Smits
>
> ORRTIZ.COM 
> OFBiz based solutions & services
>
> OFBiz Extensions Marketplace
> http://oem.ofbizci.net/oci-2/
>
> On Wed, Oct 25, 2017 at 3:49 PM,  wrote:
>
> > I have been struggling with the Credit Memo and Vendor Credit Memo
> > process for a while and I think this needs a real hard look. Can
> > someone tell me the proper way to apply a Credit Memo generated from a
> > return to the Original Invoice from the sales order.
> >
> > Here is the Example
> >
> > Customer buys GZ1000 for a $1000 and is invoiced for $1000
> > He returns GZ1000 and is given a credit for $1000
> >
> > How is that credit applied to the original invoice so it shows in
> > accounting that the customer no longer owes $1000?
> >
> >
> > Same thing on the Vendor side when returning a product back to vendor.
> >
> > Thanks,
> >
> > Jame
> >
>

RE: Credit Memos - Please give me your process and opinions!

[james]

Pierre - Thanks for the response but I dont believe the system is
behaving this way.  Right now when a return is done against the sales
order the system is actually creating a payment that can be processed as
a check.  This should NOT be the case.  How do I get the system to
generate the credit note?

 Original Message 
Subject: Re: Credit Memos - Please give me your process and opinions!
From: Pierre Smits 
Date: Sat, October 28, 2017 2:00 am
To: user@ofbiz.apache.org

Hi James,

The simple answer is NOT. On invoice level. And that is regardless of
whether you're talking about a Sales or Purchase. A sales Credit Note
(or
Credit Invoice) is not a payment of the Sales Invoice, and - equally so
- a
Purchase Credit Note is not a payment of a Purchase Invoice. For
convenience purposes I will explain more below using only the sales
domain.

Both the Invoice and the Credit Note stem from the Order. When the
Invoice
has been generated and encompasses all elements regarding the Order, the
obligation of the customer to pay the (agreed) amount due has been
established in the debtors sub ledger and in the general ledger. When
(due
to whatever reason) a Credit Note is issued, the total obligation is
reduced. The reference to the order (and other documents as delivery
notes,
RMA's, etc) help to identify where it came from.

So the Credit Note reduces the outstanding debt. When subsequently a
payment from the debtor comes in, all the appropriate Invoices and
Credit
Notes should have payments (positive for Invoice, negative for credit
note).against them. If in anyway the payment is unclear Invoices and
Credit
Notes should not be should not be marked against that payment. More
investigation is required!.

Suppose the following:
Order = USD 1.000,00, and goods have been delivered
Invoice = USD 1.000,00.
RMA is granted for 1 time on the order, valued at USD 100,00
Credit Note is issued for USD 100,00
At this moment the outstanding debt (in Accounts Receivable) is 900,00
for
the order, but the total position of the debtor can also be higher or
lower.

Subsequently a payment of UDS 910,00 arrives, but the description is
unclear. Then you can't tell which Invoices and Credit Notes are
applicable. If you take the first one(s) that may seem appropriate,
you're
creating a confusion that will go from bad to worse. So you need more
information and keep chasing the debtor.

And when everything regarding the received payment is clear (accepted by
the accounting department) an accounting transaction must be created to
ensure that everything is correct:

In the sub ledger the Invoice for USD 1.000,00 will be marked as paid
Also the Credit Note for USD 100,00 will be marked as paid
And an undesignated payment of USD 10,00 will also be registered.

I trust this helps.

Best regards,





Pierre Smits

ORRTIZ.COM 
OFBiz based solutions & services

OFBiz Extensions Marketplace
http://oem.ofbizci.net/oci-2/

On Wed, Oct 25, 2017 at 3:49 PM,  wrote:

> I have been struggling with the Credit Memo and Vendor Credit Memo
> process for a while and I think this needs a real hard look. Can
> someone tell me the proper way to apply a Credit Memo generated from a
> return to the Original Invoice from the sales order.
>
> Here is the Example
>
> Customer buys GZ1000 for a $1000 and is invoiced for $1000
> He returns GZ1000 and is given a credit for $1000
>
> How is that credit applied to the original invoice so it shows in
> accounting that the customer no longer owes $1000?
>
>
> Same thing on the Vendor side when returning a product back to vendor.
>
> Thanks,
>
> Jame
>

Re: Is website 16.11 stable release demo down?

[Jacques Le Roux]

This is the kind of issue I don't monitor (I use ping my box for that since there it's no longer supported by infra) because the server is still 
responding and I check only for its availability.

I will increase monitoring to 500s also...

I clean and restart it, WIP...

jacques


Actually untrue, I did not remember. I'm only accepting HTTP 200. All the rest is considered an error. So seems that PingMyBox did not alert me. I'll 
check that...
I have BTW added a check for the certificate, 7 days before its end. We know there is still (so far) an issue with the ASF global letsencrypt cron 
job. So we need to do it manually...


Jacques

Re: Is website 16.11 stable release demo down?

[Jacques Le Roux]

Le 09/11/2017 à 15:33, Jacques Le Roux a écrit :

Le 09/11/2017 à 15:26, Jacques Le Roux a écrit :

Le 09/11/2017 à 15:19, Sharan Foga a écrit :

Hi

I was just trying the stable demo from our website link it seems to be down at the moment. It is showing a Tomcat error, The trunk and 13.07 demos 
seem to be working fine.


Thanks
Sharan


Yep let me check

Jacques



Something bad happened, stable did not close before restarting:
[...]
:ofbiz  --start --portoffset 1
Start.java using configuration file org/apache/ofbiz/base/start/start.properties
Set OFBIZ_HOME to - /home/ofbizDemo/branch16.11
org.apache.ofbiz.base.start.StartupException: Couldn't create server 
socket(/127.0.0.1:20523) (Address already in use (Bind failed))
    at org.apache.ofbiz.base.start.AdminServer.(AdminServer.java:56)
    at 
org.apache.ofbiz.base.start.StartupControlPanel.createAdminServer(StartupControlPanel.java:154)
    at 
org.apache.ofbiz.base.start.StartupControlPanel.start(StartupControlPanel.java:65)
    at org.apache.ofbiz.base.start.Start.main(Start.java:84)
Caused by: java.net.BindException: Address already in use (Bind failed)
    at java.net.PlainSocketImpl.socketBind(Native Method)
    at java.net.AbstractPlainSocketImpl.bind(AbstractPlainSocketImpl.java:387)
    at java.net.ServerSocket.bind(ServerSocket.java:375)
    at java.net.ServerSocket.(ServerSocket.java:237)
    at org.apache.ofbiz.base.start.AdminServer.(AdminServer.java:54)
    ... 3 more
:ofbiz  --start --portoffset 1 FAILED

This is the kind of issue I don't monitor (I use ping my box for that since there it's no longer supported by infra) because the server is still 
responding and I check only for its availability.

I will increase monitoring to 500s also...

I clean and restart it, WIP...

jacques


OK, it was really a mess. A problem occurred somehow when the cronjob ran this night. So I had to kill tons of processes which were resurrecting like 
an hydra. Before I spotted the cronjob was still running. Even after few process were sill showing their heads :D


So I killed all there, and all is now slowly restarting... Hopefully well, we 
had no problems for months...
1st ready will be trunk, then stable, then old.

Jacques

Re: Is website 16.11 stable release demo down?

[Jacques Le Roux]

Le 09/11/2017 à 15:26, Jacques Le Roux a écrit :

Le 09/11/2017 à 15:19, Sharan Foga a écrit :

Hi

I was just trying the stable demo from our website link it seems to be down at the moment. It is showing a Tomcat error, The trunk and 13.07 demos 
seem to be working fine.


Thanks
Sharan


Yep let me check

Jacques



Something bad happened, stable did not close before restarting:
[...]
:ofbiz  --start --portoffset 1
Start.java using configuration file org/apache/ofbiz/base/start/start.properties
Set OFBIZ_HOME to - /home/ofbizDemo/branch16.11
org.apache.ofbiz.base.start.StartupException: Couldn't create server 
socket(/127.0.0.1:20523) (Address already in use (Bind failed))
    at org.apache.ofbiz.base.start.AdminServer.(AdminServer.java:56)
    at 
org.apache.ofbiz.base.start.StartupControlPanel.createAdminServer(StartupControlPanel.java:154)
    at 
org.apache.ofbiz.base.start.StartupControlPanel.start(StartupControlPanel.java:65)
    at org.apache.ofbiz.base.start.Start.main(Start.java:84)
Caused by: java.net.BindException: Address already in use (Bind failed)
    at java.net.PlainSocketImpl.socketBind(Native Method)
    at java.net.AbstractPlainSocketImpl.bind(AbstractPlainSocketImpl.java:387)
    at java.net.ServerSocket.bind(ServerSocket.java:375)
    at java.net.ServerSocket.(ServerSocket.java:237)
    at org.apache.ofbiz.base.start.AdminServer.(AdminServer.java:54)
    ... 3 more
:ofbiz  --start --portoffset 1 FAILED

This is the kind of issue I don't monitor (I use ping my box for that since there it's no longer supported by infra) because the server is still 
responding and I check only for its availability.

I will increase monitoring to 500s also...

I clean and restart it, WIP...

jacques

Re: Is website 16.11 stable release demo down?

[Jacques Le Roux]

Le 09/11/2017 à 15:19, Sharan Foga a écrit :

Hi

I was just trying the stable demo from our website link it seems to be down at 
the moment. It is showing a Tomcat error, The trunk and 13.07 demos seem to be 
working fine.

Thanks
Sharan


Yep let me check

Jacques

Is website 16.11 stable release demo down?

[Sharan Foga]

Hi 

I was just trying the stable demo from our website link it seems to be down at 
the moment. It is showing a Tomcat error, The trunk and 13.07 demos seem to be 
working fine. 

Thanks
Sharan