Re: Conecting to Derby on Docker
Hello Dan, The client software provides both embedded and remote connections. Let's first agree if I need to make modifications in the following Ofbiz configuration before proceeding. I tried the embedded connection with URL = 'jdbc:derby:ofbiz;create=true' the connection succeeds but it only showing schemas 'APP' and 'SQLJ' and no mention to "ofbiz'. I also tried the remote connection with default port 1527 exposed by docker and have the URL 'jdbc:derby://localhost:1527/ofbiz;create=true' and heree's the error message I'm getting: DBMS: Apache Derby (ver. 10.16.1.1 - (1901046)) Case sensitivity: plain=upper, delimited=exact Driver: Apache Derby Embedded JDBC Driver (ver. 10.16.1.1 - (1901046), JDBC4.2) A communications error has been detected: Connection reset. Regards, Emad On Tue, May 28, 2024 at 5:37 PM Daniel Watford wrote: > Hi Emad, > > How does the client software establish a connection to Derby? > > Assuming it is a TCP port, then you should be able to > expose/publish/forward those ports from the docker container to the host > system. > > Dan. > > On Tue, 28 May 2024 at 15:29, Emad Radwan wrote: > > > Hello Comunity, > > > > I have a fresh Ofbiz installation using the latest build on Docker and I > > want want to view the default database using a client like Jetbrains > tools > > - or others as I think they're similar - but I need some guidance for > how. > > to expose in Docker. > > > > Reegards, > > Emad > > > > > -- > Daniel Watford >
Conecting to Derby on Docker
Hello Comunity, I have a fresh Ofbiz installation using the latest build on Docker and I want want to view the default database using a client like Jetbrains tools - or others as I think they're similar - but I need some guidance for how. to expose in Docker. Reegards, Emad
Error with executeMRP service
Hello Community, I'm working with the Manufacturing tutorial on Sharan's book - making tables with wood, nails and varnish - when I run the MRP and as guided I got the authentication error that - when searched - found that this was reported before in the following thread but unfortunately when I applied the workaround - noticed that the problem still there in the online demo - it didn't work for me and I got the following error message which is not describing exactly what is happening as I entered the 'facilityId' in the params. facilityId and facilityGroupId cannot be both null https://lists.apache.org/list?user@ofbiz.apache.org:2022-11:User%20authorization%20is%20required%20for%20this%20service:%20executeMrp Regards, Emad
An odd behavior in Payments
Hello Community, While creating a new incoming payment if the 'Payment Method Id' dropdown I select one that is linked to a financial account, a financial account transaction is created which is fine. But if I try to create a payment where the paymentMethodId is not linked to a financial account - like Cash - then no financial account transaction is created which is also fine till now. The issue is that Ofbiz after creating the payment displays the 'edit' form for the payment allowing a user to change the paymentMethodId which if was created with "Cash' and then changed to a one based on a Financial Account, then no financial account transaction is created. Regards, Emad
Re: Create Accounting Transactions forms
Thanks, I'll check it out! On Fri, Apr 26, 2024 at 9:30 AM Pierre Smits wrote: > HI Emad, > > I had to dig a bit to get to the nitty-gritty of this. > > So you accessed: > Organization GL Settings ( > https://demo-trunk.ofbiz.apache.org/accounting/control/PartyAccountsSummary), > and > on the page shown you clicked the 'Accounting' trigger, and on the > 'Accounts Summary' page you clicked > the 'Create Payment Accounting Transaction' trigger > > https://demo-trunk.ofbiz.apache.org/accounting/control/CreateAcctgTransAndEntries?acctgTransTypeId=PAYMENT_ACCTG_TRANS=CURRENT_LIABILITY=Company=CASH_EQUIVALENT > which generated the 'Quick Create an Accounting Transaction' page, showing > the Acctg Trans Type 'Payment? > > The thing is that while the 'Create Sales Accounting Transaction is more > explaining in both description 'Sales' and parameters, the 'Create Payment > Accounting Transaction isn't. > It does not differentiate what kind of payment (e.g. Incoming, Outgoing, > Payroll, etc. Nor do the parameters in the uri help. The acctgTransTypeId= > <https://demo-trunk.ofbiz.apache.org/accounting/control/CreateAcctgTransAndEntries?acctgTransTypeId=PAYMENT_ACCTG_TRANS=CURRENT_LIABILITY=Company=CASH_EQUIVALENT> > PAYMENT_ACCTG_TRANS > <https://demo-trunk.ofbiz.apache.org/accounting/control/CreateAcctgTransAndEntries?acctgTransTypeId=PAYMENT_ACCTG_TRANS=CURRENT_LIABILITY=Company=CASH_EQUIVALENT> > is > used as a parentTypeId for: > hasTable="N" parentTypeId="PAYMENT_ACCTG_TRANS"/> > "N" parentTypeId="PAYMENT_ACCTG_TRANS"/> > > and the other two parameters =CURRENT_LIABILITY > <https://demo-trunk.ofbiz.apache.org/accounting/control/CreateAcctgTransAndEntries?acctgTransTypeId=PAYMENT_ACCTG_TRANS=CURRENT_LIABILITY=Company=CASH_EQUIVALENT> > and =CASH_EQUIVALENT > <https://demo-trunk.ofbiz.apache.org/accounting/control/CreateAcctgTransAndEntries?acctgTransTypeId=PAYMENT_ACCTG_TRANS=CURRENT_LIABILITY=Company=CASH_EQUIVALENT> > indicate > that the following was intended: > "N" parentTypeId="PAYMENT_ACCTG_TRANS"/> > > So, in this case, the uri could also have been: > > https://demo-trunk.ofbiz.apache.org/accounting/control/CreateAcctgTransAndEntries?acctgTransTypeId=RECEIPT=CURRENT_LIABILITY=Company=CASH_EQUIVALENT > <https://demo-trunk.ofbiz.apache.org/accounting/control/CreateAcctgTransAndEntries?acctgTransTypeId=PAYMENT_ACCTG_TRANS=CURRENT_LIABILITY=Company=CASH_EQUIVALENT> > to get an incoming payment into the system. > > I suggest you test-drive the 'Create Payment' function in the > MainActionMenu of accounting on demo-trunk, to generate both incoming and > outgoing payment variants to see what the GL transactions are for each., > > Met vriendelijke groet, > > Pierre > > > On Thu, Apr 25, 2024 at 12:48 PM Emad Radwan > wrote: > >> Hello Pierre, >> >> Thanks for your contribution. Trying to get more understanding on how the >> enhanced version in Payment and Sales transaction works I found that. it >> utilizes the 'GlAccountClassId' for filtering the accounts in relation with >> the transaction type as per the following DOM snippet. Do you know how to >> use the same for other transaction types? e.g. if the transaction type is >> 'Receipt', what GlAccountClassId classes to use to filter debit and credit >> accounts? >> >> > href="/accounting/control/CreateAcctgTransAndEntries?acctgTransTypeId=PAYMENT_ACCTG_TRANScreditGlAccountClassId=CURRENT_LIABILITYorganizationPartyId=CompanydebitGlAccountClassId=CASH_EQUIVALENT"> >>Create Payment Accounting Transaction >> >> Regards, >> Emad >> >> >> >> On Wed, Apr 24, 2024 at 9:27 PM Pierre Smits >> wrote: >> >>> HI Emad, >>> Thank you for reaching out. >>> >>> I have put some feedback inline. >>> >>> Met vriendelijke groet, >>> >>> Pierre >>> >>> >>> On Tue, Apr 16, 2024 at 5:26 PM Emad Radwan >>> wrote: >>> >>>> Hello Community, >>>> >>>> Ofbiz provides many ways to create transactions manually. Under >>>> accounting >>>> summary, there are two links to 'Create Sales Accounting Transaction' >>>> and >>>> 'Create Payment Accounting Transaction' where the following screens come >>>> populated with meaningful - valid - options in both Dropdowns for Debit >>>> Gl >>>> account Id and Credit Gl account id. This is good as it prevents the >>>> user >>>> from entering wrong / unrelated account
Re: Create Accounting Transactions forms
Hello Pierre, Thanks for your contribution. Trying to get more understanding on how the enhanced version in Payment and Sales transaction works I found that. it utilizes the 'GlAccountClassId' for filtering the accounts in relation with the transaction type as per the following DOM snippet. Do you know how to use the same for other transaction types? e.g. if the transaction type is 'Receipt', what GlAccountClassId classes to use to filter debit and credit accounts? Create Payment Accounting Transaction Regards, Emad On Wed, Apr 24, 2024 at 9:27 PM Pierre Smits wrote: > HI Emad, > Thank you for reaching out. > > I have put some feedback inline. > > Met vriendelijke groet, > > Pierre > > > On Tue, Apr 16, 2024 at 5:26 PM Emad Radwan wrote: > >> Hello Community, >> >> Ofbiz provides many ways to create transactions manually. Under accounting >> summary, there are two links to 'Create Sales Accounting Transaction' and >> 'Create Payment Accounting Transaction' where the following screens come >> populated with meaningful - valid - options in both Dropdowns for Debit Gl >> account Id and Credit Gl account id. This is good as it prevents the user >> from entering wrong / unrelated account Ids based on the transaction type. >> > > Thanks. It good to see that OFBiz Accounting is being used. > > >> On the other hand, the other forms for creating transactions don't provide >> such filtering of the accounts allowing the user to select any value in >> the >> three dropdowns - transaction type, debit and credit -. > > > My question is why? >> Are there cases - accounting-wise - that requires this kind of flexibility >> and depend on the user to select the right account while opening the door >> for entering nonrelated data? e.g. what would it mean to select Accounts >> Receivable in the two entries of the transaction? >> > > I can only think of the situation that the original development was done a > bit hastily to just have the functionality in, catering to all use-cases. > And after that a different contributor added the functionality under the > Accounting Summary and did the additional stuff to have a good > differentiation between the two functions for Sales Accounting Transaction > and Payment Transaction. > > As you may have noticed in demo-trunk, I contributed the MainActionMenu ( > https://demo-trunk.ofbiz.apache.org/accounting/control/main) that has the > functionality to trigger the create of a Accounting Transaction. > > If you feel that form could do with a bit of improvement, please create a > new ticket in our JIRA and I will work it into my list of priorities to do. > > Thanks, and best regards, > > >> >> Regards, >> Emad >> >
Create Accounting Transactions forms
Hello Community, Ofbiz provides many ways to create transactions manually. Under accounting summary, there are two links to 'Create Sales Accounting Transaction' and 'Create Payment Accounting Transaction' where the following screens come populated with meaningful - valid - options in both Dropdowns for Debit Gl account Id and Credit Gl account id. This is good as it prevents the user from entering wrong / unrelated account Ids based on the transaction type. On the other hand, the other forms for creating transactions don't provide such filtering of the accounts allowing the user to select any value in the three dropdowns - transaction type, debit and credit -. My question is why? Are there cases - accounting-wise - that requires this kind of flexibility and depend on the user to select the right account while opening the door for entering nonrelated data? e.g. what would it mean to select Accounts Receivable in the two entries of the transaction? Regards, Emad
Online Demo UI Language
Hello Community, I checked every where to change the current german to english with no luck. How to do that? Also any restriction to play with this to not disturb other users? Regards, Emad
Crash when logging is set to Verbose
Hello Community, I noticed that - even in the online demo - that if logging is set to verbose and while calling 'Quick receive order' for an approved purchase order that it crashes the whole session. Regards, Emad
Fwd: Sales Order and WorkEffort Integration
Hello Community, I understand that the WorkEffort module will need some customization adding extra properties for my case like Vehicle data but I need some help on the below for anybody used the Workeffort module. Any hint is appreciated. Regards, Emad -- Forwarded message - From: Emad Radwan Date: Thu, Mar 7, 2024 at 1:21 PM Subject: Sales Order and WorkEffort Integration To: Hello Community, Assume we're in a Car Dealer Workshop, would you please let me know how Ofbiz - by design - handles the situation of integrating the subject modules? I'd appreciate it if you could just mention the workflow - screens - you'll go through to handle the situation from the vehicle coming to the workshop to creating the invoice. I'm confused about which module to start with as both provide links to each other. Also, there are DB entities to - WorkEffortInventoryAssign - handle inventory to be assigned to the Workeffort which let me question if OrderItems may not be the place for spare parts used while fixing the car. Best Regards, Emad
Sales Order and WorkEffort Integration
Hello Community, Assume we're in a Car Dealer Workshop, would you please let me know how Ofbiz - by design - handles the situation of integrating the subject modules? I'd appreciate it if you could just mention the workflow - screens - you'll go through to handle the situation from the vehicle coming to the workshop to creating the invoice. I'm confused about which module to start with as both provide links to each other. Also, there are DB entities to - WorkEffortInventoryAssign - handle inventory to be assigned to the Workeffort which let me question if OrderItems may not be the place for spare parts used while fixing the car. Best Regards, Emad
Re: Shipment of inventory for a workshop
Hello Ingo, Thanks for the update. In my settings - all defaults like the demo version - 'Quick ship entire order' moves the sales order to 'Completed'! 1 - Please mention those store settings that affect this workflow. 2 - What is the workflow to link the sales order with the Workeffort. Regards, Emad On Mon, Mar 4, 2024 at 10:24 AM Ingo Wolfmayr wrote: > Hi Emad, > > > Completing the quick ship for the entire order is not the final step when > managing inventory. Depending on your store settings, inventory is > allocated when the order status changes to "approved". You can view the > assigned inventory in the order lines, with ATP being reduced while QOH > remains unchanged. At this stage, you can still edit the order > (update/create/delete order lines...). > > Upon finalizing the order, QOH will decrease as the inventory leaves the > facility. > > > Best regards, Ingo > > > Von: Emad Radwan > Gesendet: Sonntag, 3. März 2024 14:18:38 > An: user@ofbiz.apache.org > Betreff: Shipment of inventory for a workshop > > Hello Community, > > Issuing customer inventory is the last step via actions like 'Quick ship > entire order' and maybe others. That's fine in merchandising but if we're > in a workshop where we need to issue the spare parts to do the maintenance > and finalizing the sales order is yet to take place later. Could you let me > know how this situation is handled? > > Regadsm > Emad >
Shipment of inventory for a workshop
Hello Community, Issuing customer inventory is the last step via actions like 'Quick ship entire order' and maybe others. That's fine in merchandising but if we're in a workshop where we need to issue the spare parts to do the maintenance and finalizing the sales order is yet to take place later. Could you let me know how this situation is handled? Regadsm Emad
Re: Purchase Order Receive Product
getProductCost is also used from the ReceiveInventoryProduct workflow and it depends as part of its logic on SupplierProduct to get the unit cost. My concern here is, if the new purchase price is different than the last one then I think this logic won't be relevant; so is SetUnitPriceAsLastPrice is called before tht to update SupplierProduct with the new Price? Regards, Emad On Sat, Feb 24, 2024 at 12:03 AM Pierre Smits wrote: > Hi Emad, > > the 'SetUnitPriceAsLastPrice' service is called/triggered in the following > cases: > >1. when "updateOrderItems" is triggered >2. when receiveInventoryProduct is triggered > > But ideally it should not be a task of the warehouse staff to check for > correct prices. That should be done by the accounting staff when the > purchase invoice is reviewed/processed. > > Met vriendelijke groet, > > Pierre Smits > *Proud* *contributor** of* Apache OFBiz <https://ofbiz.apache.org/> since > 2008 (without privileges) > Proud contributor to the ASF since 2006 > *Apache Directory <https://directory.apache.org>, PMC Member* > > Anyone could have been you, whereas I've always been anyone. > > > On Fri, Feb 23, 2024 at 5:06 PM Emad Radwan wrote: > >> Hello Community, >> >> Part of the above workflow is to set the last product price in >> SupplierProducts entity and I believe this is done via the service >> 'SetUnitPriceAsLastPrice' >> My question is when is this taking place? >> >> 1 - With Purchase order creation. >> 2 - With Purchase Order Receive Product. >> 3 - Both. >> >> Regards, >> Emad >> >
Purchase Order Receive Product
Hello Community, Part of the above workflow is to set the last product price in SupplierProducts entity and I believe this is done via the service 'SetUnitPriceAsLastPrice' My question is when is this taking place? 1 - With Purchase order creation. 2 - With Purchase Order Receive Product. 3 - Both. Regards, Emad
Re: Unit Price & Adjustments
Thank you for the clarification. On Wed, Dec 13, 2023 at 12:46 PM Nicolas Malin wrote: > Normally if you edit your order lines like > https://demo-trunk.ofbiz.apache.org/ordermgr/control/editOrderItems?orderId=DEMO10090 > you have a adjustment line to add it manually > > Nicolas > > Le 20/11/2023 à 14:12, Emad Radwan a écrit : > > Hello Community, > > In the sales order workflow, is there a way to create a 'manual' > adjustment; a discount for example? If yes, what is the UI to do this? > > If the above is true, how will this affect the unit price? In other words, > will it be added as an order adjustment for that specific item but not > deducted from the list price or it will be deducted from the list price? > > Regards, > Emad > > > >
Unit Price & Adjustments
Hello Community, In the sales order workflow, is there a way to create a 'manual' adjustment; a discount for example? If yes, what is the UI to do this? If the above is true, how will this affect the unit price? In other words, will it be added as an order adjustment for that specific item but not deducted from the list price or it will be deducted from the list price? Regards, Emad
Confused about service createAcctgTransForSalesInvoice
Hello Community, In the subject service, there's the following comment and line of code that's located in GeneralLedgerServices line 2195. My question is why is invoiceItemTypeId being passed as a parameter to glAccountTypeId? As what I noticed in subsequent services that decide the GlAccountId starting from getGlAccoutFromAccountType that an invoiceItemTypeId like 'INV_FPROD_ITEM' or 'ITM_PROMOTION_ADJ' is used as a glAccountTypeId which I believe won't return any data - as per my basic understanding. As the demo data doesn't come with many 'GL overrides' in tables like ProductGlAccount, PartyGlAccount, etc I was not able to track a complete example but I understand that any configuration in such tables will use an actual GlAccountTypeId that when compared with an invoiceItemTypeId won't return any data. Also, the comments in the code below are not clear to me. Thanks in advance if you can shed some light on this, Regards Emad
GL Account Defaults not working as expected
Hello Community,
In a completed sales order and while inspecting the generated accounting
transactions for the sales invoice, I was expecting to have the Gl Account
Id for the Debit entry of the transaction with GlAccoutTypeId =
'ACCOUNTS_RECEIVABLE'
to get its value from the Product Gl Account defaults that I created for
the product in the invoice - see below - however, and by tracking the logs
I found Gl Account 12 was used from Gl Account Type Defaults.
Why do you think the default I created for the product was not used?
Regards,
Emad
{
"ACCTG_TRANS_ID": "10571",
"ACCTG_TRANS_ENTRY_SEQ_ID": "7",
"ACCTG_TRANS_ENTRY_TYPE_ID": "_NA_",
"DESCRIPTION": null,
"VOUCHER_REF": null,
"PARTY_ID": "DemoCustomer",
"ROLE_TYPE_ID": "BILL_TO_CUSTOMER",
"THEIR_PARTY_ID": null,
"PRODUCT_ID": null,
"THEIR_PRODUCT_ID": null,
"INVENTORY_ITEM_ID": null,
"GL_ACCOUNT_TYPE_ID": "ACCOUNTS_RECEIVABLE",
"GL_ACCOUNT_ID": "12",
"ORGANIZATION_PARTY_ID": "Company",
"AMOUNT": 23.75,
"CURRENCY_UOM_ID": "USD",
"ORIG_AMOUNT": 23.75,
"ORIG_CURRENCY_UOM_ID": "USD",
"DEBIT_CREDIT_FLAG": "D",
"DUE_DATE": null,
"GROUP_ID": null,
"TAX_ID": null,
"RECONCILE_STATUS_ID": "AES_NOT_RECONCILED",
"SETTLEMENT_TERM_ID": null,
"IS_SUMMARY": null,
"LAST_UPDATED_STAMP": "2023-11-08 12:19:48.207",
"LAST_UPDATED_TX_STAMP": "2023-11-08 12:19:28.357",
"CREATED_STAMP": "2023-11-08 12:19:48.207",
"CREATED_TX_STAMP": "2023-11-08 12:19:28.357"
}
{
"PRODUCT_ID": "GZ-1001",
"ORGANIZATION_PARTY_ID": "Company",
"GL_ACCOUNT_TYPE_ID": "ACCOUNTS_RECEIVABLE",
"GL_ACCOUNT_ID": "1",
"LAST_UPDATED_STAMP": "2023-11-08 12:14:56.733",
"LAST_UPDATED_TX_STAMP": "2023-11-08 12:14:56.313",
"CREATED_STAMP": "2023-11-08 12:14:56.733",
"CREATED_TX_STAMP": "2023-11-08 12:14:56.313"
}
{
"GL_ACCOUNT_ID": "1",
"GL_ACCOUNT_TYPE_ID": "ACCOUNTS_RECEIVABLE",
"GL_ACCOUNT_CLASS_ID": "CURRENT_ASSET",
"GL_RESOURCE_TYPE_ID": "MONEY",
"GL_XBRL_CLASS_ID": null,
"PARENT_GL_ACCOUNT_ID": "12",
"ACCOUNT_CODE": "120010",
"ACCOUNT_NAME": "ACCOUNTS RECEIVABLE - GZ-1001",
"DESCRIPTION": "SUB LEDGER ACCOUNT FOR PRODUCT GZ-1001",
"PRODUCT_ID": "GZ-1001",
"EXTERNAL_ID": null,
"LAST_UPDATED_STAMP": "2023-11-08 12:12:48.410",
"LAST_UPDATED_TX_STAMP": "2023-11-08 12:12:48.217",
"CREATED_STAMP": "2023-10-30 08:51:30.197",
"CREATED_TX_STAMP": "2023-10-30 08:51:30.040"
}
Re: What controls the creation of one or more invoices?
Thank you for the clarification. On Tue, 7 Nov 2023, 12:12 Nicolas Malin, wrote: > Hello Emad > > Your invoice is created by default from each shipment did. > > So if you order is linked to one shipment, you'll have only one invoice. > > Nicolas > > Le 15/10/2023 à 10:06, Emad Radwan a écrit : > > Hello Community, > > Please shed some light on this for a sales order. Let's assume the case > that the payment will be made using both Cash On Delivery and a Billing > Account, how will this affect the number of invoices? > > Regards, > Emad > > > >
What controls the creation of one or more invoices?
Hello Community, Please shed some light on this for a sales order. Let's assume the case that the payment will be made using both Cash On Delivery and a Billing Account, how will this affect the number of invoices? Regards, Emad
Re: Inventory - PRODUCT_FACILITY - Last_Inventory_Count
Many thanks, Giiulio for the detailed explanation. On Sat, Oct 7, 2023 at 7:15 PM Giulio Speri - MpStyle Srl < giulio.sp...@mpstyle.it> wrote: > Hello Emad, > > the lastInventoryCount field in the ProductFacility entity stores the last > stock availability of a product for a facility, that is the Available To > Promise (ATP) total among all inventory items of a product in a facility, > so it's correct that the lastInventoryCount field is updated each time an > order is created (if product store is configured to reserve inventory of > course). > > If you check the field description in the product-entitymodel.xml > (applications/datamodel/entitydef) file you can see clearly the goal of > that field. > > When the item is physically shipped the value that changes is the Quantity > On Hand (QOH) field of an InventoryItem. > The difference between the two fields is that ATP (Available To Promise) is > the quantity I still have available for other orders to come for a specific > product, while Quantity On Hand (QOH) contains both items already > reserved for some orders and items still available for new orders. > > In short: > ATP = QOH - order reservations already made for an item > QOH = the items I physically have on the shelf of the warehouse including > both items still available and items already reserved > > Hope it helps. > Giulio > > > Il giorno sab 7 ott 2023 alle ore 09:27 Emad Radwan > > ha scritto: > > > Hello Community, > > > > I noticed that when I create a sales order with the 'Approved' status the > > ProductFacility entity gets updated by deducting the reserved product > > quantity from the last_inventory_count field. Doesn't this should happen > > only when the item is physically shipped? > > > > Regards, > > Emad > > > > > -- > Giulio Speri > > > *Mp Styl**e Srl* > via Antonio Meucci, 37 > 41019 Limidi di Soliera (MO) > T 059/684916 > M 347/0965506 > > www.mpstyle.it >
Inventory - PRODUCT_FACILITY - Last_Inventory_Count
Hello Community, I noticed that when I create a sales order with the 'Approved' status the ProductFacility entity gets updated by deducting the reserved product quantity from the last_inventory_count field. Doesn't this should happen only when the item is physically shipped? Regards, Emad
https://ofbiz.markmail.org/
Hello Community, Why this site is always down recently? Regards, Emad
Re: Debug Ofbiz that's running on Docker
Hello Dan, Sorry for returning to this after long time. I think 'ofbizDebug' is not available in the code base used to build the Docker image. Regards, Emad On Fri, May 20, 2022 at 2:42 PM Daniel Watford wrote: > Hi Emad, > > I've not tested this today, but try replacing the docker-compose.yml file > with something similar to : > > > version: '3.2' > services: > activate: > image: ofbiz:latest > command: ./gradlew "ofbizDebug --load-data dir=local-config" ofbiz > volumes: > - type: bind > source: ./local-config > target: /ofbiz/local-config > ports: > - 8443:8443 - 5005:5005 > > In the above docker-compose.yml file, the command now runs the ofbizDebug > gradle task rather than ofbiz. > > Running the ofbizDebug task sets debug=true on the underlying gradle > JavaExec task used to run ofbiz. When debug=true the JVM is launched in the > suspended debug state, listening on port 5005 for a debugger to connect.. > > In the above docker-compose.yml file, port 5005 has been exposed meaning > your debugger should be able to connect to the ofbiz JVM. > > Please let us know if the above works for you. > > Thanks, > > Dan. > > > On Fri, 20 May 2022 at 13:10, Emad Radwan wrote: > > > Hello Community, > > > > I’m running the following configuration using Docker, does anyone know > how > > to modify it to allow for remote debugging? > > > > Regards, > > Emad > > > > https://github.com/danwatford/ofbiz-docker > > > > -- > Daniel Watford >
Re: Inventory for Sales People
Hello Bill, Many thanks, it's an excellent idea. Makes a lot of sense. Regards, Emad On Mon, Sep 25, 2023 at 3:28 AM Bill Harder wrote: > Emad, I have read your posts and you seem to be much more knowledgeable > than I on OFBiz. I would think that you could create facilities. A > facility could be a service van, a medical bag, a manufacturer's home based > rep, and only individuals with access could sell inventory from that > facility. It's just a thought. > > Bill > > On Sun, Sep 24, 2023 at 1:18 AM Emad Radwan wrote: > > > Hello Community, > > > > Any ideas, please? > > > > Regards, > > Emad > > > > On Thu, Sep 21, 2023 at 1:24 PM Emad Radwan > wrote: > > > > > Hello Community, > > > > > > How do we handle the workflow for the sales team that takes inventory > > > items to sell remotely? I understand that Sales Order workflow where we > > > sell directly to customers and inventory reservation happens as part of > > his > > > process. Still, in that other case if a salesperson withdraws some > > > inventory items we can't consider that a sale yet. > > > > > > Regards, > > > Emad > > > > > > > > -- > Bill Harder > OsZ Technologies > 256 N State St > Ste D > Hemet, CA 92543 > > Voice: 818-632-5790 > > eMail: bhar...@osz.com > www: www.osz.com >
Re: Inventory for Sales People
Hello Community, Any ideas, please? Regards, Emad On Thu, Sep 21, 2023 at 1:24 PM Emad Radwan wrote: > Hello Community, > > How do we handle the workflow for the sales team that takes inventory > items to sell remotely? I understand that Sales Order workflow where we > sell directly to customers and inventory reservation happens as part of his > process. Still, in that other case if a salesperson withdraws some > inventory items we can't consider that a sale yet. > > Regards, > Emad >
Re: UI/UX question on the Facility module
Many thanks Jacques; this explains the thing. Would you please have a look at my latest question? Best Regards, Emad On Wed, 20 Sept 2023, 20:37 Jacques Le Roux, wrote: > Hi Emad, > > Here you go: https://issues.apache.org/jira/browse/OFBIZ-5321 > > HTH > > Jacques > > Le 15/09/2023 à 17:09, Emad Radwan a écrit : > > Hello Community, > > > > 1- Why in Facility Manager we've to select a facility first before doing > > anything else even if there's only one facility defined; this is even > > highlighted with a remark in that screen. ' > > If there is only one facility, you need to select it to continue, no > search > > available' > > > > 2 - This is related to having the Facility LOV available in the search > > parameters for related screens; in the Inventory screen such LOV isn't > > available and the search result is for the previously selected facility > > only, while in 'Inventory Items' and 'Inventory Item Details' we have the > > Facility LOV available. > > > > I believe there's some wisdom in this design and would appreciate it if > you > > share it with me. > > > > Regards, > > Emad >
Inventory for Sales People
Hello Community, How do we handle the workflow for the sales team that takes inventory items to sell remotely? I understand that Sales Order workflow where we sell directly to customers and inventory reservation happens as part of his process. Still, in that other case if a salesperson withdraws some inventory items we can't consider that a sale yet. Regards, Emad
UI/UX question on the Facility module
Hello Community, 1- Why in Facility Manager we've to select a facility first before doing anything else even if there's only one facility defined; this is even highlighted with a remark in that screen. ' If there is only one facility, you need to select it to continue, no search available' 2 - This is related to having the Facility LOV available in the search parameters for related screens; in the Inventory screen such LOV isn't available and the search result is for the previously selected facility only, while in 'Inventory Items' and 'Inventory Item Details' we have the Facility LOV available. I believe there's some wisdom in this design and would appreciate it if you share it with me. Regards, Emad
Modeling of standard rates
Hello Community, I want to configure Ofbiz in a Car Dealer Workshop and I have a requirement to model standard rates for a combination like 'How long it takes to change oil for Toyota Camry'. I thought of the following: - Changing oil will be defined as a service. - Car make and model can be defined as Product Features - I also thought that the rate itself - 30 minutes - can also be defined as a new feature. The question - if you're ok with the above - is how to link them all together to represent a unique value. Regards, Emad
Re: Question on Barcode
Thank you for the clarification. On Sun, Jun 25, 2023 at 6:44 PM Nicolas Malin wrote: > Hello Emad, > > Barcode example in OFBiz work only with the productId. Help yourself to > implement your own screen with what you need : > * create an other screen like ProductScreens.xml#ProductBarCode.fo > * create a ftl that will contains your barcode as regards to xsl-fo > documentation > > Nicolas > > Le 19/06/2023 à 13:09, Emad Radwan a écrit : > > Hello Community, > > I'm confused about barcodes. > > 1 - Does it represent another form/format of the productId or it represents > each and every occurrence of that specific product item? In other words, is > it something related to product identification or to inventory as well in > case the barcode is related to each instance of the product? > > 2 - Is the GoodIdentification entity related to barcode generation and > management? > > Regards, > Emad > > > >
Re: Question on Barcode
Help please. On Mon, 19 Jun 2023, 14:09 Emad Radwan, wrote: > Hello Community, > > I'm confused about barcodes. > > 1 - Does it represent another form/format of the productId or it > represents each and every occurrence of that specific product item? In > other words, is it something related to product identification or to > inventory as well in case the barcode is related to each instance of the > product? > > 2 - Is the GoodIdentification entity related to barcode generation and > management? > > Regards, > Emad >
Question on Barcode
Hello Community, I'm confused about barcodes. 1 - Does it represent another form/format of the productId or it represents each and every occurrence of that specific product item? In other words, is it something related to product identification or to inventory as well in case the barcode is related to each instance of the product? 2 - Is the GoodIdentification entity related to barcode generation and management? Regards, Emad
Re: Manufacturing : Bill of Material and Product run Proccess
Hello Community, It's worth mentioning that the shared tutorial is part of a complete book that contains more information on the subject for those who are interested. The mentioned book - Getting Started with Apache OFBiz Manufacturing & MRP - by Sharan Foga, and her other book on OFBiz Accounting are very helpful. I have both books but only used the accounting one which helped me understand how the accounting module works. Regards, Emad On Mon, Jun 12, 2023 at 9:25 PM vivek mishra wrote: > Hi Yashwant, > > I am seeing a couple of discrepancies in the document and the existing > 18.12 demo site. > > 1. Manufacturing finished good is showing as Product Requirement instead of > Internal requirement under order manager -> requirement section. > 2. After approving finished good, no production run is getting created > under Manufacturing -> Job shop. > 3. Creating a purchase order from order manager -> requirement -> find > approve requirement by the supplier is throwing the below error: > Problem occurred in tax service (Service [calcTax] target threw an > unexpected exception (null)) (Service [calcTax] target threw an unexpected > exception (null)) > > Please let me know if I am missing something or if any process change is > there in the latest version(s). > > Regards, > Vivek > > > On Mon, Jun 12, 2023 at 3:15 PM vivek mishra > wrote: > > > Thanks Yashwant. This will help. > > > > Regards, > > Vivek > > > > On Mon, 12 Jun, 2023, 11:51 am Yashwant Dhakad, < > > yashwant.dha...@hotwaxsystems.com> wrote: > > > >> Hi Vivek, > >> Here is the book > >> < > >> > https://cwiki.apache.org/confluence/download/attachments/46632635/Manufacturing5StepGuide.pdf?version=1=1505722113000=v2 > >> > > >> for BOM and Production run process. > >> > >> On Mon, Jun 12, 2023 at 1:06 AM vivek mishra > >> wrote: > >> > >> > Hi Team, > >> > > >> > Could you please help with any documentation describing the Bill of > >> > Material and Product run process? > >> > Quick help will be appreciated! > >> > > >> > Regards, > >> > Vivek > >> > > >> > >> > >> -- > >> Kind Regards, > >> Yashwant Dhakad > >> Sr. Technical Consultant > >> > >> *HotWax Systems* > >> *Enterprise open source experts* > >> cell: +91-9098240513 > >> office: 0731-409-3684 > >> http://www.hotwaxsystems.com > >> > > >
ChatGPT answer to my Ofbiz question :)
This is my question that I just posted here to the community: "Part of the columns that Ofbiz allows to edit is the Product. I'm not getting the use case behind this, Won't it affect the consistency of the Purchase Order related to inventory item? Also - from business perspective - I can understand why I would need to edit the inventory item but when I'll need to create it from scratch without a purchase order?" *And here is the response from ChatGPTm what do you think?* In Apache OFBiz, the ability to edit product information is provided to accommodate certain use cases and business requirements. While it's true that modifying product information could potentially impact the consistency of purchase orders related to inventory items, OFBiz incorporates mechanisms to handle such scenarios. Regarding the impact on purchase orders, OFBiz employs a robust inventory management system that maintains the integrity of transactions. When a product's information is modified, it is important to consider the implications on existing purchase orders. OFBiz provides functionality to handle such updates, such as allowing users to choose whether the changes should be automatically propagated to related purchase orders or not. This ensures that any modifications to product information are appropriately reflected in purchase orders, thereby maintaining consistency. As for the need to create inventory items from scratch without a purchase order, there are several business scenarios where this might be necessary. For example: 1. New Product Introduction: When a company introduces a new product into their inventory, they may need to create the corresponding inventory item without an associated purchase order initially. 2. Manual Inventory Management: In certain cases, businesses might need to manually adjust their inventory levels due to factors like stock transfers, returns, or damaged goods. These adjustments might not be tied to a specific purchase order, but it's still important to track and manage the inventory item. 3. Internal Consumption: There could be instances where items are consumed internally within the organization and don't involve an external purchase order. In such cases, creating an inventory item without a purchase order allows for proper tracking and management of internal inventory usage. By providing the capability to create inventory items from scratch, OFBiz supports various business scenarios and ensures that all inventory-related activities can be effectively managed, whether they involve purchase orders or not.
Editing Inventory Items
Hello Community, Part of the columns that Ofbiz allows to edit is the Product. I'm not getting the use case behind this, Won't it affect the consistency of the Purchase Order related to inventory item? Also - from business perspective - I can understand why I would need to edit the inventory item but when I'll need to create it from scratch without a purchase order? Regards, Emad
Inventory Cost
Hello Community, Excellent reports are under the inventory tab regarding items and details that would be very helpful to the business. I understand from Purchase Orders how last price is brought from SupplierProduct but there'r also other entities like ProductAverageCost and ProductCalculatedInfo that are involved and maybe more that I don't know about. My question is about which artifacts are included when reporting 'Inventory Average Costs' for example. Regards, Emad
Re: Working with multiple facilities
Really helpful, Many thanks Ingo. On Wed, May 10, 2023 at 8:23 PM Ingo Wolfmayr wrote: > Hi Emad, > > you can create multiple facilities and assign inventory to the facility > (down to the place in the storage rack). The inventory entity has a > relation from the product to the facility. You can have the same product as > stock (inventory) in multiple facilities. > > In the facility app you will find everything to move inventory between > locations or pack & ship to the customer. > > If you use it with a product store you can configure it to use multiple > facility + inventory pick logic (FIFO, ...) > > If you lookup the product you will find a tab called "Inventory". Here you > will find an overview of your product stock by facility. > > If you select a facility in the facility app you will work with that > facility - process all shippings from that facility. Move inventory from > that faciilty to ... > > Best regards > Ingo > > -Ursprüngliche Nachricht- > Von: Emad Radwan > Gesendet: Mittwoch, 10. Mai 2023 15:47 > An: user@ofbiz.apache.org > Betreff: Working with multiple facilities > > Hello Community, > > How to work with multiple facilities at the same time? Like moving > inventory from facility A to facility B, show inventory by product in all > of our inventories, etc? > > Ofbiz - in the facility - module starts by prompting for which facility to > work with and all proceeding functionality will be based on that one > facility! > > I'm sure that I'm missing something here, please help. > > Regards, > Emad >
Working with multiple facilities
Hello Community, How to work with multiple facilities at the same time? Like moving inventory from facility A to facility B, show inventory by product in all of our inventories, etc? Ofbiz - in the facility - module starts by prompting for which facility to work with and all proceeding functionality will be based on that one facility! I'm sure that I'm missing something here, please help. Regards, Emad
Re: How to disable a Promo
Many thanks, Ingo. Appreciate it. Regards, Emad On Wed, May 10, 2023 at 10:33 AM Ingo Wolfmayr wrote: > Hi Emad, > > a promo is assigned to one or more productStore/s - you can find the > relation under the tab "stores". Here you can delete the relation or assign > a through-date. > > Best regards, > Ingo > > -Ursprüngliche Nachricht- > Von: Emad Radwan > Gesendet: Dienstag, 9. Mai 2023 21:35 > An: user@ofbiz.apache.org > Betreff: How to disable a Promo > > Hello Comunity, > > Where is the UI I can disable - temporarily / permanently - a promo, so > Ofbiz skips adding the promo product automatically to the order? > > Regards, > Emad >
Sales Order without invoice
Hello Community, If the customer is exempted from tax, is there a way to complete the sale without creating a sales invoice? Regards, Emad
Confused about the usage of table OrderPaymentPreference
Hello Community, As an example, I created a sales order for DemoCustomer and used COD as payment method, why the created record in OrderPaymentPreference is using 'EXT_OFFLINE' as payment method typem while in the generated Payment record 'COMPANY_ACCOUNT' is used instead for the same field name? Regards, Emad
Re: Purchase order payment method
Many thanks, Ashish for the usual help and valuable information. I have good experience with most of the concepts already while working with Sales Orders but you completed the missing piece of the puzzle here by mentioning agreements that I didn't visit yet, but I can imagine how the link with payments and payment methods is going to be established. Thanks again and best regards, Emad On Fri, Dec 16, 2022 at 12:42 PM Ashish Vijaywargiya < ashish.vijaywarg...@hotwaxsystems.com> wrote: > Hello Emad, > > I am sharing some details to understand the use case, hopefully it will > suffice your requirement: > > 1) Purchase Orders in the System are linked with Products(OrderItems in the > System). > > 2) Products are supplied by a Suppliers. > For example: > > https://demo-stable.ofbiz.apache.org/catalog/control/EditProductSuppliers?productId=GZ-2644 > > 3) There is a concept of agreement that plays an important role in case of > Purchase Order. > For example: > https://demo-stable.ofbiz.apache.org/accounting/control/FindAgreement > > 4) Purchase Order gets associated with a Payment. > > 5) Payments are associated with Invoices. Invoices can be of different > types: Sales Invoice, Purchase Invoice etc. > > The last step is related to the posting of transactions into General > Ledger. > > - General Ledger accounts are configured/mapped accordingly so that it > takes care of automatic posting in case of various scenarios. What type of > Invoice is there, what type of payment is there etc. > > - Once the Purchase Order is completed into the system, it means you have > received the Inventory in your warehouse. The next step is to take care of > the Payment and Invoice part in the system. > > - If you do online transfer from Company Bank Account to Supplier Bank > Account then you can keep the transaction references either in Order Note > or Invoice Note or Invoice.ReferenceNum field. > > Apache OFBiz provides you the flexibility to choose the payment method. You > can either pay by Cash, Credit Card, Billing Account etc. > > https://demo-stable.ofbiz.apache.org/webtools/control/FindGeneric?entityName=PaymentMethodType > (See the Default Gl Account field in this entity) > The agreement between a Company and a Supplier plays an important role. > > Hope this helps! > > -- > Kind Regards, > Ashish Vijaywargiya > Vice President of Operations > *HotWax Systems* > *Enterprise open source experts* > http://www.hotwaxsystems.com > > > > On Sat, Dec 10, 2022 at 11:30 PM Emad Radwan > wrote: > > > Hello Community, > > > > Would you please look inti this one? > > > > Regards, > > Emad > > > > On Mon, Dec 5, 2022 at 1:51 PM Emad Radwan > wrote: > > > > > Hello Community, > > > > > > How the subject issue is determined? In other words, how to configure > if > > > 'Company' wants to be cash or on account for their purchases? > > > > > > Regards, > > > Emad > > > > > >
Re: Purchase order payment method
Hello Community, Would you please look inti this one? Regards, Emad On Mon, Dec 5, 2022 at 1:51 PM Emad Radwan wrote: > Hello Community, > > How the subject issue is determined? In other words, how to configure if > 'Company' wants to be cash or on account for their purchases? > > Regards, > Emad >
Re: Error while receiving purchase order
Hello Dan,
The problem isn't happening when I changed the selected product from
DS-1000 - one of the three products configured for DemoSupplier - to a
newly configured product - any product like GZ-100 for the same supplier.
Hope this helps,
Regards,
Emad
On Sat, Dec 10, 2022 at 5:47 PM Daniel Watford wrote:
> Hi Emad,
>
> Can you reproduce the error using the demo site (The Apache OFBiz® Project
> - Demos <https://ofbiz.apache.org/ofbiz-demos.html>)?
>
> If so, please provide the steps to reproduce the issue and I'll take a
> look.
>
> Thanks,
>
> Dan.
>
> On Mon, 5 Dec 2022 at 17:48, Emad Radwan wrote:
>
> > Hello Community,
> >
> > This is from the logs just before the error:
> >
> > |E| {errorMessage=Value not found, cannot update, responseMessage=error}
> > ofbiz-docker-activate-1 | 2022-12-05 17:39:44,890
> > |sse-nio-8443-exec-23 |ServiceDispatcher |E| Error in
> > Service [updateProductAverageCost]: Value not found, cannot update
> > ofbiz-docker-activate-1 | 2022-12-05 17:39:44,890
> > |sse-nio-8443-exec-23 |TransactionUtil |W| Calling
> > transaction setRollbackOnly; this stack trace shows where this is
> > happening:
> > ofbiz-docker-activate-1 | java.lang.Exception: Error in Service
> > [updateProductAverageCost]: Value not found, cannot update
> >
> >
> > On Mon, Dec 5, 2022 at 7:38 PM Emad Radwan
> wrote:
> >
> > > Hello Community,
> > >
> > > While executing the subject functionality from 'quick receive entire
> > > order' I got the following error:
> > >
> > > Regards,
> > > Emad
> > >
> > > The Following Errors Occurred:
> > >
> > > Error:Service invocation error on row (0):
> > > org.codehaus.groovy.runtime.InvokerInvocationException:
> > > org.apache.ofbiz.service.ExecutionServiceException: Value not found,
> > cannot
> > > update
> > >
> >
>
>
> --
> Daniel Watford
>
Re: Error while receiving purchase order
Hello Community,
This is from the logs just before the error:
|E| {errorMessage=Value not found, cannot update, responseMessage=error}
ofbiz-docker-activate-1 | 2022-12-05 17:39:44,890
|sse-nio-8443-exec-23 |ServiceDispatcher |E| Error in
Service [updateProductAverageCost]: Value not found, cannot update
ofbiz-docker-activate-1 | 2022-12-05 17:39:44,890
|sse-nio-8443-exec-23 |TransactionUtil |W| Calling
transaction setRollbackOnly; this stack trace shows where this is
happening:
ofbiz-docker-activate-1 | java.lang.Exception: Error in Service
[updateProductAverageCost]: Value not found, cannot update
On Mon, Dec 5, 2022 at 7:38 PM Emad Radwan wrote:
> Hello Community,
>
> While executing the subject functionality from 'quick receive entire
> order' I got the following error:
>
> Regards,
> Emad
>
> The Following Errors Occurred:
>
> Error:Service invocation error on row (0):
> org.codehaus.groovy.runtime.InvokerInvocationException:
> org.apache.ofbiz.service.ExecutionServiceException: Value not found, cannot
> update
>
Error while receiving purchase order
Hello Community, While executing the subject functionality from 'quick receive entire order' I got the following error: Regards, Emad The Following Errors Occurred: Error:Service invocation error on row (0): org.codehaus.groovy.runtime.InvokerInvocationException: org.apache.ofbiz.service.ExecutionServiceException: Value not found, cannot update
Purchase order payment method
Hello Community, How the subject issue is determined? In other words, how to configure if 'Company' wants to be cash or on account for their purchases? Regards, Emad
How to add manual order adjustment
Hello Community, Would you please guide me to the user interface to achieve this? Regards, Emad
Re: GL Account Balance
Hello Ashish, Sorry for the late coming back to this one. Is there a way to view the SQL for AcctgTransEntrySums? I have Ofbiz using MS SQL Server and I can only find tables in Ofbiz DB and no views. Regards, Emad On Thu, Sep 1, 2022 at 2:58 PM Ashish Vijaywargiya < ashish.vijaywarg...@hotwaxsystems.com> wrote: > Hello Emad, > > Please check the "AcctgTransEntrySums" view entity(It has all credit/debit > entries based on the GlAccount). > > https://demo-stable.ofbiz.apache.org/webtools/control/FindGeneric?entityName=AcctgTransEntrySums > > Here is the definition of View Entity from accounting-entitymodel.xml: > package-name="org.apache.ofbiz.accounting.ledger" > title="Sum of AcctgTransEntry entity amounts grouped by > glAccountId, debitCreditFlag"> > > > > > > > > > > > > >group-by="false"/> > > > > > > > > > > > > Following line in the above view entity is important one: > > > Please let me know if you need further assistance on this. > > -- > Kind Regards, > Ashish Vijaywargiya > Vice President of Operations > *HotWax Systems* > *Enterprise open source experts* > http://www.hotwaxsystems.com > > > > On Sun, Aug 28, 2022 at 11:17 PM Emad Radwan > wrote: > > > Hello Community, > > > > Does Ofbiz maintain the balance of each GL account somehow and if yes, > > where its kept, and in which table? I see that both GL_Accounts and > > GL_Accounts_organization tables have no room for that. > > > > Is it being calculated on the fly when running reports from different > > transactions? > > > > Regards, > > Emad >
Re: Default Accounting Company
Hi Giulio, Thanks. For # 1, if product store roles mean that I configure a store and add certain employees - Parties - to it with named roles like the following, then yes, this is what I want. Regards, Emad On Mon, Oct 17, 2022 at 7:09 PM Giulio Speri - MpStyle Srl < giulio.sp...@mpstyle.it> wrote: > Hi Emad, > > I answer below. > > 1) I am not sure I fully understood your question here, but I think that > backoffice UI customization, alongside with Product Store Roles are needed > to achieve your goal. > > 2) ProductStoreFacility entity relates 1 or more ProductFacility to a > Store; the Facilities (for a Store) are basically the Warehouses where > products are taken/reserved from. > IE: if a ProductStore is setup with two Facilities A and B and a SalesOrder > for the product PRD001 comes in, then the system (if configured to check > and/or reserve inventory) checks in the facility A if there is enough > quantity for the product and, if not, checks in the Facility B. > You can configure each facility with a specific Sequence Number in > ProductStoreFacility so that you can choose the right order of inspection. > > 3) The ProductStorePaymentSetting controls which Payment Methods are shown > to the users for a specific ProductStore; then each PaymentMethod has its > own logic implemented behind. > > I hope it helps. > > Kind regards, > Giulio > > Il giorno lun 17 ott 2022 alle ore 14:53 Emad Radwan < > eradwan1...@gmail.com> > ha scritto: > > > Thanks Giulio and Ashish for the valuable input. > > > > Few more clarifications, please. > > > > 1 - If ofbiz is being used locally - no e-commerce - and two stores are > > defined, how to restrict employees - users - taking the order to be > limited > > only to one of these stores? > > > > 2 - What is the role of ProductStoreFacility? Since in demo data only a > few > > records are configured but even though much more products are available > > while creating orders? > > > > 3 - What exactly controls the Payment Methods presented to the user while > > creating a sales order, we have configurations in > > ProductStorePaymentSetting and PaymentMethod; are both used or there is > > extra logic here? > > > > Regards, > > Emad > > > > On Mon, Oct 17, 2022 at 1:26 PM Ashish Vijaywargiya < > > ashish.vijaywarg...@hotwaxsystems.com> wrote: > > > > > Hello Emad, > > > > > > Please refer two more entities which will help you to better visualise > > > setup of stores, facilities, products and inventories: > > > > > > - ProductFacility - > > > > > > > > > https://demo-stable.ofbiz.apache.org/webtools/control/FindGeneric?entityName=ProductFacility > > > > > > > > > https://demo-stable.ofbiz.apache.org/catalog/control/EditProductFacilities?productId=GZ-2644 > > > > > > - InventoryItem(There is a field facilityId in this entity) - > > > > > > > > > https://demo-stable.ofbiz.apache.org/webtools/control/FindGeneric?entityName=InventoryItem > > > > > > > > > https://demo-stable.ofbiz.apache.org/facility/control/EditFacilityInventoryItems?facilityId=WebStoreWarehouse > > > > > > Please also refer to sample demo data from OrderDemoData.xml to get > more > > > details about the other important entities. > > > > > > > > > https://github.com/apache/ofbiz-framework/blob/trunk/applications/datamodel/data/demo/OrderDemoData.xml > > > > > > Hope this helps. > > > > > > -- > > > Kind Regards, > > > Ashish Vijaywargiya > > > Vice President of Operations > > > *HotWax Systems* > > > *Enterprise open source experts* > > > http://www.hotwaxsystems.com > > > > > > > > > > > > On Mon, Oct 17, 2022 at 12:01 AM Giulio Speri - MpStyle Srl < > > > giulio.sp...@mpstyle.it> wrote: > > > > > > > Hi Emad, > > > > > > > > You can configure each store to be served by different facilities > > > > (ProductStoreFacility entity), setting to N the flag > > oneInventoryFacility > > > > and then going in the Facility tab of the Product Store and add the > > > > facilities you need. > > > > > > > > Giulio > > > > > > > > On Sun, Oct 16, 2022, 16:33 Emad Radwan > wrote: > > > > > > > > > Hello Community, > > > > > > > > > > Assuming more than one accounting company is defined, how Ofbiz > will > > > > > determine which one to use? > > > > > > > > > > I see there is a configuration for the 'Store' to tell the > > > > > 'Pay_to_partyId', and the store is linked to Facility, > > > > > but again what if more than two stores are defined, which > > > > > facility/product/inventory mix will be used while for example > > creating > > > a > > > > > sales order? > > > > > > > > > > Appreciate it if you shed some light on this. > > > > > > > > > > Regards, > > > > > Emad > > > > > > > > > > > > > > > > > -- > Giulio Speri > > > *Mp Styl**e Srl* > via Antonio Meucci, 37 > 41019 Limidi di Soliera (MO) > T 059/684916 > M 347/0965506 > > www.mpstyle.it >
Re: Default Accounting Company
Thanks Giulio and Ashish for the valuable input. Few more clarifications, please. 1 - If ofbiz is being used locally - no e-commerce - and two stores are defined, how to restrict employees - users - taking the order to be limited only to one of these stores? 2 - What is the role of ProductStoreFacility? Since in demo data only a few records are configured but even though much more products are available while creating orders? 3 - What exactly controls the Payment Methods presented to the user while creating a sales order, we have configurations in ProductStorePaymentSetting and PaymentMethod; are both used or there is extra logic here? Regards, Emad On Mon, Oct 17, 2022 at 1:26 PM Ashish Vijaywargiya < ashish.vijaywarg...@hotwaxsystems.com> wrote: > Hello Emad, > > Please refer two more entities which will help you to better visualise > setup of stores, facilities, products and inventories: > > - ProductFacility - > > https://demo-stable.ofbiz.apache.org/webtools/control/FindGeneric?entityName=ProductFacility > > https://demo-stable.ofbiz.apache.org/catalog/control/EditProductFacilities?productId=GZ-2644 > > - InventoryItem(There is a field facilityId in this entity) - > > https://demo-stable.ofbiz.apache.org/webtools/control/FindGeneric?entityName=InventoryItem > > https://demo-stable.ofbiz.apache.org/facility/control/EditFacilityInventoryItems?facilityId=WebStoreWarehouse > > Please also refer to sample demo data from OrderDemoData.xml to get more > details about the other important entities. > > https://github.com/apache/ofbiz-framework/blob/trunk/applications/datamodel/data/demo/OrderDemoData.xml > > Hope this helps. > > -- > Kind Regards, > Ashish Vijaywargiya > Vice President of Operations > *HotWax Systems* > *Enterprise open source experts* > http://www.hotwaxsystems.com > > > > On Mon, Oct 17, 2022 at 12:01 AM Giulio Speri - MpStyle Srl < > giulio.sp...@mpstyle.it> wrote: > > > Hi Emad, > > > > You can configure each store to be served by different facilities > > (ProductStoreFacility entity), setting to N the flag oneInventoryFacility > > and then going in the Facility tab of the Product Store and add the > > facilities you need. > > > > Giulio > > > > On Sun, Oct 16, 2022, 16:33 Emad Radwan wrote: > > > > > Hello Community, > > > > > > Assuming more than one accounting company is defined, how Ofbiz will > > > determine which one to use? > > > > > > I see there is a configuration for the 'Store' to tell the > > > 'Pay_to_partyId', and the store is linked to Facility, > > > but again what if more than two stores are defined, which > > > facility/product/inventory mix will be used while for example creating > a > > > sales order? > > > > > > Appreciate it if you shed some light on this. > > > > > > Regards, > > > Emad > > > > > >
Default Accounting Company
Hello Community, Assuming more than one accounting company is defined, how Ofbiz will determine which one to use? I see there is a configuration for the 'Store' to tell the 'Pay_to_partyId', and the store is linked to Facility, but again what if more than two stores are defined, which facility/product/inventory mix will be used while for example creating a sales order? Appreciate it if you shed some light on this. Regards, Emad
calculateAcctgTransTrialBalance
Hello Community, The subject service is being called from postAcctgTrans. If this is happening within the context of an automated transaction like 'quickShipOrder', is it still relevant here? In other words, with the first look at the logic in calculateAcctgTransTrialBalance I see comparisons for the debit / credit values which I think is automated in a such business transaction. Is it correct to guess that its handling cases for other kinds of transactions? Please correct me if I'm wrong and shed some light on this. Regards, Emad
Re: Configured Taxes and Discounts
Many thanks for the useful information. Regards, Emad On Fri, Oct 14, 2022 at 4:54 AM Ashish Vijaywargiya < ashish.vijaywarg...@hotwaxsystems.com> wrote: > Very well expressed, Steve!! > > Thanks, > Ashish > > On Thu, 13 Oct 2022 at 9:53 PM, Stephen Davidson > wrote: > > > Greetings. > > > > There are more than a few jurisdictions in both the US and Canada that > > depending on the items sold, taxes MUST be collected by the seller, then > > forwarded to the Govt. > > > > How, if and how much taxes to collect depends on location of seller, > > buyer, and item sold. The fact that this is configurable is a required > > feature. And if not applicable, the fact that it can be configured to > > '0' (default value) is quite helpful. > > > > Regards, > > Steve > > (1/3 of my career spent writing systems to handle charging taxes to > > customers -- happy enough to let the accountants figure out the amounts > > and rules that I have had to implement) > > > > On 10/13/22 09:42, ofbiz.u...@nym.hush.com wrote: > > > Be advised that the collection of taxes is illegal practice everywhere > > on planet earth. > > > > > > Stop supporting state crime. > > > > > > Remove tax collection facilities from ofbiz. > > > > > > Preserve logs about taxes allready paid, so that refunds can be > > collected. > > > > > > > > > > > > On 10/13/2022 at 3:48 PM, "Ashish Vijaywargiya" < > > ashish.vijaywarg...@hotwaxsystems.com> wrote: > > >> Hello Emad, > > >> > > >> Yes, taxes and discounts are automatically added when order gets > > >> placed in > > >> the system. > > >> > > >> - Taxation information is specific to a specific Party in the > > >> system and > > >> that party can be associated with a State or a Country. > > >> Please visit this link: > > >> https://demo- > > >> stable.ofbiz.apache.org/webtools/control/FindGeneric?entityName=Tax > > >> Authority > > >> > > >> - The discounts are applied based on the Promotion and Price Rule > > >> model in > > >> OFBiz. > > >> Following links will be helpful to get more details about these > > >> two topics: > > >> > > >> https://demo- > > >> stable.ofbiz.apache.org/catalog/control/FindProductPromo > > >> https://demo- > > >> stable.ofbiz.apache.org/catalog/control/FindProductPriceRules > > >> https://www.hotwaxsystems.com/ofbiz/ofbiz-development/product- > > >> promotion-engine/ > > >> https://www.hotwaxsystems.com/ofbiz/ofbiz-tutorials/ofbiz-tutorial- > > >> price-rules/ > > >> > > >> To get more details about the underneath Data Model for > > >> ProductPromo and > > >> PriceRule please visit this page: > > >> https://cwiki.apache.org/confluence/display/OFBIZ/Data+Model+Diagra > > >> ms > > >> And then download the book with heading > > >> "OFBizDatamodelBook_Combined_20171001.pdf" > > >> > > >> Hope this helps. > > >> > > >> -- > > >> Kind Regards, > > >> Ashish Vijaywargiya > > >> Vice President of Operations > > >> *HotWax Systems* > > >> *Enterprise open source experts* > > >> http://www.hotwaxsystems.com > > >> > > >> > > >> > > >> On Thu, Oct 13, 2022 at 6:01 PM Emad Radwan > > >> wrote: > > >> > > >>> Hello Community, > > >>> > > >>> I noticed that while using the demo system and create a sales > > >> order that > > >>> some taxes and discounts are automatically added to the order > > >> when I add > > >>> one product. Where are these configured? > > >>> > > >>> Regards, > > >>> Emad > > >>> > > > > -- > Sent from my iPhone >
How to configure payment method for orders?
Hello Community, I need your help to have 'Cash' to appear while creating new sales order. Also, is it a general configuration in the system or related to specific customer / party? Regards, Emad
Re: Mappings for invoice items and order items
Hello Ashish,
Thanks for the great tip. I feel I'm getting closer to understanding the
logic.
A question please for an issue that I can't understand. Following your
example and until we reach service
'createAcctgTransForSalesShipmentIssuance' I don't understand how the
glAccountType is determined here.
Service 'getGlAccountFromAccountType' is handling a number of cases but I
think it's not determining the glAccountId for this specific case. Am I
correct? Is it determined in a later called service?
I'm including the transaction entries here.
Regards,
Emad
[
{
"ACCTG_TRANS_ID": "1",
"ACCTG_TRANS_ENTRY_SEQ_ID": "1",
"ACCTG_TRANS_ENTRY_TYPE_ID": "_NA_",
"DESCRIPTION": null,
"VOUCHER_REF": null,
"PARTY_ID": "DemoCustomer",
"ROLE_TYPE_ID": "BILL_TO_CUSTOMER",
"THEIR_PARTY_ID": null,
"PRODUCT_ID": "GZ-1000",
"THEIR_PRODUCT_ID": null,
"INVENTORY_ITEM_ID": "9026",
"GL_ACCOUNT_TYPE_ID": "INVENTORY_ACCOUNT",
"GL_ACCOUNT_ID": "14",
"ORGANIZATION_PARTY_ID": "Company",
"AMOUNT": 4.80,
"CURRENCY_UOM_ID": "USD",
"ORIG_AMOUNT": 4.80,
"ORIG_CURRENCY_UOM_ID": "USD",
"DEBIT_CREDIT_FLAG": "C",
"DUE_DATE": null,
"GROUP_ID": null,
"TAX_ID": null,
"RECONCILE_STATUS_ID": "AES_NOT_RECONCILED",
"SETTLEMENT_TERM_ID": null,
"IS_SUMMARY": null,
"LAST_UPDATED_STAMP": "2022-06-19 12:55:05.220",
"LAST_UPDATED_TX_STAMP": "2022-06-19 12:55:03.257",
"CREATED_STAMP": "2022-06-19 12:55:05.220",
"CREATED_TX_STAMP": "2022-06-19 12:55:03.257"
},
{
"ACCTG_TRANS_ID": "1",
"ACCTG_TRANS_ENTRY_SEQ_ID": "2",
"ACCTG_TRANS_ENTRY_TYPE_ID": "_NA_",
"DESCRIPTION": null,
"VOUCHER_REF": null,
"PARTY_ID": "DemoCustomer",
"ROLE_TYPE_ID": "BILL_TO_CUSTOMER",
"THEIR_PARTY_ID": null,
"PRODUCT_ID": "GZ-1000",
"THEIR_PRODUCT_ID": null,
"INVENTORY_ITEM_ID": null,
"GL_ACCOUNT_TYPE_ID": "COGS_ACCOUNT",
"GL_ACCOUNT_ID": "50",
"ORGANIZATION_PARTY_ID": "Company",
"AMOUNT": 4.80,
"CURRENCY_UOM_ID": "USD",
"ORIG_AMOUNT": 4.80,
"ORIG_CURRENCY_UOM_ID": "USD",
"DEBIT_CREDIT_FLAG": "D",
"DUE_DATE": null,
"GROUP_ID": null,
"TAX_ID": null,
"RECONCILE_STATUS_ID": "AES_NOT_RECONCILED",
"SETTLEMENT_TERM_ID": null,
"IS_SUMMARY": null,
"LAST_UPDATED_STAMP": "2022-06-19 12:55:05.267",
"LAST_UPDATED_TX_STAMP": "2022-06-19 12:55:03.257",
"CREATED_STAMP": "2022-06-19 12:55:05.267",
"CREATED_TX_STAMP": "2022-06-19 12:55:03.257"
}
]
On Mon, Oct 3, 2022 at 3:02 PM Ashish Vijaywargiya <
ashish.vijaywarg...@hotwaxsystems.com> wrote:
> Hello Emad,
>
> I am not 100% sure what you are trying to achieve here. So I am providing
> the details based on presumptions that the below details might be helpful
> to you:
>
> 1) First of all, create a Sales Order in your system from the
> backend/ecommerce for a "DemoCustomer" party.
>
> 2) Then come to OrderView page, like this -
> https://localhost:8443/ordermgr/control/orderview?orderId=WSCO10010
>
> 3) Click on the "Quick Ship Entire Order". You will see this link in the
> mid right corner of the page.
>
> 4) Trace the request "quickShipOrder" controller request from the Order
> component.
>
> 5) This is how my console log looks like when I performed quickShipOrder
> operation:
>
> https://drive.google.com/file/d/15whseNPGGDUGs5xbIvl0aPtKon8DEF4r/view?usp=sharing
>
> 6) Here in the console log you can see the reference of
> "createInvoiceForOrder" as well.
>
> You need to trace the code and understand the overall flow.
>
> You will find that there are many triggers(EECA, SECA) written in OFBiz
> which get triggered based on some conditions.
>
> Hope this helps.
>
> --
> Kind Regards,
> Ashish Vijaywargiya
> Vice President of Operations
> *HotWax Systems*
> *Enterprise open source experts*
&
Re: Mappings for invoice items and order items
"OrderProblemWithInvoiceCreationServiceItems",
> locale));
> }
>
>
> If you find it difficult to understand the control flow and learn how to do
> application development in Apache OFBiz framework then you can refer to the
> following document:
> https://cwiki.apache.org/confluence/x/1gsBCw
>
> Above document will help you to understand the following topics from Apache
> OFBiz:
> - Control Flow
> - Form/Screen Widget
> - Events
> - Services
> - Groovy
> - FTL
>
> And many more things that we can't learn from a random exploration
> Please let me know if you need further help from my side.
>
> --
> Kind Regards,
> Ashish Vijaywargiya
> Vice President of Operations
> *HotWax Systems*
> *Enterprise open source experts*
> http://www.hotwaxsystems.com
>
>
>
> On Sat, Oct 1, 2022 at 6:22 PM Emad Radwan wrote:
>
> > Hello Ashish,
> >
> > One more thing please on the 'createInvoiceForOrder' service, how
> > 'billItems'
> > in line 163 are being retrieved and identified?
> >
> > Regards,
> > Emad
> >
> > On Thu, Sep 1, 2022 at 8:58 AM Ashish Vijaywargiya <
> > ashish.vijaywarg...@hotwaxsystems.com> wrote:
> >
> > > Hello Emad,
> > >
> > > Please read the code of the service/method:
> > > File: InvoiceServices.java
> > >
> > >
> >
> https://github.com/apache/ofbiz-framework/blob/trunk/applications/accounting/src/main/java/org/apache/ofbiz/accounting/invoice/InvoiceServices.java
> > > Method: createInvoiceForOrder
> > >
> > > See the line #461
> > > createInvoiceItemContext.put("invoiceItemTypeId",
> > > getInvoiceItemType(delegator, orderItem.getString("orderItemTypeId"),
> > > product == null ? null :
> > > product.getString("productTypeId"), invoiceType, "INV_FPROD_ITEM"));
> > >
> > > Then see the method present inside line # 1941:
> > > private static String getInvoiceItemType(Delegator delegator, String
> > key1,
> > > String key2, String invoiceTypeId, String defaultValue) {
> > > }
> > >
> > > Hopefully it's self explanatory, Please let me know if you need
> > > further assistance on this.
> > >
> > > --
> > > Kind Regards,
> > > Ashish Vijaywargiya
> > > Vice President of Operations
> > > *HotWax Systems*
> > > *Enterprise open source experts*
> > > http://www.hotwaxsystems.com
> > >
> > >
> > >
> > > On Wed, Aug 31, 2022 at 5:31 PM Emad Radwan
> > wrote:
> > >
> > > > Hello Ashis,
> > > >
> > > > Many thanks for the usual help! One issue please that I don't
> > understand
> > > in
> > > > the data itself, I noticed that for products - finished good - an
> > > > invoice_item_type_id is 'INV_FPROD_ITEM' while order_item_type_id is
> '
> > > > PRODUCT_ORDER_ITEM'
> > > > but the key for 'INV_FPROD_ITEM' is 'FINISHED_GOOD' however, so how
> the
> > > > mapping is happening? What am I missing here?
> > > >
> > > > For other mappings like adjustments, mappings looks fine.
> > > >
> > > > Please shed some light on this.
> > > >
> > > > Regards,
> > > > Emad
> > > >
> > > > On Wed, Aug 31, 2022 at 6:53 AM Ashish Vijaywargiya <
> > > > ashish.vijaywarg...@hotwaxsystems.com> wrote:
> > > >
> > > > > Hello Emad,
> > > > >
> > > > > A very good question. Please refer to the records present inside
> > > > > InvoiceItemTypeMap entity:
> > > > >
> > > > >
> > > >
> > >
> >
> https://demo-stable.ofbiz.apache.org/webtools/control/FindGeneric?entityName=InvoiceItemTypeMap
> > > > >
> > > > > Hopefully it's self explanatory.
> > > > >
> > > > > --
> > > > > Kind Regards,
> > > > > Ashish Vijaywargiya
> > > > > Vice President of Operations
> > > > > *HotWax Systems*
> > > > > *Enterprise open source experts*
> > > > > http://www.hotwaxsystems.com
> > > > >
> > > > >
> > > > >
> > > > > On Wed, Aug 31, 2022 at 1:16 AM Emad Radwan >
> > > > wrote:
> > > > >
> > > > > > Hello Community,
> > > > > >
> > > > > > Let me explain my query with this when I create an order with
> items
> > > and
> > > > > > possible adjustments, the auto-created invoice when the order
> gets
> > > > > > completed we get a list of invoice items that is almost a match
> > with
> > > > both
> > > > > > order items plus adjustments. My question what decides the
> > > > > > invoice_item_type for each invoice item?
> > > > > >
> > > > > > I understand that an invoice can be not only for order; e.g. work
> > > > effort,
> > > > > > but I used order item vs invoice item as an example.
> > > > > >
> > > > > > Is it mapped somehow and is configurable, or pre-determined and
> > > > > hard-coded?
> > > > > >
> > > > > >
> > > > > > Regards,
> > > > > > Emad
> > > > >
> > > >
> > >
> >
>
Re: Mappings for invoice items and order items
Hello Ashish,
One more thing please on the 'createInvoiceForOrder' service, how 'billItems'
in line 163 are being retrieved and identified?
Regards,
Emad
On Thu, Sep 1, 2022 at 8:58 AM Ashish Vijaywargiya <
ashish.vijaywarg...@hotwaxsystems.com> wrote:
> Hello Emad,
>
> Please read the code of the service/method:
> File: InvoiceServices.java
>
> https://github.com/apache/ofbiz-framework/blob/trunk/applications/accounting/src/main/java/org/apache/ofbiz/accounting/invoice/InvoiceServices.java
> Method: createInvoiceForOrder
>
> See the line #461
> createInvoiceItemContext.put("invoiceItemTypeId",
> getInvoiceItemType(delegator, orderItem.getString("orderItemTypeId"),
> product == null ? null :
> product.getString("productTypeId"), invoiceType, "INV_FPROD_ITEM"));
>
> Then see the method present inside line # 1941:
> private static String getInvoiceItemType(Delegator delegator, String key1,
> String key2, String invoiceTypeId, String defaultValue) {
> }
>
> Hopefully it's self explanatory, Please let me know if you need
> further assistance on this.
>
> --
> Kind Regards,
> Ashish Vijaywargiya
> Vice President of Operations
> *HotWax Systems*
> *Enterprise open source experts*
> http://www.hotwaxsystems.com
>
>
>
> On Wed, Aug 31, 2022 at 5:31 PM Emad Radwan wrote:
>
> > Hello Ashis,
> >
> > Many thanks for the usual help! One issue please that I don't understand
> in
> > the data itself, I noticed that for products - finished good - an
> > invoice_item_type_id is 'INV_FPROD_ITEM' while order_item_type_id is '
> > PRODUCT_ORDER_ITEM'
> > but the key for 'INV_FPROD_ITEM' is 'FINISHED_GOOD' however, so how the
> > mapping is happening? What am I missing here?
> >
> > For other mappings like adjustments, mappings looks fine.
> >
> > Please shed some light on this.
> >
> > Regards,
> > Emad
> >
> > On Wed, Aug 31, 2022 at 6:53 AM Ashish Vijaywargiya <
> > ashish.vijaywarg...@hotwaxsystems.com> wrote:
> >
> > > Hello Emad,
> > >
> > > A very good question. Please refer to the records present inside
> > > InvoiceItemTypeMap entity:
> > >
> > >
> >
> https://demo-stable.ofbiz.apache.org/webtools/control/FindGeneric?entityName=InvoiceItemTypeMap
> > >
> > > Hopefully it's self explanatory.
> > >
> > > --
> > > Kind Regards,
> > > Ashish Vijaywargiya
> > > Vice President of Operations
> > > *HotWax Systems*
> > > *Enterprise open source experts*
> > > http://www.hotwaxsystems.com
> > >
> > >
> > >
> > > On Wed, Aug 31, 2022 at 1:16 AM Emad Radwan
> > wrote:
> > >
> > > > Hello Community,
> > > >
> > > > Let me explain my query with this when I create an order with items
> and
> > > > possible adjustments, the auto-created invoice when the order gets
> > > > completed we get a list of invoice items that is almost a match with
> > both
> > > > order items plus adjustments. My question what decides the
> > > > invoice_item_type for each invoice item?
> > > >
> > > > I understand that an invoice can be not only for order; e.g. work
> > effort,
> > > > but I used order item vs invoice item as an example.
> > > >
> > > > Is it mapped somehow and is configurable, or pre-determined and
> > > hard-coded?
> > > >
> > > >
> > > > Regards,
> > > > Emad
> > >
> >
>
Re: Error while viewing service logs
Many thanks Jacques. Excuse my ignorance. Will this be available on the demo version soon? Regards, Emad On Wed, Sep 28, 2022 at 7:07 PM Jacques Le Roux < jacques.le.r...@les7arts.com> wrote: > Emad, > > As you know the R18.12 branch is no longer supported. > But you should find the fix of that bug at the bottom of > https://issues.apache.org/jira/browse/OFBIZ-9638 > > Please check that it's OK with you > > TIA > > Jacques > > Le 28/09/2022 à 17:39, Emad Radwan a écrit : > > Many thanks, Jacques. > > > > On Wed, Sep 28, 2022 at 5:36 PM Jacques Le Roux < > > jacques.le.r...@les7arts.com> wrote: > > > >> Hi Emad, > >> > >> Thanks for the report, I'm on it after it seems to have broken the > stable > >> demo (restarted one hour ago). > >> I mean I'll have already ideas, hopefully will be soon resolved, not > sure > >> today though... ;) > >> > >> Jacques > >> > >> Le 28/09/2022 à 17:28, Emad Radwan a écrit : > >>> Hello Community, > >>> > >>> Since this issue is still there and it seems from similar and previous > >>> related posts that it's not reproducible with everybody, so I'll > >> appreciate > >>> it if someone can create and ship an order on a demo instance and send > >> me a > >>> list of those services called on the operation especially those related > >> to > >>> Accounting. > >>> > >>> Solving the error itself would be best of course. > >>> > >>> Regards, > >>> Emad > >>> > >>> On Sun, Sep 11, 2022 at 1:54 PM Emad Radwan > >> wrote: > >>>> Hello Community, > >>>> > >>>> I'm getting this error after executing quickShipEntireOrder in both > >> local > >>>> and online versions. > >>>> > >>>> java.lang.IllegalArgumentException: Error running script at location > >>>> [component://webtools/groovyScripts/service/Services.groovy]: > >>>> java.lang.NullPointerException > >>>> > >>>> Regards, > >>>> Emad > >>>> >
Re: Error while viewing service logs
Many thanks, Jacques. On Wed, Sep 28, 2022 at 5:36 PM Jacques Le Roux < jacques.le.r...@les7arts.com> wrote: > Hi Emad, > > Thanks for the report, I'm on it after it seems to have broken the stable > demo (restarted one hour ago). > I mean I'll have already ideas, hopefully will be soon resolved, not sure > today though... ;) > > Jacques > > Le 28/09/2022 à 17:28, Emad Radwan a écrit : > > Hello Community, > > > > Since this issue is still there and it seems from similar and previous > > related posts that it's not reproducible with everybody, so I'll > appreciate > > it if someone can create and ship an order on a demo instance and send > me a > > list of those services called on the operation especially those related > to > > Accounting. > > > > Solving the error itself would be best of course. > > > > Regards, > > Emad > > > > On Sun, Sep 11, 2022 at 1:54 PM Emad Radwan > wrote: > > > >> Hello Community, > >> > >> I'm getting this error after executing quickShipEntireOrder in both > local > >> and online versions. > >> > >> java.lang.IllegalArgumentException: Error running script at location > >> [component://webtools/groovyScripts/service/Services.groovy]: > >> java.lang.NullPointerException > >> > >> Regards, > >> Emad > >> >
Re: Error while viewing service logs
Hello Community, Since this issue is still there and it seems from similar and previous related posts that it's not reproducible with everybody, so I'll appreciate it if someone can create and ship an order on a demo instance and send me a list of those services called on the operation especially those related to Accounting. Solving the error itself would be best of course. Regards, Emad On Sun, Sep 11, 2022 at 1:54 PM Emad Radwan wrote: > Hello Community, > > I'm getting this error after executing quickShipEntireOrder in both local > and online versions. > > java.lang.IllegalArgumentException: Error running script at location > [component://webtools/groovyScripts/service/Services.groovy]: > java.lang.NullPointerException > > Regards, > Emad >
Re: Question on Payment Application
Many thanks for taking the time to provide such valuable information. On Wed, Sep 28, 2022 at 9:53 AM Ashish Vijaywargiya < ashish.vijaywarg...@hotwaxsystems.com> wrote: > Hello Emad, > > We have many Accounting experts in the Apache OFBiz community and I have > learned many things from them. They are: > - Jacopo - https://www.linkedin.com/in/jacopoc/ > - Anil - https://www.linkedin.com/in/anilpatelhwc/ > - Sharan - https://www.linkedin.com/in/sfoga/ > > They have helped to build the Accounting module from scratch in Apache > OFBiz and now we can see a finished component. > They referred a few books while implementing and enhancing the Accounting > module(See Index of these books): > > Universal Data Model Volume 1 by Len Silverstone - All the chapters are > important one but Chapter 7 and 8 will make more sense to get a good > understanding of Accounting. > > https://www.amazon.com/Data-Model-Resource-Book-Vol/dp/0471380237/ref=sr_1_2?crid=1H0EOMFJO5UJV=universal+data+model=1664349578=eyJxc2MiOiIwLjAwIiwicXNhIjoiMC4wMCIsInFzcCI6IjAuMDAifQ%3D%3D=universal+data+model%2Caps%2C322=8-2 > > > https://www.amazon.com/Accounting-Best-Practices-Steven-Bragg-ebook/dp/B01DCOYF3I/ref=sr_1_3?keywords=accounting+best+practices=1664349689=eyJxc2MiOiIyLjU1IiwicXNhIjoiMi42OCIsInFzcCI6IjIuMTcifQ%3D%3D=accounting+best+practices%2Caps%2C294=8-3 > > > One reference I like and refer it many times is this: > > https://github.com/apache/ofbiz-framework/blob/trunk/applications/datamodel/data/seed/AccountingSeedData.xml > See the Credit and Debit entry chart present at line #210. > > You should also spend some time to review the data present inside following > files: > > - AccountingDemoData.xml > - GlAccountDemoData.xml > - OfbizChartOfAccountsData.xml > > >> My concern here, is there any 'Process diagram / workflow > logic' that simplifies the order of using such settings. > > I don't have a straight forward answer or reference of any such Process > Diagram/workflow logic document. > > This is how I would imagine in a real world: > > - A company maintains a General Ledger Accounts to log Credit and Debit > entries. The entries in these accounts can be automated as well as the > provision of manual entries is also required. > - Ledger entries are linked with Invoice and respective Payments. > - Invoices may be associated with Orders. And if required manually entered > Invoices can also be maintained in the system. > - And then time period based reports are there which you can refer > internally as well as you can use those reports to make the Government > happy at the time of Income Tax Return filing. :-) > > I understand that the overall Accounting setup in OFBiz is a complex one, > but if you can ask specific questions then all the SMEs - Accounting will > feel glad to assist you. > > -- > Kind Regards, > Ashish Vijaywargiya > Vice President of Operations > *HotWax Systems* > *Enterprise open source experts* > http://www.hotwaxsystems.com > > > > On Wed, Sep 28, 2022 at 1:50 AM Emad Radwan wrote: > > > Hello Ashish, > > > > Many many thanks. So much appreciated input from your side as usual. > > Talking about Sharan's work, I already read her book on the subject and > it > > is very interesting and valuable. However, and this is another subject I > > know but thought you may help. I understand that Ofbiz has a rich data > > model and configuration in Accounting around which GL Account to use > > especially when creating automated transactions like those related to a > > sales invoice. > > > > By this, I mean configuration - for example - related to Payment Methods, > > Payment Types, etc. And those other settings that are available via the > > following URL. My concern here, is there any 'Process diagram / workflow > > logic' that simplifies the order of using such settings. In other words, > I > > find it a bit difficult to get the logic from the code having the fact > that > > Ofbiz is using multiple ways of creating services and calling them. So > I'm > > wondering if such flowcharts exist to simplify the logic and explain the > > big picture. > > > > > > > > > https://demo-stable.ofbiz.apache.org/accounting/control/GlAccountAssignment?organizationPartyId=Company > > > > Regards, > > Emad > > > > On Tue, Sep 27, 2022 at 11:51 AM Ashish Vijaywargiya < > > ashish.vijaywarg...@hotwaxsystems.com> wrote: > > > > > Hello Emad, > > > > > > Following links will be helpful for you: > > > > > > > > > > > > https://demo-stable.ofbiz.apache.org/accounting/control/
Re: Question on Payment Application
Hello Ashish, Many many thanks. So much appreciated input from your side as usual. Talking about Sharan's work, I already read her book on the subject and it is very interesting and valuable. However, and this is another subject I know but thought you may help. I understand that Ofbiz has a rich data model and configuration in Accounting around which GL Account to use especially when creating automated transactions like those related to a sales invoice. By this, I mean configuration - for example - related to Payment Methods, Payment Types, etc. And those other settings that are available via the following URL. My concern here, is there any 'Process diagram / workflow logic' that simplifies the order of using such settings. In other words, I find it a bit difficult to get the logic from the code having the fact that Ofbiz is using multiple ways of creating services and calling them. So I'm wondering if such flowcharts exist to simplify the logic and explain the big picture. https://demo-stable.ofbiz.apache.org/accounting/control/GlAccountAssignment?organizationPartyId=Company Regards, Emad On Tue, Sep 27, 2022 at 11:51 AM Ashish Vijaywargiya < ashish.vijaywarg...@hotwaxsystems.com> wrote: > Hello Emad, > > Following links will be helpful for you: > > > https://demo-stable.ofbiz.apache.org/accounting/control/editPaymentApplications?paymentId=10001 > Here you can associate the Invoices with respect to the Payment. > > > https://demo-stable.ofbiz.apache.org/accounting/control/editInvoiceApplications?invoiceId=CI1 > Here you can associate the Payments with respect to the Invoice. > > Sales Invoices can be created in the system by the following ways. > > 1) When the Sales Order gets completed in the system then a Sales Invoice > gets created in the System. The payment associated with Sales Order creates > an entry in the system as a "Customer Payment". All the Transaction and Gl > related postings are done automatically. > 2) You can manually create Sales Invoices directly in the system and with > respect to that invoice you can do the manual entry of payment as well in > the system. > > There are status transitions for Invoices as well as for the Payments in > the system. Following link can help you: > > https://www.hotwaxsystems.com/ofbiz/ofbiz-ecommerce/ofbiz-invoice-processing-workflow-explained/ > > Types of Invoices: > > https://www.hotwaxsystems.com/ofbiz/ofbiz-ecommerce/types-of-invoices-in-ofbiz/ > > Sharan wrote a wonderful details on Accounting, please refer following > links: > https://cwiki.apache.org/confluence/display/OFBENDUSER/02+Invoices > https://cwiki.apache.org/confluence/display/OFBENDUSER/03+Payments > > Apache OFBiz provides the flexibility to the users to use the > Invoice/Payment data model based on their need. > > Hope this helps! > > -- > Kind Regards, > Ashish Vijaywargiya > Vice President of Operations > *HotWax Systems* > *Enterprise open source experts* > http://www.hotwaxsystems.com > > > > On Tue, Sep 27, 2022 at 1:17 PM Emad Radwan wrote: > > > Hello Community, > > > > I noticed that there's no link in Ofbiz to create a payment application > > from the Payments menu. > > > > How to apply a payment or part of it to an invoice? What I can think of > is > > by creating a GL Transaction! Correct? Or there are other options? > > > > Please shed some light. > > > > Regards, > > Emad > > >
Question on Payment Application
Hello Community, I noticed that there's no link in Ofbiz to create a payment application from the Payments menu. How to apply a payment or part of it to an invoice? What I can think of is by creating a GL Transaction! Correct? Or there are other options? Please shed some light. Regards, Emad
Re: Question about invoices
Many thanks Ingo. On Mon, 19 Sept 2022, 07:29 Ingo Wolfmayr, wrote: > Hi Emad, > > here some examples how I sometimes use it: > > - order is created in another system. I have usecases where the data is > provided via data interface and Ofbiz generates the invoice and everything > accounting related. > - quickly create a credit invoice > - repeating invoice for exampe IT services (domain, hosting ...) > - Invoices from work effort (for example from helpdesk) > > Best regards, > Ingo > > > -Ursprüngliche Nachricht- > Von: Emad Radwan > Gesendet: Sonntag, 18. September 2022 16:56 > An: user@ofbiz.apache.org > Betreff: Question about invoices > > Hello Community, > > Sorry for the newbie question. Why is there a feature to create an invoice > - e.g. sales invoice - from the Accounting tab and outside the normal > route from Sales Order? > > What is the use case to start with the invoice first? > > Regards, > Emad >
Question about invoices
Hello Community, Sorry for the newbie question. Why is there a feature to create an invoice - e.g. sales invoice - from the Accounting tab and outside the normal route from Sales Order? What is the use case to start with the invoice first? Regards, Emad
Error while viewing service logs
Hello Community, I'm getting this error after executing quickShipEntireOrder in both local and online versions. java.lang.IllegalArgumentException: Error running script at location [component://webtools/groovyScripts/service/Services.groovy]: java.lang.NullPointerException Regards, Emad
Re: How DB GL Account is determined when receiving a payment
Hello Community, Please, I need your help on this matter. According to the following documentation, "The DR (or Debit) entry for the transaction is created by a different GL Account default, the Payment Method Id / GL Account Id mapping (eg Cash is setup as 112000 Undeposited Receipts)" The below mentioned service - createAcctgTransAndEntriesForIncomingPayment- is the one used to create the transaction for the payment but it's not clear how the GL Account Id is derived from the default - demo data - configuration. Please anyone - kindly - to shed some light. Regards, Emad On Fri, Sep 2, 2022 at 4:59 PM Emad Radwan wrote: > Hello Community, > > While trying to trace the logic to determine the subject issue I came thru > the following service, the CR part of the transaction is more clearer as > glAccountId is derived from PaymentGlAccountTypeMap the depit part of > the transaction is marked by a TODO as in the following! > > The payment was of 'Cash' type and is getting GL Account 112000 that I > don't know how its derived. > > createAcctgTransAndEntriesForIncomingPayment > > in line 1741 > > > > > > Regards, > > Emad > > >
How DB GL Account is determined when receiving a payment
Hello Community, While trying to trace the logic to determine the subject issue I came thru the following service, the CR part of the transaction is more clearer as glAccountId is derived from PaymentGlAccountTypeMap the depit part of the transaction is marked by a TODO as in the following! The payment was of 'Cash' type and is getting GL Account 112000 that I don't know how its derived. createAcctgTransAndEntriesForIncomingPayment in line 1741 Regards, Emad
Re: Questions regarding purchase orders
Many thanks Rishi > On 1 Sep 2022, at 8:28 PM, Rishi Solanki wrote: > > Dear Emad, > If you notice then Shipment is Purchase Shipment and Item Issuance is link > with inventory item. Shipment will be incoming shipment and with item > issuance inventory received against that order. > > Rishi Solanki > *CTO, Mindpath Technology* > Intelligent Solutions > cell: +91-98932-87847 > LinkedIn <https://www.linkedin.com/in/rishi-solanki-62271b7/> > > > On Tue, Jul 5, 2022 at 2:09 PM Emad Radwan wrote: > >> Ofbiz Experts. Please have a look at this one. >> >> Regards >> Emad >> >> On Thu, 30 Jun 2022, 15:27 Emad Radwan, wrote: >> >>> Hello Community, >>> >>> In demo data for purchase order Demo1001 why tables like the following >> are >>> being used, my understanding is that shipments and item issuance are >>> related to sales orders where goods are leaving the company? >>> >>> >>> OrderItemShipGroup >>> >>> OrderItemShipGroupAssoc >>> >>> ItemIssuance >>> >>> >>> >>> Regards, >>> Emad >>> >>
Re: Mappings for invoice items and order items
Hello Ashish,
Many many thanks that is really very helpful.
May I be greedy and ask you kindly to look at another question from me recently
regarding ‘GL Account Balance’ as no one answered it?
Thanks again and best regards,
Emad
> On 1 Sep 2022, at 8:57 AM, Ashish Vijaywargiya
> wrote:
>
> Hello Emad,
>
> Please read the code of the service/method:
> File: InvoiceServices.java
> https://github.com/apache/ofbiz-framework/blob/trunk/applications/accounting/src/main/java/org/apache/ofbiz/accounting/invoice/InvoiceServices.java
> Method: createInvoiceForOrder
>
> See the line #461
> createInvoiceItemContext.put("invoiceItemTypeId",
> getInvoiceItemType(delegator, orderItem.getString("orderItemTypeId"),
>product == null ? null :
> product.getString("productTypeId"), invoiceType, "INV_FPROD_ITEM"));
>
> Then see the method present inside line # 1941:
> private static String getInvoiceItemType(Delegator delegator, String key1,
> String key2, String invoiceTypeId, String defaultValue) {
> }
>
> Hopefully it's self explanatory, Please let me know if you need
> further assistance on this.
>
> --
> Kind Regards,
> Ashish Vijaywargiya
> Vice President of Operations
> *HotWax Systems*
> *Enterprise open source experts*
> http://www.hotwaxsystems.com
>
>
>
> On Wed, Aug 31, 2022 at 5:31 PM Emad Radwan wrote:
>
>> Hello Ashis,
>>
>> Many thanks for the usual help! One issue please that I don't understand in
>> the data itself, I noticed that for products - finished good - an
>> invoice_item_type_id is 'INV_FPROD_ITEM' while order_item_type_id is '
>> PRODUCT_ORDER_ITEM'
>> but the key for 'INV_FPROD_ITEM' is 'FINISHED_GOOD' however, so how the
>> mapping is happening? What am I missing here?
>>
>> For other mappings like adjustments, mappings looks fine.
>>
>> Please shed some light on this.
>>
>> Regards,
>> Emad
>>
>> On Wed, Aug 31, 2022 at 6:53 AM Ashish Vijaywargiya <
>> ashish.vijaywarg...@hotwaxsystems.com> wrote:
>>
>>> Hello Emad,
>>>
>>> A very good question. Please refer to the records present inside
>>> InvoiceItemTypeMap entity:
>>>
>>>
>> https://demo-stable.ofbiz.apache.org/webtools/control/FindGeneric?entityName=InvoiceItemTypeMap
>>>
>>> Hopefully it's self explanatory.
>>>
>>> --
>>> Kind Regards,
>>> Ashish Vijaywargiya
>>> Vice President of Operations
>>> *HotWax Systems*
>>> *Enterprise open source experts*
>>> http://www.hotwaxsystems.com
>>>
>>>
>>>
>>> On Wed, Aug 31, 2022 at 1:16 AM Emad Radwan
>> wrote:
>>>
>>>> Hello Community,
>>>>
>>>> Let me explain my query with this when I create an order with items and
>>>> possible adjustments, the auto-created invoice when the order gets
>>>> completed we get a list of invoice items that is almost a match with
>> both
>>>> order items plus adjustments. My question what decides the
>>>> invoice_item_type for each invoice item?
>>>>
>>>> I understand that an invoice can be not only for order; e.g. work
>> effort,
>>>> but I used order item vs invoice item as an example.
>>>>
>>>> Is it mapped somehow and is configurable, or pre-determined and
>>> hard-coded?
>>>>
>>>>
>>>> Regards,
>>>> Emad
>>>
>>
Re: Mappings for invoice items and order items
Hello Ashis, Many thanks for the usual help! One issue please that I don't understand in the data itself, I noticed that for products - finished good - an invoice_item_type_id is 'INV_FPROD_ITEM' while order_item_type_id is ' PRODUCT_ORDER_ITEM' but the key for 'INV_FPROD_ITEM' is 'FINISHED_GOOD' however, so how the mapping is happening? What am I missing here? For other mappings like adjustments, mappings looks fine. Please shed some light on this. Regards, Emad On Wed, Aug 31, 2022 at 6:53 AM Ashish Vijaywargiya < ashish.vijaywarg...@hotwaxsystems.com> wrote: > Hello Emad, > > A very good question. Please refer to the records present inside > InvoiceItemTypeMap entity: > > https://demo-stable.ofbiz.apache.org/webtools/control/FindGeneric?entityName=InvoiceItemTypeMap > > Hopefully it's self explanatory. > > -- > Kind Regards, > Ashish Vijaywargiya > Vice President of Operations > *HotWax Systems* > *Enterprise open source experts* > http://www.hotwaxsystems.com > > > > On Wed, Aug 31, 2022 at 1:16 AM Emad Radwan wrote: > > > Hello Community, > > > > Let me explain my query with this when I create an order with items and > > possible adjustments, the auto-created invoice when the order gets > > completed we get a list of invoice items that is almost a match with both > > order items plus adjustments. My question what decides the > > invoice_item_type for each invoice item? > > > > I understand that an invoice can be not only for order; e.g. work effort, > > but I used order item vs invoice item as an example. > > > > Is it mapped somehow and is configurable, or pre-determined and > hard-coded? > > > > > > Regards, > > Emad >
Mappings for invoice items and order items
Hello Community, Let me explain my query with this when I create an order with items and possible adjustments, the auto-created invoice when the order gets completed we get a list of invoice items that is almost a match with both order items plus adjustments. My question what decides the invoice_item_type for each invoice item? I understand that an invoice can be not only for order; e.g. work effort, but I used order item vs invoice item as an example. Is it mapped somehow and is configurable, or pre-determined and hard-coded? Regards, Emad
GL Account Balance
Hello Community, Does Ofbiz maintain the balance of each GL account somehow and if yes, where its kept, and in which table? I see that both GL_Accounts and GL_Accounts_organization tables have no room for that. Is it being calculated on the fly when running reports from different transactions? Regards, Emad
GL Accounts without type!
Hello Community, Why some GL accounts - in GLAccounts entity - has no GL_Account_Type_ID, examples are Assets, Sales, Expense, etc? Regards, Emad
Re: Purchase Order Adjustments
Hello Rishi, I’m talking about the applicability from a business point of view - not from relations between tables - for example, I understand that ‘discount’ is a valid adjustment type in a sales order, but is it true for a purchase order? From a business practice view I mean? Regards, Emad > On 1 Aug 2022, at 5:40 PM, Rishi Solanki wrote: > > Please check the OrderAdjustmentType table is link with Order Adjustment. > > It has all type of adjustment.and yes it is common for both sales and > purchase order. > > Best Regards, > Rishi > > On Thu, 28 Jul 2022, 16:51 Emad Radwan, wrote: > >> Hello Ashish, >> >> Many thanks for the nice explanation. What about the other types of >> adjustments that we store in Order_adjustment table? For sales orders, I >> understand that this would be something like discounts, promotions, taxes, >> etc. Are there similar cases for purchase orders? >> >> Regards, >> Emad >> >> >>> On 28 Jul 2022, at 7:36 AM, Ashish Vijaywargiya < >> ashish.vijaywarg...@hotwaxsystems.com> wrote: >>> >>> Hello Emad, >>> >>> A very good question! >>> >>> Purchase Orders are linked to Suppliers. >>> >>> A simple use case is this: >>> >>> - Goods(Product in OFBiz) are associated with Supplier(SupplierProduct >>> entity) >>> - Goods are linked with Inventory(InventoryItem entity, ATP and QOH) >>> - As ATP goes negative then a "Requirement" to purchase a goods is >>> generated. >>> - Requirements are converted into PO. You can also directly create PO as >>> well in the system. >>> - As you receive the Goods in the warehouse then you do the PO receiving >>> and that helps you to adjust Inventory levels(ATP and QOH). >>> >>> So to answer your question, Yes PO in OFBiz are generally created to do >>> inventory adjustments. >>> >>> Hope this helps. >>> >>> -- >>> Kind Regards, >>> Ashish Vijaywargiya >>> Vice President of Operations >>> *HotWax Systems* >>> *Enterprise open source experts* >>> http://www.hotwaxsystems.com >>> >>> >>> >>> On Wed, Jul 27, 2022 at 9:09 PM Emad Radwan >> wrote: >>> >>>> Hello Community, >>>> >>>> Is the purchase order subject to any kind of adjustments? If yes, what >> are >>>> examples of this? >>>> >>>> Regards, >>>> Emad >> >>
Re: Purchase Order Adjustments
Hello Ashish, Many thanks for the nice explanation. What about the other types of adjustments that we store in Order_adjustment table? For sales orders, I understand that this would be something like discounts, promotions, taxes, etc. Are there similar cases for purchase orders? Regards, Emad > On 28 Jul 2022, at 7:36 AM, Ashish Vijaywargiya > wrote: > > Hello Emad, > > A very good question! > > Purchase Orders are linked to Suppliers. > > A simple use case is this: > > - Goods(Product in OFBiz) are associated with Supplier(SupplierProduct > entity) > - Goods are linked with Inventory(InventoryItem entity, ATP and QOH) > - As ATP goes negative then a "Requirement" to purchase a goods is > generated. > - Requirements are converted into PO. You can also directly create PO as > well in the system. > - As you receive the Goods in the warehouse then you do the PO receiving > and that helps you to adjust Inventory levels(ATP and QOH). > > So to answer your question, Yes PO in OFBiz are generally created to do > inventory adjustments. > > Hope this helps. > > -- > Kind Regards, > Ashish Vijaywargiya > Vice President of Operations > *HotWax Systems* > *Enterprise open source experts* > http://www.hotwaxsystems.com > > > > On Wed, Jul 27, 2022 at 9:09 PM Emad Radwan wrote: > >> Hello Community, >> >> Is the purchase order subject to any kind of adjustments? If yes, what are >> examples of this? >> >> Regards, >> Emad
Purchase Order Adjustments
Hello Community, Is the purchase order subject to any kind of adjustments? If yes, what are examples of this? Regards, Emad
Re: How to approve an order
Never mind, I found it. Regards, Emad > On 13 Jul 2022, at 12:15 PM, Emad Radwan wrote: > > Dear community > > I have a completed order and want to move to create picklist but can't find > the order as eligible for that. On the other hand I don't know how to approve > the order. > > Help appreciated please. > > Regards > Emad
How to approve an order
Dear community I have a completed order and want to move to create picklist but can't find the order as eligible for that. On the other hand I don't know how to approve the order. Help appreciated please. Regards Emad
Re: Questions regarding purchase orders
Ofbiz Experts. Please have a look at this one. Regards Emad On Thu, 30 Jun 2022, 15:27 Emad Radwan, wrote: > Hello Community, > > In demo data for purchase order Demo1001 why tables like the following are > being used, my understanding is that shipments and item issuance are > related to sales orders where goods are leaving the company? > > > OrderItemShipGroup > > OrderItemShipGroupAssoc > > ItemIssuance > > > > Regards, > Emad >
Questions regarding purchase orders
Hello Community, In demo data for purchase order Demo1001 why tables like the following are being used, my understanding is that shipments and item issuance are related to sales orders where goods are leaving the company? OrderItemShipGroup OrderItemShipGroupAssoc ItemIssuance Regards, Emad
Question regarding Price Modifications
Hello Community, Few concerns on the product_price table, please. 1 - Why do we have room for the tax while usually taxes will be added via adjustments? 2 - Where we’ll use other price types other than ‘list_price’; e.g. DEFAULT_PRICE, SPECIAL_PROMO_PRICE Regards, Emad
Re: Inventory Item Detail
Thanks a lot, makes More sense now. Regards, Emad > On 22 Jun 2022, at 12:07 PM, Ingo Wolfmayr wrote: > > Here is an example copied from the InventoryItemDetail entity: 100 income, 2 > sold > > Inventory Item ID Inventory Item Detail Seq IDEffektives Datum > Quantity On Hand Diff Available To Promise Diff Accounting Quantity > DiffUnit Cost Order IDOrder Item Seq ID Ship > Group Seq ID Shipment ID Shipment Item Seq IDReturn ID > Return Item Seq ID Work Effort ID Fixed Asset ID Maint Hist Seq ID > Item Issuance IDReceipt ID > 1. 10060 10050 2022-06-21 11:14:59.578 100 100 0 > 0 > 10030 > 2. 10060 10051 2022-06-21 11:15:00.172 0 0 100 > > > 3. 10060 10056 2022-06-21 11:39:23.352 0 -1 0 > WSWSO10110 2 > > 4. 10060 10057 2022-06-21 11:39:24.021 0 -1 0 > WSWSO10110 1 > > 5. 10060 10059 2022-06-22 12:00:04.719 0 0 -1 > > > 6. 10060 10060 2022-06-22 12:00:04.415 -1 0 0 > WSWSO10110 1 1 10035 1 > 10015 > 7. 10060 10063 2022-06-22 12:00:04.913 0 0 -1 > > > 8. 10060 10064 2022-06-22 12:00:04.908 -1 0 0 > WSWSO10110 2 1 10035 2 > 10017 > > 1. shows an income of quantity 100. QOH & ATP > 2. adds the Accounting Quantity - in this case 100 > 3., 4. are the order reservations. > 5., 6. removing inventory quantity 1 --> shipping - physical stock removed, > removed from accounting > 4., 8. removing inventory quantity 1 --> shipping - physical stock removed, > removed from accounting > > Best regards, > Ingo > > -Ursprüngliche Nachricht- > Von: Emad Radwan > Gesendet: Mittwoch, 22. Juni 2022 11:35 > An: user@ofbiz.apache.org > Betreff: Re: Inventory Item Detail > > Hi Ingo, > > In this case, in the new record where we updated the mentioned field with -2, > will be an update to the ‘QUANTITY_ON_HAND_DIFF’ field? On the same record I > mean, and that’s what confuses me from some of the demo data. > > Regards, > Emad > >> On 22 Jun 2022, at 7:57 AM, Ingo Wolfmayr wrote: >> >> Hi Emad, >> >> when the initial record is done (for example adding product inventory with >> quantity 10 for productId "demoproduc"t) the inventory item gets >> +10 QUANTITY_ON_HAND_DIFF >> +10 AVAILABLE_TO_PROMISE_DIFF’ >> >> If a customer creates an order, adding quantity 2 from demoproduct an >> inventory item detail with AVAILABLE_TO_PROMISE_DIFF -2 is created. The >> inventory is reserved for that order. >> The result: >> ATP: 8 - available to promise >> QOH: 10 - physical stock >> >> This is just one simple case for inventory change. Does this answer your >> question? >> >> Best regards, >> Ingo >> >> >> >> -Ursprüngliche Nachricht- >> Von: Emad Radwan >> Gesendet: Dienstag, 21. Juni 2022 17:11 >> An: user@ofbiz.apache.org >> Betreff: Inventory Item Detail >> >> Hello Community, >> >> I need your help please understanding the logic used while adding records to >> the subject table as demo data is not giving enough insight regarding the >> same. Usually, we’ll have one initial record added with every >> ‘inventory_item’ and fields ‘QUANTITY_ON_HAND_DIFF’ and >> ‘AVAILABLE_TO_PROMISE_DIFF’ have the same value. >> >> My question is how subsequent records on the same inventory item affect the >> values of the mentioned fields? >> >> Regards, >> Emad >
Re: Inventory Item Detail
Hi Ingo, In this case, in the new record where we updated the mentioned field with -2, will be an update to the ‘QUANTITY_ON_HAND_DIFF’ field? On the same record I mean, and that’s what confuses me from some of the demo data. Regards, Emad > On 22 Jun 2022, at 7:57 AM, Ingo Wolfmayr wrote: > > Hi Emad, > > when the initial record is done (for example adding product inventory with > quantity 10 for productId "demoproduc"t) the inventory item gets > +10 QUANTITY_ON_HAND_DIFF > +10 AVAILABLE_TO_PROMISE_DIFF’ > > If a customer creates an order, adding quantity 2 from demoproduct an > inventory item detail with AVAILABLE_TO_PROMISE_DIFF -2 is created. The > inventory is reserved for that order. > The result: > ATP: 8 - available to promise > QOH: 10 - physical stock > > This is just one simple case for inventory change. Does this answer your > question? > > Best regards, > Ingo > > > > -Ursprüngliche Nachricht- > Von: Emad Radwan > Gesendet: Dienstag, 21. Juni 2022 17:11 > An: user@ofbiz.apache.org > Betreff: Inventory Item Detail > > Hello Community, > > I need your help please understanding the logic used while adding records to > the subject table as demo data is not giving enough insight regarding the > same. Usually, we’ll have one initial record added with every > ‘inventory_item’ and fields ‘QUANTITY_ON_HAND_DIFF’ and > ‘AVAILABLE_TO_PROMISE_DIFF’ have the same value. > > My question is how subsequent records on the same inventory item affect the > values of the mentioned fields? > > Regards, > Emad
Inventory Item Detail
Hello Community, I need your help please understanding the logic used while adding records to the subject table as demo data is not giving enough insight regarding the same. Usually, we’ll have one initial record added with every ‘inventory_item’ and fields ‘QUANTITY_ON_HAND_DIFF’ and ‘AVAILABLE_TO_PROMISE_DIFF’ have the same value. My question is how subsequent records on the same inventory item affect the values of the mentioned fields? Regards, Emad
Order Adjustments
Hello Community, How can I add adjustments to orders the same way as in Quotes? I can’t find a menu link for that! However, I noticed that while creating an order that few adjustments were added automatically, are those defined on the store / promotion level? Regards, Emad
Question about Adjustments
Hello Community, In Quote Adjustment if I understand right there’ll be types of adjustments that will increase the total amount and others will decrease it; for example ‘Discount’ and ‘Sales Tax’ how this will be controlled, meaning, is it expected to provide a negative value in case it’s a ‘Discount’. Also which fields to use as we have ‘Amount’ & ‘Exempt Amount’. Also how ‘Source Percentage’ should be used in this case? Many thanks in Advance, Emad
Re: Service Logs
Hello Jacques, It’s working perfectly, however, I’m a bit confused about the way recently executed services should appear in service log. My understanding is to just execute a functionality in Ofbiz - Order module for example - and switch to service log, refresh the page, sort descending by ‘End Date/Time’, and see the expected module services on top of the list. I understand that other services are also running and will be listed as well. Am I doing it the wrong way or what? Regards, Emad > On 26 May 2022, at 2:07 PM, Jacques Le Roux > wrote: > > It's fixed in all supported branches (18.12, 22.01 and trunk) so yes > downloading the latest code and re-build should work. > You may also apply the patch at > https://github.com/apache/ofbiz-framework/commit/d8d1b03722.patch > > HTH > > Jacques > > Le 26/05/2022 à 12:45, Emad Radwan a écrit : >> Many thanks Jacques. How to deploy this, Do I need to download the latest >> code and re-build? >> >> Regards, >> Emad >> >>> On 26 May 2022, at 12:39 PM, Jacques Le Roux >>> wrote: >>> >>> It's fixed with https://issues.apache.org/jira/browse/OFBIZ-12625 >>> >>> Le 26/05/2022 à 10:55, Jacques Le Roux a écrit : >>>> Hi Emad, >>>> >>>> That's an interesting question. It also fails at >>>> https://demo-stable.ofbiz.apache.org/webtools/control/ServiceLog (NPE in >>>> Services.groovy) >>>> >>>> I'll look at it... >>>> >>>> Jacques >>>> >>>> Le 26/05/2022 à 05:05, Emad Radwan a écrit : >>>>> Hello Community, >>>>> >>>>> While visiting the following function from WebTools I always find the >>>>> ‘Service Name’ column empty; Is that by design or there’s a way to make >>>>> it visible? On the other hand, and by searching other users’ emails on >>>>> similar subjects I found a discussion about ‘Service Call Stack’ but not >>>>> sure if it was implemented or not? >>>>> >>>>> Please shed some light? >>>>> >>>>> Regards, >>>>> Emad >>>>> >>>>> https://localhost:8443/webtools/control/ServiceLog >
Re: Service Logs
Many thanks Jacques. How to deploy this, Do I need to download the latest code and re-build? Regards, Emad > On 26 May 2022, at 12:39 PM, Jacques Le Roux > wrote: > > It's fixed with https://issues.apache.org/jira/browse/OFBIZ-12625 > > Le 26/05/2022 à 10:55, Jacques Le Roux a écrit : >> Hi Emad, >> >> That's an interesting question. It also fails at >> https://demo-stable.ofbiz.apache.org/webtools/control/ServiceLog (NPE in >> Services.groovy) >> >> I'll look at it... >> >> Jacques >> >> Le 26/05/2022 à 05:05, Emad Radwan a écrit : >>> Hello Community, >>> >>> While visiting the following function from WebTools I always find the >>> ‘Service Name’ column empty; Is that by design or there’s a way to make it >>> visible? On the other hand, and by searching other users’ emails on similar >>> subjects I found a discussion about ‘Service Call Stack’ but not sure if it >>> was implemented or not? >>> >>> Please shed some light? >>> >>> Regards, >>> Emad >>> >>> https://localhost:8443/webtools/control/ServiceLog >>
Service Logs
Hello Community, While visiting the following function from WebTools I always find the ‘Service Name’ column empty; Is that by design or there’s a way to make it visible? On the other hand, and by searching other users’ emails on similar subjects I found a discussion about ‘Service Call Stack’ but not sure if it was implemented or not? Please shed some light? Regards, Emad https://localhost:8443/webtools/control/ServiceLog
Re: Facility Location
Many thanks Jacques. That’s very useful. Regards, Emad > On 22 May 2022, at 11:50 AM, Jacques Le Roux > wrote: > > Hi Emad, > > If you want to gain some time you may help yourself using ofbiz.markmail.org, > eg: > > https://ofbiz.markmail.org/search/?q=TL+LL+UL#query:TL%20LL%20UL+page:1+mid:qbtwx73jync44yfz+state:results > > HTH > > Jacques > > Le 21/05/2022 à 23:43, Emad Radwan a écrit : >> Hello Community, >> >> I’m a bit confused regarding the values for demo data introduced to the >> following fields in the subject table, looks like coded values while having >> no foreign keys to other tables or enums; would you please shed some light >> on what it refers to: >> >> FieldValue >> >> Area TL >> AisleTL >> Section TL >> LevelUL >> Position 06 >> >> Regards, >> Emad >
Facility Location
Hello Community, I’m a bit confused regarding the values for demo data introduced to the following fields in the subject table, looks like coded values while having no foreign keys to other tables or enums; would you please shed some light on what it refers to: Field Value AreaTL Aisle TL Section TL Level UL Position06 Regards, Emad
Debug Ofbiz that's running on Docker
Hello Community, I’m running the following configuration using Docker, does anyone know how to modify it to allow for remote debugging? Regards, Emad https://github.com/danwatford/ofbiz-docker
Re: Where is Quote Item
Thanks Aditya. It’s working fine now. Regards, Emad > On 18 May 2022, at 9:17 AM, Aditya Sharma wrote: > > Hello Emad, > > I think this could be done from Quote items page > https://demo-trunk.ofbiz.apache.org/ordermgr/control/ListQuoteItems?quoteId=CQ0001 > > Steps to navigate to quote items page: > 1. Create a quote > 2. Navigate to view quote page > 3. Click items > > HTH > > Thanks and Regards, > Aditya Sharma > > > On Wed, May 18, 2022 at 3:00 AM Emad Radwan wrote: > >> Hello Community, >> >> >> I’m on the latest version of Ofbiz now and trying to create a new Quote >> which was ok but can’t find a link to add items to it. Where can I find >> that? >> >> Regards, >> Emad
Re: Where is Quote Item
Hello Aditya, That’s strange, as in my installation when I navigate to the newly created quote I can see only sub-menus ‘Quotes’ and ‘Profit’. What may cause this behavior? Regards, Emad > On 18 May 2022, at 9:17 AM, Aditya Sharma wrote: > > Hello Emad, > > I think this could be done from Quote items page > https://demo-trunk.ofbiz.apache.org/ordermgr/control/ListQuoteItems?quoteId=CQ0001 > > Steps to navigate to quote items page: > 1. Create a quote > 2. Navigate to view quote page > 3. Click items > > HTH > > Thanks and Regards, > Aditya Sharma > > > On Wed, May 18, 2022 at 3:00 AM Emad Radwan wrote: > >> Hello Community, >> >> >> I’m on the latest version of Ofbiz now and trying to create a new Quote >> which was ok but can’t find a link to add items to it. Where can I find >> that? >> >> Regards, >> Emad
Where is Quote Item
Hello Community, I’m on the latest version of Ofbiz now and trying to create a new Quote which was ok but can’t find a link to add items to it. Where can I find that? Regards, Emad
Urgent please. Ofbiz hang while loadAll CleanAll
Hello Community, With a fresh install and while running ‘gradlew cleanAll loadAll’ the process hangs at the following message. I dropped the DB, re-created it, and started the process a few times with the same error. Appreciate your help, please. Regards, Emad 2022-05-13 12:41:48,322 |main |ServiceDispatcher |T| Sync service [entity-default/getInventoryAvailableByFacility] finished in [16] milliseconds 2022-05-13 12:41:48,400 |main |UtilProperties |I| ResourceBundle DefaultMessagesUiLabels (en) created in 0.078s with 11 properties c
