Administrator
|
Hi Skip,
Just a pointer : sendOrderNotificationScreen Jacques De : "skip@theDevers" <[hidden email]> > 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 > |
In reply to this post by Jacopo Cappellato
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 |
In reply to this post by Scott Gray
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 |
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 > > > > |
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:[hidden email]] Sent: Wednesday, October 31, 2007 2:32 PM To: [hidden email] 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 > > > > |
In reply to this post by BJ Freeman
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 >> >> >> >> > > > |
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 <[hidden email]> 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 > >> > >> > >> > >> > > > > > > > |
In reply to this post by BJ Freeman
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:[hidden email]] Sent: Wednesday, October 31, 2007 3:01 PM To: [hidden email] 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 >> >> >> >> > > > |
In reply to this post by Scott Gray
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:[hidden email]] Sent: Wednesday, October 31, 2007 2:10 PM To: [hidden email] 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 <[hidden email]> 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. > >> 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 > >> > >> > >> > >> > > > > > > > |
In reply to this post by Scott Gray
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:[hidden email]] Sent: Wednesday, October 31, 2007 2:10 PM To: [hidden email] 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 <[hidden email]> 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. > >> 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 > >> > >> > >> > >> > > > > > > > |
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:[hidden email]] > Sent: Wednesday, October 31, 2007 2:10 PM > To: [hidden email] > 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 <[hidden email]> 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 >>>> >>>> >>>> >>>> >>> >>> > > > > |
In reply to this post by SkipDever
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:[hidden email]] > Sent: Wednesday, October 31, 2007 3:01 PM > To: [hidden email] > 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 >>> >>> >>> >>> >> >> > > > > |
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:[hidden email]] Sent: Thursday, November 01, 2007 1:10 PM To: [hidden email] 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 > I am expecting it to turn up in Requirements, but that may be the wrong > assumption. > > Skip > > -----Original Message----- > From: BJ Freeman [mailto:[hidden email]] > Sent: Wednesday, October 31, 2007 3:01 PM > To: [hidden email] > 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 >>> 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 >>> >>> >>> >>> >> >> > > > > |
In reply to this post by SkipDever
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:[hidden email]] > Sent: Wednesday, October 31, 2007 2:10 PM > To: [hidden email] > 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 <[hidden email]> 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 >>>> >>>> >>>> >>>> >>> >>> > > > > |
In reply to this post by SkipDever
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:[hidden email]] > Sent: Thursday, November 01, 2007 1:10 PM > To: [hidden email] > 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:[hidden email]] >> Sent: Wednesday, October 31, 2007 3:01 PM >> To: [hidden email] >> 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 >>>> >>>> >>>> >>>> >>> >> >> >> > > > > |
In reply to this post by SkipDever
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:[hidden email]] > Sent: Thursday, November 01, 2007 1:10 PM > To: [hidden email] > 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:[hidden email]] >> Sent: Wednesday, October 31, 2007 3:01 PM >> To: [hidden email] >> 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 >>>> >>>> >>>> >>>> >>> >> >> >> |
In reply to this post by Scott Gray
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 |
In reply to this post by Jacopo Cappellato
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 |
In reply to this post by BJ Freeman
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 |
Administrator
|
+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" <[hidden email]> > 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 > > |
Free forum by Nabble | Edit this page |