You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by "skip@theDevers" <sk...@thedevers.org> on 2007/10/25 09:59:57 UTC
captureBillingAccountPayments
I am having a discussion with Si about billing accounts. For me,
captureBillingAccountPayments works and the deprecated
captureBillingAccountPayment does not.
However, captureBillingAccountPayments essentially does nothing (which it
the right thing to do in this case).
My question is, what was the intent of the logic after the
if (UtilValidate.isNotEmpty(paymentApplications)) {
which for me is always empty and never gets executed.
Can the author comment? Is there some case where this will contain
paymentApplications?
Skip
Re: captureBillingAccountPayments
Posted by Jacopo Cappellato <ti...@sastau.it>.
skip@theDevers wrote:
> I am having a discussion with Si about billing accounts. For me,
> captureBillingAccountPayments works and the deprecated
> captureBillingAccountPayment does not.
>
Actually not only for you: in my opinion the service that we have
deprecated during the refactoring are simply wrong because they were
based on wrong assumptions on the meaning and logic of billing accounts.
As soon as the new stuff is consolidated we should remove them.
Jacopo
RE: captureBillingAccountPayments
Posted by "skip@theDevers" <sk...@thedevers.org>.
Yeppers
-----Original Message-----
From: Jacopo Cappellato [mailto:tiz@sastau.it]
Sent: Thursday, October 25, 2007 9:08 AM
To: user@ofbiz.apache.org
Subject: Re: captureBillingAccountPayments
This seems one of the errors introduced with the last framework
improvements...
I'm sure that others will jump in and help to fix this. Are you running
the latest trunk revision?
Jacopo
skip@theDevers wrote:
> Jacopo
>
> Tried the create a store credit thing and got this error:
>
>
>
> The Following Errors Occurred:
>
> Unknown parameter found: [createTrackingCodeOrderReturns.hasPermission]
>
> Unknown parameter found: [createTrackingCodeOrderReturns.responseMessage]
>
>
>
> when I clicked "Accept Return"
>
> What I did was:
>
> 1. Click "Order" tab, then check "Completed" and click submit.
>
> 2. Picked an existing completed order on DemoCustCust for one WG-1111
>
> 3. Clicked "Create Return" button 2/3rds down toward the right side.
>
> 4. Selected "Store Credit" from the drop down list for the item and two
tax
> entries (0.00 each for the tax entries) then clicked "return selected
> items".
>
> 5. Checked the "Select All" box and clicked "Return Items"
>
> 6. Clicked the "Accept Return" button.
>
>
> Here is the relevant part of the stack trace:
>
> 2007-10-25 08:46:43,361 (http-0.0.0.0-8443-Processor2) [
> ModelService.java:484:ERROR] [ModelService.validate] :
> {createTrackingCodeOrderReturns} : (IN) Required test error:
> org.ofbiz.service.ServiceValidationException: Unknown parameter found:
> [createTrackingCodeOrderReturns.hasPermission]Unknown parameter found:
> [createTrackingCodeOrderReturns.responseMessage]
> 2007-10-25 08:46:43,371 (http-0.0.0.0-8443-Processor2) [
> ServiceDispatcher.java:355:ERROR]
> ---- exception
> report ----------------------------------------------------------
> Incoming context (in runSync : createTrackingCodeOrderReturns) does not
> match expected requirements
> Exception: org.ofbiz.service.ServiceValidationException
> Message: Unknown parameter found:
> [createTrackingCodeOrderReturns.hasPermission]Unknown parameter found:
> [createTrackingCodeOrderReturns.responseMessage]
> ---- stack
> trace ---------------------------------------------------------------
> org.ofbiz.service.ServiceValidationException: Unknown parameter found:
> [createTrackingCodeOrderReturns.hasPermission]Unknown parameter found:
> [createTrackingCodeOrderReturns.responseMessage]
> org.ofbiz.service.ModelService.validate(ModelService.java:552)
>
> -----Original Message-----
> From: Jacopo Cappellato [mailto:tiz@sastau.it]
> Sent: Thursday, October 25, 2007 1:54 AM
> To: user@ofbiz.apache.org
> Subject: Re: captureBillingAccountPayments
>
>
> skip@theDevers wrote:
>> Jacopo
>>
>> Makes perfect sense, in fact, its the almost perfect solution to my
second
>> question. Lets say you sold 4 items on 4 days on 4 invoices. The
> customer
>> pays for all 4 invoices. Then, a week later, item 2 breaks and he sends
> it
>> back for a credit. The following week, he buys something else. Is there
>> some way for the credit to show up on the in sales order payment options?
>> Could the same logic be used?
>>
>
> Yes,
>
> the business logic is the following one (correct me if I am wrong):
>
> 1) a customer return is created for 2 items
> 2) you should select as the return type: "store credit" this will store
> (as a PaymentApplication) the credit to a billing account associated
> to the customer
> 3) the new amount will increase the available balance of the billing
> account (that can be used during order entry)
> This should work, but if you see something wrong please let us know.
>
> Jacopo
>
>
>>
>> Skip
>>
>>
>> -----Original Message-----
>> From: Jacopo Cappellato [mailto:tiz@sastau.it]
>> Sent: Thursday, October 25, 2007 1:23 AM
>> To: user@ofbiz.apache.org
>> Subject: Re: captureBillingAccountPayments
>>
>>
>> skip@theDevers wrote:
>>> I am having a discussion with Si about billing accounts. For me,
>>> captureBillingAccountPayments works and the deprecated
>>> captureBillingAccountPayment does not.
>>>
>>> However, captureBillingAccountPayments essentially does nothing (which
it
>>> the right thing to do in this case).
>>>
>>> My question is, what was the intent of the logic after the
>>>
>>>
>>> if (UtilValidate.isNotEmpty(paymentApplications)) {
>>>
>>> which for me is always empty and never gets executed.
>>>
>>> Can the author comment? Is there some case where this will contain
>>> paymentApplications?
>>>
>>> Skip
>> Let's say you get a billing account and two not paid invoices associated
>> to it, one for 30$ and one for 50$.
>> You get a payment from your customer for 70$; you associate the whole
>> payment to the billing account: this will create a PaymentApplication
>> record with billingAccountId set, and a null invoiceId.
>> Then, if you go to the billing account's invoices screen and you click
>> on the "capture payments" link near to the 30$ invoice, then the
>> captureBillingAccountPayments service will be called -> the
>> PaymentApplication with null invoiceId (i.e. still not applied) is found
>> --> if (UtilValidate.isNotEmpty(paymentApplications)) is true -->
>> a new PaymentApplication is created for 30$ and applied to the invoice;
>> the original PaymentApplication is updated and the new 'available'
>> amount is 40$ (i.e. 70-30=40); we can now do the same with the otther
>> invoice...
>> At the end the first invoice will be PAID and the second PARTIALLY PAID.
>>
>> Does it make sense?
>>
>> Jacopo
>>
>>
>
Re: captureBillingAccountPayments
Posted by Jacopo Cappellato <ti...@sastau.it>.
This seems one of the errors introduced with the last framework
improvements...
I'm sure that others will jump in and help to fix this. Are you running
the latest trunk revision?
Jacopo
skip@theDevers wrote:
> Jacopo
>
> Tried the create a store credit thing and got this error:
>
>
>
> The Following Errors Occurred:
>
> Unknown parameter found: [createTrackingCodeOrderReturns.hasPermission]
>
> Unknown parameter found: [createTrackingCodeOrderReturns.responseMessage]
>
>
>
> when I clicked "Accept Return"
>
> What I did was:
>
> 1. Click "Order" tab, then check "Completed" and click submit.
>
> 2. Picked an existing completed order on DemoCustCust for one WG-1111
>
> 3. Clicked "Create Return" button 2/3rds down toward the right side.
>
> 4. Selected "Store Credit" from the drop down list for the item and two tax
> entries (0.00 each for the tax entries) then clicked "return selected
> items".
>
> 5. Checked the "Select All" box and clicked "Return Items"
>
> 6. Clicked the "Accept Return" button.
>
>
> Here is the relevant part of the stack trace:
>
> 2007-10-25 08:46:43,361 (http-0.0.0.0-8443-Processor2) [
> ModelService.java:484:ERROR] [ModelService.validate] :
> {createTrackingCodeOrderReturns} : (IN) Required test error:
> org.ofbiz.service.ServiceValidationException: Unknown parameter found:
> [createTrackingCodeOrderReturns.hasPermission]Unknown parameter found:
> [createTrackingCodeOrderReturns.responseMessage]
> 2007-10-25 08:46:43,371 (http-0.0.0.0-8443-Processor2) [
> ServiceDispatcher.java:355:ERROR]
> ---- exception
> report ----------------------------------------------------------
> Incoming context (in runSync : createTrackingCodeOrderReturns) does not
> match expected requirements
> Exception: org.ofbiz.service.ServiceValidationException
> Message: Unknown parameter found:
> [createTrackingCodeOrderReturns.hasPermission]Unknown parameter found:
> [createTrackingCodeOrderReturns.responseMessage]
> ---- stack
> trace ---------------------------------------------------------------
> org.ofbiz.service.ServiceValidationException: Unknown parameter found:
> [createTrackingCodeOrderReturns.hasPermission]Unknown parameter found:
> [createTrackingCodeOrderReturns.responseMessage]
> org.ofbiz.service.ModelService.validate(ModelService.java:552)
>
> -----Original Message-----
> From: Jacopo Cappellato [mailto:tiz@sastau.it]
> Sent: Thursday, October 25, 2007 1:54 AM
> To: user@ofbiz.apache.org
> Subject: Re: captureBillingAccountPayments
>
>
> skip@theDevers wrote:
>> Jacopo
>>
>> Makes perfect sense, in fact, its the almost perfect solution to my second
>> question. Lets say you sold 4 items on 4 days on 4 invoices. The
> customer
>> pays for all 4 invoices. Then, a week later, item 2 breaks and he sends
> it
>> back for a credit. The following week, he buys something else. Is there
>> some way for the credit to show up on the in sales order payment options?
>> Could the same logic be used?
>>
>
> Yes,
>
> the business logic is the following one (correct me if I am wrong):
>
> 1) a customer return is created for 2 items
> 2) you should select as the return type: "store credit" this will store
> (as a PaymentApplication) the credit to a billing account associated
> to the customer
> 3) the new amount will increase the available balance of the billing
> account (that can be used during order entry)
> This should work, but if you see something wrong please let us know.
>
> Jacopo
>
>
>>
>> Skip
>>
>>
>> -----Original Message-----
>> From: Jacopo Cappellato [mailto:tiz@sastau.it]
>> Sent: Thursday, October 25, 2007 1:23 AM
>> To: user@ofbiz.apache.org
>> Subject: Re: captureBillingAccountPayments
>>
>>
>> skip@theDevers wrote:
>>> I am having a discussion with Si about billing accounts. For me,
>>> captureBillingAccountPayments works and the deprecated
>>> captureBillingAccountPayment does not.
>>>
>>> However, captureBillingAccountPayments essentially does nothing (which it
>>> the right thing to do in this case).
>>>
>>> My question is, what was the intent of the logic after the
>>>
>>>
>>> if (UtilValidate.isNotEmpty(paymentApplications)) {
>>>
>>> which for me is always empty and never gets executed.
>>>
>>> Can the author comment? Is there some case where this will contain
>>> paymentApplications?
>>>
>>> Skip
>> Let's say you get a billing account and two not paid invoices associated
>> to it, one for 30$ and one for 50$.
>> You get a payment from your customer for 70$; you associate the whole
>> payment to the billing account: this will create a PaymentApplication
>> record with billingAccountId set, and a null invoiceId.
>> Then, if you go to the billing account's invoices screen and you click
>> on the "capture payments" link near to the 30$ invoice, then the
>> captureBillingAccountPayments service will be called -> the
>> PaymentApplication with null invoiceId (i.e. still not applied) is found
>> --> if (UtilValidate.isNotEmpty(paymentApplications)) is true -->
>> a new PaymentApplication is created for 30$ and applied to the invoice;
>> the original PaymentApplication is updated and the new 'available'
>> amount is 40$ (i.e. 70-30=40); we can now do the same with the otther
>> invoice...
>> At the end the first invoice will be PAID and the second PARTIALLY PAID.
>>
>> Does it make sense?
>>
>> Jacopo
>>
>>
>
Re: captureBillingAccountPayments
Posted by Adrian Crum <ad...@hlmksw.com>.
Rev 586938 is what you need.
skip@theDevers wrote:
> Jacopo
>
> Tried the create a store credit thing and got this error:
>
>
>
> The Following Errors Occurred:
>
> Unknown parameter found: [createTrackingCodeOrderReturns.hasPermission]
>
> Unknown parameter found: [createTrackingCodeOrderReturns.responseMessage]
>
>
>
> when I clicked "Accept Return"
>
> What I did was:
>
> 1. Click "Order" tab, then check "Completed" and click submit.
>
> 2. Picked an existing completed order on DemoCustCust for one WG-1111
>
> 3. Clicked "Create Return" button 2/3rds down toward the right side.
>
> 4. Selected "Store Credit" from the drop down list for the item and two tax
> entries (0.00 each for the tax entries) then clicked "return selected
> items".
>
> 5. Checked the "Select All" box and clicked "Return Items"
>
> 6. Clicked the "Accept Return" button.
>
>
> Here is the relevant part of the stack trace:
>
> 2007-10-25 08:46:43,361 (http-0.0.0.0-8443-Processor2) [
> ModelService.java:484:ERROR] [ModelService.validate] :
> {createTrackingCodeOrderReturns} : (IN) Required test error:
> org.ofbiz.service.ServiceValidationException: Unknown parameter found:
> [createTrackingCodeOrderReturns.hasPermission]Unknown parameter found:
> [createTrackingCodeOrderReturns.responseMessage]
> 2007-10-25 08:46:43,371 (http-0.0.0.0-8443-Processor2) [
> ServiceDispatcher.java:355:ERROR]
> ---- exception
> report ----------------------------------------------------------
> Incoming context (in runSync : createTrackingCodeOrderReturns) does not
> match expected requirements
> Exception: org.ofbiz.service.ServiceValidationException
> Message: Unknown parameter found:
> [createTrackingCodeOrderReturns.hasPermission]Unknown parameter found:
> [createTrackingCodeOrderReturns.responseMessage]
> ---- stack
> trace ---------------------------------------------------------------
> org.ofbiz.service.ServiceValidationException: Unknown parameter found:
> [createTrackingCodeOrderReturns.hasPermission]Unknown parameter found:
> [createTrackingCodeOrderReturns.responseMessage]
> org.ofbiz.service.ModelService.validate(ModelService.java:552)
>
> -----Original Message-----
> From: Jacopo Cappellato [mailto:tiz@sastau.it]
> Sent: Thursday, October 25, 2007 1:54 AM
> To: user@ofbiz.apache.org
> Subject: Re: captureBillingAccountPayments
>
>
> skip@theDevers wrote:
>
>>Jacopo
>>
>>Makes perfect sense, in fact, its the almost perfect solution to my second
>>question. Lets say you sold 4 items on 4 days on 4 invoices. The
>
> customer
>
>>pays for all 4 invoices. Then, a week later, item 2 breaks and he sends
>
> it
>
>>back for a credit. The following week, he buys something else. Is there
>>some way for the credit to show up on the in sales order payment options?
>>Could the same logic be used?
>>
>
>
> Yes,
>
> the business logic is the following one (correct me if I am wrong):
>
> 1) a customer return is created for 2 items
> 2) you should select as the return type: "store credit" this will store
> (as a PaymentApplication) the credit to a billing account associated
> to the customer
> 3) the new amount will increase the available balance of the billing
> account (that can be used during order entry)
> This should work, but if you see something wrong please let us know.
>
> Jacopo
>
>
>
>>
>>Skip
>>
>>
>>-----Original Message-----
>>From: Jacopo Cappellato [mailto:tiz@sastau.it]
>>Sent: Thursday, October 25, 2007 1:23 AM
>>To: user@ofbiz.apache.org
>>Subject: Re: captureBillingAccountPayments
>>
>>
>>skip@theDevers wrote:
>>
>>>I am having a discussion with Si about billing accounts. For me,
>>>captureBillingAccountPayments works and the deprecated
>>>captureBillingAccountPayment does not.
>>>
>>>However, captureBillingAccountPayments essentially does nothing (which it
>>>the right thing to do in this case).
>>>
>>>My question is, what was the intent of the logic after the
>>>
>>>
>>> if (UtilValidate.isNotEmpty(paymentApplications)) {
>>>
>>>which for me is always empty and never gets executed.
>>>
>>>Can the author comment? Is there some case where this will contain
>>>paymentApplications?
>>>
>>>Skip
>>
>>Let's say you get a billing account and two not paid invoices associated
>>to it, one for 30$ and one for 50$.
>>You get a payment from your customer for 70$; you associate the whole
>>payment to the billing account: this will create a PaymentApplication
>>record with billingAccountId set, and a null invoiceId.
>>Then, if you go to the billing account's invoices screen and you click
>>on the "capture payments" link near to the 30$ invoice, then the
>>captureBillingAccountPayments service will be called -> the
>>PaymentApplication with null invoiceId (i.e. still not applied) is found
>>--> if (UtilValidate.isNotEmpty(paymentApplications)) is true -->
>>a new PaymentApplication is created for 30$ and applied to the invoice;
>>the original PaymentApplication is updated and the new 'available'
>>amount is 40$ (i.e. 70-30=40); we can now do the same with the otther
>>invoice...
>>At the end the first invoice will be PAID and the second PARTIALLY PAID.
>>
>>Does it make sense?
>>
>>Jacopo
>>
>>
>
>
>
>
RE: captureBillingAccountPayments
Posted by "skip@theDevers" <sk...@thedevers.org>.
Jacopo
Tried the create a store credit thing and got this error:
The Following Errors Occurred:
Unknown parameter found: [createTrackingCodeOrderReturns.hasPermission]
Unknown parameter found: [createTrackingCodeOrderReturns.responseMessage]
when I clicked "Accept Return"
What I did was:
1. Click "Order" tab, then check "Completed" and click submit.
2. Picked an existing completed order on DemoCustCust for one WG-1111
3. Clicked "Create Return" button 2/3rds down toward the right side.
4. Selected "Store Credit" from the drop down list for the item and two tax
entries (0.00 each for the tax entries) then clicked "return selected
items".
5. Checked the "Select All" box and clicked "Return Items"
6. Clicked the "Accept Return" button.
Here is the relevant part of the stack trace:
2007-10-25 08:46:43,361 (http-0.0.0.0-8443-Processor2) [
ModelService.java:484:ERROR] [ModelService.validate] :
{createTrackingCodeOrderReturns} : (IN) Required test error:
org.ofbiz.service.ServiceValidationException: Unknown parameter found:
[createTrackingCodeOrderReturns.hasPermission]Unknown parameter found:
[createTrackingCodeOrderReturns.responseMessage]
2007-10-25 08:46:43,371 (http-0.0.0.0-8443-Processor2) [
ServiceDispatcher.java:355:ERROR]
---- exception
report ----------------------------------------------------------
Incoming context (in runSync : createTrackingCodeOrderReturns) does not
match expected requirements
Exception: org.ofbiz.service.ServiceValidationException
Message: Unknown parameter found:
[createTrackingCodeOrderReturns.hasPermission]Unknown parameter found:
[createTrackingCodeOrderReturns.responseMessage]
---- stack
trace ---------------------------------------------------------------
org.ofbiz.service.ServiceValidationException: Unknown parameter found:
[createTrackingCodeOrderReturns.hasPermission]Unknown parameter found:
[createTrackingCodeOrderReturns.responseMessage]
org.ofbiz.service.ModelService.validate(ModelService.java:552)
-----Original Message-----
From: Jacopo Cappellato [mailto:tiz@sastau.it]
Sent: Thursday, October 25, 2007 1:54 AM
To: user@ofbiz.apache.org
Subject: Re: captureBillingAccountPayments
skip@theDevers wrote:
> Jacopo
>
> Makes perfect sense, in fact, its the almost perfect solution to my second
> question. Lets say you sold 4 items on 4 days on 4 invoices. The
customer
> pays for all 4 invoices. Then, a week later, item 2 breaks and he sends
it
> back for a credit. The following week, he buys something else. Is there
> some way for the credit to show up on the in sales order payment options?
> Could the same logic be used?
>
Yes,
the business logic is the following one (correct me if I am wrong):
1) a customer return is created for 2 items
2) you should select as the return type: "store credit" this will store
(as a PaymentApplication) the credit to a billing account associated
to the customer
3) the new amount will increase the available balance of the billing
account (that can be used during order entry)
This should work, but if you see something wrong please let us know.
Jacopo
>
>
> Skip
>
>
> -----Original Message-----
> From: Jacopo Cappellato [mailto:tiz@sastau.it]
> Sent: Thursday, October 25, 2007 1:23 AM
> To: user@ofbiz.apache.org
> Subject: Re: captureBillingAccountPayments
>
>
> skip@theDevers wrote:
>> I am having a discussion with Si about billing accounts. For me,
>> captureBillingAccountPayments works and the deprecated
>> captureBillingAccountPayment does not.
>>
>> However, captureBillingAccountPayments essentially does nothing (which it
>> the right thing to do in this case).
>>
>> My question is, what was the intent of the logic after the
>>
>>
>> if (UtilValidate.isNotEmpty(paymentApplications)) {
>>
>> which for me is always empty and never gets executed.
>>
>> Can the author comment? Is there some case where this will contain
>> paymentApplications?
>>
>> Skip
>
> Let's say you get a billing account and two not paid invoices associated
> to it, one for 30$ and one for 50$.
> You get a payment from your customer for 70$; you associate the whole
> payment to the billing account: this will create a PaymentApplication
> record with billingAccountId set, and a null invoiceId.
> Then, if you go to the billing account's invoices screen and you click
> on the "capture payments" link near to the 30$ invoice, then the
> captureBillingAccountPayments service will be called -> the
> PaymentApplication with null invoiceId (i.e. still not applied) is found
> --> if (UtilValidate.isNotEmpty(paymentApplications)) is true -->
> a new PaymentApplication is created for 30$ and applied to the invoice;
> the original PaymentApplication is updated and the new 'available'
> amount is 40$ (i.e. 70-30=40); we can now do the same with the otther
> invoice...
> At the end the first invoice will be PAID and the second PARTIALLY PAID.
>
> Does it make sense?
>
> Jacopo
>
>
RE: captureBillingAccountPayments
Posted by "skip@theDevers" <sk...@thedevers.org>.
No worries dude, you can still have it when I put it in Jira.
Skip
-----Original Message-----
From: Scott Gray [mailto:lektran@gmail.com]
Sent: Monday, October 29, 2007 10:31 PM
To: user@ofbiz.apache.org
Subject: Re: captureBillingAccountPayments
Ok sorry I'll clarify further it's legacy and I have no access to the
code, I'm no more than a user unfortunately.
Regards
Scott
On 30/10/2007, skip@theDevers <sk...@thedevers.org> wrote:
> BTW Scott, I am about a month away from writing a "Collections Agent" for
> use by AR people for collecting past due invoices and making notes about
> contacts and the like. Because of the complexity of this application,
I'll
> likely be doing it as a java application.
>
> If you want to collaborate by giving me your AR app as a base, I'll roll
> them together and give you back a single AR app that does both functions.
I
> would particularly like this if you have the freedom to contribute your
work
> to Jira, not that I would expect the Ofbiz management to take java apps,
but
> then again, maybe other would like it.
>
> Skip
>
> -----Original Message-----
> From: Scott Gray [mailto:lektran@gmail.com]
> Sent: Monday, October 29, 2007 9:47 PM
> To: user@ofbiz.apache.org
> Subject: Re: captureBillingAccountPayments
>
>
> Sorry I should have mentioned that it's a non-OFBiz system.
>
> Regards
> Scott
>
> On 30/10/2007, skip@theDevers <sk...@thedevers.org> wrote:
> > Scott
> >
> > I need the same services as you. This is for the case where the
customer
> > pays without specifying any invoices. If invoices are specified, you
> apply
> > the payment to individual invoices the way you do now.
> >
> > Your existing non-web based screen will not change (unless you want it
> to).
> > There will just be another service to call to apply the payment as if
you
> > had selected the invoices beginning with the oldest first.
> >
> > Also, what do you do now if the customer overpays?
> >
> > Skip
> >
> > -----Original Message-----
> > From: Scott Gray [mailto:lektran@gmail.com]
> > Sent: Monday, October 29, 2007 12:23 AM
> > To: user@ofbiz.apache.org
> > Subject: Re: captureBillingAccountPayments
> >
> >
> > Hi Jacopo
> >
> > Our customers generally make payments for a specific invoice or group
> > of invoices so this wouldn't work for us. In our current system (non
> > web UI) we log a payment and then use a screen with a list of open
> > invoices to allocate the payment with the payment balance reducing as
> > each invoice is selected.
> >
> > Regards
> > Scott
> >
> > On 29/10/2007, Jacopo Cappellato <ti...@sastau.it> wrote:
> > > skip@theDevers wrote:
> > > > Jacopo
> > > >
> > > > As the man with the plan,
> > >
> > > uhm... me? :-)
> > >
> > > > I wanted to throw this new plan past you. I have
> > > > dug pretty deeply into the existing payment/billing account stuff
and
> > it
> > > > all seems a bit arcane to me and mostly because it looks like
payments
> > are
> > > > meant to be made from the company to a vendor and from a customer to
> the
> > > > company, all with the same screens.
> > > >
> > > > I want to create a really easy to use AR payment system. The user
> > enters a
> > > > payment and can then either apply the payment to individual invoices
> > (and a
> > > > store credit if too much is received) or he can apply it to the
> billing
> > > > account, in which case we automatically apply it to the oldest
> invoices
> > > > first and then to a credit if too much is received.
> > > >
> > >
> > > I'd suggest the following subtasks:
> > >
> > > a) implement a new service to automatically apply the payments
> > > associated to a billing account to the older open invoices associated
to
> > > the same account; the new service will have one mandatory parameter
> > > "billingAccountId" (and maybe one optional parameter "paymentId") and
it
> > > will:
> > > - select the open invoices associated to the billing account and sort
> > > them by date (older first)
> > > - iterate on the list and for each of them call the service
> > > capturePaymentsByInvoice passing in the invoice id and
billingAccountId
> > > (this is the service that is invoked when you click on the "capture"
> > > link near the invoice in the billingaccoun-invoices screen)
> > >
> > > b) the new service can be invoked by a new link ("apply payments to
> > > invoices") at the top of the billing account->invoices screen or
(maybe
> > > in your custom application) triggered every time you associate a
payment
> > > to a billing account.
> > >
> > > This should cover your requirements but it is also generic enough to
be
> > > a good fit for OFBiz.
> > >
> > > What do you think?
> > >
> > > Jacopo
> > >
> > > > Is this too simplistic for some reason I am missing? Do others have
> AR
> > > > needs outside this that would justify a more complicated transaction
> > set?
> > > >
> > > > Skip
> > >
> > >
> > >
> >
> >
>
>
Re: captureBillingAccountPayments
Posted by Scott Gray <le...@gmail.com>.
Ok sorry I'll clarify further it's legacy and I have no access to the
code, I'm no more than a user unfortunately.
Regards
Scott
On 30/10/2007, skip@theDevers <sk...@thedevers.org> wrote:
> BTW Scott, I am about a month away from writing a "Collections Agent" for
> use by AR people for collecting past due invoices and making notes about
> contacts and the like. Because of the complexity of this application, I'll
> likely be doing it as a java application.
>
> If you want to collaborate by giving me your AR app as a base, I'll roll
> them together and give you back a single AR app that does both functions. I
> would particularly like this if you have the freedom to contribute your work
> to Jira, not that I would expect the Ofbiz management to take java apps, but
> then again, maybe other would like it.
>
> Skip
>
> -----Original Message-----
> From: Scott Gray [mailto:lektran@gmail.com]
> Sent: Monday, October 29, 2007 9:47 PM
> To: user@ofbiz.apache.org
> Subject: Re: captureBillingAccountPayments
>
>
> Sorry I should have mentioned that it's a non-OFBiz system.
>
> Regards
> Scott
>
> On 30/10/2007, skip@theDevers <sk...@thedevers.org> wrote:
> > Scott
> >
> > I need the same services as you. This is for the case where the customer
> > pays without specifying any invoices. If invoices are specified, you
> apply
> > the payment to individual invoices the way you do now.
> >
> > Your existing non-web based screen will not change (unless you want it
> to).
> > There will just be another service to call to apply the payment as if you
> > had selected the invoices beginning with the oldest first.
> >
> > Also, what do you do now if the customer overpays?
> >
> > Skip
> >
> > -----Original Message-----
> > From: Scott Gray [mailto:lektran@gmail.com]
> > Sent: Monday, October 29, 2007 12:23 AM
> > To: user@ofbiz.apache.org
> > Subject: Re: captureBillingAccountPayments
> >
> >
> > Hi Jacopo
> >
> > Our customers generally make payments for a specific invoice or group
> > of invoices so this wouldn't work for us. In our current system (non
> > web UI) we log a payment and then use a screen with a list of open
> > invoices to allocate the payment with the payment balance reducing as
> > each invoice is selected.
> >
> > Regards
> > Scott
> >
> > On 29/10/2007, Jacopo Cappellato <ti...@sastau.it> wrote:
> > > skip@theDevers wrote:
> > > > Jacopo
> > > >
> > > > As the man with the plan,
> > >
> > > uhm... me? :-)
> > >
> > > > I wanted to throw this new plan past you. I have
> > > > dug pretty deeply into the existing payment/billing account stuff and
> > it
> > > > all seems a bit arcane to me and mostly because it looks like payments
> > are
> > > > meant to be made from the company to a vendor and from a customer to
> the
> > > > company, all with the same screens.
> > > >
> > > > I want to create a really easy to use AR payment system. The user
> > enters a
> > > > payment and can then either apply the payment to individual invoices
> > (and a
> > > > store credit if too much is received) or he can apply it to the
> billing
> > > > account, in which case we automatically apply it to the oldest
> invoices
> > > > first and then to a credit if too much is received.
> > > >
> > >
> > > I'd suggest the following subtasks:
> > >
> > > a) implement a new service to automatically apply the payments
> > > associated to a billing account to the older open invoices associated to
> > > the same account; the new service will have one mandatory parameter
> > > "billingAccountId" (and maybe one optional parameter "paymentId") and it
> > > will:
> > > - select the open invoices associated to the billing account and sort
> > > them by date (older first)
> > > - iterate on the list and for each of them call the service
> > > capturePaymentsByInvoice passing in the invoice id and billingAccountId
> > > (this is the service that is invoked when you click on the "capture"
> > > link near the invoice in the billingaccoun-invoices screen)
> > >
> > > b) the new service can be invoked by a new link ("apply payments to
> > > invoices") at the top of the billing account->invoices screen or (maybe
> > > in your custom application) triggered every time you associate a payment
> > > to a billing account.
> > >
> > > This should cover your requirements but it is also generic enough to be
> > > a good fit for OFBiz.
> > >
> > > What do you think?
> > >
> > > Jacopo
> > >
> > > > Is this too simplistic for some reason I am missing? Do others have
> AR
> > > > needs outside this that would justify a more complicated transaction
> > set?
> > > >
> > > > Skip
> > >
> > >
> > >
> >
> >
>
>
RE: captureBillingAccountPayments
Posted by "skip@theDevers" <sk...@thedevers.org>.
BTW Scott, I am about a month away from writing a "Collections Agent" for
use by AR people for collecting past due invoices and making notes about
contacts and the like. Because of the complexity of this application, I'll
likely be doing it as a java application.
If you want to collaborate by giving me your AR app as a base, I'll roll
them together and give you back a single AR app that does both functions. I
would particularly like this if you have the freedom to contribute your work
to Jira, not that I would expect the Ofbiz management to take java apps, but
then again, maybe other would like it.
Skip
-----Original Message-----
From: Scott Gray [mailto:lektran@gmail.com]
Sent: Monday, October 29, 2007 9:47 PM
To: user@ofbiz.apache.org
Subject: Re: captureBillingAccountPayments
Sorry I should have mentioned that it's a non-OFBiz system.
Regards
Scott
On 30/10/2007, skip@theDevers <sk...@thedevers.org> wrote:
> Scott
>
> I need the same services as you. This is for the case where the customer
> pays without specifying any invoices. If invoices are specified, you
apply
> the payment to individual invoices the way you do now.
>
> Your existing non-web based screen will not change (unless you want it
to).
> There will just be another service to call to apply the payment as if you
> had selected the invoices beginning with the oldest first.
>
> Also, what do you do now if the customer overpays?
>
> Skip
>
> -----Original Message-----
> From: Scott Gray [mailto:lektran@gmail.com]
> Sent: Monday, October 29, 2007 12:23 AM
> To: user@ofbiz.apache.org
> Subject: Re: captureBillingAccountPayments
>
>
> Hi Jacopo
>
> Our customers generally make payments for a specific invoice or group
> of invoices so this wouldn't work for us. In our current system (non
> web UI) we log a payment and then use a screen with a list of open
> invoices to allocate the payment with the payment balance reducing as
> each invoice is selected.
>
> Regards
> Scott
>
> On 29/10/2007, Jacopo Cappellato <ti...@sastau.it> wrote:
> > skip@theDevers wrote:
> > > Jacopo
> > >
> > > As the man with the plan,
> >
> > uhm... me? :-)
> >
> > > I wanted to throw this new plan past you. I have
> > > dug pretty deeply into the existing payment/billing account stuff and
> it
> > > all seems a bit arcane to me and mostly because it looks like payments
> are
> > > meant to be made from the company to a vendor and from a customer to
the
> > > company, all with the same screens.
> > >
> > > I want to create a really easy to use AR payment system. The user
> enters a
> > > payment and can then either apply the payment to individual invoices
> (and a
> > > store credit if too much is received) or he can apply it to the
billing
> > > account, in which case we automatically apply it to the oldest
invoices
> > > first and then to a credit if too much is received.
> > >
> >
> > I'd suggest the following subtasks:
> >
> > a) implement a new service to automatically apply the payments
> > associated to a billing account to the older open invoices associated to
> > the same account; the new service will have one mandatory parameter
> > "billingAccountId" (and maybe one optional parameter "paymentId") and it
> > will:
> > - select the open invoices associated to the billing account and sort
> > them by date (older first)
> > - iterate on the list and for each of them call the service
> > capturePaymentsByInvoice passing in the invoice id and billingAccountId
> > (this is the service that is invoked when you click on the "capture"
> > link near the invoice in the billingaccoun-invoices screen)
> >
> > b) the new service can be invoked by a new link ("apply payments to
> > invoices") at the top of the billing account->invoices screen or (maybe
> > in your custom application) triggered every time you associate a payment
> > to a billing account.
> >
> > This should cover your requirements but it is also generic enough to be
> > a good fit for OFBiz.
> >
> > What do you think?
> >
> > Jacopo
> >
> > > Is this too simplistic for some reason I am missing? Do others have
AR
> > > needs outside this that would justify a more complicated transaction
> set?
> > >
> > > Skip
> >
> >
> >
>
>
Re: captureBillingAccountPayments
Posted by Scott Gray <le...@gmail.com>.
Sorry I should have mentioned that it's a non-OFBiz system.
Regards
Scott
On 30/10/2007, skip@theDevers <sk...@thedevers.org> wrote:
> Scott
>
> I need the same services as you. This is for the case where the customer
> pays without specifying any invoices. If invoices are specified, you apply
> the payment to individual invoices the way you do now.
>
> Your existing non-web based screen will not change (unless you want it to).
> There will just be another service to call to apply the payment as if you
> had selected the invoices beginning with the oldest first.
>
> Also, what do you do now if the customer overpays?
>
> Skip
>
> -----Original Message-----
> From: Scott Gray [mailto:lektran@gmail.com]
> Sent: Monday, October 29, 2007 12:23 AM
> To: user@ofbiz.apache.org
> Subject: Re: captureBillingAccountPayments
>
>
> Hi Jacopo
>
> Our customers generally make payments for a specific invoice or group
> of invoices so this wouldn't work for us. In our current system (non
> web UI) we log a payment and then use a screen with a list of open
> invoices to allocate the payment with the payment balance reducing as
> each invoice is selected.
>
> Regards
> Scott
>
> On 29/10/2007, Jacopo Cappellato <ti...@sastau.it> wrote:
> > skip@theDevers wrote:
> > > Jacopo
> > >
> > > As the man with the plan,
> >
> > uhm... me? :-)
> >
> > > I wanted to throw this new plan past you. I have
> > > dug pretty deeply into the existing payment/billing account stuff and
> it
> > > all seems a bit arcane to me and mostly because it looks like payments
> are
> > > meant to be made from the company to a vendor and from a customer to the
> > > company, all with the same screens.
> > >
> > > I want to create a really easy to use AR payment system. The user
> enters a
> > > payment and can then either apply the payment to individual invoices
> (and a
> > > store credit if too much is received) or he can apply it to the billing
> > > account, in which case we automatically apply it to the oldest invoices
> > > first and then to a credit if too much is received.
> > >
> >
> > I'd suggest the following subtasks:
> >
> > a) implement a new service to automatically apply the payments
> > associated to a billing account to the older open invoices associated to
> > the same account; the new service will have one mandatory parameter
> > "billingAccountId" (and maybe one optional parameter "paymentId") and it
> > will:
> > - select the open invoices associated to the billing account and sort
> > them by date (older first)
> > - iterate on the list and for each of them call the service
> > capturePaymentsByInvoice passing in the invoice id and billingAccountId
> > (this is the service that is invoked when you click on the "capture"
> > link near the invoice in the billingaccoun-invoices screen)
> >
> > b) the new service can be invoked by a new link ("apply payments to
> > invoices") at the top of the billing account->invoices screen or (maybe
> > in your custom application) triggered every time you associate a payment
> > to a billing account.
> >
> > This should cover your requirements but it is also generic enough to be
> > a good fit for OFBiz.
> >
> > What do you think?
> >
> > Jacopo
> >
> > > Is this too simplistic for some reason I am missing? Do others have AR
> > > needs outside this that would justify a more complicated transaction
> set?
> > >
> > > Skip
> >
> >
> >
>
>
Re: captureBillingAccountPayments
Posted by Jacques Le Roux <ja...@les7arts.com>.
Hi Skip, Jacopo, Scott,
IMHO this kind of threads should better be in dev ML
Thanks
Jacques
PS : thanks Jacopo for the fix on ShippingEvents.java
De : "Jacopo Cappellato" <ti...@sastau.it>
> Hi Scott,
>
> Scott Gray wrote:
> > Hi Jacopo
> >
> > Our customers generally make payments for a specific invoice or group
> > of invoices so this wouldn't work for us. In our current system (non
> > web UI) we log a payment and then use a screen with a list of open
> > invoices to allocate the payment with the payment balance reducing as
> > each invoice is selected.
> >
>
> I think that you have perfectly described what is currently implemented
> in OFbiz :-)
> Maybe I'm not been very clear on this: I was not suggesting to modify
> the existing payment/payment application screens; instead I was
> suggesting to add a new option, for billing accounts, to apply billing
> account payments to billing account invoices by date; of course you can
> continue, also in the billing account, to apply payments to specific
> invoices.
>
> Cheers,
>
> Jacopo
>
>
> > Regards
> > Scott
> >
> > On 29/10/2007, Jacopo Cappellato <ti...@sastau.it> wrote:
> >> skip@theDevers wrote:
> >>> Jacopo
> >>>
> >>> As the man with the plan,
> >> uhm... me? :-)
> >>
> >>> I wanted to throw this new plan past you. I have
> >>> dug pretty deeply into the existing payment/billing account stuff and it
> >>> all seems a bit arcane to me and mostly because it looks like payments are
> >>> meant to be made from the company to a vendor and from a customer to the
> >>> company, all with the same screens.
> >>>
> >>> I want to create a really easy to use AR payment system. The user enters a
> >>> payment and can then either apply the payment to individual invoices (and a
> >>> store credit if too much is received) or he can apply it to the billing
> >>> account, in which case we automatically apply it to the oldest invoices
> >>> first and then to a credit if too much is received.
> >>>
> >> I'd suggest the following subtasks:
> >>
> >> a) implement a new service to automatically apply the payments
> >> associated to a billing account to the older open invoices associated to
> >> the same account; the new service will have one mandatory parameter
> >> "billingAccountId" (and maybe one optional parameter "paymentId") and it
> >> will:
> >> - select the open invoices associated to the billing account and sort
> >> them by date (older first)
> >> - iterate on the list and for each of them call the service
> >> capturePaymentsByInvoice passing in the invoice id and billingAccountId
> >> (this is the service that is invoked when you click on the "capture"
> >> link near the invoice in the billingaccoun-invoices screen)
> >>
> >> b) the new service can be invoked by a new link ("apply payments to
> >> invoices") at the top of the billing account->invoices screen or (maybe
> >> in your custom application) triggered every time you associate a payment
> >> to a billing account.
> >>
> >> This should cover your requirements but it is also generic enough to be
> >> a good fit for OFBiz.
> >>
> >> What do you think?
> >>
> >> Jacopo
> >>
> >>> Is this too simplistic for some reason I am missing? Do others have AR
> >>> needs outside this that would justify a more complicated transaction set?
> >>>
> >>> Skip
> >>
> >>
>
>
Re: captureBillingAccountPayments
Posted by Scott Gray <le...@gmail.com>.
Lol ok sorry, I've never actually worked on the billing account stuff
so I have no idea whats currently in place. Nice work whoever did it
:-)
Scott
On 29/10/2007, Jacopo Cappellato <ti...@sastau.it> wrote:
> Hi Scott,
>
> Scott Gray wrote:
> > Hi Jacopo
> >
> > Our customers generally make payments for a specific invoice or group
> > of invoices so this wouldn't work for us. In our current system (non
> > web UI) we log a payment and then use a screen with a list of open
> > invoices to allocate the payment with the payment balance reducing as
> > each invoice is selected.
> >
>
> I think that you have perfectly described what is currently implemented
> in OFbiz :-)
> Maybe I'm not been very clear on this: I was not suggesting to modify
> the existing payment/payment application screens; instead I was
> suggesting to add a new option, for billing accounts, to apply billing
> account payments to billing account invoices by date; of course you can
> continue, also in the billing account, to apply payments to specific
> invoices.
>
> Cheers,
>
> Jacopo
>
>
> > Regards
> > Scott
> >
> > On 29/10/2007, Jacopo Cappellato <ti...@sastau.it> wrote:
> >> skip@theDevers wrote:
> >>> Jacopo
> >>>
> >>> As the man with the plan,
> >> uhm... me? :-)
> >>
> >>> I wanted to throw this new plan past you. I have
> >>> dug pretty deeply into the existing payment/billing account stuff and it
> >>> all seems a bit arcane to me and mostly because it looks like payments are
> >>> meant to be made from the company to a vendor and from a customer to the
> >>> company, all with the same screens.
> >>>
> >>> I want to create a really easy to use AR payment system. The user enters a
> >>> payment and can then either apply the payment to individual invoices (and a
> >>> store credit if too much is received) or he can apply it to the billing
> >>> account, in which case we automatically apply it to the oldest invoices
> >>> first and then to a credit if too much is received.
> >>>
> >> I'd suggest the following subtasks:
> >>
> >> a) implement a new service to automatically apply the payments
> >> associated to a billing account to the older open invoices associated to
> >> the same account; the new service will have one mandatory parameter
> >> "billingAccountId" (and maybe one optional parameter "paymentId") and it
> >> will:
> >> - select the open invoices associated to the billing account and sort
> >> them by date (older first)
> >> - iterate on the list and for each of them call the service
> >> capturePaymentsByInvoice passing in the invoice id and billingAccountId
> >> (this is the service that is invoked when you click on the "capture"
> >> link near the invoice in the billingaccoun-invoices screen)
> >>
> >> b) the new service can be invoked by a new link ("apply payments to
> >> invoices") at the top of the billing account->invoices screen or (maybe
> >> in your custom application) triggered every time you associate a payment
> >> to a billing account.
> >>
> >> This should cover your requirements but it is also generic enough to be
> >> a good fit for OFBiz.
> >>
> >> What do you think?
> >>
> >> Jacopo
> >>
> >>> Is this too simplistic for some reason I am missing? Do others have AR
> >>> needs outside this that would justify a more complicated transaction set?
> >>>
> >>> Skip
> >>
> >>
>
>
>
Re: captureBillingAccountPayments
Posted by Jacopo Cappellato <ti...@sastau.it>.
Hi Scott,
Scott Gray wrote:
> Hi Jacopo
>
> Our customers generally make payments for a specific invoice or group
> of invoices so this wouldn't work for us. In our current system (non
> web UI) we log a payment and then use a screen with a list of open
> invoices to allocate the payment with the payment balance reducing as
> each invoice is selected.
>
I think that you have perfectly described what is currently implemented
in OFbiz :-)
Maybe I'm not been very clear on this: I was not suggesting to modify
the existing payment/payment application screens; instead I was
suggesting to add a new option, for billing accounts, to apply billing
account payments to billing account invoices by date; of course you can
continue, also in the billing account, to apply payments to specific
invoices.
Cheers,
Jacopo
> Regards
> Scott
>
> On 29/10/2007, Jacopo Cappellato <ti...@sastau.it> wrote:
>> skip@theDevers wrote:
>>> Jacopo
>>>
>>> As the man with the plan,
>> uhm... me? :-)
>>
>>> I wanted to throw this new plan past you. I have
>>> dug pretty deeply into the existing payment/billing account stuff and it
>>> all seems a bit arcane to me and mostly because it looks like payments are
>>> meant to be made from the company to a vendor and from a customer to the
>>> company, all with the same screens.
>>>
>>> I want to create a really easy to use AR payment system. The user enters a
>>> payment and can then either apply the payment to individual invoices (and a
>>> store credit if too much is received) or he can apply it to the billing
>>> account, in which case we automatically apply it to the oldest invoices
>>> first and then to a credit if too much is received.
>>>
>> I'd suggest the following subtasks:
>>
>> a) implement a new service to automatically apply the payments
>> associated to a billing account to the older open invoices associated to
>> the same account; the new service will have one mandatory parameter
>> "billingAccountId" (and maybe one optional parameter "paymentId") and it
>> will:
>> - select the open invoices associated to the billing account and sort
>> them by date (older first)
>> - iterate on the list and for each of them call the service
>> capturePaymentsByInvoice passing in the invoice id and billingAccountId
>> (this is the service that is invoked when you click on the "capture"
>> link near the invoice in the billingaccoun-invoices screen)
>>
>> b) the new service can be invoked by a new link ("apply payments to
>> invoices") at the top of the billing account->invoices screen or (maybe
>> in your custom application) triggered every time you associate a payment
>> to a billing account.
>>
>> This should cover your requirements but it is also generic enough to be
>> a good fit for OFBiz.
>>
>> What do you think?
>>
>> Jacopo
>>
>>> Is this too simplistic for some reason I am missing? Do others have AR
>>> needs outside this that would justify a more complicated transaction set?
>>>
>>> Skip
>>
>>
Backorder Question
Posted by "skip@theDevers" <sk...@thedevers.org>.
Can anyone tell me how to create a backorder? I created an order for 1
GZ-1001 and 1 WG-1111. Because there are no GZ-1001s, I expected to find a
Requirement created but did not in spite of the fact that the Order sez [1
Backordered].
Also, are there other entities involved besides Requirement?
Skip
RE: Billing Accounts
Posted by "skip@theDevers" <sk...@thedevers.org>.
Yep, already got this done, except that it also provides a list of payments
in the statement period. Just gotta check this all out with a few returns
and stuff to make sure it all works.
Thanks for all your help BTW in case I forgot to say it before.
Skip
-----Original Message-----
From: Jacopo Cappellato [mailto:tiz@sastau.it]
Sent: Monday, October 29, 2007 10:26 PM
To: user@ofbiz.apache.org
Subject: Re: Billing Accounts
Sorry,
I've missed the following statement:
skip@theDevers wrote:
>
> I am thinking of re-writing the getBillingAccountNetBalance() to use
> Invoice because that, along with Payment is the basis for statements sent
to
> customers and it makes sense to me from a data consistancy standpoint.
>
Wouldn't be better to provide a report to the customer about the balance
of a billing account with the following information:
==== billing account id (and other info) ====
account limit
* list of open invoices associated to the account with outstanding amount
* total outstanding amount
* difference between account limit and total outstanding amount
(optionally you could also include the list of unapplied payments, if any).
Of course you can create a new helper method in the BillingAccountWorker
class to help you to run the total, but it is important to use this only
for reporting purposes (and maybe it is easier to run the total directly
in your report); the reasons are in my last email.
Jacopo
Re: Billing Accounts
Posted by Jacopo Cappellato <ti...@sastau.it>.
Sorry,
I've missed the following statement:
skip@theDevers wrote:
>
> I am thinking of re-writing the getBillingAccountNetBalance() to use
> Invoice because that, along with Payment is the basis for statements sent to
> customers and it makes sense to me from a data consistancy standpoint.
>
Wouldn't be better to provide a report to the customer about the balance
of a billing account with the following information:
==== billing account id (and other info) ====
account limit
* list of open invoices associated to the account with outstanding amount
* total outstanding amount
* difference between account limit and total outstanding amount
(optionally you could also include the list of unapplied payments, if any).
Of course you can create a new helper method in the BillingAccountWorker
class to help you to run the total, but it is important to use this only
for reporting purposes (and maybe it is easier to run the total directly
in your report); the reasons are in my last email.
Jacopo
RE: Billing Accounts
Posted by "skip@theDevers" <sk...@thedevers.org>.
Hmmm, now I am beginning to understand why Si wants to make a
PaymentApplication when an invoice is created. Both are "messy", but I
guess I like your way better.
I was just thinking of using the delta of OrderItem and OrderItemBilling,
but, because this value is only used in an advisory capacity, maybe getting
too clever isn't justified. But I am gonna think on it some more.
Skip
-----Original Message-----
From: Jacopo Cappellato [mailto:tiz@sastau.it]
Sent: Monday, October 29, 2007 10:17 PM
To: user@ofbiz.apache.org
Subject: Re: Billing Accounts
Hi Skip,
skip@theDevers wrote:
> Hi Jacopo
>
> I have two questions concerning billing accounts. Account balances are
> computed in BillingAccountWorker.getBillingAccountBalance(). This routine
> uses an algorithm that subtracts the sum of
OrderPaymentPreference.maxAmount
> where the statusId is "PAYMENT_NOT_RECEIVED" (and a few others).
>
> What I am wondering is why this entity was chosen over the sum of Invoices
> outstanding which to me makes more sense. Maybe this way is faster?
>
Actually, that was the initial plan. Unfortunately, when you create an
order, and the customer asks to 'pay' it with a billing account we have
to consider this and adjust the billing account balance immediately (if
not, the customer could enter a lot of orders exceeding the billing
account credit/limit) ... but there is still no invoice for the order
(that is created when the order is shipped).
>
> Second, in the same file is getBillingAccountNetBalance() which returns
the
> sum of PaymentApplication. The comment sez this "Calculates the net
balance
> of a billing account, which is sum of all amounts applied to invoices
minus
> sum of all amounts applied from payments". If you write an order against
a
> BillingAccount, PaymentApplication is empty after an invoice is created,
so
> I don't see the value of this function. Maybe I am misinterpreting the
name
> "getBillingAccountNetBalance". However, getBillingAccountAvailableBalance
> returns the billing account limit - getBillingAccountNetBalance, so I
would
> have thought that getBillingAccountBalance() would =
> getBillingAccountAvailableBalance if there are no uninvoiced Orders.
Many of the methods in that class were created before the last
refactoring of the billing accounts and they will be removed soon: sorry
for the confusion. If I well remember there is only one balance method
that is still valid, all the other ones are deprecated.
Jacopo
>
> Note that I see that getBillingAccountAvailableBalance is commented out
in
> the one place it is used in favor of getBillingAccountBalance().
>
> I am thinking of re-writing the getBillingAccountNetBalance() to use
> Invoice because that, along with Payment is the basis for statements sent
to
> customers and it makes sense to me from a data consistancy standpoint.
>
> Am I barking up the wrong tree?
>
> Skip
>
Re: Billing Accounts
Posted by Jacopo Cappellato <ti...@sastau.it>.
Hi Skip,
skip@theDevers wrote:
> Hi Jacopo
>
> I have two questions concerning billing accounts. Account balances are
> computed in BillingAccountWorker.getBillingAccountBalance(). This routine
> uses an algorithm that subtracts the sum of OrderPaymentPreference.maxAmount
> where the statusId is "PAYMENT_NOT_RECEIVED" (and a few others).
>
> What I am wondering is why this entity was chosen over the sum of Invoices
> outstanding which to me makes more sense. Maybe this way is faster?
>
Actually, that was the initial plan. Unfortunately, when you create an
order, and the customer asks to 'pay' it with a billing account we have
to consider this and adjust the billing account balance immediately (if
not, the customer could enter a lot of orders exceeding the billing
account credit/limit) ... but there is still no invoice for the order
(that is created when the order is shipped).
>
> Second, in the same file is getBillingAccountNetBalance() which returns the
> sum of PaymentApplication. The comment sez this "Calculates the net balance
> of a billing account, which is sum of all amounts applied to invoices minus
> sum of all amounts applied from payments". If you write an order against a
> BillingAccount, PaymentApplication is empty after an invoice is created, so
> I don't see the value of this function. Maybe I am misinterpreting the name
> "getBillingAccountNetBalance". However, getBillingAccountAvailableBalance
> returns the billing account limit - getBillingAccountNetBalance, so I would
> have thought that getBillingAccountBalance() would =
> getBillingAccountAvailableBalance if there are no uninvoiced Orders.
Many of the methods in that class were created before the last
refactoring of the billing accounts and they will be removed soon: sorry
for the confusion. If I well remember there is only one balance method
that is still valid, all the other ones are deprecated.
Jacopo
>
> Note that I see that getBillingAccountAvailableBalance is commented out in
> the one place it is used in favor of getBillingAccountBalance().
>
> I am thinking of re-writing the getBillingAccountNetBalance() to use
> Invoice because that, along with Payment is the basis for statements sent to
> customers and it makes sense to me from a data consistancy standpoint.
>
> Am I barking up the wrong tree?
>
> Skip
>
Billing Accounts
Posted by "skip@theDevers" <sk...@thedevers.org>.
Hi Jacopo
I have two questions concerning billing accounts. Account balances are
computed in BillingAccountWorker.getBillingAccountBalance(). This routine
uses an algorithm that subtracts the sum of OrderPaymentPreference.maxAmount
where the statusId is "PAYMENT_NOT_RECEIVED" (and a few others).
What I am wondering is why this entity was chosen over the sum of Invoices
outstanding which to me makes more sense. Maybe this way is faster?
Second, in the same file is getBillingAccountNetBalance() which returns the
sum of PaymentApplication. The comment sez this "Calculates the net balance
of a billing account, which is sum of all amounts applied to invoices minus
sum of all amounts applied from payments". If you write an order against a
BillingAccount, PaymentApplication is empty after an invoice is created, so
I don't see the value of this function. Maybe I am misinterpreting the name
"getBillingAccountNetBalance". However, getBillingAccountAvailableBalance
returns the billing account limit - getBillingAccountNetBalance, so I would
have thought that getBillingAccountBalance() would =
getBillingAccountAvailableBalance if there are no uninvoiced Orders.
Note that I see that getBillingAccountAvailableBalance is commented out in
the one place it is used in favor of getBillingAccountBalance().
I am thinking of re-writing the getBillingAccountNetBalance() to use
Invoice because that, along with Payment is the basis for statements sent to
customers and it makes sense to me from a data consistancy standpoint.
Am I barking up the wrong tree?
Skip
RE: captureBillingAccountPayments
Posted by "skip@theDevers" <sk...@thedevers.org>.
Scott
I need the same services as you. This is for the case where the customer
pays without specifying any invoices. If invoices are specified, you apply
the payment to individual invoices the way you do now.
Your existing non-web based screen will not change (unless you want it to).
There will just be another service to call to apply the payment as if you
had selected the invoices beginning with the oldest first.
Also, what do you do now if the customer overpays?
Skip
-----Original Message-----
From: Scott Gray [mailto:lektran@gmail.com]
Sent: Monday, October 29, 2007 12:23 AM
To: user@ofbiz.apache.org
Subject: Re: captureBillingAccountPayments
Hi Jacopo
Our customers generally make payments for a specific invoice or group
of invoices so this wouldn't work for us. In our current system (non
web UI) we log a payment and then use a screen with a list of open
invoices to allocate the payment with the payment balance reducing as
each invoice is selected.
Regards
Scott
On 29/10/2007, Jacopo Cappellato <ti...@sastau.it> wrote:
> skip@theDevers wrote:
> > Jacopo
> >
> > As the man with the plan,
>
> uhm... me? :-)
>
> > I wanted to throw this new plan past you. I have
> > dug pretty deeply into the existing payment/billing account stuff and
it
> > all seems a bit arcane to me and mostly because it looks like payments
are
> > meant to be made from the company to a vendor and from a customer to the
> > company, all with the same screens.
> >
> > I want to create a really easy to use AR payment system. The user
enters a
> > payment and can then either apply the payment to individual invoices
(and a
> > store credit if too much is received) or he can apply it to the billing
> > account, in which case we automatically apply it to the oldest invoices
> > first and then to a credit if too much is received.
> >
>
> I'd suggest the following subtasks:
>
> a) implement a new service to automatically apply the payments
> associated to a billing account to the older open invoices associated to
> the same account; the new service will have one mandatory parameter
> "billingAccountId" (and maybe one optional parameter "paymentId") and it
> will:
> - select the open invoices associated to the billing account and sort
> them by date (older first)
> - iterate on the list and for each of them call the service
> capturePaymentsByInvoice passing in the invoice id and billingAccountId
> (this is the service that is invoked when you click on the "capture"
> link near the invoice in the billingaccoun-invoices screen)
>
> b) the new service can be invoked by a new link ("apply payments to
> invoices") at the top of the billing account->invoices screen or (maybe
> in your custom application) triggered every time you associate a payment
> to a billing account.
>
> This should cover your requirements but it is also generic enough to be
> a good fit for OFBiz.
>
> What do you think?
>
> Jacopo
>
> > Is this too simplistic for some reason I am missing? Do others have AR
> > needs outside this that would justify a more complicated transaction
set?
> >
> > Skip
>
>
>
Re: Store Credits creating a new billing account
Posted by Jacques Le Roux <ja...@les7arts.com>.
De : "skip@theDevers" <sk...@thedevers.org>
> If you create an Order and ship it to DemoCustCompany on a billing account,
> then do a store credit refund, you end up with a second billing account
> created to which the refund is posted (PaymentApplication and the like).
>
> I think this is an error. I think the ReturnHeader should be created with
> the same billingAccountId as the OrderHeader had. However, it is not, it is
> created with a blank billingAccountId.
>
> I am wondering if the author would comment as to whether or not this was
> intentional (the creation of a second billing account for store credits) and
> if so, what was the thinking?
I agree, this sounds weird
Jacques
> Skip
>
Store Credits creating a new billing account
Posted by "skip@theDevers" <sk...@thedevers.org>.
If you create an Order and ship it to DemoCustCompany on a billing account,
then do a store credit refund, you end up with a second billing account
created to which the refund is posted (PaymentApplication and the like).
I think this is an error. I think the ReturnHeader should be created with
the same billingAccountId as the OrderHeader had. However, it is not, it is
created with a blank billingAccountId.
I am wondering if the author would comment as to whether or not this was
intentional (the creation of a second billing account for store credits) and
if so, what was the thinking?
Skip
Re: Automatic Backorders?
Posted by BJ Freeman <bj...@free-man.net>.
Skip:
I am converting what I did to using SECAS.
i will be putting this in the Jiras I have
welcome any input on there use.
https://issues.apache.org/jira/browse/OFBIZ-1286
is the main one.
skip@theDevers sent the following on 10/31/2007 2:20 PM:
> Not having much luck here. I set the minimum stock on hand for a GZ-1001 to
> 0 and re-order quantity to 5. Sold some more (putting the ATP at -8), but
> nothing I could detect happened. So, I went to Manufacturing->MRP and ran
> it for the Web Store. Nothing that I can detect happened.
>
> Can someone tell me how to write an order with a backorder on it and then
> have a purchase order written so that when it is received, the shipping
> clerk knows the item belongs to an order? Maybe this is some new code I
> need to write?
>
> Skip
>
> -----Original Message-----
> From: Scott Gray [mailto:lektran@gmail.com]
> Sent: Wednesday, October 31, 2007 2:10 PM
> To: user@ofbiz.apache.org
> Subject: Re: Automatic Backorders?
>
>
> You need to set the details in Product -> Facilities, even then I'm
> not sure if it happens automatically or if you need to run an mrp
> first.
>
> Scott
>
> On 01/11/2007, BJ Freeman <bj...@free-man.net> wrote:
>> oops you talking about creating back orders.
>> are you doing a shopping cart or something custom.
>>
>> BJ Freeman sent the following on 10/31/2007 1:31 PM:
>>> been a while
>>> look at
>>> checkInventoryAvailability
>>>
>>> skip@theDevers sent the following on 10/31/2007 10:58 AM:
>>>> I am trying figure out how to have a backorder generated automatically.
> I
>>>> have tried various store settings and can't get anything to happen. I
> am
>>>> expecting a Requirement (maybe that's wrong?) to be generated when I
> sell an
>>>> item not in stock.
>>>>
>>>> I searched Naggle for "backorder" and found nothing on this topic
> (other
>>>> than discussions on how to improve it).
>>>>
>>>> I am hoping somone will respond so I don't have to dig through the
> source
>>>> code again.
>>>>
>>>> Skip
>>>>
>>>>
>>>>
>>>>
>>>
>>>
>
>
>
>
Re: Automatic Backorders?
Posted by BJ Freeman <bj...@free-man.net>.
in checkInventoryAvailability
dispatcher.runAsync("sendOrderBackorderNotification",
UtilMisc.toMap("orderId", orderId, "userLogin", userLogin));
is where I put code to call CheckPO's
Now in dropship the POs are generated based on the order so the vendor
may get a PO for one item to drop ship to a customer.
for local inventory it is a seperate process that is closer to MRP.
the PO's are then send the SendPOtoVendor.
where the PO is formated per that particular vendor specificatiions and
sent to them.
then could be via web scrapping, FTP, Email, EDI.
hope to have this all submitted soon
skip@theDevers sent the following on 10/31/2007 2:20 PM:
> Not having much luck here. I set the minimum stock on hand for a GZ-1001 to
> 0 and re-order quantity to 5. Sold some more (putting the ATP at -8), but
> nothing I could detect happened. So, I went to Manufacturing->MRP and ran
> it for the Web Store. Nothing that I can detect happened.
>
> Can someone tell me how to write an order with a backorder on it and then
> have a purchase order written so that when it is received, the shipping
> clerk knows the item belongs to an order? Maybe this is some new code I
> need to write?
>
> Skip
>
> -----Original Message-----
> From: Scott Gray [mailto:lektran@gmail.com]
> Sent: Wednesday, October 31, 2007 2:10 PM
> To: user@ofbiz.apache.org
> Subject: Re: Automatic Backorders?
>
>
> You need to set the details in Product -> Facilities, even then I'm
> not sure if it happens automatically or if you need to run an mrp
> first.
>
> Scott
>
> On 01/11/2007, BJ Freeman <bj...@free-man.net> wrote:
>> oops you talking about creating back orders.
>> are you doing a shopping cart or something custom.
>>
>> BJ Freeman sent the following on 10/31/2007 1:31 PM:
>>> been a while
>>> look at
>>> checkInventoryAvailability
>>>
>>> skip@theDevers sent the following on 10/31/2007 10:58 AM:
>>>> I am trying figure out how to have a backorder generated automatically.
> I
>>>> have tried various store settings and can't get anything to happen. I
> am
>>>> expecting a Requirement (maybe that's wrong?) to be generated when I
> sell an
>>>> item not in stock.
>>>>
>>>> I searched Naggle for "backorder" and found nothing on this topic
> (other
>>>> than discussions on how to improve it).
>>>>
>>>> I am hoping somone will respond so I don't have to dig through the
> source
>>>> code again.
>>>>
>>>> Skip
>>>>
>>>>
>>>>
>>>>
>>>
>>>
>
>
>
>
RE: Automatic Backorders?
Posted by "skip@theDevers" <sk...@thedevers.org>.
Not having much luck here. I set the minimum stock on hand for a GZ-1001 to
0 and re-order quantity to 5. Sold some more (putting the ATP at -8), but
nothing I could detect happened. So, I went to Manufacturing->MRP and ran
it for the Web Store. Nothing that I can detect happened.
Can someone tell me how to write an order with a backorder on it and then
have a purchase order written so that when it is received, the shipping
clerk knows the item belongs to an order? Maybe this is some new code I
need to write?
Skip
-----Original Message-----
From: Scott Gray [mailto:lektran@gmail.com]
Sent: Wednesday, October 31, 2007 2:10 PM
To: user@ofbiz.apache.org
Subject: Re: Automatic Backorders?
You need to set the details in Product -> Facilities, even then I'm
not sure if it happens automatically or if you need to run an mrp
first.
Scott
On 01/11/2007, BJ Freeman <bj...@free-man.net> wrote:
> oops you talking about creating back orders.
> are you doing a shopping cart or something custom.
>
> BJ Freeman sent the following on 10/31/2007 1:31 PM:
> > been a while
> > look at
> > checkInventoryAvailability
> >
> > skip@theDevers sent the following on 10/31/2007 10:58 AM:
> >> I am trying figure out how to have a backorder generated automatically.
I
> >> have tried various store settings and can't get anything to happen. I
am
> >> expecting a Requirement (maybe that's wrong?) to be generated when I
sell an
> >> item not in stock.
> >>
> >> I searched Naggle for "backorder" and found nothing on this topic
(other
> >> than discussions on how to improve it).
> >>
> >> I am hoping somone will respond so I don't have to dig through the
source
> >> code again.
> >>
> >> Skip
> >>
> >>
> >>
> >>
> >
> >
> >
>
RE: Automatic Backorders?
Posted by "skip@theDevers" <sk...@thedevers.org>.
Scott
Thanks, I'll check this out. I noticed that checkInventoryAvailability() is
being run as a sandbox job and I have three entries about two hours apart in
the log saying the job was run.
Skip
-----Original Message-----
From: Scott Gray [mailto:lektran@gmail.com]
Sent: Wednesday, October 31, 2007 2:10 PM
To: user@ofbiz.apache.org
Subject: Re: Automatic Backorders?
You need to set the details in Product -> Facilities, even then I'm
not sure if it happens automatically or if you need to run an mrp
first.
Scott
On 01/11/2007, BJ Freeman <bj...@free-man.net> wrote:
> oops you talking about creating back orders.
> are you doing a shopping cart or something custom.
>
> BJ Freeman sent the following on 10/31/2007 1:31 PM:
> > been a while
> > look at
> > checkInventoryAvailability
> >
> > skip@theDevers sent the following on 10/31/2007 10:58 AM:
> >> I am trying figure out how to have a backorder generated automatically.
I
> >> have tried various store settings and can't get anything to happen. I
am
> >> expecting a Requirement (maybe that's wrong?) to be generated when I
sell an
> >> item not in stock.
> >>
> >> I searched Naggle for "backorder" and found nothing on this topic
(other
> >> than discussions on how to improve it).
> >>
> >> I am hoping somone will respond so I don't have to dig through the
source
> >> code again.
> >>
> >> Skip
> >>
> >>
> >>
> >>
> >
> >
> >
>
Re: Automatic Backorders?
Posted by Scott Gray <le...@gmail.com>.
You need to set the details in Product -> Facilities, even then I'm
not sure if it happens automatically or if you need to run an mrp
first.
Scott
On 01/11/2007, BJ Freeman <bj...@free-man.net> wrote:
> oops you talking about creating back orders.
> are you doing a shopping cart or something custom.
>
> BJ Freeman sent the following on 10/31/2007 1:31 PM:
> > been a while
> > look at
> > checkInventoryAvailability
> >
> > skip@theDevers sent the following on 10/31/2007 10:58 AM:
> >> I am trying figure out how to have a backorder generated automatically. I
> >> have tried various store settings and can't get anything to happen. I am
> >> expecting a Requirement (maybe that's wrong?) to be generated when I sell an
> >> item not in stock.
> >>
> >> I searched Naggle for "backorder" and found nothing on this topic (other
> >> than discussions on how to improve it).
> >>
> >> I am hoping somone will respond so I don't have to dig through the source
> >> code again.
> >>
> >> Skip
> >>
> >>
> >>
> >>
> >
> >
> >
>
Re: Postal Address Validation
Posted by BJ Freeman <bj...@free-man.net>.
thanks have added this to the comments
Jacques Le Roux sent the following on 11/3/2007 3:10 PM:
> BJ,
>
> De : "BJ Freeman" <bj...@free-man.net>
>> Is there away I can assign some of these to me.
>
> You have to be a commiter.
>
>> BJ Freeman sent the following on 11/3/2007 2:36 PM:
>>> I believe 203 is a companion to 100
>>> it allows the formatting on the screen.
>>> it may have to be reworked.
>>> possible link the two
>
> Following your comment in OFBIZ-203, I had already linked the 2 issues before you suggested in ML
>
> Jacques
>
>>> Jacques Le Roux sent the following on 11/3/2007 1:26 PM:
>>>> +1
>>>>
>>>> Please see https://issues.apache.org/jira/browse/OFBIZ-100
>>>>
>>>> I wonder now if we should not close https://issues.apache.org/jira/browse/OFBIZ-203
>>>>
>>>> Jacques
>>>>
>>>> De : "skip@theDevers" <sk...@thedevers.org>
>>>>> BJ Freeman found a nifty service. It is so earthshakingly important, I
>>>>> wanted to highlight it here for all those who blow through the Jira emails:
>>>>>
>>>>>
>>>>> It seems google has come to our rescue.
>>>>> http://googlemapsapi.blogspot.com/2006/06/geocoding-at-last.html
>>>>> http://www.oasis-open.org/committees/ciq/ciq.html#6
>>>>>
>>>>>
>>>>
>>>
>>>
>
>
>
Re: Postal Address Validation
Posted by BJ Freeman <bj...@free-man.net>.
I live in a motorcoach. have since 89
Since I move a lot, no knows where to drop in on me..
LOL
but my reason for not being a committer is not time,but that I have to
make public information I prefer to keep private
so as long as submitting to the jira works, that is what I will do.
I will test before sending.
Jacques Le Roux sent the following on 11/3/2007 3:59 PM:
> De : "BJ Freeman" <bj...@free-man.net>
>> don't plan to go that far. LOL
>> thanks
>
> Sometimes, I look at my freetime and I wonder why I did ;o) But even with a (benevolent) dictator nobody forces you, you are still
> free (but without much freetime ;o)
>
> It's all depend of you, and of your relatives. Beware without any relatives or friends you could sunk in it (I'm alone at home this
> week, and I fell like I'm drowned)
>
> Jacques
>
> PS : Joke :o) Any workalcoholic will understand though
>
>> Jacques Le Roux sent the following on 11/3/2007 3:10 PM:
>>> BJ,
>>>
>>> De : "BJ Freeman" <bj...@free-man.net>
>>>> Is there away I can assign some of these to me.
>>> You have to be a commiter.
>>>
>>>> BJ Freeman sent the following on 11/3/2007 2:36 PM:
>>>>> I believe 203 is a companion to 100
>>>>> it allows the formatting on the screen.
>>>>> it may have to be reworked.
>>>>> possible link the two
>>> Following your comment in OFBIZ-203, I had already linked the 2 issues before you suggested in ML
>>>
>>> Jacques
>>>
>>>>> Jacques Le Roux sent the following on 11/3/2007 1:26 PM:
>>>>>> +1
>>>>>>
>>>>>> Please see https://issues.apache.org/jira/browse/OFBIZ-100
>>>>>>
>>>>>> I wonder now if we should not close https://issues.apache.org/jira/browse/OFBIZ-203
>>>>>>
>>>>>> Jacques
>>>>>>
>>>>>> De : "skip@theDevers" <sk...@thedevers.org>
>>>>>>> BJ Freeman found a nifty service. It is so earthshakingly important, I
>>>>>>> wanted to highlight it here for all those who blow through the Jira emails:
>>>>>>>
>>>>>>>
>>>>>>> It seems google has come to our rescue.
>>>>>>> http://googlemapsapi.blogspot.com/2006/06/geocoding-at-last.html
>>>>>>> http://www.oasis-open.org/committees/ciq/ciq.html#6
>>>>>>>
>>>>>>>
>>>>>
>>>
>>>
>
>
>
>
RE: Postal Address Validation
Posted by "skip@theDevers" <sk...@thedevers.org>.
"(I'm alone at home this week, and I fell like I'm drowned)"
Gads, me too! It sucks!
Skip
-----Original Message-----
From: Jacques Le Roux [mailto:jacques.le.roux@les7arts.com]
Sent: Saturday, November 03, 2007 5:00 PM
To: user@ofbiz.apache.org
Subject: Re: Postal Address Validation
De : "BJ Freeman" <bj...@free-man.net>
> don't plan to go that far. LOL
> thanks
Sometimes, I look at my freetime and I wonder why I did ;o) But even with a
(benevolent) dictator nobody forces you, you are still
free (but without much freetime ;o)
It's all depend of you, and of your relatives. Beware without any relatives
or friends you could sunk in it (I'm alone at home this
week, and I fell like I'm drowned)
Jacques
PS : Joke :o) Any workalcoholic will understand though
> Jacques Le Roux sent the following on 11/3/2007 3:10 PM:
> > BJ,
> >
> > De : "BJ Freeman" <bj...@free-man.net>
> >> Is there away I can assign some of these to me.
> >
> > You have to be a commiter.
> >
> >> BJ Freeman sent the following on 11/3/2007 2:36 PM:
> >>> I believe 203 is a companion to 100
> >>> it allows the formatting on the screen.
> >>> it may have to be reworked.
> >>> possible link the two
> >
> > Following your comment in OFBIZ-203, I had already linked the 2 issues
before you suggested in ML
> >
> > Jacques
> >
> >>> Jacques Le Roux sent the following on 11/3/2007 1:26 PM:
> >>>> +1
> >>>>
> >>>> Please see https://issues.apache.org/jira/browse/OFBIZ-100
> >>>>
> >>>> I wonder now if we should not close
https://issues.apache.org/jira/browse/OFBIZ-203
> >>>>
> >>>> Jacques
> >>>>
> >>>> De : "skip@theDevers" <sk...@thedevers.org>
> >>>>> BJ Freeman found a nifty service. It is so earthshakingly
important, I
> >>>>> wanted to highlight it here for all those who blow through the Jira
emails:
> >>>>>
> >>>>>
> >>>>> It seems google has come to our rescue.
> >>>>> http://googlemapsapi.blogspot.com/2006/06/geocoding-at-last.html
> >>>>> http://www.oasis-open.org/committees/ciq/ciq.html#6
> >>>>>
> >>>>>
> >>>>
> >>>
> >>>
> >
> >
> >
>
Re: Postal Address Validation
Posted by Jacques Le Roux <ja...@les7arts.com>.
De : "BJ Freeman" <bj...@free-man.net>
> don't plan to go that far. LOL
> thanks
Sometimes, I look at my freetime and I wonder why I did ;o) But even with a (benevolent) dictator nobody forces you, you are still
free (but without much freetime ;o)
It's all depend of you, and of your relatives. Beware without any relatives or friends you could sunk in it (I'm alone at home this
week, and I fell like I'm drowned)
Jacques
PS : Joke :o) Any workalcoholic will understand though
> Jacques Le Roux sent the following on 11/3/2007 3:10 PM:
> > BJ,
> >
> > De : "BJ Freeman" <bj...@free-man.net>
> >> Is there away I can assign some of these to me.
> >
> > You have to be a commiter.
> >
> >> BJ Freeman sent the following on 11/3/2007 2:36 PM:
> >>> I believe 203 is a companion to 100
> >>> it allows the formatting on the screen.
> >>> it may have to be reworked.
> >>> possible link the two
> >
> > Following your comment in OFBIZ-203, I had already linked the 2 issues before you suggested in ML
> >
> > Jacques
> >
> >>> Jacques Le Roux sent the following on 11/3/2007 1:26 PM:
> >>>> +1
> >>>>
> >>>> Please see https://issues.apache.org/jira/browse/OFBIZ-100
> >>>>
> >>>> I wonder now if we should not close https://issues.apache.org/jira/browse/OFBIZ-203
> >>>>
> >>>> Jacques
> >>>>
> >>>> De : "skip@theDevers" <sk...@thedevers.org>
> >>>>> BJ Freeman found a nifty service. It is so earthshakingly important, I
> >>>>> wanted to highlight it here for all those who blow through the Jira emails:
> >>>>>
> >>>>>
> >>>>> It seems google has come to our rescue.
> >>>>> http://googlemapsapi.blogspot.com/2006/06/geocoding-at-last.html
> >>>>> http://www.oasis-open.org/committees/ciq/ciq.html#6
> >>>>>
> >>>>>
> >>>>
> >>>
> >>>
> >
> >
> >
>
Re: Postal Address Validation
Posted by BJ Freeman <bj...@free-man.net>.
don't plan to go that far. LOL
thanks
Jacques Le Roux sent the following on 11/3/2007 3:10 PM:
> BJ,
>
> De : "BJ Freeman" <bj...@free-man.net>
>> Is there away I can assign some of these to me.
>
> You have to be a commiter.
>
>> BJ Freeman sent the following on 11/3/2007 2:36 PM:
>>> I believe 203 is a companion to 100
>>> it allows the formatting on the screen.
>>> it may have to be reworked.
>>> possible link the two
>
> Following your comment in OFBIZ-203, I had already linked the 2 issues before you suggested in ML
>
> Jacques
>
>>> Jacques Le Roux sent the following on 11/3/2007 1:26 PM:
>>>> +1
>>>>
>>>> Please see https://issues.apache.org/jira/browse/OFBIZ-100
>>>>
>>>> I wonder now if we should not close https://issues.apache.org/jira/browse/OFBIZ-203
>>>>
>>>> Jacques
>>>>
>>>> De : "skip@theDevers" <sk...@thedevers.org>
>>>>> BJ Freeman found a nifty service. It is so earthshakingly important, I
>>>>> wanted to highlight it here for all those who blow through the Jira emails:
>>>>>
>>>>>
>>>>> It seems google has come to our rescue.
>>>>> http://googlemapsapi.blogspot.com/2006/06/geocoding-at-last.html
>>>>> http://www.oasis-open.org/committees/ciq/ciq.html#6
>>>>>
>>>>>
>>>>
>>>
>>>
>
>
>
Re: Postal Address Validation
Posted by Jacques Le Roux <ja...@les7arts.com>.
BJ,
De : "BJ Freeman" <bj...@free-man.net>
> Is there away I can assign some of these to me.
You have to be a commiter.
>
> BJ Freeman sent the following on 11/3/2007 2:36 PM:
> > I believe 203 is a companion to 100
> > it allows the formatting on the screen.
> > it may have to be reworked.
> > possible link the two
Following your comment in OFBIZ-203, I had already linked the 2 issues before you suggested in ML
Jacques
> >
> > Jacques Le Roux sent the following on 11/3/2007 1:26 PM:
> >> +1
> >>
> >> Please see https://issues.apache.org/jira/browse/OFBIZ-100
> >>
> >> I wonder now if we should not close https://issues.apache.org/jira/browse/OFBIZ-203
> >>
> >> Jacques
> >>
> >> De : "skip@theDevers" <sk...@thedevers.org>
> >>> BJ Freeman found a nifty service. It is so earthshakingly important, I
> >>> wanted to highlight it here for all those who blow through the Jira emails:
> >>>
> >>>
> >>> It seems google has come to our rescue.
> >>> http://googlemapsapi.blogspot.com/2006/06/geocoding-at-last.html
> >>> http://www.oasis-open.org/committees/ciq/ciq.html#6
> >>>
> >>>
> >>
> >>
> >
> >
> >
>
RE: Postal Address Validation
Posted by "skip@theDevers" <sk...@thedevers.org>.
BJ
I don't think you need to have them assigned. I have been fixing issues and
just attaching patch files and they have been handled.
Skip
-----Original Message-----
From: BJ Freeman [mailto:bjfree@free-man.net]
Sent: Saturday, November 03, 2007 4:37 PM
To: user@ofbiz.apache.org
Subject: Re: Postal Address Validation
Is there away I can assign some of these to me.
BJ Freeman sent the following on 11/3/2007 2:36 PM:
> I believe 203 is a companion to 100
> it allows the formatting on the screen.
> it may have to be reworked.
> possible link the two
>
>
> Jacques Le Roux sent the following on 11/3/2007 1:26 PM:
>> +1
>>
>> Please see https://issues.apache.org/jira/browse/OFBIZ-100
>>
>> I wonder now if we should not close
https://issues.apache.org/jira/browse/OFBIZ-203
>>
>> Jacques
>>
>> De : "skip@theDevers" <sk...@thedevers.org>
>>> BJ Freeman found a nifty service. It is so earthshakingly important, I
>>> wanted to highlight it here for all those who blow through the Jira
emails:
>>>
>>>
>>> It seems google has come to our rescue.
>>> http://googlemapsapi.blogspot.com/2006/06/geocoding-at-last.html
>>> http://www.oasis-open.org/committees/ciq/ciq.html#6
>>>
>>>
>>
>>
>
>
>
Re: Postal Address Validation
Posted by BJ Freeman <bj...@free-man.net>.
Is there away I can assign some of these to me.
BJ Freeman sent the following on 11/3/2007 2:36 PM:
> I believe 203 is a companion to 100
> it allows the formatting on the screen.
> it may have to be reworked.
> possible link the two
>
>
> Jacques Le Roux sent the following on 11/3/2007 1:26 PM:
>> +1
>>
>> Please see https://issues.apache.org/jira/browse/OFBIZ-100
>>
>> I wonder now if we should not close https://issues.apache.org/jira/browse/OFBIZ-203
>>
>> Jacques
>>
>> De : "skip@theDevers" <sk...@thedevers.org>
>>> BJ Freeman found a nifty service. It is so earthshakingly important, I
>>> wanted to highlight it here for all those who blow through the Jira emails:
>>>
>>>
>>> It seems google has come to our rescue.
>>> http://googlemapsapi.blogspot.com/2006/06/geocoding-at-last.html
>>> http://www.oasis-open.org/committees/ciq/ciq.html#6
>>>
>>>
>>
>>
>
>
>
Re: Postal Address Validation
Posted by BJ Freeman <bj...@free-man.net>.
I believe 203 is a companion to 100
it allows the formatting on the screen.
it may have to be reworked.
possible link the two
Jacques Le Roux sent the following on 11/3/2007 1:26 PM:
> +1
>
> Please see https://issues.apache.org/jira/browse/OFBIZ-100
>
> I wonder now if we should not close https://issues.apache.org/jira/browse/OFBIZ-203
>
> Jacques
>
> De : "skip@theDevers" <sk...@thedevers.org>
>> BJ Freeman found a nifty service. It is so earthshakingly important, I
>> wanted to highlight it here for all those who blow through the Jira emails:
>>
>>
>> It seems google has come to our rescue.
>> http://googlemapsapi.blogspot.com/2006/06/geocoding-at-last.html
>> http://www.oasis-open.org/committees/ciq/ciq.html#6
>>
>>
>
>
>
Re: Postal Address Validation
Posted by Jacques Le Roux <ja...@les7arts.com>.
+1
Please see https://issues.apache.org/jira/browse/OFBIZ-100
I wonder now if we should not close https://issues.apache.org/jira/browse/OFBIZ-203
Jacques
De : "skip@theDevers" <sk...@thedevers.org>
> BJ Freeman found a nifty service. It is so earthshakingly important, I
> wanted to highlight it here for all those who blow through the Jira emails:
>
>
> It seems google has come to our rescue.
> http://googlemapsapi.blogspot.com/2006/06/geocoding-at-last.html
> http://www.oasis-open.org/committees/ciq/ciq.html#6
>
>
Postal Address Validation
Posted by "skip@theDevers" <sk...@thedevers.org>.
BJ Freeman found a nifty service. It is so earthshakingly important, I
wanted to highlight it here for all those who blow through the Jira emails:
It seems google has come to our rescue.
http://googlemapsapi.blogspot.com/2006/06/geocoding-at-last.html
http://www.oasis-open.org/committees/ciq/ciq.html#6
Re: Automatic Backorders?
Posted by BJ Freeman <bj...@free-man.net>.
also have a look at getSuppliersForProduct
skip@theDevers sent the following on 11/1/2007 11:28 AM:
> Thanks BJ, I'll have a look at this all. I agree about the multiple
> suppliers. I am writing a more complicated automated purchasing app partly
> because of this (different supplier prices, different shipping times,
> minimum order quantities, etc.). However, I also want to produce something
> stupid that can be run to just fill backorders from the prefered supplier so
> rush orders with backorders on them can get handled by someone without
> in-depth purchasing knowledge.
>
> Skip
>
> -----Original Message-----
> From: BJ Freeman [mailto:bjfree@free-man.net]
> Sent: Thursday, November 01, 2007 1:10 PM
> To: user@ofbiz.apache.org
> Subject: Re: Automatic Backorders?
>
>
> here is the code in checkInventoryAvailability
>
> List exprs = UtilMisc.toList(new
> EntityExpr("availableToPromiseTotal", EntityOperator.LESS_THAN, new
> Double(0)));
>
> as you have already found out it is run in the sandbox.
>
> there is a lot more to consider that what is checkInventoryAvailability
> Like inventory that has multiple suppliers. and those supplier have a
> preference.
> the Preference it updated from past orders to them.
> This has to do with cost, delivery, and billing agreements.
>
>
>
> skip@theDevers sent the following on 10/31/2007 1:17 PM:
>> BJ
>>
>> Thanks for the response. This is just OOTB ofbiz trying to see how
>> backorders get handled so I can report on them for the AR work I am doing.
>> I am just trying to generate a backorder and see what entities are created
>> and how it affects billing and the like after the order is received.
>>
>> To start with, I just want to create a backorder associated with an order
>> that has some of the parts shipped.
>>
>> I have not yet been able to create a backorder that I can recognize as
> such.
>> I am expecting it to turn up in Requirements, but that may be the wrong
>> assumption.
>>
>> Skip
>>
>> -----Original Message-----
>> From: BJ Freeman [mailto:bjfree@free-man.net]
>> Sent: Wednesday, October 31, 2007 3:01 PM
>> To: user@ofbiz.apache.org
>> Subject: Re: Automatic Backorders?
>>
>>
>> oops you talking about creating back orders.
>> are you doing a shopping cart or something custom.
>>
>> BJ Freeman sent the following on 10/31/2007 1:31 PM:
>>> been a while
>>> look at
>>> checkInventoryAvailability
>>>
>>> skip@theDevers sent the following on 10/31/2007 10:58 AM:
>>>> I am trying figure out how to have a backorder generated automatically.
>> I
>>>> have tried various store settings and can't get anything to happen. I
> am
>>>> expecting a Requirement (maybe that's wrong?) to be generated when I
> sell
>> an
>>>> item not in stock.
>>>>
>>>> I searched Naggle for "backorder" and found nothing on this topic (other
>>>> than discussions on how to improve it).
>>>>
>>>> I am hoping somone will respond so I don't have to dig through the
> source
>>>> code again.
>>>>
>>>> Skip
>>>>
>>>>
>>>>
>>>>
>>>
>>
>>
>>
>
>
>
>
Nothing to do with Ofbiz
Posted by "skip@theDevers" <sk...@thedevers.org>.
This has nothing to do with Ofbiz. But, I just got this email from out of
the blue from someone I never heard of and I thought it was so good that I
would share it.
"There is a calmness to a life lived in Gratitude, a quiet joy. Your friend
is that man who knows all about you, and still likes you."
PaymentApplication Confusion
Posted by "skip@theDevers" <sk...@thedevers.org>.
I was just checking out the effects of creating a store credit on a billing
account and found that the action ends up creating one Payment and two
PaymentApplications the sum of which is double the Payment amount. I always
thought that the SUM of PaymentApplications for a Payment should equal the
Payment amount.
Can someone comment on this?
Skip
Re: Automatic Backorders?
Posted by Jacopo Cappellato <ti...@sastau.it>.
Skip,
skip@theDevers wrote:
> Thanks BJ, I'll have a look at this all. I agree about the multiple
> suppliers. I am writing a more complicated automated purchasing app partly
> because of this (different supplier prices, different shipping times,
> minimum order quantities, etc.). However, I also want to produce something
> stupid that can be run to just fill backorders from the prefered supplier so
> rush orders with backorders on them can get handled by someone without
> in-depth purchasing knowledge.
you may want to try to set the requirementMethodEnumId field in the
Product entity (or ProductStore): there is a drop-down field for this in
the Edit Product screen.
There are many options, I'd suggest "When QOH reaches..."
All the ("product") requirements created in the system are automatically
associated to the main supplier (there is a field to mark the main
supplier in the SupplierProduct entity).
Jacopo
>
> Skip
>
> -----Original Message-----
> From: BJ Freeman [mailto:bjfree@free-man.net]
> Sent: Thursday, November 01, 2007 1:10 PM
> To: user@ofbiz.apache.org
> Subject: Re: Automatic Backorders?
>
>
> here is the code in checkInventoryAvailability
>
> List exprs = UtilMisc.toList(new
> EntityExpr("availableToPromiseTotal", EntityOperator.LESS_THAN, new
> Double(0)));
>
> as you have already found out it is run in the sandbox.
>
> there is a lot more to consider that what is checkInventoryAvailability
> Like inventory that has multiple suppliers. and those supplier have a
> preference.
> the Preference it updated from past orders to them.
> This has to do with cost, delivery, and billing agreements.
>
>
>
> skip@theDevers sent the following on 10/31/2007 1:17 PM:
>> BJ
>>
>> Thanks for the response. This is just OOTB ofbiz trying to see how
>> backorders get handled so I can report on them for the AR work I am doing.
>> I am just trying to generate a backorder and see what entities are created
>> and how it affects billing and the like after the order is received.
>>
>> To start with, I just want to create a backorder associated with an order
>> that has some of the parts shipped.
>>
>> I have not yet been able to create a backorder that I can recognize as
> such.
>> I am expecting it to turn up in Requirements, but that may be the wrong
>> assumption.
>>
>> Skip
>>
>> -----Original Message-----
>> From: BJ Freeman [mailto:bjfree@free-man.net]
>> Sent: Wednesday, October 31, 2007 3:01 PM
>> To: user@ofbiz.apache.org
>> Subject: Re: Automatic Backorders?
>>
>>
>> oops you talking about creating back orders.
>> are you doing a shopping cart or something custom.
>>
>> BJ Freeman sent the following on 10/31/2007 1:31 PM:
>>> been a while
>>> look at
>>> checkInventoryAvailability
>>>
>>> skip@theDevers sent the following on 10/31/2007 10:58 AM:
>>>> I am trying figure out how to have a backorder generated automatically.
>> I
>>>> have tried various store settings and can't get anything to happen. I
> am
>>>> expecting a Requirement (maybe that's wrong?) to be generated when I
> sell
>> an
>>>> item not in stock.
>>>>
>>>> I searched Naggle for "backorder" and found nothing on this topic (other
>>>> than discussions on how to improve it).
>>>>
>>>> I am hoping somone will respond so I don't have to dig through the
> source
>>>> code again.
>>>>
>>>> Skip
>>>>
>>>>
>>>>
>>>>
>>>
>>
>>
>>
RE: Automatic Backorders?
Posted by "skip@theDevers" <sk...@thedevers.org>.
Thanks BJ, I'll have a look at this all. I agree about the multiple
suppliers. I am writing a more complicated automated purchasing app partly
because of this (different supplier prices, different shipping times,
minimum order quantities, etc.). However, I also want to produce something
stupid that can be run to just fill backorders from the prefered supplier so
rush orders with backorders on them can get handled by someone without
in-depth purchasing knowledge.
Skip
-----Original Message-----
From: BJ Freeman [mailto:bjfree@free-man.net]
Sent: Thursday, November 01, 2007 1:10 PM
To: user@ofbiz.apache.org
Subject: Re: Automatic Backorders?
here is the code in checkInventoryAvailability
List exprs = UtilMisc.toList(new
EntityExpr("availableToPromiseTotal", EntityOperator.LESS_THAN, new
Double(0)));
as you have already found out it is run in the sandbox.
there is a lot more to consider that what is checkInventoryAvailability
Like inventory that has multiple suppliers. and those supplier have a
preference.
the Preference it updated from past orders to them.
This has to do with cost, delivery, and billing agreements.
skip@theDevers sent the following on 10/31/2007 1:17 PM:
> BJ
>
> Thanks for the response. This is just OOTB ofbiz trying to see how
> backorders get handled so I can report on them for the AR work I am doing.
> I am just trying to generate a backorder and see what entities are created
> and how it affects billing and the like after the order is received.
>
> To start with, I just want to create a backorder associated with an order
> that has some of the parts shipped.
>
> I have not yet been able to create a backorder that I can recognize as
such.
> I am expecting it to turn up in Requirements, but that may be the wrong
> assumption.
>
> Skip
>
> -----Original Message-----
> From: BJ Freeman [mailto:bjfree@free-man.net]
> Sent: Wednesday, October 31, 2007 3:01 PM
> To: user@ofbiz.apache.org
> Subject: Re: Automatic Backorders?
>
>
> oops you talking about creating back orders.
> are you doing a shopping cart or something custom.
>
> BJ Freeman sent the following on 10/31/2007 1:31 PM:
>> been a while
>> look at
>> checkInventoryAvailability
>>
>> skip@theDevers sent the following on 10/31/2007 10:58 AM:
>>> I am trying figure out how to have a backorder generated automatically.
> I
>>> have tried various store settings and can't get anything to happen. I
am
>>> expecting a Requirement (maybe that's wrong?) to be generated when I
sell
> an
>>> item not in stock.
>>>
>>> I searched Naggle for "backorder" and found nothing on this topic (other
>>> than discussions on how to improve it).
>>>
>>> I am hoping somone will respond so I don't have to dig through the
source
>>> code again.
>>>
>>> Skip
>>>
>>>
>>>
>>>
>>
>>
>
>
>
>
Re: Automatic Backorders?
Posted by BJ Freeman <bj...@free-man.net>.
here is the code in checkInventoryAvailability
List exprs = UtilMisc.toList(new
EntityExpr("availableToPromiseTotal", EntityOperator.LESS_THAN, new
Double(0)));
as you have already found out it is run in the sandbox.
there is a lot more to consider that what is checkInventoryAvailability
Like inventory that has multiple suppliers. and those supplier have a
preference.
the Preference it updated from past orders to them.
This has to do with cost, delivery, and billing agreements.
skip@theDevers sent the following on 10/31/2007 1:17 PM:
> BJ
>
> Thanks for the response. This is just OOTB ofbiz trying to see how
> backorders get handled so I can report on them for the AR work I am doing.
> I am just trying to generate a backorder and see what entities are created
> and how it affects billing and the like after the order is received.
>
> To start with, I just want to create a backorder associated with an order
> that has some of the parts shipped.
>
> I have not yet been able to create a backorder that I can recognize as such.
> I am expecting it to turn up in Requirements, but that may be the wrong
> assumption.
>
> Skip
>
> -----Original Message-----
> From: BJ Freeman [mailto:bjfree@free-man.net]
> Sent: Wednesday, October 31, 2007 3:01 PM
> To: user@ofbiz.apache.org
> Subject: Re: Automatic Backorders?
>
>
> oops you talking about creating back orders.
> are you doing a shopping cart or something custom.
>
> BJ Freeman sent the following on 10/31/2007 1:31 PM:
>> been a while
>> look at
>> checkInventoryAvailability
>>
>> skip@theDevers sent the following on 10/31/2007 10:58 AM:
>>> I am trying figure out how to have a backorder generated automatically.
> I
>>> have tried various store settings and can't get anything to happen. I am
>>> expecting a Requirement (maybe that's wrong?) to be generated when I sell
> an
>>> item not in stock.
>>>
>>> I searched Naggle for "backorder" and found nothing on this topic (other
>>> than discussions on how to improve it).
>>>
>>> I am hoping somone will respond so I don't have to dig through the source
>>> code again.
>>>
>>> Skip
>>>
>>>
>>>
>>>
>>
>>
>
>
>
>
RE: Automatic Backorders?
Posted by "skip@theDevers" <sk...@thedevers.org>.
BJ
Thanks for the response. This is just OOTB ofbiz trying to see how
backorders get handled so I can report on them for the AR work I am doing.
I am just trying to generate a backorder and see what entities are created
and how it affects billing and the like after the order is received.
To start with, I just want to create a backorder associated with an order
that has some of the parts shipped.
I have not yet been able to create a backorder that I can recognize as such.
I am expecting it to turn up in Requirements, but that may be the wrong
assumption.
Skip
-----Original Message-----
From: BJ Freeman [mailto:bjfree@free-man.net]
Sent: Wednesday, October 31, 2007 3:01 PM
To: user@ofbiz.apache.org
Subject: Re: Automatic Backorders?
oops you talking about creating back orders.
are you doing a shopping cart or something custom.
BJ Freeman sent the following on 10/31/2007 1:31 PM:
> been a while
> look at
> checkInventoryAvailability
>
> skip@theDevers sent the following on 10/31/2007 10:58 AM:
>> I am trying figure out how to have a backorder generated automatically.
I
>> have tried various store settings and can't get anything to happen. I am
>> expecting a Requirement (maybe that's wrong?) to be generated when I sell
an
>> item not in stock.
>>
>> I searched Naggle for "backorder" and found nothing on this topic (other
>> than discussions on how to improve it).
>>
>> I am hoping somone will respond so I don't have to dig through the source
>> code again.
>>
>> Skip
>>
>>
>>
>>
>
>
>
Re: Automatic Backorders?
Posted by BJ Freeman <bj...@free-man.net>.
oops you talking about creating back orders.
are you doing a shopping cart or something custom.
BJ Freeman sent the following on 10/31/2007 1:31 PM:
> been a while
> look at
> checkInventoryAvailability
>
> skip@theDevers sent the following on 10/31/2007 10:58 AM:
>> I am trying figure out how to have a backorder generated automatically. I
>> have tried various store settings and can't get anything to happen. I am
>> expecting a Requirement (maybe that's wrong?) to be generated when I sell an
>> item not in stock.
>>
>> I searched Naggle for "backorder" and found nothing on this topic (other
>> than discussions on how to improve it).
>>
>> I am hoping somone will respond so I don't have to dig through the source
>> code again.
>>
>> Skip
>>
>>
>>
>>
>
>
>
RE: Automatic Backorders?
Posted by "skip@theDevers" <sk...@thedevers.org>.
Yep, I have checkInventory and reserveInventory = "Y". I was using the OOTB
demo data and this is the default for the web store. I also tried setting
requireInventory = "Y", but then I couldnt sell it. I tried isDemoStore="N"
but that didn't make any difference.
I am thinking that there is a setting somewhere else that might affect this.
The checkInventoryAvailability() service is exactly what is needed. Gonna
see if I can track down how it gets called.
Skip
-----Original Message-----
From: BJ Freeman [mailto:bjfree@free-man.net]
Sent: Wednesday, October 31, 2007 2:32 PM
To: user@ofbiz.apache.org
Subject: Re: Automatic Backorders?
been a while
look at
checkInventoryAvailability
skip@theDevers sent the following on 10/31/2007 10:58 AM:
> I am trying figure out how to have a backorder generated automatically. I
> have tried various store settings and can't get anything to happen. I am
> expecting a Requirement (maybe that's wrong?) to be generated when I sell
an
> item not in stock.
>
> I searched Naggle for "backorder" and found nothing on this topic (other
> than discussions on how to improve it).
>
> I am hoping somone will respond so I don't have to dig through the source
> code again.
>
> Skip
>
>
>
>
Re: Automatic Backorders?
Posted by BJ Freeman <bj...@free-man.net>.
been a while
look at
checkInventoryAvailability
skip@theDevers sent the following on 10/31/2007 10:58 AM:
> I am trying figure out how to have a backorder generated automatically. I
> have tried various store settings and can't get anything to happen. I am
> expecting a Requirement (maybe that's wrong?) to be generated when I sell an
> item not in stock.
>
> I searched Naggle for "backorder" and found nothing on this topic (other
> than discussions on how to improve it).
>
> I am hoping somone will respond so I don't have to dig through the source
> code again.
>
> Skip
>
>
>
>
Automatic Backorders?
Posted by "skip@theDevers" <sk...@thedevers.org>.
I am trying figure out how to have a backorder generated automatically. I
have tried various store settings and can't get anything to happen. I am
expecting a Requirement (maybe that's wrong?) to be generated when I sell an
item not in stock.
I searched Naggle for "backorder" and found nothing on this topic (other
than discussions on how to improve it).
I am hoping somone will respond so I don't have to dig through the source
code again.
Skip
Re: captureBillingAccountPayments
Posted by Scott Gray <le...@gmail.com>.
Hi Jacopo
Our customers generally make payments for a specific invoice or group
of invoices so this wouldn't work for us. In our current system (non
web UI) we log a payment and then use a screen with a list of open
invoices to allocate the payment with the payment balance reducing as
each invoice is selected.
Regards
Scott
On 29/10/2007, Jacopo Cappellato <ti...@sastau.it> wrote:
> skip@theDevers wrote:
> > Jacopo
> >
> > As the man with the plan,
>
> uhm... me? :-)
>
> > I wanted to throw this new plan past you. I have
> > dug pretty deeply into the existing payment/billing account stuff and it
> > all seems a bit arcane to me and mostly because it looks like payments are
> > meant to be made from the company to a vendor and from a customer to the
> > company, all with the same screens.
> >
> > I want to create a really easy to use AR payment system. The user enters a
> > payment and can then either apply the payment to individual invoices (and a
> > store credit if too much is received) or he can apply it to the billing
> > account, in which case we automatically apply it to the oldest invoices
> > first and then to a credit if too much is received.
> >
>
> I'd suggest the following subtasks:
>
> a) implement a new service to automatically apply the payments
> associated to a billing account to the older open invoices associated to
> the same account; the new service will have one mandatory parameter
> "billingAccountId" (and maybe one optional parameter "paymentId") and it
> will:
> - select the open invoices associated to the billing account and sort
> them by date (older first)
> - iterate on the list and for each of them call the service
> capturePaymentsByInvoice passing in the invoice id and billingAccountId
> (this is the service that is invoked when you click on the "capture"
> link near the invoice in the billingaccoun-invoices screen)
>
> b) the new service can be invoked by a new link ("apply payments to
> invoices") at the top of the billing account->invoices screen or (maybe
> in your custom application) triggered every time you associate a payment
> to a billing account.
>
> This should cover your requirements but it is also generic enough to be
> a good fit for OFBiz.
>
> What do you think?
>
> Jacopo
>
> > Is this too simplistic for some reason I am missing? Do others have AR
> > needs outside this that would justify a more complicated transaction set?
> >
> > Skip
>
>
>
Re: Reading html template files question
Posted by Jacques Le Roux <ja...@les7arts.com>.
Hi Skip,
Just a pointer : sendOrderNotificationScreen
Jacques
De : "skip@theDevers" <sk...@thedevers.org>
> I am writing a service to email billing account statements. I want to read
> a template and generate an email from it. This is in the context of a
> scheduled service. I have to believe there is already code doing something
> similiar (sending mass emails generated from a template).
>
> Can someone point me to some sample code?
>
> Skip
>
Reading html template files question
Posted by "skip@theDevers" <sk...@thedevers.org>.
I am writing a service to email billing account statements. I want to read
a template and generate an email from it. This is in the context of a
scheduled service. I have to believe there is already code doing something
similiar (sending mass emails generated from a template).
Can someone point me to some sample code?
Skip
RE: captureBillingAccountPayments
Posted by "skip@theDevers" <sk...@thedevers.org>.
Like I said, the man with the plan
-----Original Message-----
From: Jacopo Cappellato [mailto:tiz@sastau.it]
Sent: Monday, October 29, 2007 12:15 AM
To: user@ofbiz.apache.org
Subject: Re: captureBillingAccountPayments
skip@theDevers wrote:
> Jacopo
>
> As the man with the plan,
uhm... me? :-)
> I wanted to throw this new plan past you. I have
> dug pretty deeply into the existing payment/billing account stuff and it
> all seems a bit arcane to me and mostly because it looks like payments are
> meant to be made from the company to a vendor and from a customer to the
> company, all with the same screens.
>
> I want to create a really easy to use AR payment system. The user enters
a
> payment and can then either apply the payment to individual invoices (and
a
> store credit if too much is received) or he can apply it to the billing
> account, in which case we automatically apply it to the oldest invoices
> first and then to a credit if too much is received.
>
I'd suggest the following subtasks:
a) implement a new service to automatically apply the payments
associated to a billing account to the older open invoices associated to
the same account; the new service will have one mandatory parameter
"billingAccountId" (and maybe one optional parameter "paymentId") and it
will:
- select the open invoices associated to the billing account and sort
them by date (older first)
- iterate on the list and for each of them call the service
capturePaymentsByInvoice passing in the invoice id and billingAccountId
(this is the service that is invoked when you click on the "capture"
link near the invoice in the billingaccoun-invoices screen)
b) the new service can be invoked by a new link ("apply payments to
invoices") at the top of the billing account->invoices screen or (maybe
in your custom application) triggered every time you associate a payment
to a billing account.
This should cover your requirements but it is also generic enough to be
a good fit for OFBiz.
What do you think?
Jacopo
> Is this too simplistic for some reason I am missing? Do others have AR
> needs outside this that would justify a more complicated transaction set?
>
> Skip
Re: captureBillingAccountPayments
Posted by Jacopo Cappellato <ti...@sastau.it>.
skip@theDevers wrote:
> Jacopo
>
> As the man with the plan,
uhm... me? :-)
> I wanted to throw this new plan past you. I have
> dug pretty deeply into the existing payment/billing account stuff and it
> all seems a bit arcane to me and mostly because it looks like payments are
> meant to be made from the company to a vendor and from a customer to the
> company, all with the same screens.
>
> I want to create a really easy to use AR payment system. The user enters a
> payment and can then either apply the payment to individual invoices (and a
> store credit if too much is received) or he can apply it to the billing
> account, in which case we automatically apply it to the oldest invoices
> first and then to a credit if too much is received.
>
I'd suggest the following subtasks:
a) implement a new service to automatically apply the payments
associated to a billing account to the older open invoices associated to
the same account; the new service will have one mandatory parameter
"billingAccountId" (and maybe one optional parameter "paymentId") and it
will:
- select the open invoices associated to the billing account and sort
them by date (older first)
- iterate on the list and for each of them call the service
capturePaymentsByInvoice passing in the invoice id and billingAccountId
(this is the service that is invoked when you click on the "capture"
link near the invoice in the billingaccoun-invoices screen)
b) the new service can be invoked by a new link ("apply payments to
invoices") at the top of the billing account->invoices screen or (maybe
in your custom application) triggered every time you associate a payment
to a billing account.
This should cover your requirements but it is also generic enough to be
a good fit for OFBiz.
What do you think?
Jacopo
> Is this too simplistic for some reason I am missing? Do others have AR
> needs outside this that would justify a more complicated transaction set?
>
> Skip
RE: captureBillingAccountPayments
Posted by "skip@theDevers" <sk...@thedevers.org>.
Jacopo
As the man with the plan, I wanted to throw this new plan past you. I have
dug pretty deeply into the existing payment/billing account stuff and it
all seems a bit arcane to me and mostly because it looks like payments are
meant to be made from the company to a vendor and from a customer to the
company, all with the same screens.
I want to create a really easy to use AR payment system. The user enters a
payment and can then either apply the payment to individual invoices (and a
store credit if too much is received) or he can apply it to the billing
account, in which case we automatically apply it to the oldest invoices
first and then to a credit if too much is received.
Is this too simplistic for some reason I am missing? Do others have AR
needs outside this that would justify a more complicated transaction set?
Skip
Re: captureBillingAccountPayments
Posted by Jacopo Cappellato <ti...@sastau.it>.
skip@theDevers wrote:
> Jacopo
>
> Makes perfect sense, in fact, its the almost perfect solution to my second
> question. Lets say you sold 4 items on 4 days on 4 invoices. The customer
> pays for all 4 invoices. Then, a week later, item 2 breaks and he sends it
> back for a credit. The following week, he buys something else. Is there
> some way for the credit to show up on the in sales order payment options?
> Could the same logic be used?
>
Yes,
the business logic is the following one (correct me if I am wrong):
1) a customer return is created for 2 items
2) you should select as the return type: "store credit" this will store
(as a PaymentApplication) the credit to a billing account associated
to the customer
3) the new amount will increase the available balance of the billing
account (that can be used during order entry)
This should work, but if you see something wrong please let us know.
Jacopo
>
>
> Skip
>
>
> -----Original Message-----
> From: Jacopo Cappellato [mailto:tiz@sastau.it]
> Sent: Thursday, October 25, 2007 1:23 AM
> To: user@ofbiz.apache.org
> Subject: Re: captureBillingAccountPayments
>
>
> skip@theDevers wrote:
>> I am having a discussion with Si about billing accounts. For me,
>> captureBillingAccountPayments works and the deprecated
>> captureBillingAccountPayment does not.
>>
>> However, captureBillingAccountPayments essentially does nothing (which it
>> the right thing to do in this case).
>>
>> My question is, what was the intent of the logic after the
>>
>>
>> if (UtilValidate.isNotEmpty(paymentApplications)) {
>>
>> which for me is always empty and never gets executed.
>>
>> Can the author comment? Is there some case where this will contain
>> paymentApplications?
>>
>> Skip
>
> Let's say you get a billing account and two not paid invoices associated
> to it, one for 30$ and one for 50$.
> You get a payment from your customer for 70$; you associate the whole
> payment to the billing account: this will create a PaymentApplication
> record with billingAccountId set, and a null invoiceId.
> Then, if you go to the billing account's invoices screen and you click
> on the "capture payments" link near to the 30$ invoice, then the
> captureBillingAccountPayments service will be called -> the
> PaymentApplication with null invoiceId (i.e. still not applied) is found
> --> if (UtilValidate.isNotEmpty(paymentApplications)) is true -->
> a new PaymentApplication is created for 30$ and applied to the invoice;
> the original PaymentApplication is updated and the new 'available'
> amount is 40$ (i.e. 70-30=40); we can now do the same with the otther
> invoice...
> At the end the first invoice will be PAID and the second PARTIALLY PAID.
>
> Does it make sense?
>
> Jacopo
>
>
RE: captureBillingAccountPayments
Posted by "skip@theDevers" <sk...@thedevers.org>.
Jacopo
Makes perfect sense, in fact, its the almost perfect solution to my second
question. Lets say you sold 4 items on 4 days on 4 invoices. The customer
pays for all 4 invoices. Then, a week later, item 2 breaks and he sends it
back for a credit. The following week, he buys something else. Is there
some way for the credit to show up on the in sales order payment options?
Could the same logic be used?
Skip
-----Original Message-----
From: Jacopo Cappellato [mailto:tiz@sastau.it]
Sent: Thursday, October 25, 2007 1:23 AM
To: user@ofbiz.apache.org
Subject: Re: captureBillingAccountPayments
skip@theDevers wrote:
> I am having a discussion with Si about billing accounts. For me,
> captureBillingAccountPayments works and the deprecated
> captureBillingAccountPayment does not.
>
> However, captureBillingAccountPayments essentially does nothing (which it
> the right thing to do in this case).
>
> My question is, what was the intent of the logic after the
>
>
> if (UtilValidate.isNotEmpty(paymentApplications)) {
>
> which for me is always empty and never gets executed.
>
> Can the author comment? Is there some case where this will contain
> paymentApplications?
>
> Skip
Let's say you get a billing account and two not paid invoices associated
to it, one for 30$ and one for 50$.
You get a payment from your customer for 70$; you associate the whole
payment to the billing account: this will create a PaymentApplication
record with billingAccountId set, and a null invoiceId.
Then, if you go to the billing account's invoices screen and you click
on the "capture payments" link near to the 30$ invoice, then the
captureBillingAccountPayments service will be called -> the
PaymentApplication with null invoiceId (i.e. still not applied) is found
--> if (UtilValidate.isNotEmpty(paymentApplications)) is true -->
a new PaymentApplication is created for 30$ and applied to the invoice;
the original PaymentApplication is updated and the new 'available'
amount is 40$ (i.e. 70-30=40); we can now do the same with the otther
invoice...
At the end the first invoice will be PAID and the second PARTIALLY PAID.
Does it make sense?
Jacopo
Re: captureBillingAccountPayments
Posted by Jacopo Cappellato <ti...@sastau.it>.
skip@theDevers wrote:
> I am having a discussion with Si about billing accounts. For me,
> captureBillingAccountPayments works and the deprecated
> captureBillingAccountPayment does not.
>
> However, captureBillingAccountPayments essentially does nothing (which it
> the right thing to do in this case).
>
> My question is, what was the intent of the logic after the
>
>
> if (UtilValidate.isNotEmpty(paymentApplications)) {
>
> which for me is always empty and never gets executed.
>
> Can the author comment? Is there some case where this will contain
> paymentApplications?
>
> Skip
Let's say you get a billing account and two not paid invoices associated
to it, one for 30$ and one for 50$.
You get a payment from your customer for 70$; you associate the whole
payment to the billing account: this will create a PaymentApplication
record with billingAccountId set, and a null invoiceId.
Then, if you go to the billing account's invoices screen and you click
on the "capture payments" link near to the 30$ invoice, then the
captureBillingAccountPayments service will be called -> the
PaymentApplication with null invoiceId (i.e. still not applied) is found
--> if (UtilValidate.isNotEmpty(paymentApplications)) is true -->
a new PaymentApplication is created for 30$ and applied to the invoice;
the original PaymentApplication is updated and the new 'available'
amount is 40$ (i.e. 70-30=40); we can now do the same with the otther
invoice...
At the end the first invoice will be PAID and the second PARTIALLY PAID.
Does it make sense?
Jacopo